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);
}