//--------------------------------------------------------------------------------------------------- //Sub-Sector Tab //--------------------------------------------------------------------------------------------------- //Display Data Table public ActionResult GetSubSectorDTable() { SubSectorModel model = new SubSectorModel(); List <SubSectorList> getSubSectorList = new List <SubSectorList>(); var SQLQuery = "SELECT [SubSectorID],[Tbl_FMSector_Sector].SectorTitle,[SubSectorTitle],[SectorCode]+ ' - '+[SubSectorCode] as CombinedCode FROM [BOSS].[dbo].[Tbl_FMSector_SubSector],[dbo].[Tbl_FMSector_Sector] where [Tbl_FMSector_SubSector].SectorID = [Tbl_FMSector_Sector].SectorID"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_Sector]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { getSubSectorList.Add(new SubSectorList() { SubSectorID = GlobalFunction.ReturnEmptyInt(dr[0]), SectorTitle = GlobalFunction.ReturnEmptyString(dr[1]), SubSectorTitle = GlobalFunction.ReturnEmptyString(dr[2]), CombinedCode = GlobalFunction.ReturnEmptyString(dr[3]) }); } } Connection.Close(); } model.getSubSectorList = getSubSectorList.ToList(); return(PartialView("SubSectorTab/_TableSubSector", model.getSubSectorList)); }
public ActionResult GetSectorCodeField(int SectorID, SubSectorModel model) { var sector = (from a in BOSSDB.Tbl_FMSector_Sector where a.SectorID == SectorID select a).FirstOrDefault(); var passCon = ""; model.SectorCode = sector.SectorCode; passCon = model.SectorCode; var result = new { passCon = passCon };; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetSubSectorForm(int ActionID, int PrimaryID) { SubSectorModel model = new SubSectorModel(); if (ActionID == 2) { var Subsector = (from a in BOSSDB.Tbl_FMSector_SubSector where a.SubSectorID == PrimaryID select a).FirstOrDefault(); model.SubSectorList.SectorID = Convert.ToInt32(Subsector.SectorID); model.SubSectorList.SubSectorTitle = Subsector.SubSectorTitle; model.SubSectorList.SubSectorCode = Subsector.SubSectorCode; model.SubSectorList.SubSectorID = Subsector.SubSectorID; } model.ActionID = ActionID; return(PartialView("SubSectorTab/_SubSectorForm", model)); }
public ActionResult GetSubSectorTab() { SubSectorModel model = new SubSectorModel(); return(PartialView("SubSectorTab/IndexSubSectorTab")); }
public ActionResult SaveSubSector(SubSectorModel model) { var isExist = ""; if (ModelState.IsValid) { var SubSectorTitle = model.SubSectorList.SubSectorTitle; //SubSectorTitle = Regex.Replace(SubSectorTitle, @"\s\s+", ""); ////SubSectorTitle = Regex.Replace(SubSectorTitle, @"^\s+", ""); ////SubSectorTitle = Regex.Replace(SubSectorTitle, @"\s+$", ""); SubSectorTitle = new CultureInfo("en-US").TextInfo.ToTitleCase(SubSectorTitle); Tbl_FMSector_SubSector checksubSector = (from a in BOSSDB.Tbl_FMSector_SubSector where (a.SubSectorTitle == SubSectorTitle || a.SubSectorCode == model.SubSectorList.SubSectorCode) select a).FirstOrDefault(); if (model.ActionID == 1) { if (checksubSector == null) { Tbl_FMSector_SubSector subSector = new Tbl_FMSector_SubSector(); subSector.SectorID = model.SubSectorList.SectorID; subSector.SubSectorTitle = SubSectorTitle; subSector.SubSectorCode = model.SubSectorList.SubSectorCode; BOSSDB.Tbl_FMSector_SubSector.Add(subSector); BOSSDB.SaveChanges(); isExist = "false"; } else if (checksubSector != null) { isExist = "true"; } } else if (model.ActionID == 2) { Tbl_FMSector_SubSector subSector = (from a in BOSSDB.Tbl_FMSector_SubSector where a.SubSectorID == model.SubSectorList.SubSectorID select a).FirstOrDefault(); if (checksubSector != null) { if (subSector.SubSectorTitle == SubSectorTitle && subSector.SubSectorCode == model.SubSectorList.SubSectorCode) //walang binago { subSector.SectorID = model.SubSectorList.SectorID; subSector.SubSectorTitle = SubSectorTitle; subSector.SubSectorCode = model.SubSectorList.SubSectorCode; BOSSDB.Entry(subSector); BOSSDB.SaveChanges(); isExist = "justUpdate"; } else { isExist = "true"; } } else if (checksubSector == null) { subSector.SectorID = model.SubSectorList.SectorID; subSector.SubSectorTitle = SubSectorTitle; subSector.SubSectorCode = model.SubSectorList.SubSectorCode; BOSSDB.Entry(subSector); BOSSDB.SaveChanges(); isExist = "justUpdate"; } } } return(new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { isExist = isExist } }); }