//Update SubSector
public ActionResult UpdateDepartment(FM_ResponsibilityCenter_Department model)
{
Signatory_DepartmentTable tblDepartment = (from e in TOSSDB.Signatory_DepartmentTable where e.DepartmentID == model.getDepartmentcolumns.DepartmentID select e).FirstOrDefault();
tblDepartment.DepartmentName = GlobalFunction.ReturnEmptyString(model.getDepartmentcolumns.DepartmentName);
tblDepartment.DepartmentCode = GlobalFunction.ReturnEmptyString(model.getDepartmentcolumns.DepartmentCode);
tblDepartment.DepartmentAbbreviation = GlobalFunction.ReturnEmptyString(model.getDepartmentcolumns.DepartmentAbbreviation);
tblDepartment.ResponsibilityCode = GlobalFunction.ReturnEmptyString(model.getDepartmentcolumns.ResponsibilityCode);
tblDepartment.SectorID = GlobalFunction.ReturnEmptyInt(model.SectorNameID);
var SubSectorTemp = GlobalFunction.ReturnEmptyInt(model.SubSectorNameID);
if (SubSectorTemp == 0)
{
tblDepartment.SubSectorID = null;
}
else
{
tblDepartment.SubSectorID = model.SubSectorNameID;
}
tblDepartment.OfficeTypeID = GlobalFunction.ReturnEmptyInt(model.OfficeTypeNameID);
tblDepartment.FundID = GlobalFunction.ReturnEmptyInt(model.FundNameID);
TOSSDB.Entry(tblDepartment);
TOSSDB.SaveChanges();
return(PartialView("Department/_UpdateDepartment", model));
}
//Add Department
public JsonResult AddDepartment(FM_ResponsibilityCenter_Department model)
{
Signatory_DepartmentTable tblDepartment = new Signatory_DepartmentTable();
tblDepartment.DepartmentName = GlobalFunction.ReturnEmptyString(model.getDepartmentcolumns.DepartmentName);
tblDepartment.DepartmentCode = GlobalFunction.ReturnEmptyString(model.getDepartmentcolumns.DepartmentCode);
tblDepartment.DepartmentAbbreviation = GlobalFunction.ReturnEmptyString(model.getDepartmentcolumns.DepartmentAbbreviation);
tblDepartment.ResponsibilityCode = GlobalFunction.ReturnEmptyString(model.getDepartmentcolumns.ResponsibilityCode);
tblDepartment.SectorID = GlobalFunction.ReturnEmptyInt(model.SectorNameID);
var SubSectorTemp = GlobalFunction.ReturnEmptyInt(model.SubSectorNameID);
if (SubSectorTemp == 0)
{
tblDepartment.SubSectorID = null;
}
else
{
tblDepartment.SubSectorID = model.SubSectorNameID;
}
tblDepartment.OfficeTypeID = GlobalFunction.ReturnEmptyInt(model.OfficeTypeNameID);
tblDepartment.FundID = GlobalFunction.ReturnEmptyInt(model.FundNameID);
TOSSDB.Signatory_DepartmentTable.Add(tblDepartment);
TOSSDB.SaveChanges();
return(Json(tblDepartment));
}
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));
}
//Delete Department
public ActionResult DeleteDepartment(FM_ResponsibilityCenter_Department model, int DepartmentID)
{
Signatory_DepartmentTable tblDepartment = (from e in TOSSDB.Signatory_DepartmentTable where e.DepartmentID == DepartmentID select e).FirstOrDefault();
TOSSDB.Signatory_DepartmentTable.Remove(tblDepartment);
TOSSDB.SaveChanges();
return(RedirectToAction("Index"));
}
//Get Position Update
public ActionResult Get_UpdateDepartment(FM_SignatoriesModel model, int DepartmentID)
{
Signatory_DepartmentTable tblDepartment = (from e in TOSSDB.Signatory_DepartmentTable where e.DepartmentID == DepartmentID select e).FirstOrDefault();
model.getDepartmentColumns.DepartmentID = tblDepartment.DepartmentID;
model.getDepartmentColumns.Department = tblDepartment.Department;
model.getDepartmentColumns.DepartmentCode = tblDepartment.DepartmentCode;
return(PartialView("Department/_DepartmentUpdate", model));
}
public ActionResult UpdateDepartment(FM_SignatoriesModel model)
{
Signatory_DepartmentTable tblDepartment = (from e in TOSSDB.Signatory_DepartmentTable where e.DepartmentID == model.getDepartmentColumns.DepartmentID select e).FirstOrDefault();
tblDepartment.Department = model.getDepartmentColumns.Department;
tblDepartment.DepartmentCode = model.getDepartmentColumns.DepartmentCode;
TOSSDB.Entry(tblDepartment);
TOSSDB.SaveChanges();
return(PartialView("Department/_DepartmentUpdate", model));
}
//Add Department
public JsonResult AddDepartment(FM_SignatoriesModel model)
{
Signatory_DepartmentTable tblDepartment = new Signatory_DepartmentTable();
tblDepartment.Department = GlobalFunction.ReturnEmptyString(model.getDepartmentColumns.Department);
tblDepartment.DepartmentCode = GlobalFunction.ReturnEmptyString(model.getDepartmentColumns.DepartmentCode);
TOSSDB.Signatory_DepartmentTable.Add(tblDepartment);
TOSSDB.SaveChanges();
return(Json(tblDepartment));
}
//Get Update SubSector
public ActionResult Get_UpdateDepartment(FM_ResponsibilityCenter_Department model, int DepartmentID)
{
Signatory_DepartmentTable tblDepartment = (from e in TOSSDB.Signatory_DepartmentTable where e.DepartmentID == DepartmentID select e).FirstOrDefault();
model.getDepartmentcolumns.DepartmentID = tblDepartment.DepartmentID;
model.getDepartmentcolumns.DepartmentName = tblDepartment.DepartmentName;
model.getDepartmentcolumns.DepartmentAbbreviation = tblDepartment.DepartmentAbbreviation;
model.getDepartmentcolumns.ResponsibilityCode = tblDepartment.ResponsibilityCode;
model.FundNameTempID = Convert.ToInt32(tblDepartment.FundID);
model.SectorNameTempID = Convert.ToInt32(tblDepartment.SectorID);
model.SubSectorNameTempID = Convert.ToInt32(tblDepartment.SubSectorID);
model.OfficeTypeNameTempID = Convert.ToInt32(tblDepartment.OfficeTypeID);
model.getDepartmentcolumns.DepartmentCode = tblDepartment.DepartmentCode;
return(PartialView("Department/_UpdateDepartment", model));
}
public FM_ResponsibilityCenter_Department()
{
getDepartment = new List <Signatory_DepartmentTable>();
getDepartmentcolumns = new Signatory_DepartmentTable();
getDepartmentList = new List <DepartmentList>();
}
