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