//Get Dynamic SubSector For Update Partial View public ActionResult GetDynamicFunctionSubSector(int SectorID) { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); model.FunctionList = new SelectList((from s in TOSSDB.SubSectors.Where(a => a.SectorID == SectorID).ToList() select new { SubSectorID = s.SubSectorID, SubSectorName = s.SubSectorName }), "SubSectorID", "SubSectorName"); return(PartialView("Function/_DynamicDDSubSector", model)); }
//Dropdown Office Type public ActionResult GetDynamicFunctionOfficeType() { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); model.FunctionList = new SelectList((from s in TOSSDB.OfficeTypes.ToList() select new { OfficeTypeID = s.OfficeTypeID, OfficeTypeName = s.OfficeTypeName }), "OfficeTypeID", "OfficeTypeName"); return(PartialView("Function/_DynamicDDOfficeType", model)); }
//Dropdown Department public ActionResult GetDynamicDepartment() { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); model.FunctionList = new SelectList((from s in TOSSDB.Signatory_DepartmentTable.ToList() select new { DepartmentID = s.DepartmentID, DepartmentName = s.DepartmentName }), "DepartmentID", "DepartmentName"); return(PartialView("Function/_DynamicDDDepartmentName", model)); }
//Delete Function public ActionResult DeleteFunction(FM_ResponsibilityCenter_Function model, int FunctionID) { Function tblFunction = (from e in TOSSDB.Functions where e.FunctionID == FunctionID select e).FirstOrDefault(); TOSSDB.Functions.Remove(tblFunction); TOSSDB.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult GetSelectedDynamicFunctionSector(int SectorNameTempID) { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); model.FunctionList = new SelectList((from s in TOSSDB.Sectors.ToList() select new { SectorID = s.SectorID, SectorName = s.SectorName }), "SectorID", "SectorName"); model.SectorNameID = SectorNameTempID; return(PartialView("Function/_DynamicDDSectorName", model)); }
public ActionResult GetDeptOfficeCode(int DepartmentID) { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); var deptTable = (from e in TOSSDB.Signatory_DepartmentTable where e.DepartmentID == DepartmentID select e).FirstOrDefault(); model.DepartmentCode = deptTable.DepartmentCode; return(PartialView("Function/_DynamicLBDepartmentOfficeCode", model)); }
public ActionResult GetSelectedFundName(int DepartmentID, int FundTempID) { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); Signatory_DepartmentTable tblSector = (from e in TOSSDB.Signatory_DepartmentTable where e.DepartmentID == DepartmentID select e).FirstOrDefault(); model.FundName = tblSector.Fund.FundName; return(PartialView("Function/_DynamicLBFundName", model)); }
//Get Update SubSector public ActionResult Get_UpdateFunction(FM_ResponsibilityCenter_Function model, int FunctionID) { Function tblFunction = (from e in TOSSDB.Functions where e.FunctionID == FunctionID select e).FirstOrDefault(); model.getFunctioncolumns.FunctionID = tblFunction.FunctionID; model.getFunctioncolumns.FunctionName = tblFunction.FunctionName; model.getFunctioncolumns.FunctionAbbreviation = tblFunction.FunctionAbbreviation; model.getFunctioncolumns.FunctionCode = tblFunction.FunctionCode; model.DepartmentTempID = Convert.ToInt32(tblFunction.DepartmentID); model.SectorNameTempID = Convert.ToInt32(tblFunction.SectorID); model.SubSectorNameTempID = Convert.ToInt32(tblFunction.SubSectorID); model.OfficeTypeNameTempID = Convert.ToInt32(tblFunction.OfficeTypeID); return(PartialView("Function/_UpdateFunction", model)); }
//Position Table Partial View public ActionResult Get_FunctionTable() { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); List <FunctionList> tbl_Function = new List <FunctionList>(); var SQLQuery = "SELECT FunctionID,FunctionName,FunctionAbbreviation,FunctionCode,DepartmentName,FundID ,SectorName,dbo.Functions.SubSectorID,OfficeTypeName FROM DB_TOSS.dbo.Functions,Signatory_DepartmentTable,Sector,OfficeType Where Signatory_DepartmentTable.DepartmentID = Functions.DepartmentID AND Sector.SectorID = Functions.SectorID AND OfficeType.OfficeTypeID = Functions.OfficeTypeID"; //SQLQuery += " WHERE (IsActive != 0)"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_FunctionsList]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { tbl_Function.Add(new FunctionList() { FunctionID = GlobalFunction.ReturnEmptyInt(dr[0]), FunctionName = GlobalFunction.ReturnEmptyString(dr[1]), FunctionAbbreviation = GlobalFunction.ReturnEmptyString(dr[2]), FunctionCode = GlobalFunction.ReturnEmptyString(dr[3]), DepartmentName = GlobalFunction.ReturnEmptyString(dr[4]), Sector = GlobalFunction.ReturnEmptyString(dr[6]), SubSector = GlobalFunction.ReturnEmptyInt(dr[7]), OfficeType = GlobalFunction.ReturnEmptyString(dr[8]), FundID = GlobalFunction.ReturnEmptyInt(dr[5]), }); } } Connection.Close(); } model.getFunctionList = tbl_Function.ToList(); return(PartialView("Function/_FunctionTable", model.getFunctionList)); }
//Update SubSector public ActionResult UpdateFunction(FM_ResponsibilityCenter_Function model) { Function tblDepartment = (from e in TOSSDB.Functions where e.FunctionID == model.getFunctioncolumns.FunctionID select e).FirstOrDefault(); tblDepartment.FunctionName = model.getFunctioncolumns.FunctionName; tblDepartment.FunctionCode = model.getFunctioncolumns.FunctionCode; tblDepartment.FunctionAbbreviation = model.getFunctioncolumns.FunctionAbbreviation; tblDepartment.DepartmentID = model.DepartmentID; tblDepartment.SectorID = model.SectorNameID; var SubSectorTemp = GlobalFunction.ReturnEmptyInt(model.SubSectorNameID); if (SubSectorTemp == 0) { tblDepartment.SubSectorID = null; } else { tblDepartment.SubSectorID = model.SubSectorNameID; } tblDepartment.OfficeTypeID = model.OfficeTypeNameID; TOSSDB.Entry(tblDepartment); TOSSDB.SaveChanges(); return(PartialView("Function/_UpdateFunction", model)); }
//Add Function public JsonResult AddFunction(FM_ResponsibilityCenter_Function model) { Function tblDepartment = new Function(); tblDepartment.FunctionName = model.getFunctioncolumns.FunctionName; tblDepartment.FunctionCode = model.getFunctioncolumns.FunctionCode; tblDepartment.FunctionAbbreviation = model.getFunctioncolumns.FunctionAbbreviation; tblDepartment.DepartmentID = model.DepartmentID; tblDepartment.SectorID = model.SectorNameID; var SubSectorTemp = GlobalFunction.ReturnEmptyInt(model.SubSectorNameID); if (SubSectorTemp == 0) { tblDepartment.SubSectorID = null; } else { tblDepartment.SubSectorID = model.SubSectorNameID; } tblDepartment.OfficeTypeID = model.OfficeTypeNameID; TOSSDB.Functions.Add(tblDepartment); TOSSDB.SaveChanges(); return(Json(tblDepartment)); }
public ActionResult FunctionTab() { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); return(PartialView("Function/FunctionIndex", model)); }
//Get Add Position Partial View public ActionResult Get_AddFunction() { FM_ResponsibilityCenter_Function model = new FM_ResponsibilityCenter_Function(); return(PartialView("Function/_AddFunction", model)); }