public ActionResult Create(buildingdeficiencyrepairClass Obj_buildingdeficiencyrepair, string command)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){
if (ModelState.IsValid)
{
db.insert(Obj_buildingdeficiencyrepair);
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_buildingdeficiencyrepair));
}
}
//private buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl();
//{privateVariables}
public ActionResult Create()
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){
Session["CreatePreviousURL"] = Convert.ToString(ControllerContext.HttpContext.Request.UrlReferrer);
return(View());
}
}
public ActionResult EditTableRowDelete(Int32 Buildingdeficiencyrepairid)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){
db.delete(Buildingdeficiencyrepairid);
return(RedirectToAction("EditTable"));
}
}
public ActionResult Edit(Int32 Buildingdeficiencyrepairid)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){
buildingdeficiencyrepairClass obj_buildingdeficiencyrepair = db.selectById(Buildingdeficiencyrepairid);
Session["EditPreviousURL"] = Convert.ToString(ControllerContext.HttpContext.Request.UrlReferrer);
return(View(obj_buildingdeficiencyrepair));
}
}
public ActionResult EditTableRowsDelete(string records)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){
foreach (string id in records.Trim(',').Split(','))
{
if (!string.IsNullOrEmpty(id.Trim()))
{
db.delete(Convert.ToInt32(id));
}
}
return(View());
}
}
public ActionResult Edit(buildingdeficiencyrepairClass Obj_buildingdeficiencyrepair)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){
if (ModelState.IsValid)
{
db.update(Obj_buildingdeficiencyrepair);
string sesionval = Convert.ToString(Session["EditPreviousURL"]);
if (!string.IsNullOrEmpty(sesionval))
{
Session.Remove("EditPreviousURL");
return(Redirect(sesionval));
}
else
{
return(RedirectToAction("Index"));
}
}
return(View(Obj_buildingdeficiencyrepair));
}
}
public ActionResult Details(Int32 Buildingdeficiencyrepairid)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){ buildingdeficiencyrepairClass obj_buildingdeficiencyrepair = db.selectById(Buildingdeficiencyrepairid);
return(View(obj_buildingdeficiencyrepair)); }
}
public ActionResult SaveRecords(FormCollection model)
{
if (ModelState.IsValid)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){
var BuildingdeficiencyrepairidArray = model.GetValues("item.Buildingdeficiencyrepairid");
var BuildingidArray = model.GetValues("item.Buildingid");
var DescriptionArray = model.GetValues("item.Description");
var QuantityArray = model.GetValues("item.Quantity");
var UnitsArray = model.GetValues("item.Units");
var PriorityArray = model.GetValues("item.Priority");
var NoteArray = model.GetValues("item.Note");
var NoteaudioArray = model.GetValues("item.Noteaudio");
var WorkareanoArray = model.GetValues("item.Workareano");
var UseridArray = model.GetValues("item.Userid");
var InserteddatetimeArray = model.GetValues("item.Inserteddatetime");
for (Int32 i = 0; i < BuildingdeficiencyrepairidArray.Length; i++)
{
buildingdeficiencyrepairClass obj_update = db.selectById(Convert.ToInt32(BuildingdeficiencyrepairidArray[i]));
if (!string.IsNullOrEmpty(Convert.ToString(BuildingdeficiencyrepairidArray)))
{
obj_update.Buildingdeficiencyrepairid = Convert.ToInt32(BuildingdeficiencyrepairidArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(BuildingidArray)))
{
obj_update.Buildingid = Convert.ToInt32(BuildingidArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(DescriptionArray)))
{
obj_update.Description = Convert.ToString(DescriptionArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(QuantityArray)))
{
obj_update.Quantity = Convert.ToInt32(QuantityArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(UnitsArray)))
{
obj_update.Units = Convert.ToInt32(UnitsArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(PriorityArray)))
{
obj_update.Priority = Convert.ToString(PriorityArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(NoteArray)))
{
obj_update.Note = Convert.ToString(NoteArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(NoteaudioArray)))
{
obj_update.Noteaudio = Convert.To(NoteaudioArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(WorkareanoArray)))
{
obj_update.Workareano = Convert.ToInt32(WorkareanoArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(UseridArray)))
{
obj_update.Userid = Convert.ToInt32(UseridArray[i]);
}
if (!string.IsNullOrEmpty(Convert.ToString(InserteddatetimeArray)))
{
obj_update.Inserteddatetime = Convert.ToDateTime(InserteddatetimeArray[i]);
}
db.update(obj_update);
}
}
}
return(RedirectToAction("EditTable"));
}
public ActionResult EditTableLazyLoading(Int64 StartIndex, Int64 EndIndex, string Search)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){
return(PartialView(db.selectIndexLazyLoading(StartIndex, EndIndex, Search)));
}
}
public Int32 EditTablePagingCount(Int64 PageSize, Int64 PageIndex, string Search)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){ return(db.selectIndexPagingCount(PageSize, PageIndex, Search)); }
}
public ActionResult EditTablePaging(Int64 PageSize, Int64 PageIndex, string Search)
{
using (buildingdeficiencyrepairCtl db = new buildingdeficiencyrepairCtl()){ return(PartialView(db.selectIndexPaging(PageSize, PageIndex, Search))); }
}
