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; }
public POReturnDetails Details(long DebitMemoID) { try { string SQL= SQLSelect() + "AND DebitMemoID = @DebitMemoID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmDebitMemoID = new MySqlParameter("@DebitMemoID",MySqlDbType.Int64); prmDebitMemoID.Value = DebitMemoID; cmd.Parameters.Add(prmDebitMemoID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); POReturnDetails Details = new POReturnDetails(); while (myReader.Read()) { Details.DebitMemoID = DebitMemoID; Details.MemoNo = "" + myReader["MemoNo"].ToString(); Details.MemoDate = myReader.GetDateTime("MemoDate"); Details.SupplierID = myReader.GetInt64("SupplierID"); Details.SupplierCode = "" + myReader["SupplierCode"].ToString(); Details.SupplierContact = "" + myReader["SupplierContact"].ToString(); Details.SupplierAddress = "" + myReader["SupplierAddress"].ToString(); Details.SupplierTelephoneNo = "" + myReader["SupplierTelephoneNo"].ToString(); Details.SupplierModeOfTerms = myReader.GetInt16("SupplierModeofTerms"); Details.SupplierTerms = myReader.GetInt16("SupplierTerms"); Details.RequiredPostingDate = myReader.GetDateTime("RequiredPostingDate"); Details.BranchID = myReader.GetInt16("BranchID"); Details.BranchCode = "" + myReader["BranchCode"].ToString(); Details.BranchName = "" + myReader["BranchName"].ToString(); Details.BranchAddress = "" + myReader["BranchAddress"].ToString(); Details.PurchaserID = myReader.GetInt64("PurchaserID"); Details.PurchaserName = "" + myReader["PurchaserName"].ToString(); Details.SubTotal = myReader.GetDecimal("SubTotal"); Details.Discount = myReader.GetDecimal("Discount"); Details.DiscountApplied = myReader.GetDecimal("DiscountApplied"); Details.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), myReader.GetString("DiscountType")); Details.Discount2 = myReader.GetDecimal("Discount2"); Details.Discount2Applied = myReader.GetDecimal("Discount2Applied"); Details.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), myReader.GetString("Discount2Type")); Details.Discount3 = myReader.GetDecimal("Discount3"); Details.Discount3Applied = myReader.GetDecimal("Discount3Applied"); Details.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), myReader.GetString("Discount3Type")); Details.VAT = myReader.GetDecimal("VAT"); Details.VatableAmount = myReader.GetDecimal("VatableAmount"); Details.EVAT = myReader.GetDecimal("EVAT"); Details.EVatableAmount = myReader.GetDecimal("EVatableAmount"); Details.LocalTax = myReader.GetDecimal("LocalTax"); Details.Freight = myReader.GetDecimal("Freight"); Details.Deposit = myReader.GetDecimal("Deposit"); Details.PaidAmount = myReader.GetDecimal("PaidAmount"); Details.UnpaidAmount = myReader.GetDecimal("UnpaidAmount"); Details.TotalItemDiscount = myReader.GetDecimal("TotalItemDiscount"); Details.ReturnStatus = (POReturnStatus) Enum.Parse(typeof(POReturnStatus), myReader.GetString("POReturnStatus")); Details.IsVatInclusive = myReader.GetBoolean("IsVatInclusive"); Details.Remarks = "" + myReader["Remarks"].ToString(); Details.SupplierDocNo = "" + myReader["SupplierDocNo"].ToString(); Details.PostingDate = myReader.GetDateTime("PostingDate"); Details.ChartOfAccountIDAPTracking = myReader.GetInt16("ChartOfAccountIDAPTracking"); Details.ChartOfAccountIDAPFreight = myReader.GetInt16("ChartOfAccountIDAPFreight"); Details.ChartOfAccountIDAPVDeposit = myReader.GetInt16("ChartOfAccountIDAPVDeposit"); Details.ChartOfAccountIDAPContra = myReader.GetInt16("ChartOfAccountIDAPContra"); Details.ChartOfAccountIDAPLatePayment = myReader.GetInt16("ChartOfAccountIDAPLatePayment"); } myReader.Close(); return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
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"); }
public long Insert(POReturnDetails Details) { try { ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction); APLinkConfigDetails clsAPLinkConfigDetails = clsERPConfig.APLinkDetails(); string SQL = "INSERT INTO tblPODebitMemo (" + "MemoNo, " + "MemoDate, " + "SupplierID, " + "SupplierCode, " + "SupplierContact, " + "SupplierAddress, " + "SupplierTelephoneNo, " + "SupplierModeOfTerms, " + "SupplierTerms, " + "RequiredPostingDate, " + "BranchID, " + "PurchaserID, " + "PurchaserName, " + "POReturnStatus, " + "DebitMemoStatus, " + "Remarks, " + "ChartOfAccountIDAPTracking, " + "ChartOfAccountIDAPBills, " + "ChartOfAccountIDAPFreight, " + "ChartOfAccountIDAPVDeposit, " + "ChartOfAccountIDAPContra, " + "ChartOfAccountIDAPLatePayment" + ") VALUES (" + "@MemoNo, " + "@MemoDate, " + "@SupplierID, " + "@SupplierCode, " + "@SupplierContact, " + "@SupplierAddress, " + "@SupplierTelephoneNo, " + "@SupplierModeOfTerms, " + "@SupplierTerms, " + "@RequiredPostingDate, " + "@BranchID, " + "@PurchaserID, " + "@PurchaserName, " + "@POReturnStatus, " + "@DebitMemoStatus, " + "@Remarks, " + "@ChartOfAccountIDAPTracking, " + "@ChartOfAccountIDAPBills, " + "@ChartOfAccountIDAPFreight, " + "@ChartOfAccountIDAPVDeposit, " + "@ChartOfAccountIDAPContra, " + "@ChartOfAccountIDAPLatePayment" + ");"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmReturnNo = new MySqlParameter("@MemoNo",MySqlDbType.String); prmReturnNo.Value = Details.MemoNo; cmd.Parameters.Add(prmReturnNo); MySqlParameter prmReturnDate = new MySqlParameter("@MemoDate",MySqlDbType.DateTime); prmReturnDate.Value = Details.MemoDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmReturnDate); MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64); prmSupplierID.Value = Details.SupplierID; cmd.Parameters.Add(prmSupplierID); MySqlParameter prmSupplierCode = new MySqlParameter("@SupplierCode",MySqlDbType.String); prmSupplierCode.Value = Details.SupplierCode; cmd.Parameters.Add(prmSupplierCode); MySqlParameter prmSupplierContact = new MySqlParameter("@SupplierContact",MySqlDbType.String); prmSupplierContact.Value = Details.SupplierContact; cmd.Parameters.Add(prmSupplierContact); MySqlParameter prmSupplierAddress = new MySqlParameter("@SupplierAddress",MySqlDbType.String); prmSupplierAddress.Value = Details.SupplierAddress; cmd.Parameters.Add(prmSupplierAddress); MySqlParameter prmSupplierTelephoneNo = new MySqlParameter("@SupplierTelephoneNo",MySqlDbType.String); prmSupplierTelephoneNo.Value = Details.SupplierTelephoneNo; cmd.Parameters.Add(prmSupplierTelephoneNo); MySqlParameter prmSupplierModeOfTerms = new MySqlParameter("@SupplierModeOfTerms",MySqlDbType.Int16); prmSupplierModeOfTerms.Value = Details.SupplierModeOfTerms; cmd.Parameters.Add(prmSupplierModeOfTerms); MySqlParameter prmSupplierTerms = new MySqlParameter("@SupplierTerms",MySqlDbType.Int16); prmSupplierTerms.Value = Details.SupplierTerms; cmd.Parameters.Add(prmSupplierTerms); MySqlParameter prmRequiredPostingDate = new MySqlParameter("@RequiredPostingDate",MySqlDbType.DateTime); prmRequiredPostingDate.Value = Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmRequiredPostingDate); MySqlParameter prmBranchID = new MySqlParameter("@BranchID",MySqlDbType.Int16); prmBranchID.Value = Details.BranchID; cmd.Parameters.Add(prmBranchID); MySqlParameter prmPurchaserID = new MySqlParameter("@PurchaserID",MySqlDbType.Int64); prmPurchaserID.Value = Details.PurchaserID; cmd.Parameters.Add(prmPurchaserID); MySqlParameter prmPurchaserName = new MySqlParameter("@PurchaserName",MySqlDbType.String); prmPurchaserName.Value = Details.PurchaserName; cmd.Parameters.Add(prmPurchaserName); MySqlParameter prmPOReturnStatus = new MySqlParameter("@POReturnStatus",MySqlDbType.Int16); prmPOReturnStatus.Value = Details.ReturnStatus.ToString("d"); cmd.Parameters.Add(prmPOReturnStatus); MySqlParameter prmDebitMemoStatus = new MySqlParameter("@DebitMemoStatus",MySqlDbType.Int16); prmDebitMemoStatus.Value = DebitMemoStatus.Posted.ToString("d"); cmd.Parameters.Add(prmDebitMemoStatus); MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String); prmRemarks.Value = Details.Remarks; cmd.Parameters.Add(prmRemarks); MySqlParameter prmChartOfAccountIDAPTracking = new MySqlParameter("@ChartOfAccountIDAPTracking",MySqlDbType.Int32); prmChartOfAccountIDAPTracking.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPTracking; cmd.Parameters.Add(prmChartOfAccountIDAPTracking); MySqlParameter prmChartOfAccountIDAPBills = new MySqlParameter("@ChartOfAccountIDAPBills",MySqlDbType.Int32); prmChartOfAccountIDAPBills.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPBills; cmd.Parameters.Add(prmChartOfAccountIDAPBills); MySqlParameter prmChartOfAccountIDAPFreight = new MySqlParameter("@ChartOfAccountIDAPFreight",MySqlDbType.Int32); prmChartOfAccountIDAPFreight.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPFreight; cmd.Parameters.Add(prmChartOfAccountIDAPFreight); MySqlParameter prmChartOfAccountIDAPVDeposit = new MySqlParameter("@ChartOfAccountIDAPVDeposit",MySqlDbType.Int32); prmChartOfAccountIDAPVDeposit.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit; cmd.Parameters.Add(prmChartOfAccountIDAPVDeposit); MySqlParameter prmChartOfAccountIDAPContra = new MySqlParameter("@ChartOfAccountIDAPContra",MySqlDbType.Int32); prmChartOfAccountIDAPContra.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPContra; cmd.Parameters.Add(prmChartOfAccountIDAPContra); MySqlParameter prmChartOfAccountIDAPLatePayment = new MySqlParameter("@ChartOfAccountIDAPLatePayment",MySqlDbType.Int32); prmChartOfAccountIDAPLatePayment.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment; cmd.Parameters.Add(prmChartOfAccountIDAPLatePayment); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(POReturnDetails Details) { try { ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction); APLinkConfigDetails clsAPLinkConfigDetails = clsERPConfig.APLinkDetails(); string SQL= "UPDATE tblPODebitMemo SET " + "MemoNo = @MemoNo, " + "MemoDate = @MemoDate, " + "SupplierID = @SupplierID, " + "SupplierCode = @SupplierCode, " + "SupplierContact = @SupplierContact, " + "SupplierAddress = @SupplierAddress, " + "SupplierTelephoneNo = @SupplierTelephoneNo, " + "SupplierModeOfTerms = @SupplierModeOfTerms, " + "SupplierTerms = @SupplierTerms, " + "RequiredPostingDate = @RequiredPostingDate, " + "BranchID = @BranchID, " + "PurchaserID = @PurchaserID, " + "PurchaserName = @PurchaserName, " + "Remarks = @Remarks, " + "ChartOfAccountIDAPTracking = @ChartOfAccountIDAPTracking, " + "ChartOfAccountIDAPBills = @ChartOfAccountIDAPBills, " + "ChartOfAccountIDAPFreight = @ChartOfAccountIDAPFreight, " + "ChartOfAccountIDAPVDeposit = @ChartOfAccountIDAPVDeposit, " + "ChartOfAccountIDAPContra = @ChartOfAccountIDAPContra, " + "ChartOfAccountIDAPLatePayment = @ChartOfAccountIDAPLatePayment " + "WHERE DebitMemoID = @DebitMemoID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmReturnNo = new MySqlParameter("@MemoNo",MySqlDbType.String); prmReturnNo.Value = Details.MemoNo; cmd.Parameters.Add(prmReturnNo); MySqlParameter prmReturnDate = new MySqlParameter("@MemoDate",MySqlDbType.DateTime); prmReturnDate.Value = Details.MemoDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmReturnDate); MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64); prmSupplierID.Value = Details.SupplierID; cmd.Parameters.Add(prmSupplierID); MySqlParameter prmSupplierCode = new MySqlParameter("@SupplierCode",MySqlDbType.String); prmSupplierCode.Value = Details.SupplierCode; cmd.Parameters.Add(prmSupplierCode); MySqlParameter prmSupplierContact = new MySqlParameter("@SupplierContact",MySqlDbType.String); prmSupplierContact.Value = Details.SupplierContact; cmd.Parameters.Add(prmSupplierContact); MySqlParameter prmSupplierAddress = new MySqlParameter("@SupplierAddress",MySqlDbType.String); prmSupplierAddress.Value = Details.SupplierAddress; cmd.Parameters.Add(prmSupplierAddress); MySqlParameter prmSupplierTelephoneNo = new MySqlParameter("@SupplierTelephoneNo",MySqlDbType.String); prmSupplierTelephoneNo.Value = Details.SupplierTelephoneNo; cmd.Parameters.Add(prmSupplierTelephoneNo); MySqlParameter prmSupplierModeOfTerms = new MySqlParameter("@SupplierModeOfTerms",MySqlDbType.Int16); prmSupplierModeOfTerms.Value = Details.SupplierModeOfTerms; cmd.Parameters.Add(prmSupplierModeOfTerms); MySqlParameter prmSupplierTerms = new MySqlParameter("@SupplierTerms",MySqlDbType.Int16); prmSupplierTerms.Value = Details.SupplierTerms; cmd.Parameters.Add(prmSupplierTerms); MySqlParameter prmRequiredPostingDate = new MySqlParameter("@RequiredPostingDate",MySqlDbType.DateTime); prmRequiredPostingDate.Value = Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss"); cmd.Parameters.Add(prmRequiredPostingDate); MySqlParameter prmBranchID = new MySqlParameter("@BranchID",MySqlDbType.Int16); prmBranchID.Value = Details.BranchID; cmd.Parameters.Add(prmBranchID); MySqlParameter prmPurchaserID = new MySqlParameter("@PurchaserID",MySqlDbType.Int64); prmPurchaserID.Value = Details.PurchaserID; cmd.Parameters.Add(prmPurchaserID); MySqlParameter prmPurchaserName = new MySqlParameter("@PurchaserName",MySqlDbType.String); prmPurchaserName.Value = Details.PurchaserName; cmd.Parameters.Add(prmPurchaserName); MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String); prmRemarks.Value = Details.Remarks; cmd.Parameters.Add(prmRemarks); MySqlParameter prmChartOfAccountIDAPTracking = new MySqlParameter("@ChartOfAccountIDAPTracking",MySqlDbType.Int32); prmChartOfAccountIDAPTracking.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPTracking; cmd.Parameters.Add(prmChartOfAccountIDAPTracking); MySqlParameter prmChartOfAccountIDAPBills = new MySqlParameter("@ChartOfAccountIDAPBills",MySqlDbType.Int32); prmChartOfAccountIDAPBills.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPBills; cmd.Parameters.Add(prmChartOfAccountIDAPBills); MySqlParameter prmChartOfAccountIDAPFreight = new MySqlParameter("@ChartOfAccountIDAPFreight",MySqlDbType.Int32); prmChartOfAccountIDAPFreight.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPFreight; cmd.Parameters.Add(prmChartOfAccountIDAPFreight); MySqlParameter prmChartOfAccountIDAPVDeposit = new MySqlParameter("@ChartOfAccountIDAPVDeposit",MySqlDbType.Int32); prmChartOfAccountIDAPVDeposit.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit; cmd.Parameters.Add(prmChartOfAccountIDAPVDeposit); MySqlParameter prmChartOfAccountIDAPContra = new MySqlParameter("@ChartOfAccountIDAPContra",MySqlDbType.Int32); prmChartOfAccountIDAPContra.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPContra; cmd.Parameters.Add(prmChartOfAccountIDAPContra); MySqlParameter prmChartOfAccountIDAPLatePayment = new MySqlParameter("@ChartOfAccountIDAPLatePayment",MySqlDbType.Int32); prmChartOfAccountIDAPLatePayment.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment; cmd.Parameters.Add(prmChartOfAccountIDAPLatePayment); MySqlParameter prmDebitMemoID = new MySqlParameter("@DebitMemoID",MySqlDbType.Int64); prmDebitMemoID.Value = Details.DebitMemoID; cmd.Parameters.Add(prmDebitMemoID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void SaveRecord() { POReturnItemDetails clsDetails = new POReturnItemDetails(); Products clsProducts = new Products(); ProductDetails clsProductDetails = clsProducts.Details1(Constants.BRANCH_ID_MAIN, Convert.ToInt64(cboProductCode.SelectedItem.Value)); Terminal clsTerminal = new Terminal(clsProducts.Connection, clsProducts.Transaction); TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString()); clsProducts.CommitAndDispose(); clsDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text); clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); clsDetails.ProductCode = clsProductDetails.ProductCode; clsDetails.BarCode = clsProductDetails.BarCode; clsDetails.Description = clsProductDetails.ProductDesc; clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value); clsDetails.ProductUnitCode = cboProductUnit.SelectedItem.Text; clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text); clsDetails.UnitCost = Convert.ToDecimal(txtPrice.Text); clsDetails.Discount = getItemTotalDiscount(); clsDetails.DiscountApplied = Convert.ToDecimal(txtDiscount.Text); if (clsDetails.DiscountApplied == 0) { if (chkInPercent.Checked == true) clsDetails.DiscountType = DiscountTypes.Percentage; else clsDetails.DiscountType = DiscountTypes.FixedValue; } else { clsDetails.DiscountType = DiscountTypes.NotApplicable; } clsDetails.IsVatable = chkIsTaxable.Checked; clsDetails.Amount = ComputeItemAmount(); if (clsDetails.IsVatable) { clsDetails.VatableAmount = clsDetails.Amount; clsDetails.EVatableAmount = clsDetails.Amount; clsDetails.LocalTax = clsDetails.Amount; if (clsTerminalDetails.IsVATInclusive == false) { if (clsDetails.VatableAmount < clsDetails.Discount) clsDetails.VatableAmount = 0; if (clsDetails.EVatableAmount < clsDetails.Discount) clsDetails.EVatableAmount = 0; if (clsDetails.LocalTax < clsDetails.Discount) clsDetails.LocalTax = 0; } else { if (clsDetails.VatableAmount >= clsDetails.Discount) clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.VatableAmount = 0; if (clsDetails.EVatableAmount >= clsDetails.Discount) clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.EVatableAmount = 0; if (clsDetails.LocalTax >= clsDetails.Discount) clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100)); else clsDetails.LocalTax = 0; } clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100); clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100); clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100); } else { clsDetails.VAT = 0; clsDetails.VatableAmount = 0; clsDetails.EVAT = 0; clsDetails.EVatableAmount = 0; clsDetails.LocalTax = 0; } clsDetails.isVATInclusive = clsTerminalDetails.IsVATInclusive; clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value); if (clsDetails.VariationMatrixID != 0) clsDetails.MatrixDescription = cboVariation.SelectedItem.Text; clsDetails.ProductGroup = clsProductDetails.ProductGroupCode; clsDetails.ProductSubGroup = clsProductDetails.ProductSubGroupCode; clsDetails.Remarks = txtRemarks.Text; POReturnItems clsPOReturnItems = new POReturnItems(); if (lblPODebitMemoItemID.Text != "0") { clsDetails.DebitMemoItemID = Convert.ToInt64(lblPODebitMemoItemID.Text); clsPOReturnItems.Update(clsDetails); } else clsPOReturnItems.Insert(clsDetails); POReturnDetails clsPOReturnDetails = new POReturnDetails(); clsPOReturnDetails.DebitMemoID = clsDetails.DebitMemoID; clsPOReturnDetails.DiscountApplied = Convert.ToDecimal(txtPODebitMemoDiscountApplied.Text); clsPOReturnDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscountType.SelectedItem.Value); clsPOReturnDetails.Discount2Applied = Convert.ToDecimal(txtPODebitMemoDiscount2Applied.Text); clsPOReturnDetails.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount2Type.SelectedItem.Value); clsPOReturnDetails.Discount3Applied = Convert.ToDecimal(txtPODebitMemoDiscount3Applied.Text); clsPOReturnDetails.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount3Type.SelectedItem.Value); POReturns clsPOReturns = new POReturns(clsPOReturnItems.Connection, clsPOReturnItems.Transaction); clsPOReturns.UpdateDiscount(clsDetails.DebitMemoID, clsPOReturnDetails.DiscountApplied, clsPOReturnDetails.DiscountType, clsPOReturnDetails.Discount2Applied, clsPOReturnDetails.Discount2Type, clsPOReturnDetails.Discount3Applied, clsPOReturnDetails.Discount3Type); clsPOReturnDetails = clsPOReturns.Details(clsDetails.DebitMemoID); clsPOReturnItems.CommitAndDispose(); UpdateFooter(clsPOReturnDetails); }
private void UpdateFooter(POReturnDetails clsPOReturnDetails) { lblPODebitMemoDiscount.Text = clsPOReturnDetails.Discount.ToString("#,##0.#0"); lblPODebitMemoDiscount2.Text = clsPOReturnDetails.Discount2.ToString("#,##0.#0"); lblPODebitMemoDiscount3.Text = clsPOReturnDetails.Discount3.ToString("#,##0.#0"); lblTotalDiscount1.Text = Convert.ToDecimal(clsPOReturnDetails.SubTotal + clsPOReturnDetails.Discount + clsPOReturnDetails.Discount2 + clsPOReturnDetails.Discount3).ToString("#,##0.#0"); lblTotalDiscount2.Text = Convert.ToDecimal(clsPOReturnDetails.SubTotal + clsPOReturnDetails.Discount2 + clsPOReturnDetails.Discount3).ToString("#,##0.#0"); lblTotalDiscount3.Text = Convert.ToDecimal(clsPOReturnDetails.SubTotal + clsPOReturnDetails.Discount3).ToString("#,##0.#0"); lblPODebitMemoVatableAmount.Text = clsPOReturnDetails.VatableAmount.ToString("#,##0.#0"); txtPODebitMemoFreight.Text = clsPOReturnDetails.Freight.ToString("#,##0.#0"); txtPODebitMemoDeposit.Text = clsPOReturnDetails.Deposit.ToString("#,##0.#0"); lblPODebitMemoVAT.Text = clsPOReturnDetails.VAT.ToString("#,##0.#0"); if (chkIsVatInclusive.Checked) { lblPODebitMemoSubTotal.Text = Convert.ToDecimal(clsPOReturnDetails.SubTotal - clsPOReturnDetails.VAT).ToString("#,##0.#0"); lblPODebitMemoTotal.Text = clsPOReturnDetails.SubTotal.ToString("#,##0.#0"); } else { lblPODebitMemoSubTotal.Text = clsPOReturnDetails.SubTotal.ToString("#,##0.#0"); lblPODebitMemoTotal.Text = Convert.ToDecimal(clsPOReturnDetails.SubTotal + clsPOReturnDetails.VAT).ToString("#,##0.#0"); } }
private void UpdateDeposit() { POReturnDetails clsPOReturnDetails = new POReturnDetails(); clsPOReturnDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text); clsPOReturnDetails.Deposit = Convert.ToDecimal(txtPODebitMemoDeposit.Text); POReturns clsPOReturns = new POReturns(); clsPOReturns.UpdateDeposit(clsPOReturnDetails.DebitMemoID, clsPOReturnDetails.Deposit); clsPOReturns.SynchronizeAmount(clsPOReturnDetails.DebitMemoID); clsPOReturnDetails = clsPOReturns.Details(clsPOReturnDetails.DebitMemoID); clsPOReturns.CommitAndDispose(); UpdateFooter(clsPOReturnDetails); }
private void UpdatePODiscount() { POReturnDetails clsPOReturnDetails = new POReturnDetails(); clsPOReturnDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text); clsPOReturnDetails.DiscountApplied = Convert.ToDecimal(txtPODebitMemoDiscountApplied.Text); clsPOReturnDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscountType.SelectedItem.Value); clsPOReturnDetails.Discount2Applied = Convert.ToDecimal(txtPODebitMemoDiscount2Applied.Text); clsPOReturnDetails.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount2Type.SelectedItem.Value); clsPOReturnDetails.Discount3Applied = Convert.ToDecimal(txtPODebitMemoDiscount3Applied.Text); clsPOReturnDetails.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount3Type.SelectedItem.Value); POReturns clsPOReturns = new POReturns(); clsPOReturns.UpdateDiscount(clsPOReturnDetails.DebitMemoID, clsPOReturnDetails.DiscountApplied, clsPOReturnDetails.DiscountType, clsPOReturnDetails.Discount2Applied, clsPOReturnDetails.Discount2Type, clsPOReturnDetails.Discount3Applied, clsPOReturnDetails.Discount3Type); clsPOReturns.SynchronizeAmount(Convert.ToInt64(lblDebitMemoID.Text)); clsPOReturnDetails = clsPOReturns.Details(Convert.ToInt64(lblDebitMemoID.Text)); clsPOReturns.CommitAndDispose(); UpdateFooter(clsPOReturnDetails); }
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(); }