Friday, 2 February 2018

MongoDB CRUD Operations

MongoDB CRUD Operations

 CREATE DATABASE IN mongoDB

  MongoDB use DATABASE_NAME is used to create database. The command will create a new database if it doesn't exist, otherwise it will return the existing database.

Syntax

syntax of create database is as follows - e.g. : use DataBaseName
Like :- use TestDB


Note :- CURD means  create, read, update, and delete

1 :- CREATE COLLECTION

MongoDB createCollection(name, options) is used to create collection.

e.g :- db.createCollection("Student", { size: 2147483648 } )



2 :- CREATE OPERATIONS
                       
syntax :- 1) db.collection.insertOne()
              2) db.collection.insertMany()  


Note:- (INSERT Data into Collection)

e.g :-1--) if insert one record

 db.Student.insertOne( { name: "mohan", class: "BCA", rollno :5} );

e.g :- 2--) if insert multiple record at one time

db.Student.insertMany( [
        { name: "mohan", class: "BCA", rollno :5},
        { name: "sohan", class: "MBA", rollno :15},
        { name: "ram", class: "BBA", rollno :10},
        { name: "shyam", class: "MCA", rollno :25},
   ] );


3 :- READ OPERATIONS

syntax : db.collection.find(query, projection)

e.g :- db.Student.find()

e.g :-1) db.Student.find({ name: "shyam" })

e.g :-2) db.Student.find( { rollno : 5 } )


4 :- UPDATE OPERATIONS


syntax :- db.collection.update(selectQuery, udateQuery)

e.g :-1 ) 

db.Student.update({'name':'shyam'},{$set:{'name':'shyam kumar'}})

db.Student.update({'id':'2'},{$set:{'name':'Mohan kumar'}})

e.g :-2) 

Note:- update class where rollno is greater than 10

db.Student.updateMany(
      { rollno : { $gt: 10 } },
      { $set: { "class" : 'PHD'} }
   );

5 :- DELETE OPERATIONS

syntax :-1 ) db.collection.deleteOne()
           :-2 ) db.collection.deleteMany()

e.g:- 1)

db.Student.deleteOne( { rollno : 4 } )




Wednesday, 7 June 2017

Call Other Page Using Ajax API

Call Other Page Using Ajax API



Let's Example :- Call other page on current page

First Page :- CallAjaxPage.aspx
Second Page :- AjaxExample.aspx

I want to call AjaxExample page on particular div of CallAjaxPage

Code of CallAjaxPage



<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CallAjaxPage.aspx.cs" Inherits="VIJAYRNDWebApp.CallAjaxPage" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="Scripts/AjaxAPI.js"></script>
    <script>
        function callAjaxpaGE() {

            var url = "AjaxExample.aspx";

              //Pass flag,divId,pageAddress
            fnCallAjaxAPI(1, 'otherPageLoad', url);

        }

    </script>
</head>
<body>
    <form id="form1" runat="server">
        <input type="button" value="call" onclick="callAjaxpaGE()" />
    <div id="otherPageLoad" onload="callAjaxpaGE();">
    
    </div>
    </form>
</body>
</html>

Code of AjaxExample


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="AjaxExample.aspx.cs" Inherits="VIJAYRNDWebApp.AjaxExample" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h3>Welcome on AJAX PAGE </h3>
    </div>
    </form>
</body>
</html>



USING AJAX API
-----------------------------------------------------------------------------------
//Function XHConn
function XHConn() {
    var xmlhttp, bComplete = false;
    try { xmlhttp = new ActiveXObject("Msxml2.XMLHTTP"); }
    catch (e) {
        try { xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); }
        catch (e) {
            try { xmlhttp = new XMLHttpRequest(); }
            catch (e) { xmlhttp = false; }
        }
    }
    if (!xmlhttp) return null;
    this.connect = function (sURL, sMethod, sVars, fnDone) {
        if (!xmlhttp) return false;
        bComplete = false;
        sMethod = sMethod.toUpperCase();
        try {
            if (sMethod == "GET") {
                xmlhttp.open(sMethod, sURL + "?" + sVars, true);
                sVars = "";
            }
            else {
                xmlhttp.open(sMethod, sURL, true);
                xmlhttp.setRequestHeader("Method", "POST " + sURL + " HTTP/1.1");
                xmlhttp.setRequestHeader("Content-Type",
                  "application/x-www-form-urlencoded");
            }
            xmlhttp.onreadystatechange = function () {
                if (xmlhttp.readyState == 4 && !bComplete) {
                    bComplete = true;
                    fnDone(xmlhttp);
                }
            };
            xmlhttp.send(sVars);
        }
        catch (z) { return false; }
        return true;
    };
    return this;
}


//
//
var GetCntlrResponse = function (oXML) {
    var response = oXML.responseText;
    document.getElementById(CurrDivName).innerHTML = response;

};

var doAJAXCall = function (PageURL, ReqType, PostStr, FunctionName) {
    var myConn = new XHConn();
    if (myConn) {
        myConn.connect('' + PageURL + '', '' + ReqType + '', '' + PostStr + '', FunctionName);
    }
    else {
        alert("XMLHTTP not available. Try a newer/better browser, this application will not work!");
    }
}


//Call Function 
function fnCallAjaxAPI(flg, divName, myUrl) {
    CurrDivName = divName;
    var PostStr = "";
    doAJAXCall(myUrl, 'POST', '' + PostStr + '', GetCntlrResponse);
}

------------------------------------------------------------------------------------------------


Insert Update Delete in MVC

Insert Update Delete in MVC 

For Insert


See example by using this link.


For Update & Delete

--------------------

Code of View Page of Grid View Details


@model IEnumerable<VijayMVCWebApp.Models.UserNewReg>

@{
    ViewBag.Title = "UserGridList";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>UserGridList</h2>

<table id="tblCustomers" cellpadding="0" cellspacing="0" class="table">
    <tr>
        <th>Name</th>
        <th>Gender</th>
        <th>EmailId</th>
        <th>Password</th>
        <th>MobileNo</th>
        <th>Action</th>
    </tr>
    @foreach (var customer in Model)
    {
        <tr>
            <td class="Name"><span>@customer.Name</span><input type="text" value="@customer.Name" style="display:none" /></td>
            <td class="Gender"><span>@customer.Gender</span><input type="text" value="@customer.Gender" style="display:none" /></td>
            <td class="EmailId"><span>@customer.EmailId</span><input type="text" value="@customer.EmailId" style="display:none" /></td>
            <td class="Password"><span>@customer.Password</span><input type="text" value="@customer.Password" style="display:none" /></td>
            <td class="MobileNo"><span>@customer.MobileNo</span><input type="text" value="@customer.MobileNo" style="display:none" /></td>
            <td>
                <a class="Edit" href="javascript:;">Edit</a>
                <a class="Update" href="javascript:;" style="display:none">Update</a>
                <a class="Cancel" href="javascript:;" style="display:none">Cancel</a>
                <a class="Delete" href="javascript:;">Delete</a>
            </td>
        </tr>

    }
</table>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.cdnjs.com/ajax/libs/json2/20110223/json2.js"></script>
<script type="text/javascript">
   
    //Edit event handler.
    $("body").on("click", "#tblCustomers .Edit", function () {
        var row = $(this).closest("tr");
        $("td", row).each(function () {
            if ($(this).find("input").length > 0) {
                $(this).find("input").show();
                $(this).find("span").hide();
            }
        });
        row.find(".Update").show();
        row.find(".Cancel").show();
        row.find(".Delete").hide();
        $(this).hide();
    });

    //Update event handler.
    $("body").on("click", "#tblCustomers .Update", function () {
        var row = $(this).closest("tr");
        $("td", row).each(function () {
            if ($(this).find("input").length > 0) {
                var span = $(this).find("span");
                var input = $(this).find("input");
                span.html(input.val());
                span.show();
                input.hide();
            }
        });
        row.find(".Edit").show();
        row.find(".Delete").show();
        row.find(".Cancel").hide();
        $(this).hide();

        var customer = {};
        customer.Name = row.find(".Name").find("span").html();
        customer.Gender = row.find(".Gender").find("span").html();
        customer.EmailId = row.find(".EmailId").find("span").html();
        customer.Password = row.find(".Password").find("span").html();
        customer.MobileNo = row.find(".MobileNo").find("span").html();
        $.ajax({
            type: "POST",
            url: "/Home/UpdateCustomer",
            data: '{customer:' + JSON.stringify(customer) + '}',
            contentType: "application/json; charset=utf-8",
            dataType: "json"
        });
    });

    //Cancel event handler.
    $("body").on("click", "#tblCustomers .Cancel", function () {
        var row = $(this).closest("tr");
        $("td", row).each(function () {
            if ($(this).find("input").length > 0) {
                var span = $(this).find("span");
                var input = $(this).find("input");
                input.val(span.html());
                span.show();
                input.hide();
            }
        });
        row.find(".Edit").show();
        row.find(".Delete").show();
        row.find(".Update").hide();
        $(this).hide();
    });

    //Delete event handler.
    $("body").on("click", "#tblCustomers .Delete", function () {
        if (confirm("Do you want to delete this row?")) {
            var row = $(this).closest("tr");
            var emailID = row.find(".EmailId").find("span").html();
            $.ajax({
                type: "POST",
                url: "/Home/DeleteCustomer",
                data: '{emailid: ' + emailID + '}',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (response) {
                    row.remove();
                }
            });
        }
    });
</script>


=================================================

Add Function in Home Controller



FOR UPDATE & DELETE

//UPDATE
-----------------------------------------------------------------------------------
        [HttpPost]
        public ActionResult UpdateCustomer(UserNewReg customer)
        {
            using (DotNetDBEntities entities = new DotNetDBEntities())
            {
                UserNewReg updatedCustomer = (from c in entities.UserNewRegs
                                              where c.EmailId == customer.EmailId
                                            select c).FirstOrDefault();
                updatedCustomer.Name = customer.Name;
                updatedCustomer.MobileNo = customer.MobileNo;
                updatedCustomer.EmailId = customer.EmailId;
                updatedCustomer.Password = customer.Password;
                entities.SaveChanges();
            }

            return new EmptyResult();
        }

--------------------------------------------------------------------------------------
DELETE

        [HttpPost]
        public ActionResult DeleteCustomer(string emailid)
        {
            using (DotNetDBEntities entities = new DotNetDBEntities())
            {
                UserNewReg customer = (from c in entities.UserNewRegs
                                       where c.EmailId == emailid
                                       select c).FirstOrDefault();
                entities.UserNewRegs.Remove(customer);
                entities.SaveChanges();
            }
            return new EmptyResult();
        }

--------------------------------------------------------------------------------------
SEE OUTPUT 





Monday, 5 June 2017

Registration Page Using MVC

Registration Form & Bind Grid view Using MVC

Step 1st :- Use SQL Server


-- Create Table 


CREATE TABLE UserNewReg
(
Name varchar(50),
Gender varchar(50),
EmailId varchar(50) primary key ,
Password varchar(50),
MobileNo varchar(50)
);

Step 2nd :- Use Visual Basic 2013

--- Create Emplty MVC Project (VijayMVCWebApp)




1--- First Create Model Class



2----Second  Add Validation (UserNewReg.cs)


 public partial class UserNewReg
    {

        [Required(ErrorMessage = "Enter Name.")]
        public string Name { get; set; }

        [Required(ErrorMessage = "Enter Gender.")]
        public string Gender { get; set; }

        [Required(ErrorMessage = "Enter  Email-id.")]
        [EmailAddress(ErrorMessage = "Invalid email address.")]
        public string EmailId { get; set; }

        [Required(ErrorMessage = "Enter Password.")]
        public string Password { get; set; }

        [Required(ErrorMessage = "Enter MobileNumber.")]
        public string MobileNo { get; set; }

    }



3---- Add Controller ("HomeContoller")




using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using VijayMVCWebApp.Models;

namespace VijayMVCWebApp.Controllers
{
    public class HomeController : Controller
    {
        // GET: Home
        public ActionResult Index()
        {
            return View();
        }

        //Create Object of DataBase
        DotNetDBEntities db = new DotNetDBEntities();

         //For New Registration
        public ActionResult NewUserAdd()
        {
            return View();
        }

        //Save New USer
        [HttpPost]
        public ActionResult NewUserAdd(UserNewReg emp)
        {
            db.UserNewRegs.Add(emp);
            db.SaveChanges();
            return View();
        }

       //Show User GridView
        public ActionResult UserGridList()
        {
            return View(from user in db.UserNewRegs.Take(10)
                        select user );
            //return View();
        }


    }
}


Note :- Create View as exaple As below Image




eg.:-Code of View(Bind Gridview)  UserGridList.cshtml


@model IEnumerable<VijayMVCWebApp.Models.UserNewReg>

@{
    ViewBag.Title = "UserGridList";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>UserGridList</h2>

<table cellpadding="0" cellspacing="0" class="table">
    <tr>
        <th>Name</th>
        <th>Gender</th>
        <th>EmailId</th>
        <th>Password</th>
        <th>MobileNo</th>
    </tr>
    @foreach (var user in Model)
    {
        <tr>
            <td>@user .Name</td>
            <td>@user .Gender</td>
            <td>@user .EmailId</td>
            <td>@user .Password</td>
            <td>@user .MobileNo</td>
        </tr>
    }
</table>


-----------------------------------------------------------------
OUTPUT
-----------------------------------------------------------------
1:- Registration form with validation


2:-User Bind  Gridview 


Saturday, 27 May 2017

Insert Update Delete Using Gridview

Insert Update Delete Using Grid-view

Step:-1 ) Using SQL Server Create Table


Create Table UserTest(
id int primary key identity(1,1),
Name nvarchar(200),
EmailId nvarchar(200),
DOB varchar(50),
City nvarchar(200),
Company nvarchar(200),
Salary int,
);

Step :- 2) Using Visual Studio Web Application


TestWebForm.aspx
-----------------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TestWebForm.aspx.cs" Inherits="TestWebApp.TestWebForm" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script>
        function validateForm() {
            var txtName = document.getElementById('txtName');
            var txtEmailId = document.getElementById('txtEmailId');
            var txtDOB = document.getElementById('txtDOB');
            var txtCity = document.getElementById('txtCity');
            var txtCompany = document.getElementById('txtCompany');
            var txtSalary = document.getElementById('txtSalary');

            if (txtName.value == '') { alert('Enter Name'); txtName.focus(); return false; }
            if (txtEmailId.value == '') { alert('Enter Email-Id'); txtEmailId.focus(); return false; }
            if (txtDOB.value == '') { alert('Enter Date of Birth'); txtDOB.focus(); return false; }
            if (txtCity.value == '') { alert('Enter City Name'); txtCity.focus(); return false; }
            if (txtCompany.value == '') { alert('Enter Company Name'); txtCompany.focus(); return false; }
            if (txtSalary.value == '') { alert('Enter Sallary'); txtSalary.focus(); return false; }
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <table>
                <tr>
                    <td>ID</td>
                    <td>
                        <input type="text" id="txtID"  readonly="true" class="inputTxt" runat="server" /></td>
                </tr>
                <tr>
                    <td>Name</td>
                    <td>
                        <input type="text" id="txtName" class="inputTxt" runat="server" /></td>
                </tr>
                <tr>
                    <td>EmailID</td>
                    <td>
                        <input type="text" id="txtEmailId" class="inputTxt" runat="server" /></td>
                </tr>
                <tr>
                    <td>Date of Birth</td>
                    <td>
                        <input type="text" id="txtDOB"  class="inputTxt" runat="server" /></td>
                </tr>
                <tr>
                    <td>City</td>
                    <td>
                        <input type="text" id="txtCity" class="inputTxt" runat="server" /></td>
                </tr>
                <tr>
                    <td>Company</td>
                    <td>
                        <input type="text" id="txtCompany" class="inputTxt" runat="server" /></td>
                </tr>
                <tr>
                    <td>Salary</td>
                    <td>
                        <input type="text" id="txtSalary" class="inputTxt" runat="server" /></td>
                </tr>
                <tr>
                    <td></td>
                    <td>
                        <asp:Button runat="server" ID="btnSave" CssClass="btn" Text="Save" OnClientClick="return validateForm()" OnClick="btnSave_Click" />
                        <asp:Button runat="server" ID="btnUpdate" CssClass="btn" Text="Update" Visible="false" OnClientClick="return validateForm()" OnClick="btnUpdate_Click" />
                        <asp:Button runat="server" ID="btnCancel" CssClass="btn" Text="Cancel" OnClick="btnCancel_Click" /></td>
                </tr>
            </table>

            <br />
            <br />
            <asp:GridView ID="grvTest" runat="server" DataKeyNames="id" OnRowDeleting="grvTest_RowDeleting" OnSelectedIndexChanged="grvTest_SelectedIndexChanged">
                <Columns>
                    <asp:CommandField HeaderText="Update" ShowSelectButton="true" />
                    <asp:CommandField HeaderText="Delete" ShowDeleteButton="true" />
                </Columns>
            </asp:GridView>
        </div>
    </form>
</body>
</html>





TestWebForm.aspx.cs
--------------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace TestWebApp
{
    public partial class TestWebForm : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=TestApp;Integrated Security=True");
        protected void Page_Load(object sender, EventArgs e)
        {
           
            if (!IsPostBack)
            {
                BindGridView();
            }

        }

        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                con.Open();
                string str = "INSERT INTO UserTest(Name,EmailId,DOB,City,Company,Salary)";
                str += " VALUES('" + txtName.Value + "','" + txtEmailId.Value + "','" + Convert.ToDateTime(txtDOB.Value) + "','" + txtCity.Value + "','" + txtCompany.Value + "','" + txtSalary.Value + "');";
                SqlCommand cmd = new SqlCommand(str, con);
                int i = cmd.ExecuteNonQuery();
                con.Close();
                resetForm();
                BindGridView();
            }
            catch (Exception)
            {

                throw;
            }
            finally
            {
               
            }
        }

        protected void btnCancel_Click(object sender, EventArgs e)
        {
            resetForm();
            Response.Redirect("TestWebForm.aspx");
        }

        public void resetForm() {
            txtCity.Value = "";
            txtCompany.Value = "";
            txtDOB.Value = "";
            txtEmailId.Value = "";
            txtID.Value = "";
            txtName.Value = "";
            txtSalary.Value = "";
        }

        public void BindGridView()
        {
            try
            {
                DataSet ds = new DataSet();
                con.Open();
                string str = "SELECT * FROM UserTest;";
                SqlCommand cmd = new SqlCommand();
                SqlDataAdapter sda = new SqlDataAdapter(str, con);
                sda.Fill(ds);
                con.Close();
                grvTest.DataSource = ds;
                grvTest.DataBind();
            }
            catch (Exception)
            {

                throw;
            }
            finally
            {
               
            }
        }

        protected void grvTest_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            try
            {
                con.Open();
                int id = Convert.ToInt32(grvTest.DataKeys[e.RowIndex].Value);
                string str = "DELETE FROM UserTest WHERE id='" + id + "'; ";
                SqlCommand cmd = new SqlCommand(str, con);
                int i = cmd.ExecuteNonQuery();
                con.Close();
                BindGridView();
            }
            catch (Exception)
            {

                throw;
            }
            finally
            {
                
            }
        }

        protected void grvTest_SelectedIndexChanged(object sender, EventArgs e)
        {
            GridViewRow newRow = grvTest.SelectedRow;
            txtID.Value = newRow.Cells[2].Text;
            txtName.Value = newRow.Cells[3].Text;
            txtEmailId.Value = newRow.Cells[4].Text;
            txtDOB.Value = newRow.Cells[5].Text;
            txtCity.Value = newRow.Cells[6].Text;
            txtCompany.Value = newRow.Cells[7].Text;
            txtSalary.Value = newRow.Cells[8].Text;
            btnSave.Visible = false;
            btnUpdate.Visible = true;
        }

        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                con.Open();
                string str = "UPDATE UserTest SET Name='" + txtName.Value + "',EmailId='" + txtEmailId.Value + "',DOB='" + txtDOB.Value + "',City='" + txtCity.Value + "',Company='" + txtCompany.Value + "',Salary='" + txtSalary.Value + "' WHERE id='" + txtID.Value + "'; ";
                SqlCommand cmd = new SqlCommand(str, con);
                int i = cmd.ExecuteNonQuery();
                con.Close();
                BindGridView();
                resetForm();
            }
            catch (Exception)
            {

                throw;
            }
            finally
            {
                
            }
        }

    }
}




Sunday, 7 May 2017

Curd Operation - Stored Procedure

Curd Operation - Stored Procedure




Use IDE :- Microsoft SQL Server - 2008 R2


=================================================================
Create Database
=================================================================

CREATE DATABASE CurdDB;

USE CurdDB;


=================================================================
Create Table
=================================================================



CREATE TABLE [dbo].[Employee](
[EmpId] [bigint] IDENTITY(1,1) NOT NULL,
[FirstName] [varchar](50) NOT NULL,
[LastName] [varchar](50) NOT NULL,
[EmpNo] [varchar](50) NOT NULL,
[Department] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED 
(
[EmpId] ASC
)
) ON [PRIMARY]



=================================================================
Select Table
=================================================================

Select * from Employee;





=================================================================
Create Procedure for Get Employees Details
=================================================================


USE [CurdDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GetEmployeeDetails]
AS
BEGIN
SELECT 
EmpId ,
FirstName ,
LastName ,
EmpNo ,
Department
FROM Employee
END









=================================================================
Create Procedure for INSERT AND UPDATE Record
=================================================================

USE [CurdDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[AddEmployee]
@EmpId BIGINT ,
@FirstName VARCHAR(50) ,
@LastName VARCHAR(150),
@EmpNo VARCHAR(50) ,
@Department VARCHAR(50)
AS

IF(@EmpId= 0)
BEGIN
INSERT INTO Employee
(
FirstName ,
LastName ,
EmpNo ,
Department
)
values
(
@FirstName ,
@LastName ,
@EmpNo ,
@Department
)
END
ELSE
BEGIN
UPDATE Employee
SET FirstName = @FirstName ,
LastName = @LastName ,
EmpNo = @EmpNo ,
Department = @Department
WHERE EmpId = @EmpId
END





=================================================================
Create Procedure for  Delete Record
=================================================================


USE [CurdDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[DeleteEmployee]
@EmpId BIGINT
AS
BEGIN
DELETE FROM Employee
WHERE EmpId = @EmpId
END


================================================================
Note :- Use these stored procedure for curd operation in application.
================================================================

Factorial of a Number

Recently Viewed