public ERPConfigDetails Details() { try { string SQL = "SELECT " + "LastPONo, " + "PostingDateFrom, " + "PostingDateTo " + "FROM tblERPConfig;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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); ERPConfigDetails Details = new ERPConfigDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.LastPONo = "" + dr["LastPONo"].ToString(); Details.PostingDateFrom = DateTime.Parse(dr["PostingDateFrom"].ToString()); Details.PostingDateTo = DateTime.Parse(dr["PostingDateTo"].ToString()); } return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void AddItemToInventory(long CreditMemoID) { CreditMemoDetails clsCreditMemoDetails = Details(CreditMemoID); ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction); ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details(); CreditMemoItems clsCreditMemoItems = new CreditMemoItems(base.Connection, base.Transaction); ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction); Products clsProduct = new Products(base.Connection, base.Transaction); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction); Inventory clsInventory = new Inventory(base.Connection, base.Transaction); System.Data.DataTable dt = clsCreditMemoItems.ListAsDataTable(CreditMemoID); foreach (System.Data.DataRow dr in dt.Rows) { long lngProductID = long.Parse(dr["ProductID"].ToString()); int intProductUnitID = int.Parse(dr["ProductUnitID"].ToString()); decimal decItemQuantity = decimal.Parse(dr["Quantity"].ToString()); decimal decQuantity = clsProductUnit.GetBaseUnitValue(lngProductID, intProductUnitID, decItemQuantity); long lngVariationMatrixID = long.Parse(dr["VariationMatrixID"].ToString()); string strMatrixDescription = "" + dr["MatrixDescription"].ToString(); string strProductCode = "" + dr["ProductCode"].ToString(); decimal decUnitCost = decimal.Parse(dr["UnitCost"].ToString()); decimal decItemCost = decimal.Parse(dr["Amount"].ToString()); decimal decVAT = decimal.Parse(dr["VAT"].ToString()); /******************************************* * Do not Add to Inventory coz this is a Debit Memo and no effect on inventory * ****************************************/ /******************************************* * Add to Inventory Analysis * ****************************************/ InventoryDetails clsInventoryDetails = new InventoryDetails(); clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom; clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo; clsInventoryDetails.PostingDate = clsCreditMemoDetails.PostingDate; clsInventoryDetails.ReferenceNo = clsCreditMemoDetails.CNNo; clsInventoryDetails.ContactID = clsCreditMemoDetails.CustomerID; clsInventoryDetails.ContactCode = clsCreditMemoDetails.CustomerCode; clsInventoryDetails.ProductID = lngProductID; clsInventoryDetails.ProductCode = strProductCode; clsInventoryDetails.VariationMatrixID = lngVariationMatrixID; clsInventoryDetails.MatrixDescription = strMatrixDescription; clsInventoryDetails.SCreditQuantity = decQuantity; clsInventoryDetails.SCreditCost = decItemCost - decVAT; clsInventoryDetails.SCreditVAT = decItemCost; //Sales Return with VAT clsInventory.Insert(clsInventoryDetails); } //myReader.Close(); }
private void SaveRecord() { ERPConfigDetails clsDetails = new ERPConfigDetails(); clsDetails.PostingDateFrom = Convert.ToDateTime(txtDateFrom.Text); clsDetails.PostingDateTo = Convert.ToDateTime(txtDateTo.Text); ERPConfig clsERPConfig = new ERPConfig(); clsERPConfig.UpdatePostingDate(clsDetails.PostingDateFrom, clsDetails.PostingDateTo); clsERPConfig.CommitAndDispose(); }
public ERPConfigDetails Details() { try { string SQL= "SELECT " + "LastPONo, " + "PostingDateFrom, " + "PostingDateTo " + "FROM tblERPConfig;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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); ERPConfigDetails Details = new ERPConfigDetails(); foreach(System.Data.DataRow dr in dt.Rows) { Details.LastPONo = "" + dr["LastPONo"].ToString(); Details.PostingDateFrom = DateTime.Parse(dr["PostingDateFrom"].ToString()); Details.PostingDateTo = DateTime.Parse(dr["PostingDateTo"].ToString()); } return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ERPConfigDetails Details) { try { string SQL = "CALL procSaveERPConfig(@ERPConfigID, @LastPONo, @LastPOReturnNo, @LastDebitMemoNo, @LastSONo, " + "@LastSOReturnNo, @LastCreditMemoNo, @LastTransferInNo, @LastTransferOutNo, " + "@LastInvAdjustmentNo, @LastClosingNo, @PostingDateFrom, @PostingDateTo, " + "@ChartOfAccountIDAPTracking, @ChartOfAccountIDAPBills, @ChartOfAccountIDAPFreight, " + "@ChartOfAccountIDAPVDeposit, @ChartOfAccountIDAPContra, @ChartOfAccountIDAPLatePayment, " + "@ChartOfAccountIDARTracking, @ChartOfAccountIDARBills, @ChartOfAccountIDARFreight, " + "@ChartOfAccountIDARVDeposit, @ChartOfAccountIDARContra, @ChartOfAccountIDARLatePayment, " + "@LastCreditCardNo, @LastRewardCardNo, @DBVersion, @DBVersionSales, @LastBranchTransferNo, @LastWBranchTransferNo" + "@LastCustomerCode, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("ERPConfigID", Details.ERPConfigID); cmd.Parameters.AddWithValue("LastPONo", Details.LastPONo); cmd.Parameters.AddWithValue("LastPOReturnNo", Details.LastPOReturnNo); cmd.Parameters.AddWithValue("LastDebitMemoNo", Details.LastDebitMemoNo); cmd.Parameters.AddWithValue("LastSONo", Details.LastSONo); cmd.Parameters.AddWithValue("LastSOReturnNo", Details.LastSOReturnNo); cmd.Parameters.AddWithValue("LastCreditMemoNo", Details.LastCreditMemoNo); cmd.Parameters.AddWithValue("LastTransferInNo", Details.LastTransferInNo); cmd.Parameters.AddWithValue("LastTransferOutNo", Details.LastTransferOutNo); cmd.Parameters.AddWithValue("LastInvAdjustmentNo", Details.LastInvAdjustmentNo); cmd.Parameters.AddWithValue("LastClosingNo", Details.LastClosingNo); cmd.Parameters.AddWithValue("PostingDateFrom", Details.PostingDateFrom); cmd.Parameters.AddWithValue("PostingDateTo", Details.PostingDateTo); cmd.Parameters.AddWithValue("ChartOfAccountIDAPTracking", Details.APLinkConfigDetails.ChartOfAccountIDAPTracking); cmd.Parameters.AddWithValue("ChartOfAccountIDAPBills", Details.APLinkConfigDetails.ChartOfAccountIDAPBills); cmd.Parameters.AddWithValue("ChartOfAccountIDAPFreight", Details.APLinkConfigDetails.ChartOfAccountIDAPFreight); cmd.Parameters.AddWithValue("ChartOfAccountIDAPVDeposit", Details.APLinkConfigDetails.ChartOfAccountIDAPVDeposit); cmd.Parameters.AddWithValue("ChartOfAccountIDAPContra", Details.APLinkConfigDetails.ChartOfAccountIDAPContra); cmd.Parameters.AddWithValue("ChartOfAccountIDAPLatePayment", Details.APLinkConfigDetails.ChartOfAccountIDAPLatePayment); cmd.Parameters.AddWithValue("ChartOfAccountIDARTracking", Details.ARLinkConfigDetails.ChartOfAccountIDARTracking); cmd.Parameters.AddWithValue("ChartOfAccountIDARBills", Details.ARLinkConfigDetails.ChartOfAccountIDARBills); cmd.Parameters.AddWithValue("ChartOfAccountIDARFreight", Details.ARLinkConfigDetails.ChartOfAccountIDARFreight); cmd.Parameters.AddWithValue("ChartOfAccountIDARVDeposit", Details.ARLinkConfigDetails.ChartOfAccountIDARVDeposit); cmd.Parameters.AddWithValue("ChartOfAccountIDARContra", Details.ARLinkConfigDetails.ChartOfAccountIDARContra); cmd.Parameters.AddWithValue("ChartOfAccountIDARLatePayment", Details.ARLinkConfigDetails.ChartOfAccountIDARLatePayment); cmd.Parameters.AddWithValue("LastCreditCardNo", Details.LastCreditCardNo); cmd.Parameters.AddWithValue("LastRewardCardNo", Details.LastRewardCardNo); cmd.Parameters.AddWithValue("DBVersion", Details.DBVersion); cmd.Parameters.AddWithValue("DBVersionSales", Details.DBVersionSales); cmd.Parameters.AddWithValue("LastBranchTransferNo", Details.LastBranchTransferNo); cmd.Parameters.AddWithValue("LastWBranchTransferNo", Details.LastWBranchTransferNo); cmd.Parameters.AddWithValue("LastCustomerCode", Details.LastCustomerCode); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return base.ExecuteNonQuery(cmd); } 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 Int32 Save(ERPConfigDetails Details) { try { string SQL = "CALL procSaveERPConfig(@ERPConfigID, @LastPONo, @LastPOReturnNo, @LastDebitMemoNo, @LastSONo, " + "@LastSOReturnNo, @LastCreditMemoNo, @LastTransferInNo, @LastTransferOutNo, " + "@LastInvAdjustmentNo, @LastClosingNo, @PostingDateFrom, @PostingDateTo, " + "@ChartOfAccountIDAPTracking, @ChartOfAccountIDAPBills, @ChartOfAccountIDAPFreight, " + "@ChartOfAccountIDAPVDeposit, @ChartOfAccountIDAPContra, @ChartOfAccountIDAPLatePayment, " + "@ChartOfAccountIDARTracking, @ChartOfAccountIDARBills, @ChartOfAccountIDARFreight, " + "@ChartOfAccountIDARVDeposit, @ChartOfAccountIDARContra, @ChartOfAccountIDARLatePayment, " + "@LastCreditCardNo, @LastRewardCardNo, @DBVersion, @DBVersionSales, @LastBranchTransferNo, @LastWBranchTransferNo" + "@LastCustomerCode, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("ERPConfigID", Details.ERPConfigID); cmd.Parameters.AddWithValue("LastPONo", Details.LastPONo); cmd.Parameters.AddWithValue("LastPOReturnNo", Details.LastPOReturnNo); cmd.Parameters.AddWithValue("LastDebitMemoNo", Details.LastDebitMemoNo); cmd.Parameters.AddWithValue("LastSONo", Details.LastSONo); cmd.Parameters.AddWithValue("LastSOReturnNo", Details.LastSOReturnNo); cmd.Parameters.AddWithValue("LastCreditMemoNo", Details.LastCreditMemoNo); cmd.Parameters.AddWithValue("LastTransferInNo", Details.LastTransferInNo); cmd.Parameters.AddWithValue("LastTransferOutNo", Details.LastTransferOutNo); cmd.Parameters.AddWithValue("LastInvAdjustmentNo", Details.LastInvAdjustmentNo); cmd.Parameters.AddWithValue("LastClosingNo", Details.LastClosingNo); cmd.Parameters.AddWithValue("PostingDateFrom", Details.PostingDateFrom); cmd.Parameters.AddWithValue("PostingDateTo", Details.PostingDateTo); cmd.Parameters.AddWithValue("ChartOfAccountIDAPTracking", Details.APLinkConfigDetails.ChartOfAccountIDAPTracking); cmd.Parameters.AddWithValue("ChartOfAccountIDAPBills", Details.APLinkConfigDetails.ChartOfAccountIDAPBills); cmd.Parameters.AddWithValue("ChartOfAccountIDAPFreight", Details.APLinkConfigDetails.ChartOfAccountIDAPFreight); cmd.Parameters.AddWithValue("ChartOfAccountIDAPVDeposit", Details.APLinkConfigDetails.ChartOfAccountIDAPVDeposit); cmd.Parameters.AddWithValue("ChartOfAccountIDAPContra", Details.APLinkConfigDetails.ChartOfAccountIDAPContra); cmd.Parameters.AddWithValue("ChartOfAccountIDAPLatePayment", Details.APLinkConfigDetails.ChartOfAccountIDAPLatePayment); cmd.Parameters.AddWithValue("ChartOfAccountIDARTracking", Details.ARLinkConfigDetails.ChartOfAccountIDARTracking); cmd.Parameters.AddWithValue("ChartOfAccountIDARBills", Details.ARLinkConfigDetails.ChartOfAccountIDARBills); cmd.Parameters.AddWithValue("ChartOfAccountIDARFreight", Details.ARLinkConfigDetails.ChartOfAccountIDARFreight); cmd.Parameters.AddWithValue("ChartOfAccountIDARVDeposit", Details.ARLinkConfigDetails.ChartOfAccountIDARVDeposit); cmd.Parameters.AddWithValue("ChartOfAccountIDARContra", Details.ARLinkConfigDetails.ChartOfAccountIDARContra); cmd.Parameters.AddWithValue("ChartOfAccountIDARLatePayment", Details.ARLinkConfigDetails.ChartOfAccountIDARLatePayment); cmd.Parameters.AddWithValue("LastCreditCardNo", Details.LastCreditCardNo); cmd.Parameters.AddWithValue("LastRewardCardNo", Details.LastRewardCardNo); cmd.Parameters.AddWithValue("DBVersion", Details.DBVersion); cmd.Parameters.AddWithValue("DBVersionSales", Details.DBVersionSales); cmd.Parameters.AddWithValue("LastBranchTransferNo", Details.LastBranchTransferNo); cmd.Parameters.AddWithValue("LastWBranchTransferNo", Details.LastWBranchTransferNo); cmd.Parameters.AddWithValue("LastCustomerCode", Details.LastCustomerCode); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }