/*public ActionResult OpenTargetEntry( string WorkflowID , int RequestStageID) { * * //string UserName = Request.LogonUserIdentity.Name.Substring(Request.LogonUserIdentity.Name.LastIndexOf(@"\") + 1); * string UserName = @User.Identity.Name; * * if( UserName == null || UserName.Equals(String.Empty)){ * ViewBag.ErrorMessage="You must be logged in to continue."; * return RedirectToAction("AwaitingMyApproval","AwaitingApproval"); * } * * //now resolve the user profile from AD and Xceed * StaffADProfile staffADProfile = new StaffADProfile(); * staffADProfile.user_logon_name = UserName; * * * //AD * ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery( staffADProfile ); * staffADProfile = activeDirectoryQuery.GetStaffProfile(); * if( staffADProfile==null ){ * ViewBag.ErrorMessage="Your profile is not properly setup on the system. Please contact InfoTech."; * return RedirectToAction( "AwaitingMyApproval","AwaitingApproval",new { UserName = Session["UserName"] as string } ); * } * * string approvers = new LINQCalls().getApprovers( WorkflowID,RequestStageID ); * List<SignerDetails> realApprovers = new DataHandlers().GetApprovers( approvers ); * int index = realApprovers.FindIndex(f => f.ApproverStaffNumber == staffADProfile.employee_number); * bool isApprover = ( index >= 0 ) ? true : false; * * return RedirectToAction( "EditTarget","InputTarget",new {WorkflowID=WorkflowID , editMode =isApprover , myEntries=true } ); * }*/ public ActionResult OpenMemoEntry(string WorkflowID, int RequestStageID) { //string UserName = Request.LogonUserIdentity.Name.Substring(Request.LogonUserIdentity.Name.LastIndexOf(@"\") + 1); string UserName = @User.Identity.Name; if (UserName == null || UserName.Equals(String.Empty)) { ViewBag.ErrorMessage = "You must be logged in to continue."; return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval")); } //now resolve the user profile from AD and Xceed StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = UserName; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); if (staffADProfile == null) { ViewBag.ErrorMessage = "Your profile is not properly setup on the system. Please contact InfoTech."; return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval", null)); } string approvers = new LINQCalls().getApprovers(WorkflowID, RequestStageID); List <SignerDetails> realApprovers = new DataHandlers().GetApprovers(approvers); int index = realApprovers.FindIndex(f => f.ApproverStaffNumber == staffADProfile.employee_number); bool isApprover = (index >= 0) ? true : false; return(RedirectToAction("EditMemo", "MemoSetup", new { WorkflowID = WorkflowID, editMode = isApprover, myEntries = true })); }
public ActionResult SetupAppraisalApprovers(AppraisalApproverModel appraisalApproverModel) { appraisalApproverModel.EntryKey = getEntryKey(appraisalApproverModel); /*bool duplicateEntry = LINQCalls.checkDupApproverSetup( appraisalApproverModel.EntryKey.ToUpper() ); * if (!duplicateEntry) { * TempData["ErrorMessage"] = "Error : The staff : "+ appraisalApproverModel.StaffName +" has an existing setup with the same identity"; * }*/ HRProfile hrprofile = LINQCalls.hrprofile(appraisalApproverModel.HRStaffName, 1); if (hrprofile == null) { TempData["ErrorMessage"] = "Error : You staff profile is not properly setup"; } //Setup the branch int inputMode = 0; string retVal = new AppDatabase().insertApproverSetup(appraisalApproverModel, hrprofile, inputMode, "AppraisalDbConnectionString"); if (!String.IsNullOrEmpty(retVal) && !retVal.Split('|')[0].Equals("0")) { TempData["ErrorMessage"] = "Error :" + retVal.Split('|')[1]; } else { appraisalApproverModel = null; } TempData["appraisalApproverModel"] = appraisalApproverModel; return(RedirectToAction("SetupAppraisalApprovers")); }
public static SelectList GetDepts(string branchcode) { //branchcode = "001"; string deptcodes = "118,225,224,117,180,474,1473,166"; return(LINQCalls.getHODepts(branchcode, deptcodes)); }
public ActionResult RoleEdit(string EntryKey, string Func) { AppraisalApproverModel appraisalApproverModel = new AppraisalApproverModel(); if (String.IsNullOrEmpty(EntryKey) || String.IsNullOrEmpty(Func)) { TempData["ErrorMessage"] = "Error : Please access the page properly."; } else { if (Func.Equals("Edit")) { appraisalApproverModel = LINQCalls.getRoleSetupEntry(EntryKey); } else { string retVal = new AppDatabase().deleteRoleSetup(EntryKey, "AppraisalDbConnectionString"); if (!String.IsNullOrEmpty(retVal) && !retVal.Split('|')[0].Equals("0")) { TempData["ErrorMessage"] = "Error : " + retVal.Split('|')[1]; } else { return(RedirectToAction("ViewHRUsers")); } } } TempData["appraisalApproverModel"] = appraisalApproverModel; return(RedirectToAction("HRRoleSetup")); }
public IHttpActionResult GetSearchRequestEntry(string workflowid) { int retCode = 0; string retVal = string.Empty; string connectionString = ConfigurationManager.ConnectionStrings["AppraisalDbConnectionString"].ConnectionString; string returnMessage = "{{\"responseCode\":\"{0}\",\"responseMessage\":\"{1}\",\"result\":\"{2}\"}}"; //Validate The Input Parameters if (workflowid.ToString().Equals(null)) { return(NotFound()); //returnMessage = await Task.FromResult(string.Format(returnMessage, "01", "Invalid workflowid", null)); // return JsonConvert.DeserializeObject(returnMessage.ToString()); } var Result = LINQCalls.getSearchRequestEntry(workflowid); if (Result == null) { return(NotFound()); } return(Ok(Result)); //returnMessage = await Task.FromResult(string.Format(returnMessage, retCode.ToString(), retVal, Result)); //return JsonConvert.DeserializeObject(returnMessage.ToString()); }
public ActionResult MyEntries( ) { Session["UserName"] = @User.Identity.Name; this._UserName = Session["UserName"] as string ?? ""; if (_UserName == null || _UserName.Equals(String.Empty)) { ViewBag.ErrorMessage = "You must be logged in to continue."; return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval")); } //now resolve the user profile from AD and Xceed StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = _UserName; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); if (staffADProfile == null) { ViewBag.ErrorMessage = "Your profile is not properly setup on the system. Please contact InfoTech."; return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval")); } //Check if the initiator/branch/has an existing entry for the AppraisalPeriod from the Database List <EntriesModel> entryDetails = new List <EntriesModel>(); entryDetails = LINQCalls.getMyPassportWorkflows(staffADProfile); return(View(entryDetails)); }
public ActionResult AwaitingMyApproval() { /**First let's check if the PostBackMessage has something * Very important---DO NOT DELETE!!!!!!!!!!!!!!!!!!!!!**/ Session["UserName"] = @User.Identity.Name; this.UserName = Session["UserName"] as string ?? ""; string PostBackMessage = TempData["PostBackMessage"] as string; string Approvers = TempData["Approvers"] as string; this.UserName = Session["UserName"] as String ?? ""; this.logWriter = new LogWriter(); try { logWriter.WriteErrorLog(string.Format("about to PostBackMessage : Exception!!! / {0}", "Posted back")); if (!String.IsNullOrEmpty(PostBackMessage)) { logWriter.WriteErrorLog(string.Format("PostBackMessage Status : Exception!!! / {0}", "Posted back")); ViewBag.PostBackMessage = string.Format("<script type='text/javascript'>alert(\"" + PostBackMessage + "\\n\\n{0}\");</script>", Approvers); } logWriter.WriteErrorLog(string.Format("After post back : Exception!!! / {0}", "Posted back")); //now get the pending items if (UserName == null || UserName.Equals(String.Empty)) { ViewBag.ErrorMessage = "You must be logged in to continue."; return(View()); } //now resolve the user profile from AD and Xceed StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = UserName; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); if (staffADProfile == null) { ViewBag.ErrorMessage = "Your profile is not properly setup on the system. Please contact InfoTech."; return(View()); } //Check if the approver has an existing entry in the Database logWriter.WriteErrorLog(string.Format("get Awaiting : about firing getMyPendingPassportWorkflows!!! / {0}", "")); List <EntriesModel> entryDetails = new List <EntriesModel>(); entryDetails = LINQCalls.getMyPendingPassportWorkflows(staffADProfile); logWriter.WriteErrorLog(string.Format("Entry List : Staff Name!!! / {0}", entryDetails.First().StaffName)); return(View(entryDetails)); } catch (Exception ex) { logWriter.WriteErrorLog(string.Format("AwaitingMyApproval : Exception!!! / {0}", ex.Message)); return(View()); } }
public ActionResult Reports(string UserName, string ReportMode) { string PostBackMessage = TempData["PostBackMessage"] as string; string Approvers = TempData["Approvers"] as string; if (!String.IsNullOrEmpty(PostBackMessage)) { ViewBag.PostBackMessage = "<script type='text/javascript'>alert(\"" + PostBackMessage + "\\n\\n" + Approvers + "\");</script>"; } //now get the pending items if (UserName == null || UserName.Equals(String.Empty)) { ViewBag.ErrorMessage = "You must be logged in to continue."; return(View()); } this._UserName = UserName; Session["UserName"] = UserName; //now resolve the user profile from AD and Xceed StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = _UserName; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); if (staffADProfile == null) { ViewBag.ErrorMessage = "Your profile is not properly setup on the system. Please contact InfoTech."; return(View()); } //ReportMode = (String.IsNullOrEmpty(TempData["ReportMode"] as string) ) ? ReportMode : TempData["ReportMode"] as string ; //Now let's get all entries in the workflow, depending on what was passed in to ReportMode// List <EntriesModel> entryDetails = new List <EntriesModel>(); //entryDetails = new LINQCalls().getWorkflowReport( ReportMode ); ReportModel reportModel = new ReportModel(); if (TempData["reportModel"] != null) { reportModel = TempData["reportModel"] as ReportModel; entryDetails = new LINQCalls().getWorkflowQueryReport(reportModel); } else { entryDetails = new LINQCalls().getWorkflowReport(ReportMode); reportModel.ReportMode = ReportMode; } reportModel.QueryField = SelectListItemHelper.GetQueryFields(); reportModel.EntriesModel = entryDetails; return(View(reportModel)); }
public ActionResult BHSingleSetupFormEdit(string StaffNumber, string SelectedAppraisalPeriod) { if (String.IsNullOrEmpty(StaffNumber) || String.IsNullOrEmpty(SelectedAppraisalPeriod)) { return(RedirectToAction("BHSingleSetupForm")); } BHSingleSetupEditModel bHSingleSetupModel = new LINQCalls().bHSingleSetupModel(StaffNumber, SelectedAppraisalPeriod); return(View(bHSingleSetupModel)); }
public JsonResult TagSearch(string term) { CultureInfo ci = new CultureInfo("en-US"); List <SignerDetails> signerDetails = new LINQCalls().getBankStaff(); var staffmembers = new System.Web.Script.Serialization.JavaScriptSerializer(); Debug.WriteLine(signerDetails); return(this.Json(signerDetails.Where(t => t.ApproverStaffName.ToLower().Contains(term.ToLower())), JsonRequestBehavior.AllowGet)); }
public ActionResult ViewStructure(ViewStructure viewStructure) { //Now let's get the Approvers for the Selected branch IEnumerable <IEnumerable <AppraisalApproverModel> > branchStructure = LINQCalls.getOrgStructure(viewStructure.SelectedBranch); branchStructure = branchStructure.OrderByDescending(c => c.First().RoleID); viewStructure.AppraisalApproverModel = branchStructure; TempData["viewStructure"] = viewStructure; return(RedirectToAction("ViewStructure", "OrgStructure")); }
public static SelectList GetDepts(string branchcode) { //branchcode = "001"; System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~/"); System.Configuration.KeyValueConfigurationElement HeadOfficeDepartments = rootWebConfig.AppSettings.Settings["HeadOfficeDepartments"]; //string deptcodes = "118,225,224,117,180,474,1473,166,658"; string deptcodes = HeadOfficeDepartments.Value.ToString(); return(LINQCalls.getHODepts(branchcode, deptcodes)); }
public ActionResult BHBulkSetupForm(SuperBulkSetupModel superBulkSetupModel, int?i) { HRProfile hrprofile = new LINQCalls().hrprofile(superBulkSetupModel.BHSingleSetupModel.InitiatorLoginName, 1); if (hrprofile == null) { TempData["ErrorMessage"] = "Error : You staff profile is not properly setup"; TempData["superBulkSetupModel"] = superBulkSetupModel; return(RedirectToAction("BHBulkSetupForm")); } //now get the initiator model and convert it to a datatable List <SetupExcelModel> setupExcelModel = GetDataTableFromSpreadsheet(superBulkSetupModel.BHBulkSetupFormModel.UploadedExcelFile.InputStream, false, superBulkSetupModel.BHSingleSetupModel, hrprofile); if (setupExcelModel.Count() <= 0) { TempData["ErrorMessage"] = "Error : Please upload an excel file before continuing"; TempData["superBulkSetupModel"] = superBulkSetupModel; return(RedirectToAction("BHBulkSetupForm")); } var staffinputmodel = setupExcelModel.Select(entry => new StaffInputModel() { BranchCode = entry.StaffBranchCode , BranchName = entry.StaffBranch , InitiatorName = entry.StaffName , InitiatorNumber = entry.StaffNumber //, InitiatorGrade = String.Empty , Comments = String.Empty , AppraisalPeriod = entry.SelectedAppraisalPeriod , HODeptCode = "" //entry.HODeptCode , HODeptName = "" //entry.HODeptName , HRStaffNumber = entry.HRProfile.employee_number , HRStaffName = entry.HRProfile.name }).ToList(); IEnumerable <StaffInputModel> staffInputModel = staffinputmodel; DataTable dataTable = ToDataTable(staffInputModel); //now upload the list to the db string retVal = new AppDatabase().insertBulkSetup(dataTable, "AppraisalDbConnectionString"); if (retVal != null) { TempData["UploadComplete"] = "false"; TempData["ErrorMessage"] = retVal; TempData["superBulkSetupModel"] = superBulkSetupModel; return(RedirectToAction("BHBulkSetupForm")); } TempData["UploadComplete"] = "true"; return(RedirectToAction("BHBulkSetupForm", new { ActionState = 0 })); }
public ActionResult ViewAppraisalApprovers(string FilterBy = "") { System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~/"); System.Configuration.KeyValueConfigurationElement CurrentAppraisalPeriod = rootWebConfig.AppSettings.Settings["CurrentAppraisalPeriod"]; List <AppraisalApproverModel> appraisalApproverModel = LINQCalls.getApproverSetupList(); if (!String.IsNullOrEmpty(FilterBy)) { appraisalApproverModel = FilterAppraisalApproverList(appraisalApproverModel, FilterBy.ToUpper()); } return(View(appraisalApproverModel)); }
public ActionResult OpenPassportEntry(string WorkflowID, int RequestStageID) { Session["UserName"] = @User.Identity.Name; this._UserName = Session["UserName"] as string ?? ""; if (_UserName == null || _UserName.Equals(String.Empty)) { ViewBag.ErrorMessage = "You must be logged in to continue."; return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval")); } //now resolve the user profile from AD and Xceed StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = _UserName; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); if (staffADProfile == null) { ViewBag.ErrorMessage = "Your profile is not properly setup on the system. Please contact InfoTech."; return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval")); } List <string> approvers = LINQCalls.getApproverIDs(WorkflowID, RequestStageID); bool isApprover = approvers.Contains(staffADProfile.employee_number); //get the request and setup the superPassportModel object string routeController = "PassportReviewForm"; TempData["superPassportModel"] = null; if (isApprover) { routeController = "PassportReviewForm"; } if (!RequestStageID.Equals(-1)) { return(RedirectToAction(routeController, "PassportReview", new { WorkflowID = WorkflowID, editMode = isApprover, myEntries = false })); } else { return(RedirectToAction("EditPassport", "PassportInput", new { WorkflowID = WorkflowID, editMode = isApprover, myEntries = true })); } }
public ActionResult Reroute(string RerouteAction, RerouteModel rerouteModel) { //now resolve the user profile from AD and Xceed StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = Session["UserName"] as string; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); if (staffADProfile == null) { ViewBag.ErrorMessage = "Your profile is not properly setup on the system. Please contact InfoTech."; return(View()); } // staffADProfile = new LINQCalls().setInitiatorFields( staffADProfile ); /* * if( staffADProfile.branch_code==null ){ * ViewBag.ErrorMessage="Your profile is not properly setup for Target. Please contact Human Resources."; * return View(); * } */ staffADProfile.appperiod = "20150712"; string _retVal = new AppDatabase().routeTargetEntries(rerouteModel, staffADProfile, "AppraisalDbConnectionString"); Debug.WriteLine(_retVal); if (_retVal != null) { TempData["UploadComplete"] = "false"; ViewBag.ErrorMessage = _retVal; TempData["rerouteModel"] = rerouteModel; } else { int newstageid = Int32.Parse(rerouteModel.NewRequestStageCode); var approvers = new LINQCalls().getApproverNames(rerouteModel.WorkflowID, newstageid); TempData["PostBackMessage"] = REROUTEDMSG; TempData["Approvers"] = string.Join("\\n", approvers.ToArray()); return(RedirectToAction("Reports", "Reports", new { UserName = Session["UserName"] as string, ReportMode = Session["ReportMode"] as string })); } return(RedirectToAction("Reroute", "Reroute", new { UserName = Session["UserName"] as string, ReportMode = Session["ReportMode"] as string })); }
public static StaffADProfile getStaffADProfile(string user_name = "") { user_name = string.IsNullOrEmpty(user_name) ? System.Web.HttpContext.Current.User.Identity.Name : user_name.Trim(); //Get the staff profile StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = user_name; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); if (staffADProfile == null) { return(null); } return(LINQCalls.getXceedProfile(staffADProfile)); }
public ActionResult ViewBranchInitiators(string FilterBy = "") { System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~/"); System.Configuration.KeyValueConfigurationElement CurrentAppraisalPeriod = rootWebConfig.AppSettings.Settings["CurrentAppraisalPeriod"]; List <BHSingleSetupModel> bHSingleSetupModel = new LINQCalls().getBranchInitiators(CurrentAppraisalPeriod.Value.ToString()); if (!String.IsNullOrEmpty(FilterBy)) { /*bHSingleSetupModel = bHSingleSetupModel.Where( c => c.SetupBranch.ToUpper().Contains(FilterBy) || * c.StaffNumber.ToUpper().Contains(FilterBy) || * c.StaffName.ToUpper().Contains(FilterBy) || * c.SetupAppPeriod.ToUpper().Contains(FilterBy) || * c.SelectedAppraisalPeriod.ToUpper().Contains(FilterBy)) * .ToList();*/ bHSingleSetupModel = FilterBranchInitiatorList(bHSingleSetupModel, FilterBy.ToUpper()); } return(View(bHSingleSetupModel)); }
public ActionResult GetApprovers(string WorkflowID, int RequestStageID) { string errorResult = "{{\"employee_number\":\"{0}\",\"name\":\"{1}\"}}"; if (string.IsNullOrEmpty(WorkflowID)) { errorResult = string.Format(errorResult, "Error", "Invalid entry detected"); return(Content(errorResult, "application/json")); } string approvers = new LINQCalls().getMemoApproverNames(WorkflowID, RequestStageID); if (approvers == null || approvers == "") { errorResult = string.Format(errorResult, null, "No approvers found for the entry"); return(Content(errorResult, "application/json")); } else { //20090022$ESOGBUE IKECHUKWU P$14$205$SEA|20110326$KALU NNANNA I$15$248$EA List <SignerDetails> signerDetails = new List <SignerDetails>(); SignerDetails _signerDetails; string[] approvers_ = approvers.Split('|'); foreach (string str in approvers_) { _signerDetails = new SignerDetails(); string[] appr_ = str.Split('$'); _signerDetails.ApproverStaffNumber = appr_[0]; _signerDetails.ApproverStaffName = appr_[1]; _signerDetails.GradeID = Int32.Parse(appr_[2]); _signerDetails.PayGroup_ID = Int32.Parse(appr_[3]); _signerDetails.ApproverGrade = appr_[4]; signerDetails.Add(_signerDetails); } return(Json(signerDetails.ToArray(), JsonRequestBehavior.AllowGet)); } }
public ActionResult GetApprovers(string WorkflowID, int RequestStageID) { string errorResult = "{{\"employee_number\":\"{0}\",\"name\":\"{1}\"}}"; if (string.IsNullOrEmpty(WorkflowID)) { errorResult = string.Format(errorResult, "Error", "Invalid entry detected"); return(Content(errorResult, "application/json")); } var profile = (RequestStageID == 20) ? LINQCalls.getHRApproverNames(WorkflowID, RequestStageID):LINQCalls.getApproverNumbersToNames(WorkflowID, RequestStageID); if (profile == null || profile.Count() <= 0) { errorResult = string.Format(errorResult, null, "No approvers found for the entry"); return(Content(errorResult, "application/json")); } else { return(Json(profile, JsonRequestBehavior.AllowGet)); } }
public ActionResult HRRoleSetup(AppraisalApproverModel appraisalApproverModel) { appraisalApproverModel.EntryKey = (String.IsNullOrEmpty(appraisalApproverModel.EntryKey)) ? getHREntryKey(appraisalApproverModel) : appraisalApproverModel.EntryKey; HRProfile hrprofile = LINQCalls.hrprofile(appraisalApproverModel.HRStaffName, 1); if (hrprofile == null) { TempData["ErrorMessage"] = "Error : You staff profile is not properly setup"; } //Get the staff's username from the staff number //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(appraisalApproverModel.StaffNumber); string _username = activeDirectoryQuery.GetUserName(); if (_username == null) { ViewBag.ErrorMessage = "The user's profile is not properly setup on the system. Please contact InfoTech."; return(View()); } appraisalApproverModel.UserName = _username; //Setup the staff string retVal = new AppDatabase().insertRoleSetup(appraisalApproverModel, hrprofile, "AppraisalDbConnectionString"); if (!String.IsNullOrEmpty(retVal) && !retVal.Split('|')[0].Equals("0")) { TempData["ErrorMessage"] = "Error :" + retVal.Split('|')[1]; } else { appraisalApproverModel = null; } TempData["appraisalApproverModel"] = appraisalApproverModel; return(RedirectToAction("HRRoleSetup")); }
// GET: MyEntries public ActionResult MyEntries() { _UserName = User.Identity.Name; Session["UserName"] = User.Identity.Name; if (_UserName == null || _UserName.Equals(String.Empty)) { ViewBag.ErrorMessage = "You must be logged in to continue."; return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval")); } Session["UserName"] = _UserName; //now resolve the user profile from AD and Xceed StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = _UserName; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); if (staffADProfile == null) { ViewBag.ErrorMessage = "Your profile is not properly setup on the system. Please contact InfoTech."; return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval", new { UserName = Session["UserName"] as string })); } ViewBag.AppID = DataHandlers.APP_ID; ViewBag.StaffBranch = staffADProfile.branch_name; //+ ( ( staffADProfile.branch_code.Equals(HOBRCODE) ) ? " | " + staffADProfile.hodeptcode : String.Empty ); //Check if the initiator/branch/has an existing entry for the AppraisalPeriod from the Database List <MyMemoEntriesModel> entryDetails = new List <MyMemoEntriesModel>(); entryDetails = new LINQCalls().getMyMemoWorkflows(staffADProfile); return(View(entryDetails)); }
public ActionResult AppraisalApproverBulkSetupForm(SuperApproverBulkSetupModel superApproverBulkSetupModel) { HRProfile hrprofile = LINQCalls.hrprofile(Session["UserName"] as String, 1); if (hrprofile == null) { TempData["ErrorMessage"] = "Error : You staff profile is not properly setup"; TempData["superApproverBulkSetupModel"] = superApproverBulkSetupModel; return(RedirectToAction("AppraisalApproverBulkSetupForm")); } //string periodSelectedValue = Request.Form["BHSingleSetupModel.SelectedAppraisalPeriod"]; HttpPostedFileBase uploadedExcelFile = superApproverBulkSetupModel.AppraisalApproverBulkModel.UploadedExcelFile; AppraisalApproverBulkModel sppraisalApproverBulkModel = superApproverBulkSetupModel.AppraisalApproverBulkModel; List <ApproverExcelModel> approverExcelModel = GetDataTableFromSpreadsheet(superApproverBulkSetupModel.AppraisalApproverBulkModel.UploadedExcelFile.InputStream, false, hrprofile); superApproverBulkSetupModel.ApproverExcelModel = approverExcelModel; //TempData[ "periodSelectedValue" ] = periodSelectedValue; TempData["superApproverBulkSetupModel"] = superApproverBulkSetupModel; return(RedirectToAction("AppraisalApproverBulkSetupForm")); }
public ActionResult GetStaffProfile(String StaffNumber) { string errorResult = "{{\"employee_number\":\"{0}\",\"name\":\"{1}\"}}"; if (string.IsNullOrEmpty(StaffNumber)) { errorResult = string.Format(errorResult, "Error", "Invalid staff number"); return(Content(errorResult, "application/json")); } var profile = new LINQCalls().getBranchStaffProfile(StaffNumber, 1); if (profile == null) { errorResult = string.Format(errorResult, "Error", "No records found for the staff number"); return(Content(errorResult, "application/json")); } else { return(Json(profile, JsonRequestBehavior.AllowGet)); } }
public ActionResult BHSingleSetupForm(BHSingleSetupModel bHSingleSetupModel) { if (!ModelState.IsValid) { TempData["ErrorMessage"] = "Invalid model "; TempData["bHSingleSetupModel"] = bHSingleSetupModel; return(RedirectToAction("BHSingleSetupForm")); } bool duplicateEntry = new LINQCalls().checkDuplicateEntry( bHSingleSetupModel.SelectedAppraisalPeriod, bHSingleSetupModel.StaffNumber, bHSingleSetupModel.SelectedBranch ); if (bHSingleSetupModel.SelectedBranch != "001") { if (!duplicateEntry) { TempData["ErrorMessage"] = "Error : The staff number " + bHSingleSetupModel.StaffNumber + " OR branch " + bHSingleSetupModel.SetupBranch + " has been setup for the selected appraisal period"; TempData["bHSingleSetupModel"] = bHSingleSetupModel; return(RedirectToAction("BHSingleSetupForm")); } } HRProfile hrprofile = new LINQCalls().hrprofile(bHSingleSetupModel.InitiatorLoginName, 1); if (hrprofile == null) { TempData["ErrorMessage"] = "Error : You staff profile is not properly setup"; TempData["bHSingleSetupModel"] = bHSingleSetupModel; return(RedirectToAction("BHSingleSetupForm")); } //Setup the branch int inputMode = 0; int retVal = new AppDatabase().insertSingleSetup(bHSingleSetupModel, hrprofile, inputMode, "AppraisalDbConnectionString"); return(RedirectToAction("BHSingleSetupForm")); }
public ActionResult BHSingleSetupFormEdit(BHSingleSetupEditModel bHSingleSetupEditModel) { if (!ModelState.IsValid) { TempData["ErrorMessage"] = "Invalid model "; TempData["bHSingleSetupEditModel"] = bHSingleSetupEditModel; return(RedirectToAction("BHSingleSetupFormEdit")); } HRProfile hrprofile = new LINQCalls().hrprofile(bHSingleSetupEditModel.InitiatorLoginName, 1); if (hrprofile == null) { TempData["ErrorMessage"] = "Error : You staff profile is not properly setup"; TempData["bHSingleSetupEditModel"] = bHSingleSetupEditModel; return(RedirectToAction("BHSingleSetupFormEdit")); } int inputMode = 1; int retVal = new AppDatabase().insertSingleSetup(bHSingleSetupEditModel, hrprofile, inputMode, "AppraisalDbConnectionString"); return(RedirectToAction("ViewBranchInitiators")); }
public IHttpActionResult PostLeaveAllowanceToAccount(string initiator_employee_number, string amount, string transaction_ref, string approver_employee_number) { logwriter.WriteTolog("In get leave Allowance"); StaffADProfile initiatorADProfile = new StaffADProfile(); initiatorADProfile.employee_number = initiator_employee_number; initiatorADProfile = LINQCalls.getXceedProfile(initiatorADProfile); string leave_gl_code = "01-" + initiatorADProfile.branch_code + "-1-53055"; string connString = ConfigurationManager.ConnectionStrings["PhoenixConn"].ConnectionString; FTPostingProfille postingProfile = new FTPostingProfille(); List <PostingEntries> plist = new List <PostingEntries>(); postingProfile = new FTPostingProfille(initiatorADProfile.employee_number, initiatorADProfile.branch_code, amount, transaction_ref, approver_employee_number); //force debit outstanding amount plist = new List <PostingEntries>(); plist.Add(new PostingEntries(leave_gl_code, amount, "DR", "LEAVE ALLOWANCE " + postingProfile.getLeaveFinancialYear() + " /" + initiatorADProfile.name + "/" + initiatorADProfile.account_no)); plist.Add(new PostingEntries(initiatorADProfile.account_no, amount, "CR", "LEAVE ALLOWANCE " + postingProfile.getLeaveFinancialYear() + " /" + initiatorADProfile.name + "/" + initiatorADProfile.account_no)); postingProfile.PostingEntries = plist; Tuple <int, string> postResult = postingProfile.insertTransaction(); if (!postResult.Item1.Equals(0)) { return(Ok(postResult.Item1 + " : " + postResult.Item2)); } else { return(Ok("00: Post Success")); } }
public ActionResult BHBulkSetupForm(SuperBulkSetupModel superBulkSetupModel) { HRProfile hrprofile = new LINQCalls().hrprofile(superBulkSetupModel.BHSingleSetupModel.InitiatorLoginName, 1); if (hrprofile == null) { TempData["ErrorMessage"] = "Error : You staff profile is not properly setup"; TempData["superBulkSetupModel"] = superBulkSetupModel; return(RedirectToAction("BHBulkSetupForm")); } string periodSelectedValue = Request.Form["BHSingleSetupModel.SelectedAppraisalPeriod"]; HttpPostedFileBase uploadedExcelFile = superBulkSetupModel.BHBulkSetupFormModel.UploadedExcelFile; superBulkSetupModel.BHSingleSetupModel.Comments = ""; BHBulkSetupFormModel bHBulkSetupFormModel = superBulkSetupModel.BHBulkSetupFormModel; List <SetupExcelModel> setupExcelModel = GetDataTableFromSpreadsheet(bHBulkSetupFormModel.UploadedExcelFile.InputStream, false, superBulkSetupModel.BHSingleSetupModel, hrprofile); superBulkSetupModel.SetupExcelModel = setupExcelModel; TempData["periodSelectedValue"] = periodSelectedValue; TempData["superBulkSetupModel"] = superBulkSetupModel; return(RedirectToAction("BHBulkSetupForm")); }
public static SelectList GetBranches() { return(LINQCalls.getBranches()); }
/*public static SelectList GetUnits( string deptcode ) { * return LINQCalls.getUnits( deptcode ); * } * public static SelectList GetDepts() { * return LINQCalls.getDepts(); * }*/ internal static SelectList GetHRRoles() { return(LINQCalls.getHRRoles()); }