protected bool ValidateAmount() { bool blnReturn = false; double dblCartSumValidator = 0; DataTable tblCartSUmValidator = ViewState["CartItems"] as DataTable; foreach (DataRow drw in tblCartSUmValidator.Rows) { using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails()) { dblCartSumValidator = dblCartSumValidator + Convert.ToDouble(drw["amount"]); } } if (dblCartSumValidator <= 1000) { if (dgItems.Items.Count != 0) { blnReturn = true; } else { divError.Visible = true; lblErrMsg.Text = "No items found."; } } else { divError.Visible = true; lblErrMsg.Text = "The PCAS Amount should not be greater than 1,000.00 Pesos."; } return(blnReturn); }
protected void LoadDetails() { DataTable tblDetails = clsPCASRequestAllocation.GetDSGMainForm(Request.QueryString["pcascode"]); ViewState["Cart"] = tblDetails; DataTable tblCartdg = ViewState["Cartdg"] as DataTable; foreach (DataRow drw in tblDetails.Rows) { DataRow drowCartdg = tblCartdg.NewRow(); drowCartdg["aexpname"] = drw["aexpname"]; string strChargedTo = ""; if (drw["schlcode"].ToString().Trim() != "") { strChargedTo = clsSchool.GetSchoolName(drw["schlcode"].ToString().Trim()); } if (drw["rccode"].ToString().Trim() != "") { strChargedTo = clsRC.GetRCName(drw["rccode"].ToString().Trim()); } if (drw["others"].ToString().Trim() != "") { strChargedTo = drw["others"].ToString().Trim(); } double dblAmount = double.Parse(drw["amount"].ToString()); drowCartdg["chargeto"] = strChargedTo; drowCartdg["amount"] = string.Format("{0:0,0.00}", dblAmount); tblCartdg.Rows.Add(drowCartdg); } ViewState["Cartdg"] = tblCartdg; dgItems.DataSource = tblCartdg; dgItems.DataBind(); //added 2013-09-02 double dblCartSum = 0; DataTable tblCartSUm = ViewState["Cart"] as DataTable; foreach (DataRow drw in tblCartSUm.Rows) { using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails()) { dblCartSum = dblCartSum + Convert.ToDouble(drw["amount"]); } } //txtRequestAmount.Text = string.Format("{0:0,0.00}", dblCartSum); txtRequestAmount.Text = string.Format("{0:0.00}", dblCartSum); }
protected void dgItems_DeleteCommand(object source, DataGridCommandEventArgs e) { try { DataTable tblCart = ViewState["Cart"] as DataTable; DataTable tblCartdg = ViewState["Cartdg"] as DataTable; tblCart.Rows[e.Item.ItemIndex].Delete(); tblCartdg.Rows[e.Item.ItemIndex].Delete(); tblCart.AcceptChanges(); tblCartdg.AcceptChanges(); ViewState["Cartdg"] = tblCartdg; ViewState["Cart"] = tblCart; dgItems.DataSource = tblCartdg; dgItems.DataBind(); //added 2013-09-02 double dblCartSum = 0; DataTable tblCartSUm = ViewState["Cart"] as DataTable; foreach (DataRow drw in tblCartSUm.Rows) { using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails()) { dblCartSum = dblCartSum + Convert.ToDouble(drw["amount"]); } } //txtRequestAmount.Text = string.Format("{0:0,0.00}", dblCartSum); txtRequestAmount.Text = string.Format("{0:0.00}", dblCartSum); //trNoRequest.Visible = dgItems.Items.Count == 0; try { txtNet.Text = (Convert.ToDouble(txtApprovedRFA.Text) - Convert.ToDouble(txtAmountAllocated.Text)).ToString(); } catch { } try { //txtRemainingBudget.Text = (Convert.ToDouble(txtNet.Text) - Convert.ToDouble(txtRequestAmount.Text)).ToString(); } catch { } } catch { Response.Redirect("PettyCashRequestCashierMenu.aspx"); } }
protected void btnSend_Click(object sender, EventArgs e) { string strPurpose = "0"; if (chkTransportation.Checked == true && chkOthers.Checked == true) { strPurpose = "3"; } else if (chkTransportation.Checked == true && chkOthers.Checked == false) { strPurpose = "1"; } else if (chkTransportation.Checked == false && chkOthers.Checked == true) { strPurpose = "2"; } else { strPurpose = "0"; } if (strPurpose != "0") { if (ValidateAmount() == false) { } else { using (clsPCASRequest objPCASRequest = new clsPCASRequest()) { objPCASRequest.RequestedBy = ddlExecutive.SelectedValue.ToString(); objPCASRequest.IsExecutive = "1"; objPCASRequest.Reason = txtReason.Text; objPCASRequest.DateNeeded = dtpDateFromNeeded.SelectedDate; objPCASRequest.Classification = strPurpose; objPCASRequest.ChargeTypeCode = ddlChargeType.SelectedValue.ToString(); if (ddlChargeType.SelectedValue.ToString() == "1") { objPCASRequest.Others = ""; objPCASRequest.SchoolCode = ""; objPCASRequest.RCCode = clsDepartmentRC.GetRCcode(clsEmployee.GetDepartmentCode(Request.Cookies["Speedo"]["UserName"].ToString())); } else if (ddlChargeType.SelectedValue.ToString() == "2") { objPCASRequest.Others = ""; objPCASRequest.SchoolCode = ""; objPCASRequest.RCCode = ddlMainChargeTo.SelectedValue.ToString(); } else if (ddlChargeType.SelectedValue.ToString() == "3") { objPCASRequest.Others = ""; objPCASRequest.RCCode = ""; objPCASRequest.SchoolCode = ddlMainChargeTo.SelectedValue.ToString(); } else if (ddlChargeType.SelectedValue.ToString() == "4") { objPCASRequest.Others = txtAppOthers.Text; objPCASRequest.SchoolCode = ""; objPCASRequest.RCCode = ""; } objPCASRequest.PCASStat = "P"; objPCASRequest.OBCode = ""; objPCASRequest.CreatedBy = Request.Cookies["Speedo"]["UserName"].ToString(); objPCASRequest.ModifyBy = Request.Cookies["Speedo"]["UserName"].ToString(); objPCASRequest.Remarks = txtRemarks.Text; if (objPCASRequest.Insert() > 0) { DataTable tblCart1 = ViewState["CartItems"] as DataTable; foreach (DataRow drw in tblCart1.Rows) { using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails()) { objRequestDetails.PCascode = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()); objRequestDetails.ItemName = drw["itemdesc"].ToString(); objRequestDetails.Amount = Convert.ToDouble(drw["amount"]); objRequestDetails.Insert(); } } DataTable tblApprovers = new DataTable(); tblApprovers.Columns.Add("PCASCode"); tblApprovers.Columns.Add("Username"); tblApprovers.Columns.Add("ApproverOrder"); tblApprovers.Columns.Add("ApproverType"); tblApprovers.Columns.Add("StatusCode"); int intCount = 0; if (ddlChargeType.SelectedValue.ToString() == "2") { intCount++; DataRow drNewRow = tblApprovers.NewRow(); drNewRow["PCASCode"] = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()); drNewRow["Username"] = ddlRequestEndorser.SelectedValue.ToString(); drNewRow["ApproverOrder"] = intCount; drNewRow["ApproverType"] = "E"; drNewRow["StatusCode"] = "0"; tblApprovers.Rows.Add(drNewRow); } intCount++; DataRow drNewRowAH = tblApprovers.NewRow(); drNewRowAH["PCASCode"] = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()); drNewRowAH["Username"] = ddlHeadApprover.SelectedValue.ToString(); drNewRowAH["ApproverOrder"] = intCount; drNewRowAH["ApproverType"] = "H"; drNewRowAH["StatusCode"] = "0"; tblApprovers.Rows.Add(drNewRowAH); intCount++; DataRow drNewRowDH = tblApprovers.NewRow(); drNewRowDH["PCASCode"] = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()); drNewRowDH["Username"] = ddlDivisionHead.SelectedValue.ToString(); drNewRowDH["ApproverOrder"] = intCount; drNewRowDH["ApproverType"] = "D"; drNewRowDH["StatusCode"] = "0"; tblApprovers.Rows.Add(drNewRowDH); int intFCount = 0; foreach (DataRow drwFPCApprover in clsPCASFPCApprover.GetDSGMainForm().Rows) { intCount++; intFCount++; DataRow drNewRowFPC = tblApprovers.NewRow(); drNewRowFPC["PCASCode"] = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()); drNewRowFPC["Username"] = drwFPCApprover["fpcaname"].ToString(); drNewRowFPC["ApproverOrder"] = intCount; drNewRowFPC["ApproverType"] = "F" + intFCount.ToString(); drNewRowFPC["StatusCode"] = "0"; tblApprovers.Rows.Add(drNewRowFPC); } using (clsPCASApproval objApproval = new clsPCASApproval()) { objApproval.Insert(tblApprovers); } clsPCASRequest.SendEmailNotification("Requestor", clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()), Request.Cookies["Speedo"]["UserName"].ToString(), ddlHeadApprover.SelectedValue.ToString()); if (ddlChargeType.SelectedValue.ToString() == "2") { clsPCASRequest.SendEmailNotification("Approver", clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()), Request.Cookies["Speedo"]["UserName"].ToString(), ddlRequestEndorser.SelectedValue.ToString()); } else { clsPCASRequest.SendEmailNotification("Approver", clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()), Request.Cookies["Speedo"]["UserName"].ToString(), ddlHeadApprover.SelectedValue.ToString()); } Response.Redirect("PettyCashRequestMenu.aspx"); } } } } }
protected void btnSaveAdd_Click(object sender, EventArgs e) { try { if (dgItems.Items.Count <= 13) { DataTable tblCart = ViewState["Cart"] as DataTable; DataRow drowCart = tblCart.NewRow(); double dblAmount = Convert.ToDouble(txtAmount.Text); drowCart["aexpcode"] = ddlAccountExpenses.SelectedValue.ToString(); drowCart["schlcode"] = (ddlChargeTo.SelectedValue == "School") ? ddlSchool.SelectedValue.ToString() : ""; drowCart["rccode"] = (ddlChargeTo.SelectedValue == "Rc Group") ? ddlRcCode.SelectedValue.ToString() : ""; drowCart["others"] = (ddlChargeTo.SelectedValue == "Others") ? txtOthers.Text.Trim().ToString() : ""; drowCart["amount"] = string.Format("{0:0,0.00}", dblAmount); tblCart.Rows.Add(drowCart); //display in datagrid DataTable tblCartdg = ViewState["Cartdg"] as DataTable; DataRow drowCartdg = tblCartdg.NewRow(); drowCartdg["aexpname"] = clsFinanceAccountExpenses.GetAccountExpenseName(ddlAccountExpenses.SelectedValue.ToString()); string strChargedTo = ""; if (ddlChargeTo.SelectedValue == "School") //{ strChargedTo = clsFinanceAccountDueFrom.GetDueFromName(ddlSchool.SelectedValue.ToString()); } { strChargedTo = clsFinanceAccountDueFrom.GetDueFromName(ddlSchool.SelectedValue.ToString()); } if (ddlChargeTo.SelectedValue == "Rc Group") { strChargedTo = clsRC.GetRCName(ddlRcCode.SelectedValue.ToString()); } if (ddlChargeTo.SelectedValue == "Others") { strChargedTo = txtOthers.Text.Trim(); } drowCartdg["chargeto"] = strChargedTo; drowCartdg["amount"] = string.Format("{0:0,0.00}", dblAmount); tblCartdg.Rows.Add(drowCartdg); dgItems.DataSource = tblCartdg; dgItems.DataBind(); //add to temporary memory ViewState["Cart"] = tblCart; ViewState["Cartdg"] = tblCartdg; //txtItemDescription.Text = ""; txtAmount.Text = ""; //added 2013-09-02 double dblCartSum = 0; DataTable tblCartSUm = ViewState["Cart"] as DataTable; foreach (DataRow drw in tblCartSUm.Rows) { using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails()) { dblCartSum = dblCartSum + Convert.ToDouble(drw["amount"]); } } //txtRequestAmount.Text = string.Format("{0:0,0.00}", dblCartSum); txtRequestAmount.Text = string.Format("{0:0.00}", dblCartSum); } else { divError.Visible = true; lblErrMsg.Text = "Unable to add item to request list.<br>" + "<table>" + "<tr>" + "<td style='vertical-align:top;'><b>Reason:</b></td>" + "<td>A maximum of <b>thirteen(13)</b> items can be added in request list.</td>" + "</tr>" + "</table>"; return; } try { txtNet.Text = (Convert.ToDouble(txtApprovedRFA.Text) - Convert.ToDouble(txtAmountAllocated.Text)).ToString(); } catch { } try { //txtRemainingBudget.Text = (Convert.ToDouble(txtNet.Text) - Convert.ToDouble(txtRequestAmount.Text)).ToString(); } catch { } } catch { Response.Redirect("PettyCashRequestDetailsApprover.aspx"); } }