public ActionResult GetStaffByFL(ApproverModel model)
{
ApproverModel approver = new ApproverModel();
string viewName = "CreateApprover";
if (!model.Id.Equals(Guid.Empty))
{
Approver entityApprover = staffService.GetApproverById(model.Id);
approver = ApproverExtension.ToModel(entityApprover);
viewName = "EditApprover";
}
UserSession.CurrentSession.ProjectDonorId = (Guid)model.ProjectDonorId;
List <FinanceLimit> financeLimits = budgetService.GetFinanceLimits(countryProg.Id);
Guid flId = model.FinancialLimitId != null ? (Guid)model.FinancialLimitId : Guid.Empty;
List <StaffView> staffList = (model.ActivityCode != NotificationHelper.grnCode && model.ActivityCode != NotificationHelper.wrnCode) ?
staffService.GetStaffByFinanceLimit(flId, countryProg.Id) : staffService.GetStaffByCountryProgramme(countryProg.Id);
approver.FinancialLimitId = model.FinancialLimitId;
approver.ActivityCode = model.ActivityCode;
approver.ActionType = model.ActionType;
approver.ActionTypes = new SelectList(SCMS.CoreBusinessLogic.NotificationsManager.NotificationHelper.GetActionType(model.ActivityCode), "Name", "Name");
approver.FinancialLimits = new SelectList(financeLimits, "Id", "Name", model.FinancialLimitId);
approver.SystemUsers = new SelectList(staffList, "Id", "StaffName");
approver.DocumentTypes = new SelectList(SCMS.CoreBusinessLogic.NotificationsManager.NotificationHelper.GetDocumentTypes4Project(), "DocumentCode", "DocumentName");
ViewBag.Unlimited = FinanceLimitUlimited(flId, financeLimits);
return(View(viewName, approver));
}
public ActionResult Create(ApproverModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
return(RedirectToAction("Index", "Approver", new { area = "Administrators" }));
}
public ActionResult UpdateApprover(ApproverModel approver)
{
//Set Priority to 1
approver.Priority = 1;
Approver entityApprover = ApproverExtension.ToEntity(approver);
entityApprover.CountryProgrammeId = countryProg.Id;
staffService.UpdateApprover(entityApprover);
return(ApprovalSettings(entityApprover.ProjectDonorId.Value));
}
public ActionResult UpdateApprover(ApproverModel approver)
{
//Set Priority to 1
approver.Priority = 1;
Approver entityApprover = ApproverExtension.ToEntity(approver);
entityApprover.CountryProgrammeId = countryProg.Id;
staffService.UpdateApprover(entityApprover);
UserSession.CurrentSession.ApproverList = staffService.GetCPGlobalApprovers(countryProg.Id);
return(ApproverList());
}
//
// GET: /Admin/Approver/Create
public ActionResult CreateApprover(string id)
{
ApproverModel approver = new ApproverModel();
List <FinanceLimit> financeLimits = budgetService.GetFinanceLimits(countryProg.Id);
Guid flId = financeLimits.Count > 0 ? financeLimits[0].Id : Guid.Empty;
List <StaffView> staffList = (id != NotificationHelper.grnCode && id != NotificationHelper.wrnCode && id != NotificationHelper.ccCode && id != NotificationHelper.paramsCode) ?
staffService.GetStaffByFinanceLimit(flId, countryProg.Id) : staffService.GetStaffByCountryProgramme(countryProg.Id);
approver.ActivityCode = id;
approver.ActionTypes = new SelectList(NotificationHelper.GetActionType(id), "Name", "Name");
approver.FinancialLimits = new SelectList(financeLimits, "Id", "Name");
approver.SystemUsers = new SelectList(staffList, "Id", "StaffName");
approver.DocumentTypes = new SelectList(SCMS.CoreBusinessLogic.NotificationsManager.NotificationHelper.GetDocumentTypes(), "DocumentCode", "DocumentName");
ViewBag.Unlimited = FinanceLimitUlimited(flId, financeLimits);
return(View(approver));
}
public ActionResult SaveApprover(ApproverModel approver)
{
try
{
//Set Priority to 1
approver.Priority = 1;
approver.Id = Guid.NewGuid();
Approver entityApprover = ApproverExtension.ToEntity(approver);
entityApprover.CountryProgrammeId = countryProg.Id;
staffService.InsertApprover(entityApprover);
UserSession.CurrentSession.ApproverList = staffService.GetCPGlobalApprovers(countryProg.Id);
return(ApproverList());
}
catch (Exception ex)
{
return(Index());
}
}
public void CreateApprover(ApproverModel am)
{
if (am != null)
{
SQLServerDBHelper db = new SQLServerDBHelper("EsignDB");
string InsertSQL = "INSERT INTO Approver(SiteID, BUID, ApproverType, ApproverEmpNo, ApproverEmpName, SetupEmp) VALUES('" + am.SiteId + "','" + am.BUID + "',N'" + am.ApproverType + "','" + am.ApproverEmpNo + "',N'" + am.ApproverEmpName + "','" + Ultils.GetCookie("UserId") + "')";
if (db.ExcuteNonQuery(InsertSQL))
{
Ultils.WriteCookie("Success", LanguageHelper.GetResource("AddSuccess"));
}
else
{
Ultils.WriteCookie("Error", LanguageHelper.GetResource("AddFail"));
}
}
else
{
Ultils.WriteCookie("Error", LanguageHelper.GetResource("ApproverUpdateEmpty"));
}
}
public void UpdateApprover(ApproverModel am)
{
if (am != null && !string.IsNullOrWhiteSpace(am.ApproverID))
{
SQLServerDBHelper db = new SQLServerDBHelper("EsignDB");
string UpdateSql = "UPDATE Approver SET SiteID='" + am.SiteId + "',BUID='" + am.BUID + "',ApproverType=N'" + am.ApproverType + "',ApproverEmpNo='" + am.ApproverEmpNo + "',ApproverEmpName=N'" + am.ApproverEmpName + "',SetupEmp='" + Ultils.GetCookie("UserId") + "',SetupTime=getDate() WHERE ApproverID='" + am.ApproverID.Trim() + "'";
if (db.ExcuteNonQuery(UpdateSql))
{
Ultils.WriteCookie("Success", LanguageHelper.GetResource("UpdateSuccess"));
}
else
{
Ultils.WriteCookie("Error", LanguageHelper.GetResource("UpdateFail"));
}
}
else
{
Ultils.WriteCookie("Error", LanguageHelper.GetResource("ApproverUpdateEmpty"));
}
}
public ActionResult EditApprover(Guid Id)
{
Approver entityApprover = staffService.GetApproverById(Id);
ApproverModel approver = ApproverExtension.ToModel(entityApprover);
List <StaffView> staffList = (approver.ActivityCode != NotificationHelper.ppCode) ?
staffService.GetStaffByFinanceLimit((Guid)approver.FinancialLimitId, countryProg.Id) : staffService.GetStaffByCountryProgramme(countryProg.Id);
UserSession.CurrentSession.ProjectDonorId = (Guid)entityApprover.ProjectDonorId;
List <FinanceLimit> financeLimits = budgetService.GetFinanceLimits(countryProg.Id);
approver.ActionTypes = new SelectList(SCMS.CoreBusinessLogic.NotificationsManager.NotificationHelper.GetActionType(entityApprover.ActivityCode), "Name", "Name", entityApprover.ActionType);
approver.SystemUsers = new SelectList(staffList, "Id", "StaffName", entityApprover.UserId);
approver.Assistants = new SelectList(staffList, "Id", "StaffName", entityApprover.AssistantId);
approver.DocumentTypes = new SelectList(SCMS.CoreBusinessLogic.NotificationsManager.NotificationHelper.GetDocumentTypes4Project(), "DocumentCode", "DocumentName", entityApprover.ActivityCode);
approver.FinancialLimits = new SelectList(financeLimits, "Id", "Name", entityApprover.FinanceLimitId);
if (approver.ActivityCode != NotificationHelper.ppCode)
{
ViewBag.Unlimited = FinanceLimitUlimited((Guid)entityApprover.FinanceLimitId, financeLimits);
}
return(View(approver));
}
