protected void btnMDFinal_Click(object sender, EventArgs e) { try { AppUser usr = null; if (Session["user"] != null) { usr = (AppUser)Session["user"]; } else { Response.Redirect("../Login.aspx", false); return; } int deptID = int.Parse(ddlDept.SelectedValue); List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptID).ToList(); if (budMenuLst.Count() > 0) { foreach (DeptBudgetItem dm in budMenuLst) { if (dm.Code == "CA")//for capex { Utility.UpdateBudgetCapex((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2); } if (dm.Code == "DI") { Utility.UpdateBudgetDirect((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2); } if (dm.Code == "ID") { Utility.UpdateBudgetIndirect((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2); } if (dm.Code == "MO") { Utility.UpdateBudgetMovable((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2); } if (dm.Code == "RE") { Utility.UpdateBudgetRevenue((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2); } if (dm.Code == "SA") { Utility.UpdateBudgetExistingSf((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2); } } BudgetYear budYr = (BudgetYear)Session["budgetYr"]; List <TrackApproval> getTrackApproval = null; getTrackApproval = LookUpBLL.GetTrackApproval(deptID, budYr.ID).ToList(); if (getTrackApproval != null && getTrackApproval.Count() > 0) { TrackApproval appTrack = getTrackApproval.FirstOrDefault(); appTrack.status = (int)Utility.BudgetItemStatus.MD_Approved; appTrack.ActionBy = usr.FullName; LookUpBLL.UpdateApprovalStatus(appTrack); dvExco.Visible = false; success.Visible = true; success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Budget has been successfully approved."; return; } else { LookUpBLL.AddApprovaltrack(new TrackApproval() { BudgetYr = budYr.ID, DepartmentID = deptID, ActionBy = usr.FullName, dateApproved = DateTime.Now, status = (int)Utility.BudgetItemStatus.MD_Approved }); dvExco.Visible = false; success.Visible = true; success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Budget has been successfully approved."; return; } } } catch (Exception ex) { error.Visible = true; error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!."; Utility.WriteError("Error: " + ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { error.Visible = false; success.Visible = false; try { // hidEDPending.Value = ""; hidMDPending.Value = ""; // btnCorrect.Visible = false; // btnMD.Visible = false; //dvExco.Visible = false; if (Session["user"] != null) { usr = (AppUser)Session["user"]; budYr = (BudgetYear)Session["budgetYr"]; } else { Response.Redirect("Login.aspx", false); return; } if (!IsPostBack) { lbDept.Text = usr.Department.Name.ToUpper(); lbyr.Text = budYr.Year; int budyrID = budYr.ID; int deptID = usr.DepartmentID.Value; List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptID).ToList(); if (budMenuLst.Count() > 0) { foreach (DeptBudgetItem dm in budMenuLst) { if (dm.Code == "CA")//for capex { Utility.ComputeBudgetSummaryCapexProjection(budyrID, deptID); } if (dm.Code == "DI") { Utility.ComputeBudgetSummaryDirectProjection(budyrID, deptID); } if (dm.Code == "ID") { Utility.ComputeBudgetSummaryIndirectProjection(budyrID, deptID); } if (dm.Code == "MO") { Utility.ComputeBudgetSummaryFixedAsset(budyrID, deptID); } if (dm.Code == "RE") { Utility.ComputeBudgetSummaryRevenue(budyrID, deptID); } if (dm.Code == "SA") { Utility.ComputeBudgetSummaryExistingStff(budyrID, deptID); } } } if (User.IsInRole(AdminRole) || User.IsInRole(PBMgrRole) || User.IsInRole(PBOffRole)) { dvFilter.Visible = true; Utility.BindDept(ddlDept); List <Department> deptList = DepartmentBLL.GetDeptList(); } if (User.IsInRole(MDRole)) { dvFilter.Visible = true; Utility.BindDept(ddlDept); List <Department> deptList = DepartmentBLL.GetDeptList(); lbDept.Visible = false; } if (User.IsInRole(EDRole)) { dvFilter.Visible = true; Utility.BindDept(ddlDept, usr.Department.DirectorateID.Value); List <Department> deptList = DepartmentBLL.GetDeptList(usr.Department.DirectorateID.Value); lbDept.Visible = false; } BindGrid(); if (User.IsInRole(deptApprRole)) { List <TrackApproval> getTrackApproval = null; getTrackApproval = LookUpBLL.GetTrackApproval(usr.DepartmentID.Value, budYr.ID).ToList(); if (getTrackApproval != null && getTrackApproval.Count() > 0) { TrackApproval tt = getTrackApproval.FirstOrDefault(); if (tt.status == (int)Utility.BudgetItemStatus.Returned_For_Correction) { dvDept.Visible = true; dvExco.Visible = false; //hidEDPending.Value = "1"; } } else { dvDept.Visible = true; dvExco.Visible = false; //hidEDPending.Value = "1"; } } } } catch (Exception ex) { error.Visible = true; error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!"; Utility.WriteError("Error: " + ex.Message); } }
protected void btnReturn_Click(object sender, EventArgs e) { try { AppUser usr = null; if (Session["user"] != null) { usr = (AppUser)Session["user"]; } else { Response.Redirect("../Login.aspx", false); return; } if (string.IsNullOrEmpty(txtcomment.Text)) { modalErr.Visible = true; modalErr.InnerText = "Comment is required!!!"; mpeAppr.Show(); return; } bool isset = false; AppUser budgetInputer = new AppUser(); int deptID = int.Parse(ddlDept.SelectedValue); List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptID).ToList(); if (budMenuLst.Count() > 0) { foreach (DeptBudgetItem dm in budMenuLst) { if (dm.Code == "CA")//for capex { Utility.UpdateBudgetCapex((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4); } if (dm.Code == "DI") { Utility.UpdateBudgetDirect((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4); } if (dm.Code == "ID") { Utility.UpdateBudgetIndirect((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4); } if (dm.Code == "MO") { Utility.UpdateBudgetMovable((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4); } if (dm.Code == "RE") { Utility.UpdateBudgetRevenue((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4); } if (dm.Code == "SA") { Utility.UpdateBudgetExistingSf((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4); } } BudgetYear budYr = (BudgetYear)Session["budgetYr"]; List <TrackApproval> getTrackApproval = null; getTrackApproval = LookUpBLL.GetTrackApproval(deptID, budYr.ID).ToList(); if (getTrackApproval != null && getTrackApproval.Count() > 0) { TrackApproval appTrack = getTrackApproval.FirstOrDefault(); appTrack.status = (int)Utility.BudgetItemStatus.Returned_For_Correction; appTrack.ActionBy = usr.FullName; LookUpBLL.UpdateApprovalStatus(appTrack); dvExco.Visible = false; //success.Visible = true; //success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Budget has been successfully returned to HOD."; //return; } else { LookUpBLL.AddApprovaltrack(new TrackApproval() { BudgetYr = budYr.ID, DepartmentID = deptID, ActionBy = usr.FullName, dateApproved = DateTime.Now, status = (int)Utility.BudgetItemStatus.Returned_For_Correction }); dvExco.Visible = false; //success.Visible = true; //success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Budget has been successfully approved."; //return; } isset = true; } if (isset) { BindGrid(); //sending mail string body = ""; string from = ConfigurationManager.AppSettings["exUser"].ToString(); string siteUrl = ConfigurationManager.AppSettings["siteUrl"].ToString(); string appLogo = ConfigurationManager.AppSettings["appLogoUrl"].ToString(); string hodEmail = Utility.GetUsersEmailAdd(deptApprRole, deptID); string subject = "Budget Item Correction Notification"; string FilePath = Server.MapPath("EmailTemplates/"); if (File.Exists(FilePath + "ReturnBudget.htm")) { FileStream f1 = new FileStream(FilePath + "ReturnBudget.htm", FileMode.Open); StreamReader sr = new StreamReader(f1); body = sr.ReadToEnd(); body = body.Replace("@add_appLogo", appLogo); body = body.Replace("@siteUrl", siteUrl); body = body.Replace("@BudgetElement", ddlDept.SelectedItem.Text + " Department"); body = body.Replace("@add_Comment", txtcomment.Text); //Replace the values from DB or any other source to personalize each mail. f1.Close(); } string rst = ""; try { rst = Utility.SendMail(budgetInputer.Email, from, hodEmail, subject, body); } catch { } if (rst.Contains("Successful")) { success.Visible = true; success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Action was successful. Notification has been sent to HOD"; return; } else { success.Visible = true; success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Action was successful.Notification could NOT be sent at this time"; return; } } else { BindGrid(); error.Visible = true; error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. kindly try again.If error persist contact Administrator!!."; } } catch (Exception ex) { error.Visible = true; error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!."; Utility.WriteError("Error: " + ex.Message); } }
protected void btnSearch_Click(object sender, EventArgs e) { try { usr = (AppUser)Session["user"]; budYr = (BudgetYear)Session["budgetYr"]; if (ddlDept.SelectedValue != "") { int deptId = int.Parse(ddlDept.SelectedValue); budYr = (BudgetYear)Session["budgetYr"]; int budyrID = budYr.ID; if (User.IsInRole(EDRole)) { List <TrackApproval> getTrackApproval = null; getTrackApproval = LookUpBLL.GetTrackApproval(deptId, budYr.ID).ToList(); if (getTrackApproval != null && getTrackApproval.Count() > 0) { TrackApproval tt = getTrackApproval.FirstOrDefault(); if (tt.status == (int)Utility.BudgetItemStatus.Pending_ED_Approval) { dvExco.Visible = true; btnCorrect.Visible = true; hidEDPending.Value = "1"; } if (tt.status == (int)Utility.BudgetItemStatus.Pending_MD_Approval) { dvExco.Visible = true; btnCorrect.Visible = false; btnReturn.Visible = true; btnReturn.Text = "Return For Correction After Review"; hidEDPending.Value = "1"; } //dvExco.Visible = false; //btnCorrect.Visible = false; //hidEDPending.Value = "1"; } List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptId).ToList(); if (budMenuLst.Count() > 0) { foreach (DeptBudgetItem dm in budMenuLst) { if (dm.Code == "CA")//for capex { Utility.ComputeBudgetSummaryCapexProjection(budyrID, deptId); } if (dm.Code == "DI") { Utility.ComputeBudgetSummaryDirectProjection(budyrID, deptId); } if (dm.Code == "ID") { Utility.ComputeBudgetSummaryIndirectProjection(budyrID, deptId); } if (dm.Code == "MO") { Utility.ComputeBudgetSummaryFixedAsset(budyrID, deptId); } if (dm.Code == "RE") { Utility.ComputeBudgetSummaryRevenue(budyrID, deptId); } if (dm.Code == "SA") { Utility.ComputeBudgetSummaryExistingStff(budyrID, deptId); } } } } gvDept.DataSource = CommonBLL.GetBudgetSummaryList(budYr.ID).Where(d => d.DepartmentID == deptId).ToList(); gvDept.DataBind(); lbmsg.Text = ""; lbmsg.Text = ddlDept.SelectedItem.Text + " Department Budgets"; if (User.IsInRole(MDRole)) { List <TrackApproval> getTrackApproval = null; getTrackApproval = LookUpBLL.GetTrackApproval(deptId, budYr.ID).ToList(); if (getTrackApproval != null && getTrackApproval.Count() > 0) //if selected department has been pushed for approval { TrackApproval tt = getTrackApproval.FirstOrDefault(); if (tt.status == (int)Utility.BudgetItemStatus.Pending_MD_Approval) { dvExco.Visible = true; btnMD.Visible = true; hidMDPending.Value = "1"; } if (tt.status == (int)Utility.BudgetItemStatus.Pending_MD_Final_Approval) { dvExco.Visible = true; btnMD.Visible = false; btnReject.Visible = false; btnMDFinal.Visible = true; hidMDPending.Value = "1"; } } else { dvExco.Visible = false; btnMD.Visible = false; } } if (User.IsInRole(AdminRole) || User.IsInRole(PBMgrRole) || User.IsInRole(PBOffRole)) { List <TrackApproval> getTrackApproval = null; getTrackApproval = LookUpBLL.GetTrackApproval(deptId, budYr.ID).ToList(); if (getTrackApproval != null && getTrackApproval.Count() > 0)//if selected department has been pushed for approval { TrackApproval tt = getTrackApproval.FirstOrDefault(); if (tt.status == (int)Utility.BudgetItemStatus.Pending_ReAlignment) { dvPB.Visible = true; btnMD.Visible = false; hidMDPending.Value = "1"; List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptId).ToList(); if (budMenuLst.Count() > 0) { foreach (DeptBudgetItem dm in budMenuLst) { if (dm.Code == "CA")//for capex { Utility.ComputeBudgetSummaryCapexProjection(budyrID, deptId); } if (dm.Code == "DI") { Utility.ComputeBudgetSummaryDirectProjection(budyrID, deptId); } if (dm.Code == "ID") { Utility.ComputeBudgetSummaryIndirectProjection(budyrID, deptId); } if (dm.Code == "MO") { Utility.ComputeBudgetSummaryFixedAsset(budyrID, deptId); } if (dm.Code == "RE") { Utility.ComputeBudgetSummaryRevenue(budyrID, deptId); } if (dm.Code == "SA") { Utility.ComputeBudgetSummaryExistingStff(budyrID, deptId); } } } } gvDept.DataSource = CommonBLL.GetBudgetSummaryList(budYr.ID).Where(d => d.DepartmentID == deptId).ToList(); gvDept.DataBind(); lbPBmsg.Text = ""; lbPBmsg.Text = ddlDept.SelectedItem.Text + " Department Budgets"; } else { dvExco.Visible = false; btnMD.Visible = false; } } } } catch (Exception ex) { error.Visible = true; error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!"; Utility.WriteError("Error: " + ex.Message); } }