public ActionResult GetBrgyNameDTable()
{
BrgyNameModel model = new BrgyNameModel();
List <BarangayNameList> getBarangayNameList = new List <BarangayNameList>();
var SQLQuery = "SELECT * FROM [Tbl_FMBrgy_Barangay]";
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())
{
getBarangayNameList.Add(new BarangayNameList()
{
BrgyID = GlobalFunction.ReturnEmptyInt(dr[0]),
BrgyName = GlobalFunction.ReturnEmptyString(dr[1])
});
}
}
Connection.Close();
}
model.getBarangayNameList = getBarangayNameList.ToList();
return(PartialView("BrgyNameTab/_TableBrgyName", getBarangayNameList));
}
public ActionResult SaveBrgyName(BrgyNameModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var brgyname = model.BarangayNameList.BrgyName;
Tbl_FMBrgy_Barangay checkbrgy = (from a in BOSSDB.Tbl_FMBrgy_Barangay where (a.BrgyName == brgyname) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkbrgy == null)
{
Tbl_FMBrgy_Barangay brgy = new Tbl_FMBrgy_Barangay();
brgy.BrgyName = brgyname;
BOSSDB.Tbl_FMBrgy_Barangay.Add(brgy);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkbrgy != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMBrgy_Barangay bgryii = (from a in BOSSDB.Tbl_FMBrgy_Barangay where a.BrgyID == model.BarangayNameList.BrgyID select a).FirstOrDefault();
List <Tbl_FMBrgy_Barangay> brgyCount = (from e in BOSSDB.Tbl_FMBrgy_Barangay where e.BrgyName == brgyname select e).ToList();
if (checkbrgy != null)
{
if (bgryii.BrgyName != brgyname && brgyCount.Count >= 1)
{
isExist = "true";
}
else
{
isExist = "justUpdate";
}
}
else if (checkbrgy == null)
{
isExist = "justUpdate";
}
if (isExist == "justUpdate")
{
bgryii.BrgyName = brgyname;
BOSSDB.Entry(bgryii);
BOSSDB.SaveChanges();
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
public ActionResult GetBrgyNameForm(int ActionID, int PrimaryID)
{
BrgyNameModel model = new BrgyNameModel();
if (ActionID == 2)
{
var brgy = (from a in BOSSDB.Tbl_FMBrgy_Barangay where a.BrgyID == PrimaryID select a).FirstOrDefault();
model.BarangayNameList.BrgyID = brgy.BrgyID;
model.BarangayNameList.BrgyName = brgy.BrgyName;
}
model.ActionID = ActionID;
return(PartialView("BrgyNameTab/_BrgyNameForm", model));
}
//---------------------------------------------------------------------------------------------------------------------
//Barangay Name Tab
//---------------------------------------------------------------------------------------------------------------------
public ActionResult GetBrgyNameTab()
{
BrgyNameModel model = new BrgyNameModel();
return(PartialView("BrgyNameTab/IndexBrgyName", model));
}
// GET: FileMaintenanceBarangay
public ActionResult FileBarangay()
{
BrgyNameModel model = new BrgyNameModel();
return(View(model));
}