private void UpdateFooter(POReturnDetails clsPOReturnDetails) { lblPODiscount.Text = clsPOReturnDetails.Discount.ToString("#,##0.#0"); lblPOVatableAmount.Text = clsPOReturnDetails.VatableAmount.ToString("#,##0.#0"); txtPOFreight.Text = clsPOReturnDetails.Freight.ToString("#,##0.#0"); txtPODeposit.Text = clsPOReturnDetails.Deposit.ToString("#,##0.#0"); lblPOSubTotal.Text = Convert.ToDecimal(clsPOReturnDetails.SubTotal - clsPOReturnDetails.VAT).ToString("#,##0.#0"); lblPOVAT.Text = clsPOReturnDetails.VAT.ToString("#,##0.#0"); lblPOTotal.Text = clsPOReturnDetails.SubTotal.ToString("#,##0.#0"); }
private void LoadRecord() { Common Common = new Common(); Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["retid"], Session.SessionID)); POReturns clsPOReturns = new POReturns(); POReturnDetails clsDetails = clsPOReturns.Details(iID); clsPOReturns.CommitAndDispose(); lblDebitMemoID.Text = clsDetails.DebitMemoID.ToString(); lblReturnNo.Text = clsDetails.MemoNo; lblReturnDate.Text = clsDetails.MemoDate.ToString("yyyy-MM-dd HH:mm:ss"); lblRequiredReturnDate.Text = clsDetails.RequiredPostingDate.ToString("yyyy-MM-dd"); lblSupplierID.Text = clsDetails.SupplierID.ToString(); lblSupplierCode.Text = clsDetails.SupplierCode.ToString(); string stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(clsDetails.SupplierID.ToString(), Session.SessionID); lblSupplierCode.NavigateUrl = Constants.ROOT_DIRECTORY + "/PurchasesAndPayables/_Vendor/Default.aspx" + stParam; lblSupplierContact.Text = clsDetails.SupplierContact; lblSupplierTelephoneNo.Text = clsDetails.SupplierTelephoneNo; lblTerms.Text = clsDetails.SupplierTerms.ToString("##0"); switch (clsDetails.SupplierModeOfTerms) { case 0: lblModeOfterms.Text = "Days"; break; case 1: lblModeOfterms.Text = "Months"; break; case 2: lblModeOfterms.Text = "Years"; break; } lblSupplierAddress.Text = clsDetails.SupplierAddress; lblBranchID.Text = clsDetails.BranchID.ToString(); lblBranchCode.Text = clsDetails.BranchCode; lblBranchAddress.Text = clsDetails.BranchAddress; lblReturnRemarks.Text = clsDetails.Remarks; UpdateFooter(clsDetails); }
private long SaveRecord() { POReturns clsPOReturns = new POReturns(); clsPOReturns.GetConnection(); lblReturnNo.Text = Constants.PURCHASE_RETURN_CODE + CompanyDetails.BECompanyCode + DateTime.Now.Year.ToString() + clsPOReturns.LastTransactionNo(); POReturnDetails clsDetails = new POReturnDetails(); clsDetails.MemoNo = lblReturnNo.Text; clsDetails.MemoDate = Convert.ToDateTime(lblReturnDate.Text); clsDetails.SupplierID = Convert.ToInt64(cboSupplier.SelectedItem.Value); clsDetails.SupplierCode = cboSupplier.SelectedItem.Text; clsDetails.SupplierContact = txtSupplierContact.Text; clsDetails.SupplierAddress = txtSupplierAddress.Text; clsDetails.SupplierTelephoneNo = txtSupplierTelephoneNo.Text; clsDetails.SupplierTerms = Convert.ToInt32(lblTerms.Text); switch (lblModeOfterms.Text) { case "Days": clsDetails.SupplierModeOfTerms = 0; break; case "Months": clsDetails.SupplierModeOfTerms = 1; break; case "Years": clsDetails.SupplierModeOfTerms = 2; break; } clsDetails.RequiredPostingDate = Convert.ToDateTime(txtRequiredReturnDate.Text); clsDetails.BranchID = Convert.ToInt16(cboBranch.SelectedItem.Value); clsDetails.PurchaserID = Convert.ToInt64(Session["UID"].ToString()); clsDetails.PurchaserName = Session["Name"].ToString(); clsDetails.ReturnStatus = POReturnStatus.Open; clsDetails.Remarks = txtRemarks.Text; long id = clsPOReturns.Insert(clsDetails); clsPOReturns.CommitAndDispose(); return(id); }
private void SaveRecord() { POReturnDetails clsDetails = new POReturnDetails(); clsDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text); clsDetails.MemoNo = lnkReturnNo.Text; clsDetails.MemoDate = Convert.ToDateTime(lblReturnDate.Text); clsDetails.SupplierID = Convert.ToInt64(cboSupplier.SelectedItem.Value); clsDetails.SupplierCode = cboSupplier.SelectedItem.Text; clsDetails.SupplierContact = txtSupplierContact.Text; clsDetails.SupplierAddress = txtSupplierAddress.Text; clsDetails.SupplierTelephoneNo = txtSupplierTelephoneNo.Text; switch (lblModeOfterms.Text) { case "Days": clsDetails.SupplierModeOfTerms = 0; break; case "Months": clsDetails.SupplierModeOfTerms = 1; break; case "Years": clsDetails.SupplierModeOfTerms = 2; break; } clsDetails.RequiredPostingDate = Convert.ToDateTime(txtRequiredReturnDate.Text); clsDetails.BranchID = Convert.ToInt16(cboBranch.SelectedItem.Value); clsDetails.PurchaserID = Convert.ToInt64(Session["UID"].ToString()); clsDetails.PurchaserName = Session["Name"].ToString(); clsDetails.ReturnStatus = POReturnStatus.Open; clsDetails.Remarks = txtRemarks.Text; POReturns clsPOReturns = new POReturns(); clsPOReturns.Update(clsDetails); clsPOReturns.CommitAndDispose(); }
private void LoadRecord() { Common Common = new Common(); Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["retid"], Session.SessionID)); POReturns clsPOReturns = new POReturns(); POReturnDetails clsDetails = clsPOReturns.Details(iID); clsPOReturns.CommitAndDispose(); lblDebitMemoID.Text = clsDetails.DebitMemoID.ToString(); lnkReturnNo.Text = clsDetails.MemoNo; lnkReturnNo.NavigateUrl = "Default.aspx?task=" + Common.Encrypt("details", Session.SessionID) + "&retid=" + Common.Encrypt(clsDetails.DebitMemoID.ToString(), Session.SessionID); lblReturnDate.Text = clsDetails.MemoDate.ToString("yyyy-MM-dd HH:mm:ss"); txtRequiredReturnDate.Text = clsDetails.RequiredPostingDate.ToString("yyyy-MM-dd"); cboSupplier.SelectedIndex = cboSupplier.Items.IndexOf(cboSupplier.Items.FindByValue(clsDetails.SupplierID.ToString())); txtSupplierContact.Text = clsDetails.SupplierContact; txtSupplierTelephoneNo.Text = clsDetails.SupplierTelephoneNo; lblTerms.Text = clsDetails.SupplierTerms.ToString("##0"); switch (clsDetails.SupplierModeOfTerms) { case 0: lblModeOfterms.Text = "Days"; break; case 1: lblModeOfterms.Text = "Months"; break; case 2: lblModeOfterms.Text = "Years"; break; } txtSupplierAddress.Text = clsDetails.SupplierAddress; cboBranch.SelectedIndex = cboBranch.Items.IndexOf(cboBranch.Items.FindByValue(clsDetails.BranchID.ToString())); txtBranchAddress.Text = clsDetails.BranchAddress; txtRemarks.Text = clsDetails.Remarks; }