public ActionResult GetBrgyCollectorDTable() { BrgyCollectorModel model = new BrgyCollectorModel(); List <BarangayCollectorList> getBarangayCollectorList = new List <BarangayCollectorList>(); var SQLQuery = " Select BrgyCollectorID, CONCAT([Fname],' ',[Mname] ,' ',[Lname] , ' ' ) as Fullname from [Tbl_FMBrgy_BrgyCollector]"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_Brgy]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { getBarangayCollectorList.Add(new BarangayCollectorList() { BrgyCollectorID = GlobalFunction.ReturnEmptyInt(dr[0]), Fullname = GlobalFunction.ReturnEmptyString(dr[1]) }); } } Connection.Close(); } model.getBarangayCollectorList = getBarangayCollectorList.ToList(); return(PartialView("BrgyCollectorTab/_TableBrgyCollector", getBarangayCollectorList)); }
public ActionResult GetBrgyCollertorForm(int ActionID, int PrimaryID) { BrgyCollectorModel model = new BrgyCollectorModel(); if (ActionID == 2) { var brgycollector = (from a in BOSSDB.Tbl_FMBrgy_BrgyCollector where a.BrgyCollectorID == PrimaryID select a).FirstOrDefault(); model.BrangayCollectorList.BrgyCollectorID = brgycollector.BrgyCollectorID; model.BrangayCollectorList.Fname = brgycollector.Fname; model.BrangayCollectorList.Mname = brgycollector.Mname; model.BrangayCollectorList.Lname = brgycollector.Lname; } model.ActionID = ActionID; return(PartialView("BrgyCollectorTab/_BrgyCollectorForm", model)); }
public ActionResult SaveBrgyCollector(BrgyCollectorModel model) { var isExist = ""; if (ModelState.IsValid) { var fname = model.BrangayCollectorList.Fname; var mname = model.BrangayCollectorList.Mname; var lname = model.BrangayCollectorList.Lname; var collectorid = model.BrangayCollectorList.BrgyCollectorID; Tbl_FMBrgy_BrgyCollector checkcollector = (from a in BOSSDB.Tbl_FMBrgy_BrgyCollector where (a.Fname == fname && a.Mname == mname && a.Lname == lname) select a).FirstOrDefault(); if (model.ActionID == 1) { if (checkcollector == null) { Tbl_FMBrgy_BrgyCollector brgyCollect = new Tbl_FMBrgy_BrgyCollector(); brgyCollect.Fname = fname; brgyCollect.Mname = mname; brgyCollect.Lname = lname; BOSSDB.Tbl_FMBrgy_BrgyCollector.Add(brgyCollect); BOSSDB.SaveChanges(); isExist = "false"; } else if (checkcollector != null) { isExist = "true"; } } else if (model.ActionID == 2) { Tbl_FMBrgy_BrgyCollector collectii = (from a in BOSSDB.Tbl_FMBrgy_BrgyCollector where a.BrgyCollectorID == collectorid select a).FirstOrDefault(); List <Tbl_FMBrgy_BrgyCollector> fnameCount = (from e in BOSSDB.Tbl_FMBrgy_BrgyCollector where e.Fname == fname select e).ToList(); List <Tbl_FMBrgy_BrgyCollector> lnameCount = (from e in BOSSDB.Tbl_FMBrgy_BrgyCollector where e.Lname == lname select e).ToList(); List <Tbl_FMBrgy_BrgyCollector> mnameCount = (from e in BOSSDB.Tbl_FMBrgy_BrgyCollector where e.Mname == mname select e).ToList(); if (checkcollector != null) { if (mname != null) { if (collectii.Fname != fname && fnameCount.Count >= 1 && collectii.Lname != lname && lnameCount.Count >= 1 && collectii.Mname != mname) { isExist = "true"; } else { isExist = "justUpdate"; } } else { if (collectii.Fname != fname && fnameCount.Count >= 1 && collectii.Lname != lname && lnameCount.Count >= 1) { isExist = "true"; } else { isExist = "justUpdate"; } } } else if (checkcollector == null) { isExist = "justUpdate"; } if (isExist == "justUpdate") { collectii.Fname = fname; collectii.Mname = mname; collectii.Lname = lname; BOSSDB.Entry(collectii); BOSSDB.SaveChanges(); } } } return(new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { isExist = isExist } }); }
//--------------------------------------------------------------------------------------------------------------------- //Barangay Collector Tab //--------------------------------------------------------------------------------------------------------------------- public ActionResult GetBrgyCollectorTab() { BrgyCollectorModel model = new BrgyCollectorModel(); return(PartialView("BrgyCollectorTab/IndexBrgyCollector", model)); }