DOTNET POINT: 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");

}

Wednesday 20 September 2023

HOW TO CREATE ORIYA PAGE IN HTML

First you upload the TTF font in your project folder. then you can implement in your project.

<?php include 'Header.php'; ?>

<div class="well well-lg" style="text-align:justify;font-size:large;">
<p class="x">
^ì@û iõi\ ba^e Kû~ðý @ûe¸ ùjaûe ÊZª @]ôùag^ùe _â[c \ò^ùe _â[c aòf bûùa cjòkû @ûi^ iõelY aòf ajê _âZòlúZ I @ûùfûPòZ Gjò aòfKê ùK¦â ieKûe @ûMZ KeòQ«òö Gjò ^ì@û aòfe ^ûc ejòQò "^ûeú gqò a¦^ @]ô^òdc'ö ùfûK ibûùe cjòkûu _âZò^ò]ôZß 1970eê cûZâ 5% ejò@ûiò[ôaû ùaùk 2009ùe \êA @uKê QêAñ[ôfûö ùfûKibû Zêk^ûùe eûRý ibûùe cjòkûu _âZò^ò]ôZß iûcû^ý Kc ejò[ôfûö ùZùa 1951 _eVê @\ýûa]ô Cy i\^ùe Gjû 13% @ZòKâc Keò_ûeò ^ûjóö i´ò]û^e 128Zc iõùgû]^ aòf, 2023 cwkaûe ùfûK ibûùe @ûMZ ùjûAQòö ^ì@û iõi\ ba^e ÊZª @]ôùag^ùe @ûMZ ùjûA[ôaû Gjû ùjCQò _â[c aòù]dKö 1047 iê¡û bûeZKê GK aòKgòZ eûÁâùe _eòYZ Keòaû _ûAñ cjòkûu bìcòKû @Zý« MêeêZß_ì‰ð \gðûA ieKûe GjûKê @ûYòQ«òö ùfûKibûKê 2019ùe iaðû]ôK cjòkû ^òaðûPòZ ùjûA[ôùfö Kò«ê ùcûU i\iýu cûZâ 15%ö @^ý_ùl 2014ùe eûRýibûùe iaðû]ôK 12.7% cjòkû _âZò^ò]ôZß Keòaû iêù~ûM _ûA[ôùfö
Gjò aòf ùfûKibû, \òfäú aò]û^ibû I eûRý aò]û^ibû MêWÿòKùe cjòkûuê 33% iõelY _â\û^ Keòaö Kò«ê eûRýibû Kò´û eûRý aò]û^ _eòh\ MêWÿòK _âZò Gjò ùKûUû _â~êRý ùja^ûjóö Gjò ùKûUûeê GKZéZúdûõg @^êiìPúZ RûZò I R^RûZò iµâ\ûde cjòkûu _ûAñ iõelòZ ejòaö @ûi«û R^MY^û Z[ý _âKûg _ûAaû _ùe _ê^üiúcû ^ò¡ðûeY _âKâòdû ùgh ùjaû _ùe ~ûA cjòkûOK _ûAñ @ûi^ iõelY aýaiÚû fûMê ùjaö ùfûKibû I eûRý aò]û^ibû MêWÿòKùe cjòkûu _ûAñ @ûi^ iõelYe ùeûùUi^ aýaiÚû _âùZýK _ea©ðú iúcû _ê^ü^ò¡ðûeY _âKâòdû _ùe fûMê ùjaö ùMûUòG @ûi^eê \êA RY cjòkû iûõi\uê fXÿòaûKê @^êcZò còkòa ^ûjóö Gjò aòfùe Iaòiò aMðe cjòkûu _ûAñ iõelYKê aû\ \ò@û~ûAQòö eûRý I RûZúd Éeùe ^úZò ^ò¡ðûeYùe cjòkû cû^u iµéqò aé¡ò Keòaû Gjò aòfe CùŸgýö MZ 27 ahð ]eò Gjò aòf _ûi _ûAñ C\ýc ùjûA @ûiòQòö ùZùa 2010 ciòjûùe eûRýibûùe Gj MéjúZ ùjûA[ôfûö Kò«ê ùfûKibûùe MéjúZ ùjûA ^_ûeòaûeê Gjû @ûA^ùe _eòYZ ùjûA_ûeò ^[ôfûö @ù^K ahð ]eò Gjò aòf _ûAñ @ù^K eûRù^÷ZòK \k _leê \ûaú, _âZòaû\ ùjûA[ôfûö @Ukaòjûeú aûRù_dúu icdùe Gjò iõelY aòf @ûMZ ùjûA[ôùf c¤ GjûKê ic[ð^ùe ùbûU còkò^[ôfûö Gjò aòfUò Kò«ê aûÉaùe ù\ge _ea©ðú iúcû _ê^ü ^ò¡ðûeY Kû~ðýKâc _ùe @[ðûZ 2026 R^MY^û _ùe Gjû Kû~ðýKûeú ùjaö cjòkû iõelY aòf 2029 ùfûKibû ^òaðûP^ iê¡û Kû~ðýKûeú ùjûA_ûùeö Gùa cjòkû i\iýu iõLýû 82[ôaûùùak Gjû 181Kê aé¡ò _ûAaö Gjò aòf 2010ùe eûRýibûùe MéjúZ ùjûA[ôùf c¤ Gjû ùfûKibûùe MéjúZ ùjûA_ûeò^[ôfûö Gjò aòf \ßûeû cjòkûcûù^ igq ùjaûij cjòkû _âMZò Zßeû^ßòZ ùjûA_ûeòaö icMâ aògßùe ^ûeú gqòe @MâMZò I _âMZò iaê ùlZâùe ù\Lûù\CQòö bûeZe _âMZòùe cjòkû cû^ue @a\û^ I _âZò_û\òZû @ù^K iûc[ðýe ù~Cñ gúhðÉeùe iê^ûcKê fò_òa¡ Keò_ûeòQò Gjò ^ì@û aòf \ßûeû @ûMûcú _òXÿòùe @ù^K cjòkû ^ûeú gqòe ~[û[ð iêù~ûMý _âZò^ò]ô bûùa ^òR aýqòZß, @]ôKûe I iûc[ðýKê C{ßk Keò_ûeòùa Gjò @ûgû ejòQòö
</p>
</div>
</div>
<style> 

@font-face {
  font-family: myFirstFont;
  src: url(AOSAR06N.TTF);
}
.x {
  font-family: myFirstFont;
}
</style>
<?php include 'Footer.php'; ?>

Wednesday 23 August 2023

API IN PHP

<?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'];
$path=explode('/',$_SERVER['REQUEST_URI']);
switch ($method) {
    case 'GET' : 
        if(isset($path[4]) && is_numeric($path[4]))
        {
            $result=mysqli_query($conn,"Select * from expence where ID='$path[4]'");
            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 expence");
        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':
        $dE=$obj["DE"];
        $aMOUNT=$obj["AMOUNT"];
        $tYPE=$obj["TYPE"];
        $yEAR=$obj["YEAR"];
        $cDATE=$obj["CDATE"];
        $result=mysqli_query($conn,"INSERT INTO `expence`(`DE`, `AMOUNT`, `TYPE`, `YEAR`, `CDATE`) VALUES ('$dE','$aMOUNT','$tYPE','$yEAR','$cDATE')");
        if($result)
        {
            echo json_encode("Data Inserted successfully.");
        }
        else
        {
            echo json_encode("Something went wrong.");
        }
        break;
        case 'PUT':
            $iD=$obj["ID"];
            $dE=$obj["DE"];
            $aMOUNT=$obj["AMOUNT"];
            $tYPE=$obj["TYPE"];
            $yEAR=$obj["YEAR"];
            $cDATE=$obj["CDATE"];
            $result=mysqli_query($conn,"UPDATE `expence` SET `DE`='$dE',`AMOUNT`='$aMOUNT',`TYPE`='$tYPE',`YEAR`='$yEAR',`CDATE`='$cDATE'  WHERE ID='$iD'");
            if($result)
            {
                echo json_encode("Data Updated successfully.");
            }
            else
            {
                echo json_encode("Something went wrong.");
            }  
            break;
            case 'DELETE':
                $iD=$obj["ID"];
    $result=mysqli_query($conn,"delete from  expence where ID='$iD'");
    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);
?>

Thursday 17 August 2023

how to implement payment gateway

<html>

<button id="rzp-button1" class="btn btn-outline-dark btn-lg"><i class="fas fa-money-bill"></i> Own Checkout</button>

var options = {

"key": "Enter Your Key", // Enter the Key ID generated from the Dashboard

"amount": "1000",

"currency": "INR",

"description": "Acme Corp",

"image": "https://s3.amazonaws.com/rzp-mobile/images/rzp.jpg",

"prefill":

{

"email": "gaurav.kumar@example.com",

"contact": +919900000000,

config: {

display: {

blocks: {

banks: {

name: 'Pay using Axis banks',

instruments: [

{

method: 'netbanking',

banks: ['UTIB'],

{

method: 'card',

issuers: ['UTIB'],

{

method: 'wallet',

wallets:['payzapp']

}

sequence: ['block.banks'],

preferences: {

show_default_blocks: true,

"handler": function (response) {

alert(response.razorpay_payment_id);

"modal": {

"ondismiss": function () {

if (confirm("Are you sure, you want to close the form?")) {

txt = "You pressed OK!";

console.log("Checkout form closed by the user");

} else {

txt = "You pressed Cancel!";

console.log("Complete the Payment")

}

};

var rzp1 = new Razorpay(options);

document.getElementById('rzp-button1').onclick = function (e) {

rzp1.open();

e.preventDefault();

}

</script>

</html>

Monday 14 August 2023

how to send mail in php

<?php

include 'Header.php';

if(isset($_POST["SubmitBtn"])){

$message ="Name = ". $_POST["name"] . "\r\n Mobile Number = " . $_POST["mobile"] . "\r\n Email id ="

.$_POST["email"]."\r\n".$_POST["msg"];

$subject ="Feedback from JBS";

$fromname ="JBSTECHNOSOFT";

$fromemail = 'noreply@codeconia.com'; //if u dont have an email create one on your cpanel

$mailto = 'chinmayaparijabanglore@gmail.com'; //the email which u want to recv this email

// a random hash will be necessary to send mixed content

$separator = md5(time());

// carriage return type (RFC)

$eol = "\r\n";

// main header (multipart mandatory)

$headers = "From: ".$fromname." <".$fromemail.">" . $eol;

$headers .= "MIME-Version: 1.0" . $eol;

$headers .= "Content-Type: multipart/mixed; boundary=\"" . $separator . "\"" . $eol;

$headers .= "Content-Transfer-Encoding: 7bit" . $eol;

$headers .= "This is a MIME encoded message." . $eol;

// message

$body = "--" . $separator . $eol;

$body .= "Content-Type: text/plain; charset=\"iso-8859-1\"" . $eol;

$body .= "Content-Transfer-Encoding: 8bit" . $eol;

$body .= $message . $eol;

// attachment

$body .= "--" . $separator . $eol;

$body .= "Content-Transfer-Encoding: base64" . $eol;

$body .= "Content-Disposition: attachment" . $eol;

$body .= "--" . $separator . "--";

//SEND Mail

if (mail($mailto, $subject, $body, $headers)) {

echo ""; // do what you want after sending the email

} else {

echo "mail send ... ERROR!";

print_r( error_get_last() );

}

<div class="panel-heading">Feedback</div>

<div class="col-md-3 col-sm-3 col-lg-3 col-xl-3">Enter Your Name</div>

</div>

</div>

<div class="col-md-3 col-sm-3 col-lg-3 col-xl-3">Enter Your Mobile Number</div>

</div>

</div>

<div class="col-md-3 col-sm-3 col-lg-3 col-xl-3">Enter Your Email Id</div>

</div>

</div>

<div class="col-md-3 col-sm-3 col-lg-3 col-xl-3">Enter Your Feedback</div>

</div>

</div>

</div>

</from>

</div>

</div><br>

<?php include 'Footer.php'; ?>