DOTNET POINT: 2022

Friday 9 December 2022

How to add audio in website

</audio>

Sunday 4 December 2022

CRUD operations using php api & mysql

.htaccess :

RewriteEngine On

RewriteCond %{REQUEST_FILENAME} !-d

RewriteCond %{REQUEST_FILENAME} !-f

RewriteRule ^ Index.php [L]

DB.php :

<?php

class DbConnect {

private $server = 'localhost';

private $dbname = 'hanuman';

private $user = 'root';

private $pass = '';

public function connect() {

try {

$conn = new PDO('mysql:host=' .$this->server .';dbname=' . $this->dbname, $this->user, $this->pass);

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

return $conn;

} catch (\Exception $e) {

echo "Database Error: " . $e->getMessage();

}

Index.php

<?php

error_reporting(E_ALL);

ini_set('display_errors',1);

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("DB.php");

$dbConnect = new DbConnect();

$conn= $dbConnect->connect();

$method=$_SERVER['REQUEST_METHOD'];

switch ($method) {

case 'GET' :

$sql="select * from emp";

$path=explode('/',$_SERVER['REQUEST_URI']);

if(isset($path[2]) && is_numeric($path[2])){

$sql .=" where eid =:eid order by eid desc";

$stmt = $conn->prepare($sql);

$stmt ->bindParam(':eid',$path[2]);

$stmt->execute();

$emp= $stmt->fetch(PDO::FETCH_ASSOC);

}else {

$stmt=$conn->prepare($sql);

$stmt->execute();

$emp= $stmt->fetchAll(PDO::FETCH_ASSOC);

}

echo json_encode($emp);

break;

case 'POST':

$emp= json_decode(file_get_contents('php://input'));

$sql="INSERT INTO `emp`(`NAME`, `ADDRESS`) VALUES (:name,:address)";

$stmt = $conn->prepare($sql);

$stmt->bindParam(':name',$emp->name);

$stmt->bindParam(':address',$emp->address);

if($stmt->execute()) {

$response= ['status' =>200, 'message' => 'Data Saved.'];

}

else {

$response= ['status' =>500, 'message' => 'Internal server error.'];

}

return json_encode($response);

break;

case 'PUT':

$emp= json_decode(file_get_contents('php://input'));

$sql="UPDATE emp SET NAME=:name,ADDRESS=:address WHERE EID=:eid";

$stmt = $conn->prepare($sql);

$stmt->bindParam(':eid',$emp->eid);

$stmt->bindParam(':name',$emp->name);

$stmt->bindParam(':address',$emp->address);

if($stmt->execute()) {

$response= ['status' =>200, 'message' => 'Data Updated.'];

}

else {

$response= ['status' =>500, 'message' => 'Internal server error.'];

}

return json_encode($response);

break;

case 'DELETE':

$path=explode('/',$_SERVER['REQUEST_URI']);

$sql="delete from emp where eid=:eid";

$stmt = $conn->prepare($sql);

$stmt ->bindParam(':eid',$path[2]);

if($stmt->execute()) {

$response= ['status' =>200, 'message' => 'Data deleted.'];

}

else {

$response= ['status' =>500, 'message' => 'Internal server error.'];

}

break;

default:

echo 'Something went wrong.';

break;

}

How call jquery ajax in php

Emp.php

<?php

if(isset($_POST['Name']))

{

$name=$_POST['Name'];

$addr=$_POST['Addr'];

$conn=mysqli_connect("localhost","root","","hanuman");

$sql="INSERT INTO `emp`( `NAME`, `ADDRESS`) VALUES ('$name','$addr')";

$result=mysqli_query($conn,$sql);

if($result)

{

echo "Data saved successfully.";

}

else

{

echo "Data can not saved.";

}

Index.html

<!DOCTYPE html>

<html>

</header>

<form>

</div>

</div>

</div>

<label for="txtadd">Address</label>

</div>

</div>

</div>

</div>

</div>

</div>

</form>

</div>

</body>

</html>

$(function(){

$('#btnsave').click(function(){

var name=$('#txtname').val();

var addr=$('#txtadd').val();

$.post("Emp.php",{

"Name":name,

"Addr":addr

},function(data,status){

alert(data);

});

})

});

</script>

Call Api In Php :

<!DOCTYPE html>

<html>

</header>

<form>

</div>

</div>

</div>

<label for="txtadd">Address</label>

</div>

</div>

</div>

</div>

</div>

</div>

</form>

</div>

</body>

</html>

$(function(){

$('#btnsave').click(function(){

var name=$('#txtname').val();

var addr=$('#txtadd').val();

$.post("http://localhost:8080/rabiapi/Index/Save",JSON.stringify({

"name":name,

"address":addr

}),function(data,status){

alert(data);

});

})

});

</script>

Saturday 19 March 2022

CRUD operations using MVC & WebApi2

Web Api Code:

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Linq;

using System.Web;

namespace WebApplication4.Models

{

public class EMP

{

[Key]

public int Eid { get; set; }

public string Name { get; set; }

public string Address { get; set; }

}

---

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.Entity;

namespace WebApplication4.Models

{

public class AppdbContext:DbContext

{

public AppdbContext() : base("name=AppDbConnection")

{

}

public DbSet<EMP> Emps { get; set; }

}

In web.config file u add the connection string

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionStrings>
    <add name="AppDbConnection"
    connectionString="Data Source=(localdb)\ProjectsV13;Initial Catalog=Mahadev;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"
    providerName="System.Data.SqlClient"/>
  </connectionStrings>
</configuration>

Enable-Migrations: Enables the migration in your project by creating a Configuration class.
Add-Migration: Creates a new migration class as per specified name with the Up() and Down() methods.
Update-Database: Executes the last migration file created by the Add-Migration command and applies changes to the database schema.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Net.Http;

using System.Threading.Tasks;

using System.Web.Http;

using WebApplication4.Models;

using System.Data.Entity;

using System.Web.Http.Description;

namespace WebApplication4.Controllers

{

[RoutePrefix("api/Emps")]

public class EmpsController : ApiController

{

[HttpGet]

public async Task<IHttpActionResult> Gets()

{

try

{

using (AppdbContext obj = new AppdbContext())

{

return Ok(await obj.Emps.ToListAsync());

}

catch (Exception ex)

{

return StatusCode(HttpStatusCode.InternalServerError);

}

[HttpGet]

[ResponseType(typeof(EMP))]

[Route("Get/{id}",Name ="Get")]

public async Task<IHttpActionResult> Get(int Id)

{

try

{

using (AppdbContext obj = new AppdbContext())

{

return Ok(await obj.Emps.FirstOrDefaultAsync(m=>m.Eid==Id));

}

catch (Exception ex)

{

return StatusCode(HttpStatusCode.InternalServerError);

}

[HttpPost]

[ResponseType(typeof(EMP))]

public async Task<IHttpActionResult> Post(EMP eMP)

{

try

{

using (AppdbContext obj = new AppdbContext())

{

obj.Emps.Add(eMP);

await obj.SaveChangesAsync();

return CreatedAtRoute("Get", new { Id = eMP.Eid }, eMP);

}

catch (Exception ex)

{

return StatusCode(HttpStatusCode.InternalServerError);

}

[HttpPut]

[ResponseType(typeof(void))]

public async Task<IHttpActionResult> Put(EMP eMP)

{

try

{

using (AppdbContext obj = new AppdbContext())

{

EMP Emp = obj.Emps.Find(eMP.Eid);

Emp.Name = eMP.Name;

Emp.Address = eMP.Address;

await obj.SaveChangesAsync();

return StatusCode(HttpStatusCode.NoContent);

}

catch (Exception ex)

{

return StatusCode(HttpStatusCode.InternalServerError);

}

[HttpDelete]

[ResponseType(typeof(EMP))]

public async Task<IHttpActionResult> Delete(int Id)

{

try

{

using (AppdbContext obj = new AppdbContext())

{

EMP Emp = obj.Emps.Find(Id);

obj.Emps.Remove(Emp);

await obj.SaveChangesAsync();

return Ok(Emp);

}

catch (Exception ex)

{

return StatusCode(HttpStatusCode.InternalServerError);

}

MVC code :

IIn order to create a Web API client.

Add Microsoft.AspNet.Webapi.Client using NuGet package manager.

using System.Collections.Generic;

using System.Linq;

using System.Net.Http;

using System.Web;

using System.Web.Mvc;

using WebApplication1.Models;

namespace WebApplication1.Controllers

{

public class EmpsController : Controller

{

private string Baseurl = string.Empty;

public EmpsController()

{

Baseurl = "http://localhost:55419/api/Emps";

}

[HttpGet]

public ActionResult Index()

{

using (HttpClient webClient = new HttpClient())

{

HttpResponseMessage webResponse = webClient.GetAsync(Baseurl).Result;

return View(webResponse.Content.ReadAsAsync<List<Empvm>>().Result);

}

[HttpGet]

public ActionResult Create()

{

return View(new Empvm());

}

[HttpPost]

public ActionResult Create(Empvm empvm)

{

using (HttpClient webClient = new HttpClient())

{

HttpResponseMessage webResponse = webClient.PostAsJsonAsync(Baseurl, empvm).Result;

return RedirectToAction("Index");

}

[HttpGet]

public ActionResult Edit(int id)

{

using (HttpClient webClient = new HttpClient())

{

HttpResponseMessage webResponse = webClient.GetAsync(Baseurl + "/Get/" + id).Result;

Empvm empvm1 = webResponse.Content.ReadAsAsync<Empvm>().Result;

Empvm empvm = new Empvm();

empvm.Eid = empvm1.Eid;

empvm.Name = empvm1.Name;

empvm.Address = empvm1.Address;

return View(empvm);

}

[HttpPost]

public ActionResult Edit(Empvm empvm)

{

using (HttpClient webClient = new HttpClient())

{

HttpResponseMessage webResponse = webClient.PutAsJsonAsync(Baseurl, empvm).Result;

return RedirectToAction("Index");

}

[HttpGet]

public ActionResult Delete(int id)

{

using (HttpClient webClient = new HttpClient())

{

HttpResponseMessage httpResponseMessage = webClient.DeleteAsync(Baseurl + "/" + id).Result;

return RedirectToAction("Index");

}