DOTNET POINT: December 2023

Saturday 9 December 2023

CRUD opration using PHP API & DOT NET MVC

PHP API :

<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: *');
header('Access-Control-Allow-Headers: *');
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Max-Age: 3600");
include "conn.php";
$json = file_get_contents("php://input");
$obj= json_decode($json,true);
$mark= $obj["mark"];
if ($mark==1)
{
    $result=mysqli_query($conn,"Select * from class");
    if (mysqli_num_rows($result) > 0) {
        while($row[] = mysqli_fetch_assoc($result)) {
          $data=json_encode($row);
        }
        echo $data;
    }
    else
    {
        echo json_encode("result not found.");
    }
}
elseif($mark==2)
{
    $cID=$obj["CID"];
    $result=mysqli_query($conn,"Select * from class where CID='$cID'");
    if (mysqli_num_rows($result) > 0) {
        while($row = mysqli_fetch_assoc($result)) {
          $data=json_encode($row);
        }
        echo $data;
    }
    else
    {
        echo json_encode("result not found.");
    }
   
}
elseif($mark==3)
{
    $cNAME=$obj["CNAME"];
    $result=mysqli_query($conn,"INSERT INTO `class`(`CNAME`) VALUES ('$cNAME')");
    if($result)
    {
        echo json_encode("Data Inserted successfully.");
    }
    else
    {
        echo json_encode("Something went wrong.");
    }
}
elseif($mark==4)
{
    $cID=$obj["CID"];
    $CNAME=$obj["CNAME"];
    $result=mysqli_query($conn,"UPDATE `class` SET  `CNAME`='$CNAME'   WHERE CID='$cID'");
    if($result)
    {
        echo json_encode("Data Updated successfully.");
    }
    else
    {
        echo json_encode("Something went wrong.");
    }  
}
elseif($mark==5)
{
    $cID=$obj["CID"];
    $result=mysqli_query($conn,"delete from  `class` where CID='$cID'");
    if($result)
    {
        echo json_encode("Data deleted successfully.");
    }
    else
    {
        echo json_encode("Something went wrong.");
    }
}
mysqli_close($conn);
?>

DOTNET CODE :

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Linq;

using System.Web;

namespace WebApplication9.Models

{

public class ClassVM

{

[Required(ErrorMessage ="Cid should not be blank.")]

public int? CID { get; set; }

[Required(ErrorMessage = "Class should not be blank.")]

public string CNAME { get; set; }

public string mark { get; set; }

}

using Newtonsoft.Json;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Security.Policy;

using System.Text;

using System.Web;

using System.Web.Mvc;

using WebApplication9.Models;

using System.Threading.Tasks;

using System.Net;

namespace WebApplication9.Controllers

{

public class ClassController : Controller

{

public string baseurl;

public ClassController()

{

baseurl = "https://abc.com/API/";

}

// GET: Class

public ActionResult Index()

{

List<ClassVM> result = new List<ClassVM>();

using (WebClient webClient = new WebClient())

{

ClassVM vm = new ClassVM();

vm.mark = "1";

string data = JsonConvert.SerializeObject(vm);

webClient.BaseAddress = baseurl;

var json = webClient.UploadString("Class", data);

result = JsonConvert.DeserializeObject<List<ClassVM>>(json);

}

return View(result);

}

[HttpGet]

public ActionResult Create()

{

ClassVM cvm = new ClassVM();

return View(cvm);

}

[HttpPost]

public ActionResult Create(ClassVM vm)

{

using (WebClient webClient = new WebClient())

{

vm.mark = "3";

string data = JsonConvert.SerializeObject(vm);

webClient.BaseAddress = baseurl;

var json = webClient.UploadString("Class", data);

}

return RedirectToAction("Index");

}

[HttpGet]

public ActionResult Edit(int id)

{

ClassVM result =new ClassVM();

using (WebClient webClient = new WebClient())

{

result.CID = id;

result.mark = "2";

string data = JsonConvert.SerializeObject(result);

webClient.BaseAddress = baseurl;

var json = webClient.UploadString("Class", data);

result = JsonConvert.DeserializeObject<ClassVM>(json);

}

return View(result);

}

[HttpPost]

public ActionResult Edit(ClassVM vm)

{

using (WebClient webClient = new WebClient())

{

vm.mark = "4";

string data = JsonConvert.SerializeObject(vm);

webClient.BaseAddress = baseurl;

var json = webClient.UploadString("Class", data);

}

return RedirectToAction("Index");

}

[HttpGet]

public ActionResult Delete(int id)

{

using (WebClient webClient = new WebClient())

{

ClassVM vm = new ClassVM();

vm.CID = id;

vm.mark = "5";

string data = JsonConvert.SerializeObject(vm);

webClient.BaseAddress = baseurl;

var json = webClient.UploadString("Class", data);

}

return RedirectToAction("Index");

}

Tuesday 5 December 2023

CRUD opration using PHP API & DOT NET MVC

PHP API :

<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: *');
header('Access-Control-Allow-Headers: *');
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Max-Age: 3600");
include "conn.php";
$json = file_get_contents("php://input");
$obj= json_decode($json,true);
$method=$_SERVER['REQUEST_METHOD'];
if(strstr($_SERVER['REQUEST_URI'],'?'))
{
    $path1=explode('?',$_SERVER['REQUEST_URI']);
    $path =explode('=',$path1[1]);
}
switch ($method) {
    case 'GET' : 
        if(isset($path[1]) && is_numeric($path[1]))
        {
            $result=mysqli_query($conn,"Select * from class where CID='$path[1]'");
            if (mysqli_num_rows($result) > 0) {
                while($row = mysqli_fetch_assoc($result)) {
                  $data=json_encode($row);
                }
                echo $data;
            }
            else
            {
                echo json_encode("result not found.");
            }
        }
        else
        {
            $result=mysqli_query($conn,"Select * from class");
        if (mysqli_num_rows($result) > 0) {
            while($row[] = mysqli_fetch_assoc($result)) {
              $data=json_encode($row);
            }
            echo $data;
        }
        else
        {
            echo json_encode("result not found.");
        }
        }
        break;
    case 'POST':
        $cNAME=$obj["CNAME"];
    $result=mysqli_query($conn,"INSERT INTO `class`(`CNAME`) VALUES ('$cNAME')");
    if($result)
    {
        echo json_encode("Data Inserted successfully.");
    }
    else
    {
        echo json_encode("Something went wrong.");
    }
        break;
        case 'PUT':
            $cID=$obj["CID"];
            $CNAME=$obj["CNAME"];
            $result=mysqli_query($conn,"UPDATE `class` SET  `CNAME`='$CNAME'   WHERE CID='$cID'");
            if($result)
            {
                echo json_encode("Data Updated successfully.");
            }
            else
            {
                echo json_encode("Something went wrong.");
            }  
            break;
            case 'DELETE':
                if(strstr($_SERVER['REQUEST_URI'],'?'))
                {
                $path2=explode('?',$_SERVER['REQUEST_URI']);
                $path3 =explode('=',$path2[1]);
                }
                $cID= $path3[1];
                $result=mysqli_query($conn,"delete from  `class` where CID='$cID'");
                if($result)
                {
                    echo json_encode("Data deleted successfully.");
                }
                else
                {
                    echo json_encode("Something went wrong.");
                }
                break;
    default:

        echo 'Something went wrong.';

        break;

}
mysqli_close($conn);
?>

DOT NET MVC:

using Newtonsoft.Json;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net.Http;

using System.Security.Policy;

using System.Text;

using System.Web;

using System.Web.Mvc;

using WebApplication9.Models;

using System.Threading.Tasks;

namespace WebApplication9.Controllers

{

public class ClassController : Controller

{

// GET: Class

public async Task<ActionResult> Index()

{

List<ClassVM> result = new List<ClassVM>();

using (var client = new HttpClient())

{

using (var response = await client.GetAsync("http://localhost:8080/CMS/API/Test"))

{

if (response.IsSuccessStatusCode)

{

var productJsonString = await response.Content.ReadAsStringAsync();

result = JsonConvert.DeserializeObject<ClassVM[]>(productJsonString).ToList();

}

return View(result);

}

[HttpGet]

public ActionResult Create()

{

ClassVM cvm = new ClassVM();

return View(cvm);

}

[HttpPost]

public async Task<ActionResult> Create(ClassVM vm)

{

using (var client = new HttpClient())

{

var serializedProduct = JsonConvert.SerializeObject(vm);

var content = new StringContent(serializedProduct, Encoding.UTF8, "application/json");

var result = await client.PostAsync("http://localhost:8080/CMS/API/Test", content);

}

return RedirectToAction("Index");

}

[HttpGet]

public async Task<ActionResult> Edit(int id)

{

ClassVM result = new ClassVM();

using (var client = new HttpClient())

{

using (var response = await client.GetAsync("http://localhost:8080/CMS/API/Test?CID="+id))

{

if (response.IsSuccessStatusCode)

{

var productJsonString = await response.Content.ReadAsStringAsync();

result = JsonConvert.DeserializeObject<ClassVM>(productJsonString);

}

return View(result);

}

[HttpPost]

public async Task<ActionResult> Edit(ClassVM vm)

{

using (var client = new HttpClient())

{

var serializedProduct = JsonConvert.SerializeObject(vm);

var content = new StringContent(serializedProduct, Encoding.UTF8, "application/json");

var result = await client.PutAsync("http://localhost:8080/CMS/API/Test", content);

}

return RedirectToAction("Index");

}

[HttpGet]

public async Task<ActionResult> Delete(int id)

{

using (var client = new HttpClient())

{

var result = await client.DeleteAsync("http://localhost:8080/CMS/API/Test?CID="+id);

}

return RedirectToAction("Index");

}