public ActionResult Delete(Int32?Stateid)
{
using (StatesCtl db = new StatesCtl()){
db.delete(Stateid);
return(RedirectToAction("Index"));
}
}
public ActionResult Create(StatesClass Obj_States, string command)
{
using (StatesCtl db = new StatesCtl()){
if (ModelState.IsValid)
{
db.insert(Obj_States);
if (command.ToLower().Trim() == "save")
{
string sesionval = Convert.ToString(Session["CreatePreviousURL"]);
if (!string.IsNullOrEmpty(sesionval))
{
Session.Remove("CreatePreviousURL");
return(Redirect(sesionval));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
ModelState.Clear();
return(View());
}
}
return(View(Obj_States));
}
}
public ActionResult EditTableRowDelete(Int32?Stateid)
{
using (StatesCtl db = new StatesCtl()){
db.delete(Stateid);
return(RedirectToAction("EditTable"));
}
}
//private StatesCtl db = new StatesCtl();
//{privateVariables}
public ActionResult Create()
{
using (StatesCtl db = new StatesCtl()){
Session["CreatePreviousURL"] = Convert.ToString(ControllerContext.HttpContext.Request.UrlReferrer);
return(View());
}
}
public ActionResult Edit(Int32?Stateid)
{
using (StatesCtl db = new StatesCtl()){
StatesClass obj_States = db.selectById(Stateid);
Session["EditPreviousURL"] = Convert.ToString(ControllerContext.HttpContext.Request.UrlReferrer);
return(View(obj_States));
}
}
public ActionResult EditTableRowsDelete(string records)
{
using (StatesCtl db = new StatesCtl()){
foreach (string id in records.Trim(',').Split(','))
{
if (!string.IsNullOrEmpty(id.Trim()))
{
db.delete(Convert.ToInt32(id));
}
}
return(View());
}
}
public ActionResult SaveRecords(FormCollection model)
{
if (ModelState.IsValid)
{
using (StatesCtl db = new StatesCtl()){
var StateidArray = model.GetValues("item.Stateid");
var StatenameArray = model.GetValues("item.Statename");
var CountryidArray = model.GetValues("item.Countryid");
var IsactiveArray = model.GetValues("item.Isactive");
var IsdeletedArray = model.GetValues("item.Isdeleted");
var CreatedonArray = model.GetValues("item.Createdon");
var DeletedonArray = model.GetValues("item.Deletedon");
for (Int32 i = 0; i < StateidArray.Length; i++)
{
StatesClass obj_update = db.selectById(Convert.ToInt32(StateidArray[i]));
if (!string.IsNullOrEmpty(Convert.ToString(StateidArray)))
{
obj_update.Stateid = Convert.ToInt32(StateidArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(StatenameArray)))
{
obj_update.Statename = Convert.ToString(StatenameArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(CountryidArray)))
{
obj_update.Countryid = Convert.ToInt32(CountryidArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(IsactiveArray)))
{
obj_update.Isactive = Convert.ToBoolean(IsactiveArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(IsdeletedArray)))
{
obj_update.Isdeleted = Convert.ToBoolean(IsdeletedArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(CreatedonArray)))
{
obj_update.Createdon = Convert.ToDateTime(CreatedonArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(DeletedonArray)))
{
obj_update.Deletedon = Convert.ToDateTime(DeletedonArray[i]);
}
db.update(obj_update);
}
}
}
return(RedirectToAction("EditTable"));
}
public ActionResult Edit(StatesClass Obj_States)
{
using (StatesCtl db = new StatesCtl()){
if (ModelState.IsValid)
{
db.update(Obj_States);
string sesionval = Convert.ToString(Session["EditPreviousURL"]);
if (!string.IsNullOrEmpty(sesionval))
{
Session.Remove("EditPreviousURL");
return(Redirect(sesionval));
}
else
{
return(RedirectToAction("Index"));
}
}
return(View(Obj_States));
}
}
public ActionResult Details(Int32?Stateid)
{
using (StatesCtl db = new StatesCtl()){ StatesClass obj_States = db.selectById(Stateid);
return(View(obj_States)); }
}
public ActionResult EditTableLazyLoading(Int64 StartIndex, Int64 EndIndex, string Search)
{
using (StatesCtl db = new StatesCtl()){
return(PartialView(db.selectIndexLazyLoading(StartIndex, EndIndex, Search)));
}
}
public Int32 EditTablePagingCount(Int64 PageSize, Int64 PageIndex, string Search)
{
using (StatesCtl db = new StatesCtl()){ return(db.selectIndexPagingCount(PageSize, PageIndex, Search)); }
}
public ActionResult EditTablePaging(Int64 PageSize, Int64 PageIndex, string Search)
{
using (StatesCtl db = new StatesCtl()){ return(PartialView(db.selectIndexPaging(PageSize, PageIndex, Search))); }
}
