public ActionResult Delete(Custdet_1288 cst)
{
try {
castleaccount33 ccc = db.castleaccount33.Where(x => x.CustomerId == cst.custid).FirstOrDefault();
if (ccc != null)
{
TempData["not"] = "Delete Operation unSuccessful as customer has an account";
return(RedirectToAction("Viewdet"));
}
else
{
int rows = db.delete_castle(cst.custid);
if (rows > 0)
{
TempData["second"] = "Delete Operation Successful";
return(RedirectToAction("Viewdet"));
}
else
{
ViewBag.Message = "Delete Operation Failed";
return(View("Error"));
}
}
}catch (Exception e)
{
ViewBag.Message = "Delete Operation Failed";
return(View("Error"));
}
}
public ActionResult edit_customer(Custdet_1288 objj /*,string event1, string city1, string city2*/)
{
try {
//objj.state = event1;
//objj.city = city1 != "--Select--" ? city1 : city2;
//var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
ObjectParameter para = new ObjectParameter("custid", typeof(int));
para.Value = 0;
int rows = db.update_customer(para, objj.custSsnId, objj.custName, objj.Age, objj.Address1, objj.Address2, objj.city, objj.state);
if (rows > 0)
{
TempData["second"] = "Edit successful";
return(RedirectToAction("Viewdet"));
}
else
{
ViewBag.Message = "Edit Failed";
return(View("Error"));
}
}
else
{
return(View("Error"));
}
}
catch (Exception e)
{
return(View("Error"));
}
}
public ActionResult AddCustDet()
{
try
{
Custdet_1288 obj = new Custdet_1288();
List <SelectListItem> lst2 = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "Vizag", Value = "Vizag"
},
new SelectListItem()
{
Text = "Jaipur", Value = "Jaipur"
},
new SelectListItem()
{
Text = "Kochi", Value = "Kochi"
},
new SelectListItem()
{
Text = "Amritsar", Value = "Amritsar"
}
};
List <SelectListItem> lst1 = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "A.P", Value = "A.P"
},
new SelectListItem()
{
Text = "Rajasthan", Value = "Rajasthan"
},
new SelectListItem()
{
Text = "Kerala", Value = "Kerala"
},
new SelectListItem()
{
Text = "Punjab", Value = "Punjab"
}
};
obj.lst2 = lst2;
obj.lst1 = lst1;
return(View(obj));
}
catch (Exception e)
{
return(View("Error"));
}
}
public ActionResult Delete(int id)
{
try
{
Custdet_1288 cst = db.Custdet_1288.Where(x => x.custid == id).FirstOrDefault();
return(View(cst));
}
catch (Exception e)
{
return(View("Error"));
}
}
public ActionResult searchdetails()
{
int abb = int.Parse(Session["abb"].ToString());
Custdet_1288 cust = db.Custdet_1288.Where(x => x.custid == abb).FirstOrDefault();
ViewBag.cid = cust.custid;
ViewBag.ssnid = cust.custSsnId;
ViewBag.nm = cust.custName;
ViewBag.ag = cust.Age;
ViewBag.ad = cust.Address1;
ViewBag.add = cust.Address2;
return(View());
}
public ActionResult edit_customer(int id)
{
// if (Session["check"].ToString() != "primeadmin")
// {
List <SelectListItem> lst2 = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "Vizag", Value = "Vizag"
},
new SelectListItem()
{
Text = "Jaipur", Value = "Jaipur"
},
new SelectListItem()
{
Text = "Kochi", Value = "Kochi"
},
new SelectListItem()
{
Text = "Amritsar", Value = "Amritsar"
}
};
List <SelectListItem> lst1 = new List <SelectListItem>
()
{
new SelectListItem()
{
Text = "A.P", Value = "A.P"
},
new SelectListItem()
{
Text = "Rajasthan", Value = "Rajasthan"
},
new SelectListItem()
{
Text = "Kerala", Value = "Kerala"
},
new SelectListItem()
{
Text = "Punjab", Value = "Punjab"
}
};
Custdet_1288 objj = db.Custdet_1288.Where(x => x.custid == id).FirstOrDefault();
ViewBag.one = objj.custName;
ViewBag.two = objj.Age;
ViewBag.three = objj.Address1;
ViewBag.four = objj.Address2;
objj.lst2 = lst2;
objj.lst1 = lst1;
if (objj != null)
{
return(View(objj));
}
else
{
return(View("Error"));
}
// }
// else
//{
//return View("login");
//}
}
public ActionResult AddCustDet(Custdet_1288 obj1 /*, string event1, string city1, string city2*/)
{
try {
//if (Session["check"].ToString() != "primeadmin")
//{
List <SelectListItem> lst2 = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "Vizag", Value = "Vizag"
},
new SelectListItem()
{
Text = "Jaipur", Value = "Jaipur"
},
new SelectListItem()
{
Text = "Kochi", Value = "Kochi"
},
new SelectListItem()
{
Text = "Amritsar", Value = "Amritsar"
}
};
List <SelectListItem> lst1 = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "A.P", Value = "A.P"
},
new SelectListItem()
{
Text = "Rajasthan", Value = "Rajasthan"
},
new SelectListItem()
{
Text = "Kerala", Value = "Kerala"
},
new SelectListItem()
{
Text = "Punjab", Value = "Punjab"
}
};
obj1.lst2 = lst2;
obj1.lst1 = lst1;
// obj1.state = event1;
//obj1.city = city1 != "--Select--" ? city1 : city2;
//var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
if (!db.Custdet_1288.Select(x => x.custSsnId == obj1.custSsnId).FirstOrDefault())
{
ObjectParameter objParam = new ObjectParameter("custid", typeof(int));
objParam.Value = 0;
db.sp_Custdet_1288(objParam, obj1.custSsnId, obj1.custName, obj1.Age, obj1.Address1, obj1.Address2, obj1.city, obj1.state, obj1.DisplayMessage = "Customer added successfully", obj1.AccountStatus = "Active");
int custid = (int)objParam.Value;
TempData["first"] = "Customer Id " + custid + " added successfully";
return(RedirectToAction("Viewdet"));
}
else
{
TempData["exx"] = "enter a unique ssn id";
return(View("Error"));
}
}
else
{
return(View());
}
}
// else
// {
// return View("login");
// }
// }
catch (Exception e)
{
TempData["exx"] = "enter a unique ssn id";
return(View("Error"));
}
}
