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));
}
