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