public ActionResult Index() { StaffADProfile staffADProfile = new StaffADProfile(); // staffADProfile.user_logon_name = Environment.UserName; staffADProfile.user_logon_name = User.Identity.Name; // staffADProfile.user_logon_name = "ijeoma.okoye"; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); Profile profile = new Profile(); profile = new LinqCalls().getProfile(staffADProfile.employee_number); bool checkICA = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["ICA"] = checkICA; bool checkAdmin = new IC_A_Users().ValidateAdminUser(staffADProfile.employee_number); ViewData["Admin"] = checkAdmin; if (profile.JobTitle == "HEAD OF OPERATIONS" || profile.JobTitle == "ACTING HEAD OF OPERATIONS" || checkAdmin == true) { ViewData["HopUser"] = true; } else { ViewData["HopUser"] = false; } return(View()); }
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 SearchPage() { StaffADProfile staffADProfile = new StaffADProfile(); //CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); Profile profile = new Profile(); profile = new LinqCalls().getProfile(staffADProfile.employee_number); bool checkICA = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["ICA"] = checkICA; bool checkAdmin = new IC_A_Users().ValidateAdminUser(staffADProfile.employee_number); ViewData["Admin"] = checkAdmin; if (checkICA || checkAdmin) { ViewData["HopUser"] = false; //ViewData["ICA"] = true; return(View()); } else { ViewData["HopUser"] = false; //ViewData["ICA"] = false; TempData["ErrorMessage"] = "You are not Authorized to view this page"; //TempData["Approvernames"] = string.Join("\\n", approverNames); return(RedirectToAction("ErrorPage")); } }
public ActionResult Manage_Approval_List() { StaffADProfile staffADProfile = new StaffADProfile(); CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); currentuser.UserNo = staffADProfile.employee_number; currentuser.UserName = staffADProfile.in_StaffName; currentuser.logonName = staffADProfile.user_logon_name; currentuser.Email = staffADProfile.email; bool checkApproverUser = new AppClass().ValidateCheckApproverUser(currentuser.UserNo); ViewData["checkApproverUser"] = checkApproverUser; if (!checkApproverUser) { TempData["ErrorMessage"] = ""; return(RedirectToAction("AwaitingApproval")); } else { ApproverInfo approvers = new ApproverInfo(); //approvers = new AdminClass().GetApproverList(); ViewBag.ErrorMessage = TempData["ErrorMessage"] as string; return(View(approvers)); } //List<ApproverInfo> approvers = new List<ApproverInfo>(); }
public ActionResult Edit_Approver(string StaffNumber) { try { StaffADProfile staffADProfile = new StaffADProfile(); CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); currentuser.UserNo = staffADProfile.employee_number; bool checkApproverUser = new AppClass().ValidateCheckApproverUser(currentuser.UserNo); ViewData["checkApproverUser"] = checkApproverUser; ApproverInfo approvers = new ApproverInfo(); approvers = new AdminClass().GetApproverDetails(StaffNumber).First(); ViewBag.ErrorMessage = TempData["ErrorMessage"] as string; return(View(approvers)); }catch (Exception ex) { TempData["ErrorMessage"] = ex.Message; return(RedirectToAction("Edit_Approver")); } }
/*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 ErrorPage() { StaffADProfile staffADProfile = new StaffADProfile(); // CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); bool checkICA = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["ICA"] = checkICA; bool checkAdmin = new IC_A_Users().ValidateAdminUser(staffADProfile.employee_number); ViewData["Admin"] = checkAdmin; Profile profile = new Profile(); profile = new LinqCalls().getProfile(staffADProfile.employee_number); if (profile.JobTitle == "HEAD OF OPERATIONS" || profile.JobTitle == "ACTING HEAD OF OPERATIONS" || checkAdmin == true) { ViewData["HopUser"] = true; } else { ViewData["HopUser"] = false; } ViewBag.ErrorMessage = TempData["ErrorMessage"] as string; return(View()); }
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 AwaitingApproval() { try { StaffADProfile staffADProfile = new StaffADProfile(); // staffADProfile.user_logon_name = User.Identity.Name; CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); currentuser.UserNo = staffADProfile.employee_number; currentuser.UserName = staffADProfile.in_StaffName; currentuser.logonName = staffADProfile.user_logon_name; currentuser.Email = staffADProfile.email; List <TravelRequest> requestList = new List <TravelRequest>(); bool checkApprover = new AppClass().ValidateCurrentUser(currentuser); bool checkApproverUser = new AppClass().ValidateCheckApproverUser(currentuser.UserNo); ViewData["checkApproverUser"] = checkApproverUser; // bool checkAdmin = new AppClass().ValidateAdminUser(staffADProfile.employee_number); string Key = TempData["key"] as string; if (Key != "Approval") { ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? "" : "<script type='text/javascript'>alert(\"" + TempData["ErrorMessage"] + "\\n\\n" + TempData["Approvernames"] + "\");</script>"; } else { ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? "" : "<script type='text/javascript'>alert('" + TempData["ErrorMessage"] + "');</script>"; } //ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? // "" : "<script type='text/javascript'>alert(\"" + TempData["ErrorMessage"] + "\\n\\n" + TempData["Approvernames"] + "\");</script>"; // ViewBag.PostBackMessage = "<script type='text/javascript'>alert(\"" + PostBackMessage + "\\n\\n" + Approvers + "\");</script>"; if (checkApprover != false) { requestList = new AppClass().AwaitingApprovals(); return(View(requestList)); } else { return(View(requestList)); } } catch (Exception ex) { return(View(ex.Message)); } }
public ActionResult UpdateApprover(ApproverInfo approver) { try { StaffADProfile staffADProfile = new StaffADProfile(); CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); currentuser.UserNo = staffADProfile.employee_number; bool checkApproverUser = new AppClass().ValidateCheckApproverUser(currentuser.UserNo); ViewData["checkApproverUser"] = checkApproverUser; bool checkAdmin = new AppClass().ValidateAdminUser(currentuser.UserNo); //ViewData["checkAdmin"] = checkAdmin; if (!checkAdmin) { TempData["ErrorMessage"] = "You are not authorized to Perform these operation"; TempData["TravelRequest"] = approver; return(RedirectToAction("Manage_Approval_List")); } else { var Update = new AdminClass().UpdateApprover(approver); string[] result = Update.ToString().Split('|'); if (result[0] != "0") { if (result[0] == "2627") { TempData["ErrorMessage"] = "User Already Existed on Approver list"; // TempData["TravelRequest"] = approver; return(RedirectToAction("EditApprover")); } else { TempData["ErrorMessage"] = result[1]; //TempData["TravelRequest"] = approver; return(RedirectToAction("EditApprover")); } } else { TempData["ErrorMessage"] = "You have successfully Updated ApproverName"; // TempData["Approvernames"] = string.Join("\\n", approverNames); return(RedirectToAction("ApproverList")); } } } catch (Exception ex) { return(Content(ex.Message)); } }
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 NewIncident() { long ticks = DateTime.Now.Ticks; byte[] bytes = BitConverter.GetBytes(ticks); string id = Convert.ToBase64String(bytes) .Replace('+', '_') .Replace('/', '-') .TrimEnd('='); StaffADProfile staffADProfile = new StaffADProfile(); // staffADProfile.user_logon_name = Environment.UserName; staffADProfile.user_logon_name = User.Identity.Name; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); Profile profile = new Profile(); profile = new LinqCalls().getProfile(staffADProfile.employee_number); bool checkICA = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["ICA"] = checkICA; bool checkAdmin = new IC_A_Users().ValidateAdminUser(staffADProfile.employee_number); ViewData["Admin"] = checkAdmin; if (profile.JobTitle == "HEAD OF OPERATIONS" || profile.JobTitle == "ACTING HEAD OF OPERATIONS" || checkAdmin == true) { ViewData["HopUser"] = true; InputClass input = new InputClass(); Account account = new Account(); input.RequesterDetails = profile; input.RequesterDetails.JobTitle = profile.JobTitle; input.RequesterDetails.Job_Category = profile.JobTitle; input.AccountDetials = account; input.RequesterDetails.Email = staffADProfile.email; input.DocumentID = profile.StaffNo + "BVNINCIDENT" + id; return(View(input)); } else { ViewData["HopUser"] = false; TempData["ErrorMessage"] = "You are not Authorized to view this page"; return(RedirectToAction("ErrorPage")); } //AD }
public ActionResult ApproverList() { try { StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); List <ApproverInfo> approverList = new List <ApproverInfo>(); // bool checkApprover = new AppClass().ValidateCurrentUser(currentuser); //bool checkApproverUser = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); //ViewData["checkApproverUser"] = checkApproverUser; bool checkICA = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["ICA"] = checkICA; bool checkAdmin = new IC_A_Users().ValidateAdminUser(staffADProfile.employee_number); ViewData["Admin"] = checkAdmin; if (staffADProfile.jobtitle == "HEAD OF OPERATIONS" || staffADProfile.jobtitle == "ACTING HEAD OF OPERATIONS") { ViewData["HopUser"] = true; } else { ViewData["HopUser"] = false; } if (checkAdmin != false) { approverList = new IC_A_Users().GetApproverList(); ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? "" : "<script type='text/javascript'>alert('" + TempData["ErrorMessage"] + "');</script>"; return(View(approverList)); } else { ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? "" : "<script type='text/javascript'>alert('" + TempData["ErrorMessage"] + "');</script>"; return(View(approverList)); } } catch (Exception ex) { ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? "" : "<script type='text/javascript'>alert('" + TempData["ErrorMessage"] + "');</script>"; return(View(ex.Message)); } return(View()); }
internal static zib_workflow_xceed_definitions getXceedDefinition(StaffADProfile staffADProfile) { AppraisalDbEntities conn = new AppraisalDbEntities(); var entry = (from d in conn.zib_workflow_xceed_definitions where (d.ad_org_id.Equals(staffADProfile.org_id)) select d ).First(); return(entry); }
public ActionResult Edit_Approver(string StaffNumber) { try { StaffADProfile staffADProfile = new StaffADProfile(); // CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); //currentuser.UserNo = staffADProfile.employee_number; //bool checkApproverUser = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); //ViewData["checkApproverUser"] = checkApproverUser; bool checkICA = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["ICA"] = checkICA; bool checkAdmin = new IC_A_Users().ValidateAdminUser(staffADProfile.employee_number); ViewData["Admin"] = checkAdmin; Profile profile = new Profile(); profile = new LinqCalls().getProfile(staffADProfile.employee_number); if (profile.JobTitle == "HEAD OF OPERATIONS" || profile.JobTitle == "ACTING HEAD OF OPERATIONS") { ViewData["HopUser"] = true; } else { ViewData["HopUser"] = false; } if (!checkAdmin) { TempData["ErrorMessage"] = "You are not authorized to Perform these operation"; //TempData["TravelRequest"] = approver; return(RedirectToAction("Manage_Approval_List")); } else { ApproverInfo approvers = new ApproverInfo(); approvers = new IC_A_Users().GetApproverDetails(StaffNumber).First(); ViewBag.ErrorMessage = TempData["ErrorMessage"] as string; return(View(approvers)); } } catch (Exception ex) { TempData["ErrorMessage"] = ex.Message; return(RedirectToAction("Edit_Approver")); } }
internal string inputTargetEntriesHRUpload(string workflowid, StaffADProfile staffADProfile, string ConnString, string Status) { string retVal = null; string connString = getConnectionString(ConnString); SqlConnection conn = new SqlConnection(connString); SqlCommand cmnd = new SqlCommand(); cmnd.Connection = conn; cmnd.CommandType = CommandType.StoredProcedure; cmnd.CommandText = "zsp_insert_target_entries_hrupload"; cmnd.Parameters.Add("@workflowids", SqlDbType.VarChar).Value = workflowid; cmnd.Parameters.Add("@deptname", SqlDbType.VarChar).Value = staffADProfile.branch_name; cmnd.Parameters.Add("@deptcode", SqlDbType.VarChar).Value = staffADProfile.branch_code; cmnd.Parameters.Add("@target_status", SqlDbType.VarChar).Value = Status; cmnd.Parameters.Add("@hr_uploader_name", SqlDbType.VarChar).Value = staffADProfile.user_logon_name; cmnd.Parameters.Add("@hr_uploader_id", SqlDbType.VarChar).Value = staffADProfile.employee_number; cmnd.Parameters.Add("@appperiod", SqlDbType.VarChar).Value = staffADProfile.appperiod; cmnd.Parameters.Add("@appid", SqlDbType.VarChar).Value = DataHandlers.APP_ID; cmnd.Parameters.Add("@rErrorCode", SqlDbType.Int, 2).Direction = ParameterDirection.Output; cmnd.Parameters.Add("@rErrorMsg", SqlDbType.VarChar, 255).Direction = ParameterDirection.Output; SqlDataReader dr; try { // Open the data connection cmnd.Connection = conn; conn.Open(); dr = cmnd.ExecuteReader(); int retCode = int.Parse(cmnd.Parameters["@rErrorCode"].Value.ToString()); if (retCode != 0) { retVal = retCode + "|" + cmnd.Parameters["@rErrorMsg"].Value.ToString(); } } catch (SqlException ex) { if (ex.Number != 0) { retVal = ex.Number + "|" + ex.Message; logWriter.WriteErrorLog(string.Format("inpuTargetEntries : Exception!!! / {0}", retVal)); } } finally { conn.Close(); cmnd.Dispose(); dr = null; } return(retVal); }
internal string routeTargetEntries(RerouteModel rerouteModel, StaffADProfile staffADProfile, string ConnString) { string retVal = null; string connString = getConnectionString(ConnString); SqlConnection conn = new SqlConnection(connString); SqlCommand cmnd = new SqlCommand(); cmnd.Connection = conn; cmnd.CommandType = CommandType.StoredProcedure; cmnd.CommandText = "zsp_reroute_target_entries"; cmnd.Parameters.Add("@workflowid", SqlDbType.VarChar).Value = rerouteModel.WorkflowID; cmnd.Parameters.Add("@newrequeststageid", SqlDbType.Int).Value = Int32.Parse(rerouteModel.NewRequestStageCode); cmnd.Parameters.Add("@comments", SqlDbType.VarChar).Value = rerouteModel.Comments; cmnd.Parameters.Add("@target_status", SqlDbType.VarChar).Value = "Rerouted"; cmnd.Parameters.Add("@hr_uploader_name", SqlDbType.VarChar).Value = staffADProfile.user_logon_name; cmnd.Parameters.Add("@hr_uploader_id", SqlDbType.VarChar).Value = staffADProfile.employee_number; cmnd.Parameters.Add("@appperiod", SqlDbType.VarChar).Value = staffADProfile.appperiod; cmnd.Parameters.Add("@appid", SqlDbType.VarChar).Value = DataHandlers.APP_ID; cmnd.Parameters.Add("@rErrorCode", SqlDbType.Int, 2).Direction = ParameterDirection.Output; cmnd.Parameters.Add("@rErrorMsg", SqlDbType.VarChar, 255).Direction = ParameterDirection.Output; SqlDataReader dr; try { // Open the data connection cmnd.Connection = conn; conn.Open(); dr = cmnd.ExecuteReader(); int retCode = int.Parse(cmnd.Parameters["@rErrorCode"].Value.ToString()); if (retCode != 0) { retVal = retCode + "|" + cmnd.Parameters["@rErrorMsg"].Value.ToString(); } } catch (SqlException ex) { if (ex.Number != 0) { retVal = ex.Number + "|" + ex.Message; logWriter.WriteErrorLog(string.Format("routeTargetEntries : Exception!!! / {0}", retVal)); } } finally { conn.Close(); cmnd.Dispose(); dr = null; } return(retVal); }
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 })); } }
internal static Tuple <int, string, int> getXceedConnector(StaffADProfile staffADProfile) { AppraisalDbEntities conn = new AppraisalDbEntities(); var entry = (from d in conn.zib_workflow_xceed_definitions where (d.ad_org_id.Equals(staffADProfile.org_id)) select new { conn_name = d.conn_name, org_id = d.org_id, ad_org_id = d.ad_org_id }).First(); string connString = System.Configuration.ConfigurationManager.ConnectionStrings[entry.conn_name].ConnectionString; return(Tuple.Create(entry.org_id, connString, entry.ad_org_id)); }
public ActionResult Index() { StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.user_logon_name = User.Identity.Name; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); ViewBag.StaffNumber = staffADProfile.employee_number; bool checkApproverUser = new AppClass().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["checkApproverUser"] = checkApproverUser; return(View()); }
public ActionResult AdminPage() { StaffADProfile staffADProfile = new StaffADProfile(); CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); currentuser.UserNo = staffADProfile.employee_number; bool checkApproverUser = new AppClass().ValidateCheckApproverUser(currentuser.UserNo); ViewData["checkApproverUser"] = checkApproverUser; return(View()); }
public static StaffADProfile getStaffADProfile(string staff_id, int chk = 0) { //Get the staff profile StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile.employee_number = staff_id; //AD //ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile, staff_number); // = activeDirectoryQuery.GetStaffProfileByNumber(); //if (staffADProfile == null) //{ // return null; //} return(LINQCalls.getXceedProfile(staffADProfile)); }
private StaffADProfile GetStaffInformation(string username, string password, string domain) { SearchResult rs = null; try { Debug.WriteLine(username); Debug.WriteLine(password); Debug.WriteLine(domain); rs = SearchUserByUserName(GetDirectorySearcher(username, password, domain)); if (rs != null) { DirectoryEntry de = rs.GetDirectoryEntry(); staffADProfile.employee_number = object.ReferenceEquals(de.Properties["description"].Value as string, null) ? String.Empty : de.Properties["description"].Value.ToString(); staffADProfile.branch_name = object.ReferenceEquals(de.Properties["physicalDeliveryOfficeName"].Value as string, null) ? String.Empty : de.Properties["physicalDeliveryOfficeName"].Value.ToString(); staffADProfile.branch_address = object.ReferenceEquals(de.Properties["streetAddress"].Value as string, null) ? String.Empty : de.Properties["streetAddress"].Value.ToString(); staffADProfile.mobile_phone = object.ReferenceEquals(de.Properties["mobile"].Value as string, null) ? String.Empty : de.Properties["mobile"].Value.ToString(); staffADProfile.gsm = object.ReferenceEquals(de.Properties["telephoneNumber"].Value as string, null)? String.Empty : de.Properties["telephoneNumber"].Value.ToString(); staffADProfile.jobtitle = object.ReferenceEquals(de.Properties["title"].Value as string, null) ? String.Empty : de.Properties["title"].Value.ToString(); staffADProfile.office_ext = object.ReferenceEquals(de.Properties["pager"].Value as string, null) ? String.Empty : de.Properties["pager"].Value.ToString(); staffADProfile.department = object.ReferenceEquals(de.Properties["department"].Value as string, null) ? String.Empty : de.Properties["department"].Value.ToString(); staffADProfile.user_logon_name = object.ReferenceEquals(de.Properties["sAMAccountName"].Value as string, null) ? String.Empty : de.Properties["sAMAccountName"].Value.ToString(); staffADProfile.email = object.ReferenceEquals(de.Properties["mail"].Value as string, null) ? String.Empty : de.Properties["mail"].Value.ToString(); staffADProfile.membership = GetMemberships(de); staffADProfile.branch_code = GetBranchCode(de); logWriter.WriteErrorLog(string.Format("GetStaffInformation : User found!!! / {0}", staffADProfile.user_logon_name)); } else { staffADProfile = null; logWriter.WriteErrorLog(string.Format("GetStaffInformation : User not found!!! / {0}", staffADProfile.user_logon_name)); } } catch (Exception ex) { logWriter.WriteErrorLog(string.Format("GetStaffInformation : Exception!!! / {0}", ex.Message)); staffADProfile = null; } finally { Dispose(); rs = null; } return(staffADProfile); }
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 ActionResult Manage_Approval_List() { StaffADProfile staffADProfile = new StaffADProfile(); //CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); bool checkICA = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["ICA"] = checkICA; bool checkAdmin = new IC_A_Users().ValidateAdminUser(staffADProfile.employee_number); ViewData["Admin"] = checkAdmin; Profile profile = new Profile(); profile = new LinqCalls().getProfile(staffADProfile.employee_number); if (profile.JobTitle == "HEAD OF OPERATIONS" || profile.JobTitle == "ACTING HEAD OF OPERATIONS") { ViewData["HopUser"] = true; } else { ViewData["HopUser"] = false; } if (!checkAdmin) { TempData["ErrorMessage"] = ""; return(RedirectToAction("ErrorPage")); } else { ApproverInfo approvers = new ApproverInfo(); //approvers = new AdminClass().GetApproverList(); ViewBag.ErrorMessage = TempData["ErrorMessage"] as string; return(View(approvers)); } //List<ApproverInfo> approvers = new List<ApproverInfo>(); }
public ActionResult ApproverList() { try { StaffADProfile staffADProfile = new StaffADProfile(); CurrentUser currentuser = new CurrentUser(); staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); currentuser.UserNo = staffADProfile.employee_number; currentuser.UserName = staffADProfile.in_StaffName; currentuser.logonName = staffADProfile.user_logon_name; currentuser.Email = staffADProfile.email; List <ApproverInfo> approverList = new List <ApproverInfo>(); // bool checkApprover = new AppClass().ValidateCurrentUser(currentuser); bool checkApproverUser = new AppClass().ValidateCheckApproverUser(currentuser.UserNo); ViewData["checkApproverUser"] = checkApproverUser; if (checkApproverUser != false) { approverList = new AdminClass().GetApproverList(); ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? "" : "<script type='text/javascript'>alert('" + TempData["ErrorMessage"] + "');</script>"; return(View(approverList)); } else { ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? "" : "<script type='text/javascript'>alert('" + TempData["ErrorMessage"] + "');</script>"; return(View(approverList)); } } catch (Exception ex) { ViewBag.coInit = (String.IsNullOrEmpty(TempData["ErrorMessage"] as string)) ? "" : "<script type='text/javascript'>alert('" + TempData["ErrorMessage"] + "');</script>"; return(View(ex.Message)); } return(View()); }
public ActionResult NewRequest() { StaffADProfile staffADProfile = new StaffADProfile(); // staffADProfile.user_logon_name = Environment.UserName; staffADProfile.user_logon_name = User.Identity.Name; long ticks = DateTime.Now.Ticks; byte[] bytes = BitConverter.GetBytes(ticks); string id = Convert.ToBase64String(bytes) .Replace('+', '_') .Replace('/', '-') .TrimEnd('='); //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); TravelRequest newrequest = new TravelRequest(); Profile profile = new Profile(); Country countries = new Country(); Account acc = new Account(); acc.description = "no card"; countries.countryList = new AppClass().getCountry(); profile.StaffNo = staffADProfile.employee_number; bool checkApproverUser = new AppClass().ValidateCheckApproverUser(profile.StaffNo); ViewData["checkApproverUser"] = checkApproverUser; // bool checkAdmin = new AppClass().ValidateAdminUser(profile.StaffNo); profile = new AppClass().getProfile(profile.StaffNo); profile.Email = staffADProfile.email; newrequest.StaffProfile = profile; newrequest.id = "TRA" + profile.StaffNo + id; newrequest.country = countries; newrequest.Accountdetails = acc; ViewBag.ErrorMessage = TempData["ErrorMessage"] as string; //ViewBag.coInit = "<script type='text/javascript'>alert('"+ TempData["ErrorMessage"] +"');</script>"; return(View(newrequest)); }
public ActionResult FilterHRUpload(string FilterBy, FormCollection form, string[] WorkflowID, string TargetAction) { switch (TargetAction) { case "Search": TempData["FilterBy"] = FilterBy; return(RedirectToAction("HRUpload", new { UserName = Session["UserName"] as string })); case "Upload": StaffADProfile staffADProfile = new StaffADProfile(); staffADProfile = Session["staffADProfile"] as StaffADProfile; string _retVal = string.Empty; foreach (string workflowid in WorkflowID) { if (workflowid.Length > 0) { staffADProfile.user_logon_name = User.Identity.Name; ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); staffADProfile.branch_code = new LINQCalls().getEntryProfile(workflowid).branch_code; staffADProfile.branch_name = new LINQCalls().getEntryProfile(workflowid).branch_name; staffADProfile.appperiod = "20150712"; _retVal = new AppDatabase().inputTargetEntriesHRUpload(workflowid, staffADProfile, "AppraisalDbConnectionString", "Submitted"); if (_retVal != null) { TempData["UploadComplete"] = "false"; TempData["PostBackMessage"] = _retVal; } else { TempData["PostBackMessage"] = UPLOADEDMSG; TempData["Approvers"] = ""; } } } Debug.WriteLine(_retVal); break; //return RedirectToAction( "AwaitingMyApproval","AwaitingApproval",new { UserName = Session["UserName"] as string } ); } return(RedirectToAction("AwaitingMyApproval", "AwaitingApproval", new { UserName = Session["UserName"] as string })); }
internal static bool IsBranchHead(StaffADProfile staffADProfile) { XceedEntities ctx = new XceedEntities(); var result = new List <LinqResponseModel>(); switch (staffADProfile.branch_code) { case "001": result = (from w in ctx.vw_headoffice_workflow where w.depthead_number == staffADProfile.employee_number select new LinqResponseModel { value = w.depthead_name }).ToList(); break; case "013": result = (from w in ctx.vw_abuja_workflow where w.branch_head_number == staffADProfile.employee_number select new LinqResponseModel { value = w.branchhead_name }).ToList(); break; default: result = (from w in ctx.vw_branches_workflow where w.branch_head_number == staffADProfile.employee_number select new LinqResponseModel { value = w.branchhead_name }).ToList(); break; } if (result.Count > 0) { return(true); } else { return(false); } }
public ActionResult OpenIncident(string DocumentID) { StaffADProfile staffADProfile = new StaffADProfile(); // staffADProfile.user_logon_name = Environment.UserName; staffADProfile.user_logon_name = User.Identity.Name; //AD ActiveDirectoryQuery activeDirectoryQuery = new ActiveDirectoryQuery(staffADProfile); staffADProfile = activeDirectoryQuery.GetStaffProfile(); Profile profile = new Profile(); profile = new LinqCalls().getProfile(staffADProfile.employee_number); bool checkICA = new IC_A_Users().ValidateCheckApproverUser(staffADProfile.employee_number); ViewData["ICA"] = checkICA; bool checkAdmin = new IC_A_Users().ValidateAdminUser(staffADProfile.employee_number); ViewData["Admin"] = checkAdmin; if (profile.JobTitle == "HEAD OF OPERATIONS" || profile.JobTitle == "ACTING HEAD OF OPERATIONS" || checkAdmin == true || checkICA == true) { if (profile.JobTitle == "HEAD OF OPERATIONS" || profile.JobTitle == "ACTING HEAD OF OPERATIONS" || checkAdmin == true) { ViewData["HopUser"] = true; } else { ViewData["HopUser"] = false; } InputClass Entry = new InputClass(); Entry = new ProcessEntry().GetEntry(DocumentID).First(); ViewBag.date = Entry.DateSubmitted; return(View(Entry)); } else { ViewData["HopUser"] = false; TempData["ErrorMessage"] = "You are not Authorized to view this page"; return(RedirectToAction("ErrorPage")); } }