private Int64 SaveRecord() { DebitMemos clsDebitMemos = new DebitMemos(); clsDebitMemos.GetConnection(); lblMemoNo.Text = Constants.PURCHASE_DEBITMEMO_CODE + CompanyDetails.BECompanyCode + DateTime.Now.Year.ToString() + clsDebitMemos.LastTransactionNo(); DebitMemoDetails clsDetails = new DebitMemoDetails(); clsDetails.MemoNo = lblMemoNo.Text; clsDetails.MemoDate = Convert.ToDateTime(lblMemoDate.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(txtRequiredPostingDate.Text); clsDetails.BranchID = Convert.ToInt16(cboBranch.SelectedItem.Value); clsDetails.PurchaserID = Convert.ToInt64(Session["UID"].ToString()); clsDetails.PurchaserName = Session["Name"].ToString(); clsDetails.DebitMemoStatus = DebitMemoStatus.Open; clsDetails.Remarks = txtRemarks.Text; Int64 id = clsDebitMemos.Insert(clsDetails); clsDebitMemos.CommitAndDispose(); return id; }
private void UpdateDeposit() { DebitMemoDetails clsDebitMemoDetails = new DebitMemoDetails(); clsDebitMemoDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text); clsDebitMemoDetails.Deposit = Convert.ToDecimal(txtPODebitMemoDeposit.Text); DebitMemos clsDebitMemos = new DebitMemos(); clsDebitMemos.UpdateDeposit(clsDebitMemoDetails.DebitMemoID, clsDebitMemoDetails.Deposit); clsDebitMemos.SynchronizeAmount(clsDebitMemoDetails.DebitMemoID); clsDebitMemoDetails = clsDebitMemos.Details(clsDebitMemoDetails.DebitMemoID); clsDebitMemos.CommitAndDispose(); UpdateFooter(clsDebitMemoDetails); }
private void UpdateFooter(DebitMemoDetails clsDebitMemoDetails) { lblPODebitMemoDiscount.Text = clsDebitMemoDetails.Discount.ToString("#,##0.#0"); lblPODebitMemoDiscount2.Text = clsDebitMemoDetails.Discount2.ToString("#,##0.#0"); lblPODebitMemoDiscount3.Text = clsDebitMemoDetails.Discount3.ToString("#,##0.#0"); lblTotalDiscount1.Text = Convert.ToDecimal(clsDebitMemoDetails.SubTotal + clsDebitMemoDetails.Discount + clsDebitMemoDetails.Discount2 + clsDebitMemoDetails.Discount3).ToString("#,##0.#0"); lblTotalDiscount2.Text = Convert.ToDecimal(clsDebitMemoDetails.SubTotal + clsDebitMemoDetails.Discount2 + clsDebitMemoDetails.Discount3).ToString("#,##0.#0"); lblTotalDiscount3.Text = Convert.ToDecimal(clsDebitMemoDetails.SubTotal + clsDebitMemoDetails.Discount3).ToString("#,##0.#0"); lblPODebitMemoVatableAmount.Text = clsDebitMemoDetails.VatableAmount.ToString("#,##0.#0"); txtPODebitMemoFreight.Text = clsDebitMemoDetails.Freight.ToString("#,##0.#0"); txtPODebitMemoDeposit.Text = clsDebitMemoDetails.Deposit.ToString("#,##0.#0"); lblPODebitMemoVAT.Text = clsDebitMemoDetails.VAT.ToString("#,##0.#0"); if (chkIsVatInclusive.Checked) { lblPODebitMemoSubTotal.Text = Convert.ToDecimal(clsDebitMemoDetails.SubTotal - clsDebitMemoDetails.VAT).ToString("#,##0.#0"); lblPODebitMemoTotal.Text = clsDebitMemoDetails.SubTotal.ToString("#,##0.#0"); } else { lblPODebitMemoSubTotal.Text = clsDebitMemoDetails.SubTotal.ToString("#,##0.#0"); lblPODebitMemoTotal.Text = Convert.ToDecimal(clsDebitMemoDetails.SubTotal + clsDebitMemoDetails.VAT).ToString("#,##0.#0"); } }
private void SaveRecord() { DebitMemoItemDetails clsDetails = new DebitMemoItemDetails(); 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.PrevUnitCost = Convert.ToDecimal(txtPrevPrice.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; DebitMemoItems clsDebitMemoItems = new DebitMemoItems(); if (lblDebitMemoItemID.Text != "0") { clsDetails.DebitMemoItemID = Convert.ToInt64(lblDebitMemoItemID.Text); clsDebitMemoItems.Update(clsDetails); } else clsDebitMemoItems.Insert(clsDetails); DebitMemoDetails clsDebitMemoDetails = new DebitMemoDetails(); clsDebitMemoDetails.DebitMemoID = clsDetails.DebitMemoID; clsDebitMemoDetails.DiscountApplied = Convert.ToDecimal(txtPODebitMemoDiscountApplied.Text); clsDebitMemoDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscountType.SelectedItem.Value); clsDebitMemoDetails.Discount2Applied = Convert.ToDecimal(txtPODebitMemoDiscount2Applied.Text); clsDebitMemoDetails.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount2Type.SelectedItem.Value); clsDebitMemoDetails.Discount3Applied = Convert.ToDecimal(txtPODebitMemoDiscount3Applied.Text); clsDebitMemoDetails.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount3Type.SelectedItem.Value); DebitMemos clsDebitMemos = new DebitMemos(clsDebitMemoItems.Connection, clsDebitMemoItems.Transaction); clsDebitMemos.UpdateDiscount(clsDetails.DebitMemoID, clsDebitMemoDetails.DiscountApplied, clsDebitMemoDetails.DiscountType, clsDebitMemoDetails.Discount2Applied, clsDebitMemoDetails.Discount2Type, clsDebitMemoDetails.Discount3Applied, clsDebitMemoDetails.Discount3Type); clsDebitMemoDetails = clsDebitMemos.Details(clsDetails.DebitMemoID); clsDebitMemoItems.CommitAndDispose(); UpdateFooter(clsDebitMemoDetails); }
private void UpdatePODiscount() { DebitMemoDetails clsDebitMemoDetails = new DebitMemoDetails(); clsDebitMemoDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text); clsDebitMemoDetails.DiscountApplied = Convert.ToDecimal(txtPODebitMemoDiscountApplied.Text); clsDebitMemoDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscountType.SelectedItem.Value); clsDebitMemoDetails.Discount2Applied = Convert.ToDecimal(txtPODebitMemoDiscount2Applied.Text); clsDebitMemoDetails.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount2Type.SelectedItem.Value); clsDebitMemoDetails.Discount3Applied = Convert.ToDecimal(txtPODebitMemoDiscount3Applied.Text); clsDebitMemoDetails.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount3Type.SelectedItem.Value); DebitMemos clsDebitMemos = new DebitMemos(); clsDebitMemos.UpdateDiscount(clsDebitMemoDetails.DebitMemoID, clsDebitMemoDetails.DiscountApplied, clsDebitMemoDetails.DiscountType, clsDebitMemoDetails.Discount2Applied, clsDebitMemoDetails.Discount2Type, clsDebitMemoDetails.Discount3Applied, clsDebitMemoDetails.Discount3Type); clsDebitMemos.SynchronizeAmount(Convert.ToInt64(lblDebitMemoID.Text)); clsDebitMemoDetails = clsDebitMemos.Details(Convert.ToInt64(lblDebitMemoID.Text)); clsDebitMemos.CommitAndDispose(); UpdateFooter(clsDebitMemoDetails); }
public System.Data.DataTable ListAsDataTable(DebitMemoStatus DebitMemoStatus = DebitMemoStatus.All, DebitMemoDetails searchKey = new DebitMemoDetails(), DateTime? MemoStartDate = null, DateTime? MemoEndDate = null, DateTime? PostingStartDate = null, DateTime? PostingEndDate = null, string SortField = "DebitMemoID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0, Int64 SupplierID = 0, Int64 DebitMemoID = 0, eSalesFilter clseSalesFilter = new eSalesFilter()) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; // Note WHERE is already included in SQLSelect() string SQL = SQLSelect(); if (DebitMemoStatus != DebitMemoStatus.All) { SQL += "AND DebitMemoStatus = @DebitMemoStatus "; cmd.Parameters.AddWithValue("@DebitMemoStatus", DebitMemoStatus.ToString("d")); } if (DebitMemoID != 0) { SQL += "AND DebitMemoID = @DebitMemoID "; cmd.Parameters.AddWithValue("@DebitMemoID", DebitMemoID); } if (SupplierID != 0) { SQL += "AND SupplierID >= @SupplierID "; cmd.Parameters.AddWithValue("@SupplierID", SupplierID); } if ((MemoStartDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : MemoStartDate) != Constants.C_DATE_MIN_VALUE) { SQL += "AND MemoDate >= @MemoStartDate "; cmd.Parameters.AddWithValue("@MemoStartDate", MemoStartDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); } if ((MemoEndDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : MemoEndDate) != Constants.C_DATE_MIN_VALUE) { SQL += "AND MemoDate <= @MemoEndDate "; cmd.Parameters.AddWithValue("@MemoEndDate", MemoEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); } if ((PostingStartDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : PostingStartDate) != Constants.C_DATE_MIN_VALUE) { SQL += "AND PostingDate >= @PostingStartDate "; cmd.Parameters.AddWithValue("@PostingStartDate", PostingStartDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); } if ((PostingEndDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : PostingEndDate) != Constants.C_DATE_MIN_VALUE) { SQL += "AND PostingDate <= @PostingEndDate "; cmd.Parameters.AddWithValue("@PostingEndDate", PostingEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); } if (clseSalesFilter.FilterIncludeIneSales) { SQL += "AND a.IncludeIneSales = @IncludeIneSales "; cmd.Parameters.AddWithValue("@IncludeIneSales", clseSalesFilter.IncludeIneSales); } SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "DebitMemoID") + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; 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); return dt; } catch (Exception ex) { throw base.ThrowException(ex); } }
public DebitMemoDetails 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); DebitMemoDetails Details = new DebitMemoDetails(); 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.DebitMemoStatus = (DebitMemoStatus)Enum.Parse(typeof(DebitMemoStatus), myReader.GetString("DebitMemoStatus")); 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); } }
public void Update(DebitMemoDetails 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; cmd.Parameters.AddWithValue("@MemoNo", Details.MemoNo); cmd.Parameters.AddWithValue("@MemoDate", Details.MemoDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@SupplierID", Details.SupplierID); cmd.Parameters.AddWithValue("@SupplierCode", Details.SupplierCode); cmd.Parameters.AddWithValue("@SupplierContact", Details.SupplierContact); cmd.Parameters.AddWithValue("@SupplierAddress", Details.SupplierAddress); cmd.Parameters.AddWithValue("@SupplierTelephoneNo", Details.SupplierTelephoneNo); cmd.Parameters.AddWithValue("@SupplierModeOfTerms", Details.SupplierModeOfTerms); cmd.Parameters.AddWithValue("@SupplierTerms", Details.SupplierTerms); cmd.Parameters.AddWithValue("@RequiredPostingDate", Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@BranchID", Details.BranchID); cmd.Parameters.AddWithValue("@PurchaserID", Details.PurchaserID); cmd.Parameters.AddWithValue("@PurchaserName", Details.PurchaserName); cmd.Parameters.AddWithValue("@POReturnStatus", POReturnStatus.Posted.ToString("d")); cmd.Parameters.AddWithValue("@DebitMemoStatus", Details.DebitMemoStatus.ToString("d")); cmd.Parameters.AddWithValue("@Remarks", Details.Remarks); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPTracking", clsAPLinkConfigDetails.ChartOfAccountIDAPTracking); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPBills", clsAPLinkConfigDetails.ChartOfAccountIDAPBills); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPFreight", clsAPLinkConfigDetails.ChartOfAccountIDAPFreight); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPVDeposit", clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPContra", clsAPLinkConfigDetails.ChartOfAccountIDAPContra); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPLatePayment", clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment); cmd.Parameters.AddWithValue("@DebitMemoID", Details.DebitMemoID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public long Insert(DebitMemoDetails 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; cmd.Parameters.AddWithValue("@MemoNo", Details.MemoNo); cmd.Parameters.AddWithValue("@MemoDate", Details.MemoDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@SupplierID", Details.SupplierID); cmd.Parameters.AddWithValue("@SupplierCode", Details.SupplierCode); cmd.Parameters.AddWithValue("@SupplierContact", Details.SupplierContact); cmd.Parameters.AddWithValue("@SupplierAddress", Details.SupplierAddress); cmd.Parameters.AddWithValue("@SupplierTelephoneNo", Details.SupplierTelephoneNo); cmd.Parameters.AddWithValue("@SupplierModeOfTerms", Details.SupplierModeOfTerms); cmd.Parameters.AddWithValue("@SupplierTerms", Details.SupplierTerms); cmd.Parameters.AddWithValue("@RequiredPostingDate", Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@BranchID", Details.BranchID); cmd.Parameters.AddWithValue("@PurchaserID", Details.PurchaserID); cmd.Parameters.AddWithValue("@PurchaserName", Details.PurchaserName); cmd.Parameters.AddWithValue("@POReturnStatus", POReturnStatus.Posted.ToString("d")); cmd.Parameters.AddWithValue("@DebitMemoStatus", Details.DebitMemoStatus.ToString("d")); cmd.Parameters.AddWithValue("@Remarks", Details.Remarks); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPTracking", clsAPLinkConfigDetails.ChartOfAccountIDAPTracking); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPBills", clsAPLinkConfigDetails.ChartOfAccountIDAPBills); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPFreight", clsAPLinkConfigDetails.ChartOfAccountIDAPFreight); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPVDeposit", clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPContra", clsAPLinkConfigDetails.ChartOfAccountIDAPContra); cmd.Parameters.AddWithValue("@ChartOfAccountIDAPLatePayment", clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment); 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); } }
private void SaveRecord() { DebitMemoDetails clsDetails = new DebitMemoDetails(); clsDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text); clsDetails.MemoNo = lnkMemoNo.Text; clsDetails.MemoDate = Convert.ToDateTime(lblMemoDate.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(txtRequiredPostingDate.Text); clsDetails.BranchID = Convert.ToInt16(cboBranch.SelectedItem.Value); clsDetails.PurchaserID = Convert.ToInt64(Session["UID"].ToString()); clsDetails.PurchaserName = Session["Name"].ToString(); clsDetails.DebitMemoStatus = DebitMemoStatus.Open; clsDetails.Remarks = txtRemarks.Text; DebitMemos clsDebitMemos = new DebitMemos(); clsDebitMemos.Update(clsDetails); clsDebitMemos.CommitAndDispose(); }