Asp Tutorial Beginner

public JsonResult LoginProcess(string UserName, string Password)
{
try
{
List_userlist = db.Sec_User2.ToList();
if (_userlist != null && _userlist.Count>0)
{
_userlist = _userlist.Where(a => a.User_id == UserName && a.User_password == Password).ToList();
if (_userlist != null && _userlist.Count>0)
{
Session["UserId"] = UserName;
return Json(new { login=true, success = true, data = "Customer/Index", message = "123" }, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { login = false, success = false, data = "", message = "Invalid Login"}, JsonRequestBehavior.AllowGet);
}
}
else {
return Json(new { login = false, success = false, data = "", message = "Please Register" }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
return Json(new { login = false, success = false, data = "", message = ex.Message }, JsonRequestBehavior.AllowGet);
}
}

jQuery(document).ready(function () {
jQuery(".btn-login-click").click(function (evt) {
evt.preventDefault();
var UserName = jQuery("#User_id").val();
var Password = jQuery("#User_password").val();
jQuery.ajax({
cache: false,
type: "GET",
url: "/Login/LoginProcess",
data: { UserName: UserName, Password: Password },
success: function (result) {
if (result.login == true) {
if (result.success == true) {
window.location.href = result.data;
} else {
alert(result.message);
}
} else {
//Logout();
}
}
});
});
});

public JsonResult SaveCustomer(string Firstname, string LastName, string FullName, string Mobile, string CusCode)
{ try
{ if (CusCode == "")
{ //create
mst_bussentity ob = new mst_bussentity();
ob.mbe_act = 1;
ob.mbe_cre_by = Session["UserId"].ToString();
ob.mbe_cre_dt = DateTime.Now;
ob.mbe_fname = Firstname;
ob.mbe_fullname = FullName;
ob.mbe_lmane = LastName;
ob.mbe_mob = Mobile;
ob.mbe_mod_by = Session["UserId"].ToString();
ob.mbe_mod_dt = DateTime.Now;
decimal maxseq = 0;
List
list = db.mst_bussentity.ToList();
if (list != null)
{
if (list.Count > 0)
{
maxseq = db.mst_bussentity.Max(a => a.mbe_seq) + 1;
if (maxseq == 0) maxseq = 1;
}
}
ob.mbe_code = "CUS-" + Convert.ToInt64(maxseq.ToString()).ToString();
db.mst_bussentity.Add(ob);
db.SaveChanges();
return Json(new { login = true, success = true, data = "", message = "Successfully Saved ! Customer Code - "+ ob.mbe_code }, JsonRequestBehavior.AllowGet);
}
else
{
//update
mst_bussentity ob = new mst_bussentity
ob.mbe_act = 1;
ob.mbe_cre_by = Session["UserId"].ToString();
ob.mbe_cre_dt = DateTime.Now;
ob.mbe_fname = Firstname;
ob.mbe_fullname = FullName;
ob.mbe_lmane = LastName;
ob.mbe_mob = Mobile;
ob.mbe_mod_by = Session["UserId"].ToString();
ob.mbe_mod_dt = DateTime.Now;
ob.mbe_code = CusCode;
db.Entry(ob).State = EntityState.Modified;
db.SaveChanges();
return Json(new { login = true, success = true, data = "", message = "Successfully Updated ! Customer Code - " + ob.mbe_code }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
return Json(new { login = false, success = false, data = "", message = ex.Message }, JsonRequestBehavior.AllowGet);
}
}

jQuery(".btn-cust-save").click(function (evt) {
evt.preventDefault();
var Firstname = jQuery("#mbe_fname").val();
var LastName = jQuery("#mbe_lmane").val();
var FullName = jQuery("#mbe_fullname").val();
var Mobile = jQuery("#mbe_mob").val();
var CusCode = jQuery("#mbe_code").val();
if (Firstname=="")
{
alert("Please Enter First Name");
return;
} if (LastName == "") {
alert("Please Enter Last Name");
return;
} if (FullName == "") {
alert("Please Enter Full Name");
return;
} if (Mobile == "") {
alert("Please Enter Mobile");
return;
}
jQuery.ajax({
cache: false,
type: "GET",
url: "/Customer/SaveCustomer",
data: { Firstname: Firstname, LastName: LastName, FullName: FullName, Mobile: Mobile, CusCode: CusCode },
success: function (result) {
if (result.login == true) {
if (result.success == true) {
alert(result.message);
} else {
alert(result.message);
}
} else {
//Logout();
}
}
});
});
$('input#mbe_mob').blur(function () {
var num = parseFloat($(this).val());
var cleanNum = num.toFixed();
if (cleanNum == "NaN") {
// cleanNum = 0;
alert("Invalid Mobile");
jQuery("#mbe_mob").val("");
return;
}
if (Number(cleanNum) < 0) {
// cleanNum = 0;
alert("Invalid Mobile");
jQuery("#mbe_mob").val("");
return;
}
// $(this).val(cleanNum);
});
$('#mbe_code').focusout(function () {
jQuery.ajax({
cache: false,
type: "GET",
url: "/Customer/LoadData",
data: { CusCode: jQuery("#mbe_code").val() },
success: function (result) {
if (result.login == true) {
if (result.success == true) {
Binddata(result.data);
} else {
alert(result.message);
jQuery("#mbe_code").val("");
return;
}
} else {
// Logout();
}
}
});
});
function Binddata(data)
{
jQuery("#mbe_fullname").val(data[0].mbe_fullname);
jQuery("#mbe_fname").val(data[0].mbe_fname);
jQuery("#mbe_lmane").val(data[0].mbe_lmane);
jQuery("#mbe_mob").val(data[0].mbe_mob);
}
jQuery("#mbe_fname").on("input", function () {
var Firstname = jQuery("#mbe_fname").val();
var LastName = jQuery("#mbe_lmane").val();
var FullName = Firstname + " " + LastName;
jQuery("#mbe_fullname").val(FullName);
});

div class="row"
div class="col-md-12"
div class="comm-pc-div-scroll"
table class="table table-striped table-hover item-row"
tr
th style="color: black; font-size: x-small">Item Codeth
th style="color: black; font-size: x-small">Priceth
th style="color: black; font-size: x-small">Qtyth
th style="color: black; font-size: x-small">Totalth
th>th
tr
table
div
div
div

function Updategrid(data) {
jQuery('.item-row .new-row').remove();
if (data.length > 0) {
for (i = 0; i < data.length; i++) {
jQuery('.item-row').append('tr class="new-row">
' + ' td' + data[i].sad_item + '' +
' td' + data[i].sad_price + '' +
' td' + data[i].sad_qty + '' +
' td' + data[i].sad_total + '' +
' td style="text-align:center;" input type="button" value="Remove" class="btn btn-default btn-del-items" tdn' +
' tr');
}
RemoveItemCodeFunction();
}
}
function RemoveItemCodeFunction() {
jQuery(".btn-del-items").unbind('click').click(function (evt) {
evt.preventDefault();
var td = jQuery(this).parent('td');
var tr = jQuery(td).parent('tr');
var item = jQuery(tr).find('td:eq(0)').html();
var price = jQuery(tr).find('td:eq(2)').html();
jQuery.ajax({
type: "GET",
url: "/Invoice/RemoveItemCode",
data: { item: item, price: price },
contentType: "application/json;charset=utf-8",
dataType: "json",
success: function (result) {
if (result.login == true) {
if (result.success == true) {
Updategrid(result.data);
}
} else {
// Logout();
}
}
});
});
}

public JsonResult AddItem(string Item, string Price, string Qty, string Total)
{
try
{
List
_list = Session["sat_item"] as List
;
if (_list != null && _list.Count > 0)
{
sat_item ob = new sat_item();
ob.sad_item = Item;
ob.sad_price = Convert.ToDecimal(Price);
ob.sad_qty = Convert.ToDecimal(Qty);
ob.sad_total = Convert.ToDecimal(Total);
_list.Add(ob);
_list = _list.GroupBy(l => new { l.sad_item, l.sad_price })
.Select(cl => new sat_item
{
sad_item = cl.First().sad_item,
sad_price = cl.First().sad_price,
sad_qty = cl.Sum(a => a.sad_qty),
sad_total = cl.Sum(a => a.sad_total),
}).ToList();
Session["sat_item"] = _list;
return Json(new { login = true, success = true, data = _list, message = "Sucessfully Added" }, JsonRequestBehavior.AllowGet);
}
else {
_list = new List
();
sat_item ob = new sat_item();
ob.sad_item = Item;
ob.sad_price = Convert.ToDecimal(Price);
ob.sad_qty = Convert.ToDecimal(Qty);
ob.sad_total = Convert.ToDecimal(Total);
_list.Add(ob);
Session["sat_item"] = _list;
return Json(new { login = true, success = true, data = _list, message = "Sucessfully Added" }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
return Json(new { login = false, success = false, data = "", message = ex.Message }, JsonRequestBehavior.AllowGet);
}
}
public JsonResult RemoveItemCode(string item, string price)
{
try
{
List
_list = Session["sat_item"] as List
; sat_item ob = new sat_item();
var itemToRemove = _list.First(r => r.sad_item == item && r.sad_price==Convert.ToDecimal(price));
_list.Remove(itemToRemove);
Session["sat_item"] = _list;
return Json(new { login = true, success = true, data = _list, message = "Sucessfully Removed" }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { login = false, success = false, data = "", message = ex.Message }, JsonRequestBehavior.AllowGet);
}
}

ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("/Reports/" + "SalesExContribution.rpt"));
rd.Database.Tables["SalesExContribution"].SetDataSource(_finaldt);
rd.Database.Tables["param"].SetDataSource(param);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
this.Response.Clear();
this.Response.ContentType = "application/pdf";
Response.AppendHeader("Content-Disposition", "inline; filename=ExecutiveTarget.pdf");
return File(rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat), "application/pdf");