public static bool checkOutstandingReceives(int warehouseID) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectCheckOutstandingReceives(warehouseID, ReceiptConfirmationStatus.Constants.GRV_PRINTED, ReceiptType.CONSTANTS.STOCK_RETURN, ReceiptType.CONSTANTS.STANDARD_RECEIPT); ReceiveDoc receipt = new ReceiveDoc(); receipt.LoadFromRawSql(query); return receipt.Getint("count") == 0; }
/// <summary> /// Gets the last issued date for the facility /// </summary> /// <param name="storeId"></param> /// <param name="itemId"></param> /// <returns></returns> public static DateTime GetLastReceivedDate() { var rd = new ReceiveDoc(); rd.LoadFromRawSql(String.Format("SELECT TOP (1) EurDate FROM ReceiveDoc ORDER BY EurDate DESC")); DateTime dt = (rd.DataTable.Rows.Count > 0) ? Convert.ToDateTime(rd.DataTable.Rows[0]["EurDate"]) : new DateTime(); return dt; }
/// <summary> /// Gets the last issued date for the facility /// </summary> /// <param name="storeId"></param> /// <param name="itemId"></param> /// <returns></returns> public static DateTime GetLastReceivedDate() { var rd = new ReceiveDoc(); rd.LoadFromRawSql(String.Format("SELECT TOP (1) EurDate FROM ReceiveDoc ORDER BY EurDate DESC")); DateTime dt = (rd.DataTable.Rows.Count > 0) ? Convert.ToDateTime(rd.DataTable.Rows[0]["EurDate"]) : new DateTime(); return(dt); }
internal static int ItemReceived(int itemID, int storeId) { string query = string.Format("select sum(Quantity) as Quantity from ReceiveDoc rd where ItemID = {0} and StoreID = {1}", itemID, storeId); ReceiveDoc rd = new ReceiveDoc(); rd.LoadFromRawSql(query); if (rd.RowCount > 0 && !rd.IsColumnNull("Quantity") && rd.Quantity > 0) { return(1); } return(0); }
public static int FixQuantityProblem(int itemId) { BLL.ReceiveDoc rd = new ReceiveDoc(); var query = HCMIS.Repository.Queries.ReceiveDoc.SelectFixQuantityProblem(itemId); rd.LoadFromRawSql(query); int i = Convert.ToInt32(rd.GetColumn("Count")); query = HCMIS.Repository.Queries.ReceiveDoc.UpdateFixQuantityProblemReceivedoc(itemId); rd.LoadFromRawSql(query); return i; }
/// <summary> /// Loads the pricing summary /// </summary> /// <param name="itemID">The item ID.</param> /// <param name="storeID">The store ID.</param> /// <param name="supplierID">The supplier ID.</param> /// <param name="manufacturerID">The manufacturer ID.</param> /// <param name="unitId">The unit id.</param> /// <returns></returns> public static DataView LoadForCostSheetDetail(int itemID, int storeID, int supplierID, int manufacturerID, int unitId) { //They asked that beginningBalance shows on the moving Average //u do what they ask if (!BLL.Settings.SkipBeginningBalancePricing) { Activity st = new Activity(); st.LoadByPrimaryKey(storeID); String query; query = HCMIS.Repository.Queries.ReceiveDoc.SelectLoadForCostSheetDetailSkipBeginningBalancePricing(itemID, storeID, supplierID, manufacturerID, unitId); ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadFromRawSql(query); return receivedoc.DefaultView; } else { Activity st = new Activity(); st.LoadByPrimaryKey(storeID); String query; query = HCMIS.Repository.Queries.ReceiveDoc.SelectLoadForCostSheetDetail(itemID, storeID, supplierID, manufacturerID, unitId); ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadFromRawSql(query); return receivedoc.DefaultView; } }
public static DataTable ListOfItemPendingPrintAndConfirmation(int itemID, int ManufacturerID, int ItemUnitID, int MovingAverageID) { ReceiveDoc rd = new ReceiveDoc(); var query = HCMIS.Repository.Queries.ReceiveDoc.SelectListOfItemPendingPrintAndConfirmation(itemID, ManufacturerID, ItemUnitID, MovingAverageID, ReceiptConfirmationStatus.Constants.GRNF_PRINTED, ReceiptConfirmationStatus.Constants.GRV_PRINTED); rd.LoadFromRawSql(query); return rd.DataTable; }
public static bool IsShortageOrDamageForBatchElectronicReceive(int reference) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectIsBatchElectronicReceive(reference); ReceiveDoc rd = new ReceiveDoc(); rd.LoadFromRawSql(query); var invoicedQty = rd.DataTable.AsEnumerable().Select(t => t.Field<decimal>("InvoicedQty")).FirstOrDefault<decimal>(); var TotalReceived = rd.DataTable.AsEnumerable().Select(t => t.Field<decimal>("TotalReceived")).FirstOrDefault<decimal>(); return invoicedQty != TotalReceived; }
public static DataTable GetOutstandingReceives(int warehouseID = 0) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetOutstandingReceives( ReceiptConfirmationStatus.Constants.GRNF_PRINTED, warehouseID, ReceiptType.CONSTANTS.STOCK_RETURN, ReceiptType.CONSTANTS.STANDARD_RECEIPT); ReceiveDoc receipt = new ReceiveDoc(); receipt.LoadFromRawSql(query); return receipt.DataTable; }
public static DataTable GetOutstandingReceiveDeliveryNote(int warehouseID = 0) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetOutstandingReceiveDeliveryNote(warehouseID, ReceiptConfirmationStatus.Constants.GRNF_PRINTED, ReceiptType.CONSTANTS.DELIVERY_NOTE); ReceiveDoc receipt = new ReceiveDoc(); receipt.LoadFromRawSql(query); return receipt.DataTable; }
internal PalletLocation GetWhereItIsLocated() { int receiveDocID = this.ID; var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetWhereItIsLocated(receiveDocID); BLL.ReceiveDoc rd = new ReceiveDoc(); rd.LoadFromRawSql(query); if(rd.RowCount==0) { throw new Exception(string.Format("Pallet doesn't exist for the receive ID = {0}", receiveDocID)); } int palletLocationID = Convert.ToInt32(rd.GetColumn("PalletLocationID")); //We just take the first one. BLL.PalletLocation pl = new PalletLocation(); pl.LoadByPrimaryKey(palletLocationID); return pl; }
/// <summary> /// Returns a QtyPerPack of an item as it exists in the ReceiveDoc table. /// </summary> /// <param name="itemID">The item ID.</param> /// <returns></returns> public static int GetNextQtyPerPackFor(int itemID) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetNextQtyPerPackFor(itemID); ReceiveDoc receiveDoc = new ReceiveDoc(); receiveDoc.LoadFromRawSql(query); if (receiveDoc.RowCount > 0) { return receiveDoc.QtyPerPack; } return 1; }
public static DataTable GetItemInformation(int ItemID, int ItemUnitID, int ManufacturerID, int AccountID) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetItemInformation(ItemID, ItemUnitID, ManufacturerID, AccountID); ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadFromRawSql(query); return receivedoc.DataTable; }
public static DataTable GetCutOffNumber(int fiscalPeriodID, int accountID) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetCutOffNumber(fiscalPeriodID, accountID); ReceiveDoc receipt = new ReceiveDoc(); receipt.LoadFromRawSql(query); return receipt.DataTable; }
public static decimal GetSoundStock(CostElement costElement) { ReceiveDoc receipt = new ReceiveDoc(); var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetSoundStock(costElement.ItemID, costElement.ItemUnitID, costElement.ManufacturerID, costElement.MovingAverageID, ReceiptConfirmationStatus.Constants.GRV_PRINTED); receipt.LoadFromRawSql(query); return Convert.ToDecimal(receipt.GetColumn("Quantity")); }
public static bool IsBatchElectronicReceive(int reference) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectIsBatchElectronicReceive(reference); ReceiveDoc rd = new ReceiveDoc(); rd.LoadFromRawSql(query); return rd.DataTable.Rows.Count == 1; }
public static DataTable GetOutstandingTransfer(int receiptType) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetOutstandingTransfer(receiptType, ReceiptConfirmationStatus.Constants.GRNF_PRINTED); ReceiveDoc receipt = new ReceiveDoc(); receipt.LoadFromRawSql(query); return receipt.DataTable; }
/// <summary> /// Determines whether [is there shortage or damage] [the specified reference]. /// </summary> /// <param name="reference">The reference.</param> /// <returns> /// <c>true</c> if [is there shortage or damage] [the specified reference]; otherwise, <c>false</c>. /// </returns> public static bool IsThereShortageOrDamage(int reference) { //TODO: Make this not use the ReceivePallet table. var query = HCMIS.Repository.Queries.ReceiveDoc.SelectIsThereShortageOrDamage(reference); BLL.ReceiveDoc rd = new ReceiveDoc(); rd.LoadFromRawSql(query); return rd.RowCount > 0; }
public static DataTable GetOutstandingVoidRequestGRV(int warehouseID = 0) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetOutstandingVoidRequestGRV(warehouseID, ReceiptConfirmationStatus.Constants.GRNF_PRINTED); var receipt = new ReceiveDoc(); receipt.LoadFromRawSql(query); return receipt.DataTable; }
/// <summary> /// Loads the expiry dates for all items. /// </summary> /// <returns></returns> public static DataView LoadExpiryDatesForAllItems() { //string balanceQuery = loadOnlyThoseWithBalance ? " and QuantityLeft>0 " : ""; // cast(cast(ExpDate as date) as nvarchar(50)) BLL.ReceiveDoc rd = new ReceiveDoc(); var query = HCMIS.Repository.Queries.ReceiveDoc.SelectLoadExpiryDatesForAllItems(); rd.LoadFromRawSql(query); return rd.DefaultView; }
public static DataTable GetRelatedPicklistForChangingPrice(int ItemID, int ManufacturerID, int ItemUnitID, int AccountID, double SellingPrice) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetRelatedPicklistForChangingPrice(ItemID, ManufacturerID, ItemUnitID, AccountID, SellingPrice); ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadFromRawSql(query); return receivedoc.DataTable; }
public static DataView ReceivedAmoutByYear(int ethiopianYear, int accountID) { ReceiveDoc receiveDoc = new ReceiveDoc(); var query = HCMIS.Repository.Queries.ReceiveDoc.SelectReceivedAmoutByYear(ethiopianYear, accountID); receiveDoc.LoadFromRawSql(query); return receiveDoc.DefaultView; }
public static DataTable GetRelatedReceiveForFinalPriceSetting(int? ReceiptID, int ItemID, int ManufacturerID, int ItemUnitID, int AccountID) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetRelatedReceiveForFinalPriceSetting(ReceiptID, ItemID, ManufacturerID, ItemUnitID, AccountID); ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadFromRawSql(query); return receivedoc.DataTable; }
public static bool DoesPriceNeedToBeChanged(int storeID, int itemID, int unitID,int ManufacturerID) { BLL.Activity store = new Activity(); store.LoadByPrimaryKey(storeID); ReceiveDoc rd = new ReceiveDoc(); string query; query = HCMIS.Repository.Queries.ReceiveDoc.SelectDoesPriceNeedToBeChanged(storeID, itemID, unitID, ManufacturerID); rd.LoadFromRawSql(query); if (rd.RowCount > 1) return true; return false; }
public static DataTable GetRelatedReceiveForMarginChange(int ReceiptID, int ItemID, int ItemUnitID, int ManufacturerID, int ActivityID, double Margin) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetRelatedReceiveForMarginChange(ReceiptID, ItemID, ItemUnitID, ManufacturerID, ActivityID, Margin); ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadFromRawSql(query); return receivedoc.DataTable; }
internal static int ItemReceived(int itemID, int storeId) { string query = string.Format("select sum(Quantity) as Quantity from ReceiveDoc rd where ItemID = {0} and StoreID = {1}", itemID, storeId); ReceiveDoc rd = new ReceiveDoc(); rd.LoadFromRawSql(query); if (rd.RowCount > 0 && !rd.IsColumnNull("Quantity") && rd.Quantity > 0) { return 1; } return 0; }
public static DataTable GetRelatedReceiveForUnitCostAndSellingPrice(int ReceiptID, int ItemID, int ManufacturerID, int ItemUnitID, int ActivityID, double NewUnitCost, double NewSellingPrice) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetRelatedReceiveForUnitCostAndSellingPrice(ReceiptID, ItemID, ManufacturerID, ItemUnitID, ActivityID, NewUnitCost, NewSellingPrice); ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadFromRawSql(query); return receivedoc.DataTable; }
public static DataTable GetRelatedReceiveForUnitCostAndSellingPrice(int ReceiptID,CostElement costElement) { var query = HCMIS.Repository.Queries.ReceiveDoc.SelectGetRelatedReceiveForUnitCostAndSellingPriceRd(ReceiptID, costElement.ItemID, costElement.ItemUnitID, costElement.ManufacturerID, costElement.MovingAverageID, costElement.AverageCost, costElement.SellingPrice); ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadFromRawSql(query); return receivedoc.DataTable; }
/// <summary> /// Fixes the quantity left problem. /// </summary> /// <param name="itemID">The item ID.</param> public static void FixQuantityLeftProblem(int itemID) { var query = HCMIS.Repository.Queries.ReceiveDoc.UpdateFixQuantityLeftProblemRd(itemID); //and (rd.Quantity-x.TotalQty-x.LostQty>0) ReceiveDoc receiveDoc = new ReceiveDoc(); receiveDoc.LoadFromRawSql(query); query = HCMIS.Repository.Queries.ReceiveDoc.UpdateFixQuantityLeftProblemReceivedoc(itemID); receiveDoc.LoadFromRawSql(query); }