public void LoadDetails() { ddlJournalYear.DataSource = EmployeeJournal.GetDSLJournalYearsALL(); ddlJournalYear.DataValueField = "pvalue"; ddlJournalYear.DataTextField = "ptext"; ddlJournalYear.DataBind(); ddlJournalDates.DataSource = EmployeeJournal.GetDSLJournalDatesALL(ddlJournalYear.SelectedValue.ToString()); ddlJournalDates.DataValueField = "pvalue"; ddlJournalDates.DataTextField = "ptext"; ddlJournalDates.DataBind(); ddlDivision.DataSource = clsDivision.GetDdlDsBasedOnApproverModule(Request.Cookies["Speedo"]["UserName"].ToString()); ddlDivision.DataValueField = "pvalue"; ddlDivision.DataTextField = "ptext"; ddlDivision.DataBind(); // ddlDivision.SelectedValue = clsEmployee.GetDivisionCode(Request.Cookies["Speedo"]["UserName"].ToString()); ddlDepartment.DataSource = clsDepartment.GetDdlDsBasedOnModuleApprover(ddlDivision.SelectedValue.ToString(), Request.Cookies["Speedo"]["UserName"].ToString()); ddlDepartment.DataValueField = "pvalue"; ddlDepartment.DataTextField = "ptext"; ddlDepartment.DataBind(); //ddlDepartment.SelectedValue = clsEmployee.GetDepartmentCode(Request.Cookies["Speedo"]["UserName"].ToString()); ddlEmployee.DataSource = clsEmployee.DSLEmployeeList(ddlDepartment.SelectedValue.ToString()); ddlEmployee.DataValueField = "pvalue"; ddlEmployee.DataTextField = "ptext"; ddlEmployee.DataBind(); }
protected void btnFinalize_Click(object sender, EventArgs e) { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournal.JournalStatus = "F"; objEmployeeJournal.LockStatus = "1"; objEmployeeJournal.Enabled = "1"; objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); if (objEmployeeJournal.UpdateStatus() > 0) { using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval()) { objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode; objEmployeeJournalApproval.JournalApprover = ddlDeptHead.SelectedValue.ToString(); objEmployeeJournalApproval.JournalAStatus = "F"; objEmployeeJournalApproval.JournalAOrder = 1; objEmployeeJournalApproval.JournalADate = DateTime.Now; objEmployeeJournalApproval.Insert(); objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode; objEmployeeJournalApproval.JournalApprover = ddlDivHead.SelectedValue.ToString(); objEmployeeJournalApproval.JournalAStatus = "F"; objEmployeeJournalApproval.JournalAOrder = 2; objEmployeeJournalApproval.JournalADate = DateTime.Now; objEmployeeJournalApproval.Insert(); } Response.Redirect("EmployeeJournalList.aspx"); } } }
protected void btnApprove_Click(object sender, EventArgs e) { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { //objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.LockStatus = "1"; objEmployeeJournal.Enabled = "1"; objEmployeeJournal.JournalStatus = "F"; objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); if (objEmployeeJournal.UpdateStatus() > 0) { using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval()) { objEmployeeJournalApproval.EmployeeJournalACode = EmployeeJournalApproval.GetForApprovalJournalACode(objEmployeeJournal.EmployeeJournalCode); objEmployeeJournalApproval.JournalAStatus = "A"; if (EmployeeJournalApproval.GetForApprovalJournalAOrder(objEmployeeJournal.EmployeeJournalCode) == 1) { objEmployeeJournalApproval.Remarks = txtDepartmentHeadsRemarks.Text; } else if (EmployeeJournalApproval.GetForApprovalJournalAOrder(objEmployeeJournal.EmployeeJournalCode) == 2) { objEmployeeJournal.JournalStatus = "A"; objEmployeeJournal.UpdateStatus(); objEmployeeJournalApproval.Remarks = txtDivisionHeadsRemarks.Text; } if (objEmployeeJournalApproval.UpdateStatus() > 0) { Response.Redirect("EmployeeJournalListA.aspx"); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { txtDepartmentHeadsRemarks.Visible = true; txtDivisionHeadsRemarks.Visible = true; txtDepartmentHeadsRemarks.Enabled = false; txtDivisionHeadsRemarks.Enabled = false; txtDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); txtDivisionHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2"); lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")"; this.MakeCart(); if (EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1").ToString() == Request.Cookies["Speedo"]["UserName"].ToString()) { txtDepartmentHeadsRemarks.Enabled = true; btnApprove.Text = "Approved"; } if (EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2").ToString() == Request.Cookies["Speedo"]["UserName"].ToString()) { txtDivisionHeadsRemarks.Enabled = true; btnApprove.Text = "Read and Commented"; } } }
protected void LoadUpdates() { string strWrite = ""; string strStatus = ""; string strLink = ""; string strPreview = ""; string strJournalStatus = ""; string strEmployeeStatDate = ""; string strDepHeadStatus = ""; string strDivHeadStatus = ""; foreach (DataRow drJournal in EmployeeJournal.GetDSG(Convert.ToInt16(ddlJournalYear.SelectedValue), ddlJournalDates.SelectedValue.ToString(), ddlDepartment.SelectedValue.ToString()).Rows) { if (drJournal["JournalStatus"].ToString() == "S" && drJournal["LockStatus"].ToString() == "0") { strJournalStatus = "Draft"; strEmployeeStatDate = "(Last Log on " + drJournal["ModifiedOn"].ToString() + ")"; strDepHeadStatus = ""; strDivHeadStatus = ""; } else if (drJournal["JournalStatus"].ToString() == "F") { strJournalStatus = "For Approval"; strEmployeeStatDate = "(Submitted on " + drJournal["ModifiedOn"].ToString() + ")"; if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(drJournal["JournalCode"]), "1") == "A") { strDepHeadStatus = "(" + EmployeeJournalApproval.GetApproverADate(Convert.ToInt16(drJournal["JournalCode"]), "1") + ")"; } else { strDepHeadStatus = "(Not Yet Approved)"; } if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(drJournal["JournalCode"]), "2") == "A") { strDivHeadStatus = "(" + EmployeeJournalApproval.GetApproverADate(Convert.ToInt16(drJournal["JournalCode"]), "2") + ")"; } else { strDivHeadStatus = "(Not Yet Approved)"; } } else if (drJournal["JournalStatus"].ToString() == "A") { strJournalStatus = "Approved"; strEmployeeStatDate = "(Submitted on " + drJournal["ModifiedOn"].ToString() + ")"; strDepHeadStatus = ""; strDivHeadStatus = ""; } strLink = "JournalViewer"; strWrite = strWrite + "<tr>" + "<td class='GridRows'>" + clsEmployee.GetName(drJournal["CreatedBy"].ToString()) + "<br />" + strEmployeeStatDate + "</td>" + "<td class='GridRows'>" + strJournalStatus + "</td>" + "<td class='GridRows'>" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(drJournal["JournalCode"]), "1") + "<br />" + strDepHeadStatus + "</td>" + //"<td class='GridRows'>" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(drJournal["JournalCode"]), "2") + "<br />" + strDivHeadStatus + "</td>" + "</tr>"; } //Response.Write(strWrite); lblWrite.Text = strWrite; }
protected void Page_Load(object sender, EventArgs e) { lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")"; this.MakeCart(); lblDeptApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + ")"; lblDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); lblDivApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") + ")"; lblDivisionHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2"); }
public void LoadContents() { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { //objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.Fill2(); ckeContents.Text = objEmployeeJournal.Contents; } }
protected void btnDraft_Click(object sender, EventArgs e) { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { if (objEmployeeJournal.Update() > 0) { Response.Redirect("EmployeeJournalList.aspx"); } } }
public void LoadContent() { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { //objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.Fill2(); litContent.Text = objEmployeeJournal.Contents; lblSubmittedDetails.Text = objEmployeeJournal.ModifiedBy + " " + "(" + objEmployeeJournal.ModifiedOn + ")"; //litContent.Text += "<font style='font-size:14px;'>" + objEmployeeJournal.Contents + "</font>"; } }
protected void MakeCart() { DataTable tblCart = new DataTable("Cart"); tblCart.Columns.Add("JournalDCode", System.Type.GetType("System.String")); tblCart.Columns.Add("JournalCode", System.Type.GetType("System.String")); tblCart.Columns.Add("ItemNumber", System.Type.GetType("System.String")); tblCart.Columns.Add("Contents", System.Type.GetType("System.String")); tblCart = EmployeeJournalDetails.GetDSGCart(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString())); ViewState["Cart"] = tblCart; LoadGrid(); }
public void LoadContent() { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.Fill2(); //lblSubmittedDetails.Text = "<br />Submitted By: " + objEmployeeJournal.ModifiedBy + "<br />" + "Submitted On: " + objEmployeeJournal.ModifiedOn; lblSubmittedDetails.Text = objEmployeeJournal.ModifiedBy + " " + "(" + objEmployeeJournal.ModifiedOn + ")"; //litContent.Text += "<font style='font-size:14px;'>" + objEmployeeJournal.Contents + "</font>"; litContent.Text = objEmployeeJournal.Contents; } }
protected void Page_Load(object sender, EventArgs e) { clsSpeedo.Authenticate(); if (!Page.IsPostBack) { string strDeptDetails = "", strDivDetails = ""; string strDeptStatus = "", strDivStatus = ""; lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")"; this.MakeCart(); this.LoadContent(); //lblDeptApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + ")"; try { lblDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "F") { strDeptStatus = "For Review"; } else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "A") { strDeptStatus = "Reviewed"; } else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "F") { strDeptStatus = "Disapproved"; } strDeptDetails = "Reviewer: " + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + "<br />" + "Status: " + strDeptStatus + "<br />" + "Remarks: <br />" + EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); lblDepartmentHeadsRemarks.Text = strDeptDetails; } catch { } //if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "F") //{ // strDivStatus = "For Approval"; //} //else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "A") //{ // strDivStatus = "Approved"; //} //else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "F") //{ // strDivStatus = "Disapproved"; //} //strDivDetails = "Approver: " + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") + "<br />" + // "Status: " + strDivStatus + "<br />" + // "Remarks: <br />" + EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2"); //lblDivisionHeadsRemarks.Text = strDivDetails; } }
protected void LoadUpdates() { string strWrite = ""; string strStatus = ""; string strLink = ""; string strPreview = ""; foreach (DataRow drJournal in EmployeeJournal.GetDSG(Request.Cookies["Speedo"]["UserName"], Convert.ToInt16(ddlJournalYear.SelectedValue), ddlJournalDates.SelectedValue.ToString()).Rows) { //if (WeekYear.GetActiveWeekCode().ToString() == drJournal["WeekCode"].ToString()) //{ if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "S" && EmployeeJournal.GetLockStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "0") { strLink = "JournalEncoding"; strWrite = strWrite + "<tr>" + "<td class='GridRows'><img src='../Support/Pending.png' alt='' width='16' height='16' /></td>" + "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" + "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" + "</tr>"; } else if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "F" && EmployeeJournal.GetLockStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "0") { strLink = "JournalEncodingM"; strWrite = strWrite + "<tr>" + "<td class='GridRows'><img src='../Support/MRCF_New.png' alt='' width='16' height='16' /></td>" + "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" + "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" + "</tr>"; } else { strLink = "JournalViewer"; strWrite = strWrite + "<tr>" + "<td class='GridRows'><img src='../Support/MRCF_View.png' alt='' width='16' height='16' /></td>" + "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" + "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" + "</tr>"; } //} //else //{ // strLink = "JournalViewer"; // strWrite = strWrite + "<tr>" + // "<td class='GridRows'><img src='../Support/MRCF_View.png' alt='' /></td>" + // "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" + // "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" + // "</tr>"; //} } //Response.Write(strWrite); lblWrite.Text = strWrite; }
protected void ddlJournalYear_SelectedIndexChanged(object sender, EventArgs e) { ddlJournalDates.DataSource = EmployeeJournal.GetDSLJournalDatesALL(ddlJournalYear.SelectedValue.ToString()); ddlJournalDates.DataValueField = "pvalue"; ddlJournalDates.DataTextField = "ptext"; ddlJournalDates.DataBind(); try { ddlJournalDates.SelectedValue = WeekYear.GetActiveWeekCode(); } catch { } }
protected void btnFinalize_Click(object sender, EventArgs e) { ViewState["JournalCode"] = Request.QueryString["JournalCode"]; if (lblReviewer.ForeColor == Color.Black) { string confirmValue = Request.Form["confirm_value"]; if (confirmValue == "Yes") { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.JournalStatus = "F"; objEmployeeJournal.LockStatus = "1"; objEmployeeJournal.Enabled = "1"; objEmployeeJournal.Contents = ckeContents.Text.Replace("style=\"display: none\"", ""); objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); if (objEmployeeJournal.UpdateStatus() > 0) { using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval()) { objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode; objEmployeeJournalApproval.JournalApprover = EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournalApproval.JournalAStatus = "F"; objEmployeeJournalApproval.JournalAOrder = 1; objEmployeeJournalApproval.JournalADate = DateTime.Now; objEmployeeJournalApproval.Insert(); objEmployeeJournal.SendNotification(EmployeeJournal.EJSMailType.FiledAcknowledgementRequestor, Request.Cookies["Speedo"]["UserName"].ToString(), EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString())); objEmployeeJournal.SendNotification(EmployeeJournal.EJSMailType.FiledNotificationApprover, Request.Cookies["Speedo"]["UserName"].ToString(), EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString())); } Response.Redirect("EmployeeJournalList.aspx"); } } } else { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.Contents = ckeContents.Text; objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); objEmployeeJournal.ModifiedOn = DateTime.Now; if (objEmployeeJournal.Update() > 0) { Response.Redirect("JournalEncoding.aspx?JournalCode=" + Request.QueryString["JournalCode"]); } } } } }
protected void LoadUpdates() { string strWrite = ""; string strStatus = ""; string strLink = ""; string strPreview = ""; foreach (DataRow drJournal in EmployeeJournal.GetDSG(ddlEmployee.SelectedValue.ToString(), Convert.ToInt16(ddlJournalYear.SelectedValue), ddlJournalDates.SelectedValue.ToString()).Rows) { if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "S" && EmployeeJournal.GetLockStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "0") { strLink = "JournalViewer"; strWrite = strWrite + "<tr>" + "<td class='GridRows'><img src='../Support/MRCF_New.png' alt='' /></td>" + "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" + "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" + "</tr>"; } else if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "F" && EmployeeJournal.GetLockStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "0") { strLink = "JournalViewer"; strWrite = strWrite + "<tr>" + "<td class='GridRows'><img src='../Support/MRCF_New.png' alt='' /></td>" + "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" + "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" + "</tr>"; } else if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "A") { strLink = "JournalViewer"; strWrite = strWrite + "<tr>" + "<td class='GridRows'><img src='../Support/Approved.png' alt='' width='16' height='16' /></td>" + "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" + "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" + "</tr>"; } else { strLink = "JournalViewer"; strWrite = strWrite + "<tr>" + "<td class='GridRows'><img src='../Support/hammer128.png' alt='' width='16' height='16' /></td>" + "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" + "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" + "</tr>"; } } //Response.Write(strWrite); lblWrite.Text = strWrite; }
protected void btnPreview_Click(object sender, EventArgs e) { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { //objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.Contents = ckeContents.Text.Replace("style=\"display: none\"", ""); objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); objEmployeeJournal.ModifiedOn = DateTime.Now; if (objEmployeeJournal.Update() > 0) { Response.Redirect("JournalViewer.aspx?JournalCode=" + Request.QueryString["JournalCode"]); } } }
public void LoadDetails() { ddlJournalYear.DataSource = EmployeeJournal.GetDSLJournalYearsALL(); ddlJournalYear.DataValueField = "pvalue"; ddlJournalYear.DataTextField = "ptext"; ddlJournalYear.DataBind(); ddlJournalDates.DataSource = EmployeeJournal.GetDSLJournalDatesALL(ddlJournalYear.SelectedValue.ToString()); ddlJournalDates.DataValueField = "pvalue"; ddlJournalDates.DataTextField = "ptext"; ddlJournalDates.DataBind(); try { ddlJournalDates.SelectedValue = WeekYear.GetActiveWeekCode(); } catch { } }
protected void LoadUpdates() { string strWrite = ""; string strStatus = ""; string strLink = ""; string strPreview = ""; foreach (DataRow drJournal in EmployeeJournal.GetDSGForApproval(Request.Cookies["Speedo"]["UserName"]).Rows) { strLink = "JournalViewerA"; strWrite = strWrite + "<tr>" + "<td class='GridRows'><img src='../Support/MRCF_View.png' alt='' /></td>" + "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br>" + "Submitted by: " + drJournal["ModifiedBy"].ToString() + "<br />" + "Submitted On: " + drJournal["ModifiedOn"].ToString() + "<br />" + "</td>" + "</tr>"; } Response.Write(strWrite); }
protected void btnGoToJournal_Click(object sender, EventArgs e) { string strLink = ""; using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { if (EmployeeJournal.HasExistingJournal(Request.Cookies["Speedo"]["UserName"].ToString(), Convert.ToInt16(WeekYear.GetActiveWeekCode()))) { if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()))).ToString() == "S" && EmployeeJournal.GetLockStatus(Convert.ToInt16(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()))).ToString() == "0") { strLink = "JournalEncoding"; Response.Redirect("JournalEncoding.aspx?JournalCode=" + EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()).ToString()); } else if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()))).ToString() == "F" && EmployeeJournal.GetLockStatus(Convert.ToInt16(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()))).ToString() == "0") { strLink = "JournalEncodingM"; Response.Redirect("JournalEncodingM.aspx?JournalCode=" + EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()).ToString()); } else { strLink = "JournalViewer"; Response.Redirect("JournalViewer.aspx?JournalCode=" + EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()).ToString()); } } else { objEmployeeJournal.WeekCode = Convert.ToInt16(WeekYear.GetActiveWeekCode()); objEmployeeJournal.Enabled = "1"; objEmployeeJournal.CreatedBy = Request.Cookies["Speedo"]["UserName"].ToString(); objEmployeeJournal.CreatedOn = DateTime.Now; objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); objEmployeeJournal.ModifiedOn = DateTime.Now; if (objEmployeeJournal.Insert() > 0) { Response.Redirect("JournalEncoding.aspx"); } } } }
public void LoadDueValidation() { //Response.Write(WeekYear.GetDateDue(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"]))).AddHours(9).ToString()); //Response.Write("<br> " + DateTime.Now.ToString()); //Response.Write(Convert.ToDateTime("11/12/2015 4:50:17 PM").ToString()); if (WeekYear.GetDateDue(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"]))).AddHours(9) < DateTime.Now) //if (Convert.ToDateTime("11/12/2015 4:57:00 PM") < DateTime.Now) { if (JournalExceptions.CountIfExist(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])), Request.Cookies["Speedo"]["UserName"].ToString()) > 0) { btnDraft.Enabled = true; btnFinalize.Enabled = true; btnPreview.Enabled = true; } else { btnDraft.Enabled = false; btnFinalize.Enabled = false; btnPreview.Enabled = false; } } }
public static int InputIndexValidation() { int value; while (!int.TryParse(Console.ReadLine(), out value) || value < 0) { Console.WriteLine("Please enter a valid positive number"); } if (value < EmployeeJournal.GetEmployees().Length) { EmployeeJournal.RemoveAt(value); Console.WriteLine($"The employee on index {value} was succesffully removed from the list"); Console.WriteLine(); } else { Console.WriteLine("There is no such employee"); } return(value); }
protected void btnSave_Click(object sender, EventArgs e) { using (EmployeeJournalDetails objEmployeeJournalDetails = new EmployeeJournalDetails()) { objEmployeeJournalDetails.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournalDetails.Contents = txtContents.Text; objEmployeeJournalDetails.ItemNumber = EmployeeJournalDetails.GetTotalRecords(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString())) + 1; objEmployeeJournalDetails.JournalDate = DateTime.Now; objEmployeeJournalDetails.CreatedOn = DateTime.Now; objEmployeeJournalDetails.EndorsedBy = "NA"; objEmployeeJournalDetails.EndorsedOn = DateTime.Now; objEmployeeJournalDetails.EndoredRemarks = "NA"; objEmployeeJournalDetails.ApprovedBy = "NA"; objEmployeeJournalDetails.ApprovedOn = DateTime.Now; objEmployeeJournalDetails.ApprovedRemarks = "NA"; objEmployeeJournalDetails.JournalStatus = "F"; objEmployeeJournalDetails.IsEnabled = "1"; if (objEmployeeJournalDetails.Insert() > 0) { Response.Redirect("JournalEncodingM.aspx?JournalCode=" + ViewState["JournalCode"].ToString()); } } }
protected void Page_Load(object sender, EventArgs e) { clsSpeedo.Authenticate(); this.LoadDueValidation(); if (!Page.IsPostBack) { //lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString("MMM dd, yyyy") + ")"; lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")"; this.MakeCart(); this.LoadDSLs(); this.LoadContents(); if (EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString()).Length > 0) { lblReviewer.ForeColor = Color.Black; lblReviewer.Text = EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString()); } else { lblReviewer.ForeColor = Color.Red; lblReviewer.Text = "No assigned reviewer."; } } }
static void Main(string[] args) { EmployeeJournal.OpenFile(); do { Console.Clear(); Console.WriteLine("=======MENU======="); Console.WriteLine("1. Add new employee"); Console.WriteLine("2. Check all employees"); Console.WriteLine("3. Remove employee"); Console.WriteLine("4. Total hours worked by the team"); Console.WriteLine("5. Exit"); Menu menu = (Menu)InputIntValidation(); switch (menu) { case Menu.AddNewEmployee: { Console.Clear(); Console.Write("Please enter the passport number of the employee: "); int passport = InputIntValidation(); Console.Write("Please enter the name of the employee: "); string name = Console.ReadLine(); Console.Write("Please enter the age of the employee: "); int age = InputIntValidation(); Console.Write("Please enter the position of the employee: "); string position = Console.ReadLine(); Console.Write("Please enter the name of the team: "); string team = Console.ReadLine(); Console.Write("Please enter the number of hours worked: "); double hoursWorked = InputDoubleValidation(); Employee employee = new Employee ( passport: passport, name: name, age: age, position: position, team: team, hoursWorked: hoursWorked ); EmployeeJournal.Add(employee); } break; case Menu.CheckEmployees: { Console.Clear(); foreach (var employee in EmployeeJournal.GetEmployees()) { Console.WriteLine($"==========\n{employee}"); } Console.ReadKey(); } break; case Menu.RemoveEmployee: { Console.Write("Please enter the index of the emplyoyee you would like to remove: "); InputIndexValidation(); Console.ReadKey(); } break; case Menu.TeamHoursWorked: { Console.Write("Please enter the name of the team: "); string team = Console.ReadLine(); double teamHoursWorked = EmployeeJournal.TeamHours(team); Console.WriteLine($"The total hours worked by team {team}: {teamHoursWorked}"); Console.ReadKey(); } break; case Menu.Exit: { EmployeeJournal.SaveToFile(); return; } default: { Console.WriteLine("There is no such command"); } break; } } while (true); }
private async Task View_Loading() { try { var main = View.Main; _usersJournal = new EmployeeJournal(main.DGV_Employees, true); _workingHoursJournal = new WorkingHourJournal(main.DGV_WorkingHours); _unitsJournal = new UnitJournal(main.DGV_Unit); _nomenclaturesJournal = new NomenclatureJournal(main.DGV_Nomenclatures); _optionsJournal = new OptionJournal(main.DGV_Options); _reasonsJournal = new ReasonJournal(main.DGV_Reasons); _marksJournal = new MarkJournal(main.DGV_Marks); _modelsJournal = new ModelJournal(main.DGV_Models); _contractorsJournal = new ContractorJournal(main.DGV_Contractors); _applicationsJournal = new ApplicationJournal(main.DGV_Apptications); using (var context = new DbSSContext()) { int countViewСontractor = await context.ViewСontractor.CountAsync(); int countTypeManifestation = await context.TypeManifestation.CountAsync(); int countTypeRepair = await context.TypeRepair.CountAsync(); var countTypeNomenclature = await context.TypeNomenclature.CountAsync(); if (countViewСontractor == 0) { List <ViewСontractorModel> view = new List <ViewСontractorModel>() { new ViewСontractorModel { View = "Юридическое лицо" }, new ViewСontractorModel { View = "Физическое лицо" } }; context.ViewСontractor.AddRange(view); } if (countTypeManifestation == 0) { List <TypeManifestationModel> type = new List <TypeManifestationModel>() { new TypeManifestationModel { Type = "Внешнее" }, new TypeManifestationModel { Type = "Втуреннее" } }; context.TypeManifestation.AddRange(type); } if (countTypeRepair == 0) { List <TypeRepairModel> type = new List <TypeRepairModel>() { new TypeRepairModel { Type = "Гарантийный" }, new TypeRepairModel { Type = "Текущий" } }; context.TypeRepair.AddRange(type); } if (countTypeNomenclature == 0) { List <TypeNomenclatureModel> type = new List <TypeNomenclatureModel>() { new TypeNomenclatureModel { Type = "Товар" }, new TypeNomenclatureModel { Type = "Работа" } }; context.TypeNomenclature.AddRange(type); } await context.SaveChangesAsync(); } await _applicationsJournal.Update(); } catch (Exception ex) { ShowError(ex.Message); } }