Friday 30 December 2022

Education E-commerce Synopsis | BCA, MCA, Bsc, O-Level, A-Level, IGNOU

 Education E-commerce Synopsis



This is an e-commerce category project, with the help of this project, you can sell education-related material online such as audio, video, PDF, etc. A payment gateway is integrated with this project and detailed reporting is done for admin. The website is completely dynamic so there is no need to change any kind of static code. This website is completely secure and the latest technology has been used.

Thursday 15 December 2022

FormsAuthentication C# ASP.NET MVC

 


FormsAuthentication

FormsAuthentication class from System.Web.Security is used to authenticate a user whether login or not. FormsAuthentication class has many functions to check the user login and it's very easy to implement. Follow the code given below

Views

<h2>Login</h2>

<form method="post">

    <input type="text" name="UserName" placeholder="User Name"  required /><br /><br />

    <input type="password" name="Password" placeholder="Password" required /><br /><br />

    <input type="submit" value="Login" />

    @if (Request.QueryString["msg"] != null)

    {

        <br /><br />

        <span style="color:red">@Request.QueryString["msg"]</span>

    }

</form>

Monday 12 December 2022

How to insert into a table with just one IDENTITY column? SQL Server

 I have a table named Slider, Which stores my website's homepage slider image. So I need one column auto-increment identity field for the slider image record and the uploaded image will be renamed as the identity field value.

So I had to insert a row in a single-column auto increment field. I have achieved this by the query given below.

INSERT INTO [dbo].[Slider]  DEFAULT VALUES 

Next Topic

Monday 28 November 2022

Editable Table Jquery

Name Value
Lorem Ipsum

Source Code

<html>

<head>

    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Editable Table</title>

   

Saturday 12 November 2022

Select A Table all rows by checkbox using jquery

Select/Unselect  Table all row by clicking the checkbox using jquery. You can do this by class selector. Make a class and apply it on all checkbox and select or unselect using class name by just one line of code.

Name City
Ram Vns
Syam Alld
Gita LKO
Anita Vns

Code

<html>

<head>

    <title>Table Select</title>

    <style>

        .chk {

        }

    </style>

Thursday 10 November 2022

Make PDF from hyperlink | ASP.NET C#


 This post will help you to create a PDF file from a URL in ASP.Net C#. Follow the steps given below. We will save a PDF file on the server then after viewing the PDF file, the file will be deleted. 

Step 1 : 

Download Select.HtmlToPdf.NetCore package from NuGet. 

Goto Tools Menu>Nuget Package Manager > Manage Nuget Package for Solution

Step 2 : 

 
 Create a Button and call the javascript function, which will create a PDF file from the given URL. The passing argument is URL of the page. Which will be converted into PDF file on the server at the given path. Then you can download the file.

<input type="button" value="Get PDF" onclick="createPDF('https://girfa.co.in/')" />

Step 3 


Javascript Code

function createPDF(pageurl)
 {

         $.ajax({

                url: '/Common/htmltopdf/',
                async: true,
                dataType: "json",
                type: "GET",
                contentType: 'application/json; charset=utf-8',       

                data: { url: pageurl},

                success: function (data) {              

                    DelPDF('/upload/print/' + $.trim(invid) + '.pdf');                   

                    window.location.href = '/upload/print/' + $.trim(invid) + '.pdf';                          

                }

            });          

        }

 

function DelPDF(path) 
{          

            $.ajax({

                url: '/Common/DeleteCommonFile?path=' + path,

                type: "POST",

                contentType: false, // Not to set any content header

                processData: false, // Not to process data           

                 success: function (result) {

                    //Update Extension
                    if (result.sMessage == "1")
                    {
   

                    }
                    else
                        alert(result.sMessage);

                },
                error: function (abc) {
                    alert(abc.statusText); 

                }

            });

}

Step 4

Controller C# code

public JsonResult htmltopdf(string url,string inv)

        {

            // instantiate a html to pdf converter object

            HtmlToPdf converter = new HtmlToPdf(); 

            // create a new pdf document converting an url
            PdfDocument doc = converter.ConvertUrl(url); 

            // save pdf document

            doc.Save(Server.MapPath("~/upload/print/" + inv + ".pdf")); 

            // close pdf document

            doc.Close();

            return Json(new { sMessage = "11"}, JsonRequestBehavior.AllowGet); 

        }

 

[HttpPost]

        public JsonResult DeleteCommonFile(string path)
        {

            try
            {

                string filename = Server.MapPath(path);
                if (System.IO.File.Exists(filename))
                {

                    System.IO.File.Delete(filename);

                } 

                return Json(new { sMessage = "1", JsonRequestBehavior.AllowGet });

            }

            catch (Exception ex)
            {

                return Json(new { sMessage = ex.Message, JsonRequestBehavior.AllowGet });

            }

        }


Wednesday 12 October 2022

E-Commerce Website IGNOU Synopsis



Download E-Commerce IGNO Synopsis

इस पेज पर आप इ-कॉमर्स टॉपिक पर इग्नू के लिए सिनोप्सिस डाउनलोड क्र सकते  है।  इ-कॉमर्स प्रोजेक्ट सिनोप्सिस इग्नू के द्वारा दिए गए निर्देशों के अनुरूप बनाया गया है।  ये प्रोजेक्ट सिनोप्सिस इग्नू में उपयोग किया जा सकता है , क्योकि इग्नू द्वारा दिए गए सिनोप्सिस सैंपल  के सारे  पॉइंट को कवर किया गया है। 


On this page, you can download Synopsis for IGNOU on the E-commerce topic. The e-commerce project synopsis is designed as per the instructions given by IGNOU. This project synopsis can be used in IGNOU, as all the points of the synopsis sample given by IGNOU are covered.

Saturday 8 October 2022

IGNOU Synopsis Computer Science

Get MCA project synopsis for IGNOU . All Synopsis on this page are made as per the IGNOU guidline . All points are covered. PDF and editable word both version are available . PDF is free and editable word version is paid and can be modified if required. List synopis on different topics are given below.

IGNOU  Project Guidline


Download IGNOU MCA/BCA Synopsis

 Next Synopsis

Wednesday 21 September 2022

Delete Record Entity Framework C# | ASP.Net MVC

dbConnection db = new dbConnection();

db.WebMsg.Remove(db.WebMsg.Single(x => x.ID == 123));

 Next Topic

Wednesday 14 September 2022

Update Table CodeIgniter

 $DataModel  =new \App\Models\NewsModel();

$DataModel->set('FileName','jpg');

$DataModel->where('id', 101);

$DataModel->update();


Next Topic

File Upload with new name Codeigniter

 HTML

<form method="post"  action="<?php echo site_url('/Admin/newsadddb'); ?>" enctype="multipart/form-data">

 <input type="file" name="NewsFile" id="NewsFile" style="display:none">

<input type="submit" name="submit" value="Save" class="btn btn-danger" >

</form>

Monday 12 September 2022

Aggregate Function Entity Framework C#

 Sum 

Get Sum of amount by a select filter using C# MVC Entity Framework


First Method

 dbConnection db = new dbConnection();
 int InvoiceAmount = db.Bill.Where(x => x.CID == 123).Select(i => i.Amount).Sum();


Second Method


data.Where(x => x.msg == "paid").Sum(y => Convert.ToInt32(y.Amount));


Next Topic

Thursday 28 July 2022

PHP Date Manipulation


Convert Date in dd/mm/yyyy (28-07-2022) format coming from database.

 echo date("d-m-Y", strtotime($item['CreatedDate']));

Next Topic

Monday 11 July 2022

Google Recaptcha Integration | PHP , ASP.NET C# , Codeiginater 4

 




Wednesday 6 July 2022

Google Captcha Integration in Codeiginater 4

 Step 1 : 

    Signup to Google Recaptcha and get the public and private key.

Step 2 :

    Make a Model named CaptchaResponse in Model folder and add the given code below.

Monday 4 July 2022

Delete from database in Codeiginater 4

Function

 public function DelContact($field,$val)

    {       

         $db = new ContactModel();

         $db->where($field,$val)->delete();

       return redirect()->to(site_url('admin/contact'));

    }


Calling

<a href="<?php echo site_url('admin/DelContact/ID/123'); ?>" onclick="return confirm('Are you sure to delete this record')">


Next Topic

Saturday 2 July 2022

Get Data through Model in Codeigniter 4

Table Structure



 Model

<?php

namespace App\Models;
use CodeIgniter\Model;
class ContactModel extends Model
{
      protected $table='holywebcontact';
       protected $primaryKey = 'ID';
       protected $allowedFields = ['ID', 'Name', 'Phone', 'Message', 'CreatedDate'];     

}

Controller

<?php 

namespace App\Controllers;
use App\Models\ContactModel;
class Home extends BaseController
{

     public function dataread()
    {

        $data['title'] = 'DB Get Demo';
       $crudModel = new ContactModel();
        $data['user_data'] = $crudModel->findAll(); 
        return view('tmp2', $data);

    }

}

Note: Below is a list of some different types of conditions/filters for data access.
 
$data['user_data'] = $crudModel->where('id>=','5')->orderBy('id', 'DESC')->paginate(5);

 $data['user_data'] = $crudModel->where('id>=','5','phone','22')->orderBy('id', 'DESC')->paginate(5);

$data["model"]=$album->where('AlbumID', $aid)->findAll();


Get All record with ouder by clause

$data=$GalleryModel->orderBy('ID', 'DESC')->findAll();

View

<?php

foreach ($model as $item)
{
       echo $item["ID"] . "," . $item['Name'] . "<br>";
}

?>

Next Topic

Friday 1 July 2022

Record Save Using Entity Framework

Read Basics of Entity Framework on my previous post for understand this example.

EntityFramework Basics


Date Save Code

 dbConnection db = new dbConnection();

db.Bill.Add(data);

db.SaveChanges();


Next Topic

Wednesday 29 June 2022

Unable to write in session folder in windows 10 using Codeigniter 4

 This post is applied on following Codeigniter Error

  • Unable to write in session folder in windows 10 using Codeigniter 4
  •  SYSTEMPATH\Session\Handlers\FileHandler.php at line 102
  •  Uncaught Exception: Session: Configured save path
  • CodeIgniter\Session\Exceptions\SessionException

Solution 

I solved this issue... for anyone experiencing this... changing permissions to anything didn't work. Somehow they had been corrupted on the actual folder so I deleted the cache folder and session folder and created new folders and replaced the contents (files ended up not being an issue). This fixed my issue.

Note: In my case, this error occurred due to google cloud backup because I was working simultaneously while the backup is running and Google Backup corrupted the session folder. 

Thursday 23 June 2022

Celebrating 10 Years Anniversary SVG Animation

 Celebrating 10 Years Anniversary SVG Animation




Step to create and animate SVG File

SVG is numeric formate of graphic representation. You can create SVG files easily using Coral Draw. Create a graphic in the coral draw and export it in SVG format. One's SVG file was extracted. You will get the code of the entire file in SVG format.

Apply CSS animation code as you apply in HTML file

HTML File Code : 

<html>

<head>

    <title>SVG</title>

</head>

<body>

    <style>

     

    </style>

    <object data="akt.svg" width="500" height="500"> </object>

    <p class="rotate">Lorem</p>

</body>

</html>

Friday 3 June 2022

Microsoft Access Read/Write on Plesk Windows Server C# ASP.NET




Microsoft Access database crud operations are mostly done by the ACE driver which works offline smoothly but when you run your application online especially on the windows server through Plesk. The ACE driver is not supported by the mostly windows server and MS Access is also not recommended for online applications. But in some circumstances, there is a need to run it online mostly, in the case of running an offline application online to enhance customer services. This post will help you that how can you run the MS Access application on a windows server using the Plesk server interface.  I will show you to connect your application using ODBC server and perform read/write operations in MS Access in the Windows Server Plesk server interface. 

Monday 23 May 2022

Multiple Condition Entity framework toList Method | ASP.Net C# MVC

Hi, This post will show you, How to apply multiple or complicated condition with Entity framwork dbContext toList method using the where clause. If you are coming first time to this post, please read my post for Entity Framework Introduction. Example of this post-based Entity Framework Introduction. 

Friday 20 May 2022

Introduction Entity Framework for Begina record display | ASP.NET MVC C#

Entity Framework (EF)

Entity Framework (EF) is developed by Microsoft which automates the database insert,Update,select and delete (CRUD) operations without manually coding. ER increase the development time because database-related task is done without long code. 

This post will help you understand ER operation. This post is designed for beginners as well as experts both. Step by step instruction is given to display records from SQL Server. 

Friday 8 April 2022

Send Whatapp message from contact form | PHP

 

PHP Code

<?php

if(isset($_POST['submit']))
{

 

$str="https://wa.me/+91-9795000000?text=";

$str.="Roll%20:%20" . preg_replace('/ /','%20',$_POST['Roll']);

$str.= ",Name%20:%20. preg_replace('/ /','%20',$_POST['Name']);

$str.=",City%20:%20" . preg_replace('/ /','%20',$_POST['City']);

header("Location: $str");
}

?>          


HTML

<form method="post" style="margin:4%">

 

    <input type="text" name="Roll" /><br />

    <input type="text" name="Name" /><br />

    <input type="text" name="City" /><br />

    <input type="submit" name="submit" value="Send" />

 

</form>