public void Cancel(long WBranchTransferID, DateTime CancelledDate, string Remarks, long CancelledByID) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "UPDATE tblWBranchTransfer SET " + "CancelledDate = @CancelledDate, "+ "CancelledRemarks = @CancelledRemarks, "+ "CancelledByID = @CancelledByID, "+ "Status = @Status "+ "WHERE WBranchTransferID = @WBranchTransferID;"; cmd.Parameters.AddWithValue("@CancelledDate", CancelledDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@CancelledRemarks", Remarks); cmd.Parameters.AddWithValue("@CancelledByID", CancelledByID); cmd.Parameters.AddWithValue("@Status", WBranchTransferStatus.Cancelled.ToString("d")); cmd.Parameters.AddWithValue("@WBranchTransferID", WBranchTransferID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); /******************************************* * Update the status of items * ****************************************/ WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(base.Connection, base.Transaction); clsWBranchTransferItem.Cancel(WBranchTransferID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void IssueGRN(Int64 WBranchTransferID, string ReceivedBy, DateTime DeliveryDate) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "UPDATE tblWBranchTransfer SET " + "ReceivedBy = @ReceivedBy, "+ "DeliveryDate = @DeliveryDate, "+ "Status = @Status "+ "WHERE WBranchTransferID = @WBranchTransferID;"; cmd.Parameters.AddWithValue("@ReceivedBy", ReceivedBy); cmd.Parameters.AddWithValue("@DeliveryDate", DeliveryDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@Status", WBranchTransferStatus.Posted.ToString("d")); cmd.Parameters.AddWithValue("@WBranchTransferID", WBranchTransferID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); /******************************************* * Update the status of items * ****************************************/ WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(base.Connection, base.Transaction); clsWBranchTransferItem.Post(WBranchTransferID); /******************************************* * Update Vendor Account * ****************************************/ AddItemToInventory(WBranchTransferID); /******************************************* * Update Account Balance * ****************************************/ UpdateAccounts(WBranchTransferID); /******************************************* * Update Required Inventory Days (RID) * ****************************************/ UpdateRID(WBranchTransferID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Cancel(long WBranchTransferID, DateTime CancelledDate, string Remarks, long CancelledByID) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL= "UPDATE tblWBranchTransfer SET " + "CancelledDate = @CancelledDate, " + "CancelledRemarks = @CancelledRemarks, " + "CancelledByID = @CancelledByID, " + "Status = @Status " + "WHERE WBranchTransferID = @WBranchTransferID;"; cmd.Parameters.AddWithValue("@CancelledDate", CancelledDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@CancelledRemarks", Remarks); cmd.Parameters.AddWithValue("@CancelledByID", CancelledByID); cmd.Parameters.AddWithValue("@Status", WBranchTransferStatus.Cancelled.ToString("d")); cmd.Parameters.AddWithValue("@WBranchTransferID", WBranchTransferID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); /******************************************* * Update the status of items * ****************************************/ WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(base.Connection, base.Transaction); clsWBranchTransferItem.Cancel(WBranchTransferID); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void AddItemToInventory(long WBranchTransferID) { WBranchTransferDetails clsWBranchTransferDetails = Details(WBranchTransferID); ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction); ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details(); WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(base.Connection, base.Transaction); ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction); Products clsProduct = new Products(base.Connection, base.Transaction); Inventory clsInventory = new Inventory(base.Connection, base.Transaction); InventoryDetails clsInventoryDetails; System.Data.DataTable dt = clsWBranchTransferItem.ListAsDataTable(WBranchTransferID, "WBranchTransferItemID", SortOption.Ascending); foreach (System.Data.DataRow dr in dt.Rows) { long lngProductID = Int64.Parse(dr["ProductID"].ToString()); int intProductUnitID = Int16.Parse(dr["ProductUnitID"].ToString()); decimal decItemQuantity = decimal.Parse(dr["Quantity"].ToString()); decimal decQuantity = clsProductUnit.GetBaseUnitValue(lngProductID, intProductUnitID, decItemQuantity); long lngVariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString()); string strMatrixDescription = "" + dr["MatrixDescription"].ToString(); string strProductCode = "" + dr["ProductCode"].ToString(); string strProductUnitCode = "" + dr["ProductUnitCode"].ToString(); decimal decUnitCost = decimal.Parse(dr["UnitCost"].ToString()); decimal decItemCost = decimal.Parse(dr["Amount"].ToString()); decimal decVAT = decimal.Parse(dr["VAT"].ToString()); /******************************************* * Subtract BranchIDFrom then Add to BranchIDTo -- Inventory * ****************************************/ clsProduct.SubtractQuantity(clsWBranchTransferDetails.BranchIDFrom, lngProductID, lngVariationMatrixID, decQuantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_BRANCH_TRANSFER_FROM) + " " + clsWBranchTransferDetails.BranchCodeFrom + " @ " + decUnitCost.ToString("#,##0.#0") + "/" + strProductUnitCode, DateTime.Now, clsWBranchTransferDetails.WBranchTransferNo, clsWBranchTransferDetails.TransferrerName); clsProduct.AddQuantity(clsWBranchTransferDetails.BranchIDTo, lngProductID, lngVariationMatrixID, decQuantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_BRANCH_TRANSFER_TO) + " " + clsWBranchTransferDetails.BranchCodeTo + " @ " + decUnitCost.ToString("#,##0.#0") + "/" + strProductUnitCode, DateTime.Now, clsWBranchTransferDetails.WBranchTransferNo, clsWBranchTransferDetails.TransferrerName); /******************************************* * Add to Inventory Analysis * ****************************************/ clsInventoryDetails = new InventoryDetails(); clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom; clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo; clsInventoryDetails.PostingDate = clsWBranchTransferDetails.DeliveryDate; clsInventoryDetails.ReferenceNo = clsWBranchTransferDetails.WBranchTransferNo; clsInventoryDetails.ContactID = Constants.C_RETAILPLUS_SUPPLIERID; clsInventoryDetails.ContactCode = Constants.C_RETAILPLUS_SUPPLIER; clsInventoryDetails.ProductID = lngProductID; clsInventoryDetails.ProductCode = strProductCode; clsInventoryDetails.VariationMatrixID = lngVariationMatrixID; clsInventoryDetails.MatrixDescription = strMatrixDescription; clsInventoryDetails.PurchaseCost = decItemCost - decVAT; clsInventoryDetails.PurchaseVAT = decItemCost; // Purchase Cost with VAT // insert into branchid from with minus quantity clsInventoryDetails.BranchID = clsWBranchTransferDetails.BranchIDFrom; clsInventoryDetails.PurchaseQuantity = -decQuantity; clsInventory.Insert(clsInventoryDetails); // insert into branchid to with add quantity clsInventoryDetails.BranchID = clsWBranchTransferDetails.BranchIDTo; clsInventoryDetails.PurchaseQuantity = decQuantity; clsInventory.Insert(clsInventoryDetails); } }
public void IssueGRN(Int64 WBranchTransferID, string ReceivedBy, DateTime DeliveryDate) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL= "UPDATE tblWBranchTransfer SET " + "ReceivedBy = @ReceivedBy, " + "DeliveryDate = @DeliveryDate, " + "Status = @Status " + "WHERE WBranchTransferID = @WBranchTransferID;"; cmd.Parameters.AddWithValue("@ReceivedBy", ReceivedBy); cmd.Parameters.AddWithValue("@DeliveryDate", DeliveryDate.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@Status", WBranchTransferStatus.Posted.ToString("d")); cmd.Parameters.AddWithValue("@WBranchTransferID", WBranchTransferID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); /******************************************* * Update the status of items * ****************************************/ WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(base.Connection, base.Transaction); clsWBranchTransferItem.Post(WBranchTransferID); /******************************************* * Update Vendor Account * ****************************************/ AddItemToInventory(WBranchTransferID); /******************************************* * Update Account Balance * ****************************************/ UpdateAccounts(WBranchTransferID); /******************************************* * Update Required Inventory Days (RID) * ****************************************/ UpdateRID(WBranchTransferID); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void AddItemToInventory(long WBranchTransferID) { WBranchTransferDetails clsWBranchTransferDetails = Details(WBranchTransferID); ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction); ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details(); WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(base.Connection, base.Transaction); ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction); Products clsProduct = new Products(base.Connection, base.Transaction); Inventory clsInventory = new Inventory(base.Connection, base.Transaction); InventoryDetails clsInventoryDetails; System.Data.DataTable dt = clsWBranchTransferItem.ListAsDataTable(WBranchTransferID, "WBranchTransferItemID", SortOption.Ascending); foreach (System.Data.DataRow dr in dt.Rows) { long lngProductID = Int64.Parse(dr["ProductID"].ToString()); int intProductUnitID = Int16.Parse(dr["ProductUnitID"].ToString()); decimal decItemQuantity = decimal.Parse(dr["Quantity"].ToString()); decimal decQuantity = clsProductUnit.GetBaseUnitValue(lngProductID, intProductUnitID, decItemQuantity); long lngVariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString()); string strMatrixDescription = "" + dr["MatrixDescription"].ToString(); string strProductCode = "" + dr["ProductCode"].ToString(); string strProductUnitCode = "" + dr["ProductUnitCode"].ToString(); decimal decUnitCost = decimal.Parse(dr["UnitCost"].ToString()); decimal decItemCost = decimal.Parse(dr["Amount"].ToString()); decimal decVAT = decimal.Parse(dr["VAT"].ToString()); /******************************************* * Subtract BranchIDFrom then Add to BranchIDTo -- Inventory * ****************************************/ clsProduct.SubtractQuantity(clsWBranchTransferDetails.BranchIDFrom, lngProductID, lngVariationMatrixID, decQuantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_BRANCH_TRANSFER_FROM) + " " + clsWBranchTransferDetails.BranchCodeFrom + " @ " + decUnitCost.ToString("#,##0.#0") + "/" + strProductUnitCode, DateTime.Now, clsWBranchTransferDetails.WBranchTransferNo, clsWBranchTransferDetails.TransferrerName); clsProduct.AddQuantity(clsWBranchTransferDetails.BranchIDTo, lngProductID, lngVariationMatrixID, decQuantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_BRANCH_TRANSFER_TO) + " " + clsWBranchTransferDetails.BranchCodeTo + " @ " + decUnitCost.ToString("#,##0.#0") + "/" + strProductUnitCode, DateTime.Now, clsWBranchTransferDetails.WBranchTransferNo, clsWBranchTransferDetails.TransferrerName); /******************************************* * Add to Inventory Analysis * ****************************************/ clsInventoryDetails = new InventoryDetails(); clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom; clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo; clsInventoryDetails.PostingDate = clsWBranchTransferDetails.DeliveryDate; clsInventoryDetails.ReferenceNo = clsWBranchTransferDetails.WBranchTransferNo; clsInventoryDetails.ContactID = Constants.C_RETAILPLUS_SUPPLIERID; clsInventoryDetails.ContactCode = Constants.C_RETAILPLUS_SUPPLIER; clsInventoryDetails.ProductID = lngProductID; clsInventoryDetails.ProductCode = strProductCode; clsInventoryDetails.VariationMatrixID = lngVariationMatrixID; clsInventoryDetails.MatrixDescription = strMatrixDescription; clsInventoryDetails.PurchaseCost = decItemCost - decVAT; clsInventoryDetails.PurchaseVAT = decItemCost; // Purchase Cost with VAT // insert into branchid from with minus quantity clsInventoryDetails.BranchID = clsWBranchTransferDetails.BranchIDFrom; clsInventoryDetails.PurchaseQuantity = -decQuantity; clsInventory.Insert(clsInventoryDetails); // insert into branchid to with add quantity clsInventoryDetails.BranchID = clsWBranchTransferDetails.BranchIDTo; clsInventoryDetails.PurchaseQuantity = decQuantity; clsInventory.Insert(clsInventoryDetails); } }
private void SetDataSource(ReportDocument Report) { long iID = 0; try { if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["WBranchTransferid"].ToString() != null) { iID = Convert.ToInt64(Request.QueryString["WBranchTransferid"].ToString()); } else { iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["WBranchTransferid"].ToString(), Session.SessionID)); } } catch { iID = Convert.ToInt64(Common.Decrypt(lblReferrer.Text.Substring(lblReferrer.Text.IndexOf("WBranchTransferid") + 13), Session.SessionID)); } ReportDataset rptds = new ReportDataset(); WBranchTransfer clsWBranchTransfer = new WBranchTransfer(); System.Data.DataTable dt = clsWBranchTransfer.ListAsDataTable(iID); WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(clsWBranchTransfer.Connection, clsWBranchTransfer.Transaction); System.Data.DataTable dtitems = clsWBranchTransferItem.ListAsDataTable(iID); clsWBranchTransfer.CommitAndDispose(); foreach (System.Data.DataRow dr in dt.Rows) { DataRow drNew = rptds.WBranchTransfer.NewRow(); foreach (DataColumn dc in rptds.WBranchTransfer.Columns) drNew[dc] = dr[dc.ColumnName]; rptds.WBranchTransfer.Rows.Add(drNew); } foreach (System.Data.DataRow dr in dtitems.Rows) { DataRow drNew = rptds.WBranchTransferItems.NewRow(); foreach (DataColumn dc in rptds.WBranchTransferItems.Columns) drNew[dc] = dr[dc.ColumnName]; rptds.WBranchTransferItems.Rows.Add(drNew); } Report.SetDataSource(rptds); SetParameters(Report); }
private void LoadItems() { DataClass clsDataClass = new DataClass(); WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(); lstItem.DataSource = clsWBranchTransferItem.ListAsDataTable(Convert.ToInt64(lblWBranchTransferID.Text)).DefaultView; lstItem.DataBind(); clsWBranchTransferItem.CommitAndDispose(); }
private void LoadItem(string stID) { WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(); WBranchTransferItemDetails clsWBranchTransferItemDetails = clsWBranchTransferItem.Details(Convert.ToInt64(stID)); clsWBranchTransferItem.CommitAndDispose(); cboProductCode.Items.Clear(); cboVariation.Items.Clear(); cboProductUnit.Items.Clear(); txtProductCode.Text = clsWBranchTransferItemDetails.BarCode; cmdProductCode_Click(null, null); cboProductCode.SelectedIndex = cboProductCode.Items.IndexOf(new ListItem(clsWBranchTransferItemDetails.ProductCode, clsWBranchTransferItemDetails.ProductID.ToString())); if (clsWBranchTransferItemDetails.VariationMatrixID == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0")); cboVariation.SelectedIndex = 0; } else { cboVariation.SelectedIndex = cboVariation.Items.IndexOf(new ListItem(clsWBranchTransferItemDetails.MatrixDescription, clsWBranchTransferItemDetails.VariationMatrixID.ToString())); } if (clsWBranchTransferItemDetails.ProductUnitID == 0) { cboProductUnit.Items.Add(new ListItem("No Unit", "0")); cboProductUnit.SelectedIndex = 0; } else { cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsWBranchTransferItemDetails.ProductUnitCode, clsWBranchTransferItemDetails.ProductUnitID.ToString()));} txtQuantity.Text = clsWBranchTransferItemDetails.Quantity.ToString("###0.#0"); txtPrice.Text = clsWBranchTransferItemDetails.UnitCost.ToString("###0.#0"); txtDiscount.Text = clsWBranchTransferItemDetails.Discount.ToString("###0.#0"); if (clsWBranchTransferItemDetails.DiscountType == DiscountTypes.Percentage) chkInPercent.Checked = true; else { chkInPercent.Checked = false; } txtAmount.Text = clsWBranchTransferItemDetails.Amount.ToString("###0.#0"); txtRemarks.Text = clsWBranchTransferItemDetails.Remarks; lblWBranchTransferItemID.Text = stID; chkIsTaxable.Checked = clsWBranchTransferItemDetails.IsVatable; //Added Jan 1, 2010 4:20PM : For selling information txtSellingQuantity.Text = "1"; txtMargin.Text = decimal.Parse(Convert.ToString(((clsWBranchTransferItemDetails.SellingPrice - clsWBranchTransferItemDetails.UnitCost) / clsWBranchTransferItemDetails.UnitCost) * 100)).ToString("###0.#0"); txtSellingPrice.Text = clsWBranchTransferItemDetails.SellingPrice.ToString("###0.#0"); txtVAT.Text = clsWBranchTransferItemDetails.SellingVAT.ToString("###0.#0"); txtEVAT.Text = clsWBranchTransferItemDetails.SellingEVAT.ToString("###0.#0"); txtLocalTax.Text = clsWBranchTransferItemDetails.SellingLocalTax.ToString("###0.#0"); txtOldSellingPrice.Text = clsWBranchTransferItemDetails.OldSellingPrice.ToString("###0.#0"); txtProductCode.Focus(); ShowCommandButtons(true); }
private bool DeleteItems() { bool boRetValue = false; string stIDs = ""; foreach(DataListItem item in lstItem.Items) { HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList"); if (chkList!=null) { if (chkList.Checked == true) { stIDs += chkList.Value + ","; boRetValue = true; } } } if (boRetValue) { WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(); clsWBranchTransferItem.Delete( stIDs.Substring(0,stIDs.Length-1)); WBranchTransfer clsWBranchTransfer = new WBranchTransfer(clsWBranchTransferItem.Connection, clsWBranchTransferItem.Transaction); clsWBranchTransfer.SynchronizeAmount(Convert.ToInt64(lblWBranchTransferID.Text)); WBranchTransferDetails clsWBranchTransferDetails = clsWBranchTransfer.Details(Convert.ToInt64(lblWBranchTransferID.Text)); clsWBranchTransferItem.CommitAndDispose(); UpdateFooter(clsWBranchTransferDetails); } return boRetValue; }
private void SaveRecord() { WBranchTransferItemDetails clsDetails = new WBranchTransferItemDetails(); 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.WBranchTransferID = Convert.ToInt64(lblWBranchTransferID.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; clsDetails.SellingPrice = decimal.Parse(txtSellingPrice.Text); clsDetails.SellingVAT = decimal.Parse(txtVAT.Text); clsDetails.SellingEVAT = decimal.Parse(txtEVAT.Text); clsDetails.SellingLocalTax = decimal.Parse(txtLocalTax.Text); clsDetails.OldSellingPrice = decimal.Parse(txtOldSellingPrice.Text); WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(); if (lblWBranchTransferItemID.Text != "0") { clsDetails.WBranchTransferItemID = Convert.ToInt64(lblWBranchTransferItemID.Text); clsWBranchTransferItem.Update(clsDetails); } else clsWBranchTransferItem.Insert(clsDetails); WBranchTransferDetails clsWBranchTransferDetails = new WBranchTransferDetails(); clsWBranchTransferDetails.WBranchTransferID = clsDetails.WBranchTransferID; clsWBranchTransferDetails.DiscountApplied = Convert.ToDecimal(txtWBranchTransferDiscountApplied.Text); clsWBranchTransferDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboWBranchTransferDiscountType.SelectedItem.Value); WBranchTransfer clsWBranchTransfer = new WBranchTransfer(clsWBranchTransferItem.Connection, clsWBranchTransferItem.Transaction); clsWBranchTransfer.UpdateDiscount(clsDetails.WBranchTransferID, clsWBranchTransferDetails.DiscountApplied, clsWBranchTransferDetails.DiscountType); clsWBranchTransferDetails = clsWBranchTransfer.Details(clsDetails.WBranchTransferID); clsWBranchTransferItem.CommitAndDispose(); UpdateFooter(clsWBranchTransferDetails); }
private void LoadItems() { WBranchTransferItem clsWBranchTransferItem = new WBranchTransferItem(); lstItem.DataSource = clsWBranchTransferItem.ListAsDataTable(Convert.ToInt64(lblWBranchTransferID.Text), "WBranchTransferItemID",SortOption.Ascending).DefaultView; lstItem.DataBind(); clsWBranchTransferItem.CommitAndDispose(); }