public static DataTable GetPreviousStockforCostAnalysisPrintout(int ReceiptID) { Receipt receipt = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetPreviousStockforCostAnalysisPrintout(ReceiptID); receipt.LoadFromRawSql(query); if (BLL.Settings.UseCostTier) { query = HCMIS.Repository.Queries.Receipt.SelectGetPreviousStockforCostAnalysisPrintoutUseCostTier(ReceiptID); receipt.LoadFromRawSql(query); return(CostingService.SetPrice(receipt.DataTable)); } return(receipt.DataTable); }
public static DataTable GetReceiptStatusList() { string query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList(); Receipt receipt = new Receipt(); receipt.LoadFromRawSql(query); System.Data.DataTable tbl = receipt.DataTable; query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList2(); receipt.FlushData(); receipt.LoadFromRawSql(query); tbl.Merge(receipt.DataTable); return(tbl); }
/// <summary> /// Loads the soundp GRV. /// </summary> public void LoadSoundpGRV() { Receipt receipt = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectLoadSoundpGRV(ID); receipt.LoadFromRawSql(query); _pGRVSound = receipt.DefaultView; }
public static DataRow GetReceiptStatusDetail(int receiptID, int receiptStatusID) { var receipt = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusDetails(receiptID, receiptStatusID); receipt.LoadFromRawSql(query); return(receipt.DataTable != null && receipt.DataTable.Rows.Count > 0 ? receipt.DataTable.Rows[0] : null); }
public static DataView GetInventoryListByAccount(int movingAverageID, int statusID) { Receipt receiptInventory = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetInventoryListByAccount(movingAverageID, statusID); receiptInventory.LoadFromRawSql(query); return(receiptInventory.DefaultView); }
public DataTable GetGRVDetailsforCostAnalysis(int ID) { Receipt receipt = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetGRVDetailsforCostAnalysis(ID, BLL.Settings.NoOfDigitsAfterTheDecimalPoint); receipt.LoadFromRawSql(query); return(receipt.DataTable); }
public static DataTable GetDiscrepancyGRVDetailsforCosting(int ReceiptID) { Receipt receipt = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetDiscrepancyGRVDetailsforCosting(ReceiptID, StorageType.Quaranteen, ShortageReasons.Constants.SHORT_LANDED, ShortageReasons.Constants.DAMAGED); receipt.LoadFromRawSql(query); return(receipt.DataTable); }
/// <summary> /// Gets the inventory list by accountand warehouse. /// </summary> /// <param name="AccountID">The account ID.</param> /// <param name="WarehouseID">The warehouse ID.</param> /// <param name="TypeID">The type ID.</param> /// <returns></returns> public static DataView GetInventoryListByAccountandWarehouse(int AccountID, int WarehouseID, int TypeID) { Receipt receiptInventory = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetInventoryListByAccountandWarehouse(AccountID, WarehouseID, TypeID, ReceiptConfirmationStatus.Constants.RECEIVE_QUANTITY_CONFIRMED, ReceiptConfirmationStatus.Constants.GRNF_PRINTED, ReceiptConfirmationStatus.Constants.PRICE_CALCULATED); receiptInventory.LoadFromRawSql(query); return(receiptInventory.DefaultView); }
public static DataTable GetItemPriceHistoryCostTierByDate(DateTime Startdate, DateTime Enddate, int userID) { var query = HCMIS.Repository.Queries.Receipt.SelectGetItemPriceHistoryByDate(Startdate, Enddate, userID); var receipt = new Receipt(); receipt.LoadFromRawSql(query); receipt.DataTable.TableName = "PriceListHistory"; return(receipt.DataTable); }
/// <summary> /// Gets the raw inventory countby accountand warehouse item. /// </summary> /// <param name="AccountID">The account ID.</param> /// <param name="WarehouseID">The warehouse ID.</param> /// <param name="ItemID">The item ID.</param> /// <param name="UnitID">The unit ID.</param> /// <returns></returns> public static DataView GetRawInventoryCountbyAccountandWarehouseItem(int AccountID, int WarehouseID, int ItemID, int UnitID) { Receipt receiptInventory = new Receipt(); //string query = String.Format("Select rd.ItemID,rd.UnitID,rd.ManufacturerID,iu.text Unit, vw.FullItemName , sum(rd.NoOfPack) NoOfPack,rd.PricePerPack PricePerPack,Sum(rd.NoOfPack * rd.PricePerPack)as TotalReceived, m.Name as Manufacturer,pst.Name Warehouse,cl.Name Cluster,sg.Name Account,s.StoreName SubSubAccount,sgDiv.Name SubAccount,t.Name commodityType, vw.StockCode from ReceivePallet rp join ReceiveDoc rd on rp.ReceiveID = rd.ID join receipt r on r.ID = rd.ReceiptID Join Stores s on s.ID = rd.StoreID join Manufacturers m on m.ID = rd.ManufacturerID join vwGetAllItems vw on vw.ID = rd.ItemID join PalletLocation pl on rp.PalletLocationID = pl.ID left join Supplier su on su.ID = rd.SupplierID join Receipt rt on rt.ID = rd.ReceiptID join itemUnit iu on rd.unitID = iu.ID Join Shelf sh on pl.ShelfID = sh.ID join PhysicalStore ps on Ps.ID = sh.StoreID Join PhysicalStoreType pst on pst.ID = ps.PhysicalStoreTypeID join Cluster cl on cl.ID = pst.ClusterID join StoreGroupDivision sgDiv on sgDiv.ID=s.StoreGroupDivisionID join StoreGroup sg on sg.ID = sgDiv.StoreGroupID join [type] t on t.ID = vw.TypeId where s.ID = {0} and ps.PhysicalStoreTypeID = {1} group by rd.ItemID,rd.UnitID,rd.ManufacturerId,sg.Name,sgDiv.Name, vw.FullItemName,m.Name,iu.Text,pst.Name,cl.Name,s.StoreName,t.Name, vw.StockCode,rd.PricePerPack", AccountID, WarehouseID); var query = HCMIS.Repository.Queries.Receipt.SelectGetRawInventoryCountbyAccountandWarehouseItem(AccountID, WarehouseID, ItemID, UnitID); receiptInventory.LoadFromRawSql(query); return(receiptInventory.DefaultView); }
public static DataView GetListOfGRVByUserIDForCosting(int userID) { Receipt receipt = new Receipt(); string query; query = HCMIS.Repository.Queries.Receipt.SelectGetListOfGRVByUserIDForCosting(userID, BLL.ReceiptConfirmationStatus.Constants.GRNF_PRINTED); receipt.LoadFromRawSql(query); return(receipt.DefaultView); }
public static DataView GetListOfReceipt(int receiptTypeID, int receiptStatusID, int userID) { Receipt receipt = new Receipt(); string query; query = HCMIS.Repository.Queries.Receipt.GetListOfReceipt(receiptTypeID, receiptStatusID, userID); receipt.LoadFromRawSql(query); return(receipt.DefaultView); }
public DataTable GetDiscrepancyForGRNF() { string query; Receipt Receipt = new Receipt(); query = HCMIS.Repository.Queries.Receipt.SelectGetDiscrepancyForGRNF(ID); Receipt.LoadFromRawSql(query); return(Receipt.DataTable); }
public static DataTable GetlistOfPrints(int ID) { string query; Receipt Receipt = new Receipt(); query = HCMIS.Repository.Queries.Receipt.SelectGetlistOfPrints(ID); Receipt.LoadFromRawSql(query); return(Receipt.DataTable); }
public static DataView GetInventoryCountbyInventoryPeriodID(int inventoryPeriodId, int physicalStoreId, int activityId) { Receipt receiptInventory = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetInventoryCountbyInventoryPeriodID(inventoryPeriodId, physicalStoreId, activityId); receiptInventory.LoadFromRawSql(query); return(receiptInventory.DefaultView); }
public static DataTable GetPriceConfirmationListFromCostTier(int MovingAverageGroupID) { string query; Receipt Receipt = new Receipt(); query = HCMIS.Repository.Queries.Receipt.SelectGetPriceConfirmationListFromCostTier(MovingAverageGroupID, ChangeMode.PriceOverride.Id); Receipt.LoadFromRawSql(query); return(Receipt.DataTable); }
/// <summary> /// Confirmbies the store. /// </summary> /// <param name="StoreID">The store ID.</param> /// <param name="WarehouseID">The warehouse ID.</param> public static void ConfirmbyStore(int StoreID, int WarehouseID) { Receipt receiptInventory = new Receipt(); string query = ""; query = HCMIS.Repository.Queries.Receipt.SelectConfirmbyStore(StoreID, WarehouseID); receiptInventory.LoadFromRawSql(query); }
public static void Confirm(int StoreID, int WarehouseID) { Receipt receiptInventory = new Receipt(); string query = ""; query = HCMIS.Repository.Queries.Receipt.SelectConfirm(StoreID, WarehouseID, ReceiptConfirmationStatus.Constants.RECEIVE_ENTERED, Settings.HandleGRV, ReceiptConfirmationStatus.Constants.RECEIVE_QUANTITY_CONFIRMED, ReceiptConfirmationStatus.Constants.GRV_PRINTED); receiptInventory.LoadFromRawSql(query); }
public string FacilityName(int receiptID) { string query; Receipt Receipt = new Receipt(); query = HCMIS.Repository.Queries.Receipt.SelectFacilityName(receiptID); Receipt.LoadFromRawSql(query); if (Receipt.RowCount == 0) { return(""); } return(Receipt.DataRow["FacilityName"].ToString()); }
public string GetNewInvoiceNoForConvertedDeliveryNote() { var receiptInvoice = new ReceiptInvoice(ReceiptInvoiceID); if (!receiptInvoice.IsConvertedFromDeliveryNote) { return(null); } var receipt = new Receipt(); string query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetReprintedInvoice(ReceiptInvoiceID); receipt.LoadFromRawSql(query); return(receipt.STVOrInvoiceNo); }
/// <summary> /// Gets the warehouse. /// </summary> /// <returns></returns> public String GetWarehouse() { Receipt receipt = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetWarehouse(ID); receipt.LoadFromRawSql(query); try { return(receipt.GetColumn("WarehouseName").ToString()); } catch { return(""); } }
/// <summary> /// Gets the margin by account. /// </summary> /// <param name="AccountID">The account ID.</param> /// <param name="TypeID">The type ID.</param> /// <returns></returns> public static DataView GetMarginByAccount(int AccountID, int TypeID) { if (TypeID != 0) { Receipt receiptInventory = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetMarginByAccount(AccountID, TypeID); receiptInventory.LoadFromRawSql(query); return(receiptInventory.DefaultView); } else { Receipt receiptInventory = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetMarginByAccount(AccountID); receiptInventory.LoadFromRawSql(query); return(receiptInventory.DefaultView); } }
public static DataTable GetPriceListFromCostTier(int MovingAverageGroupID, bool ShowAll = false) { string query; Receipt Receipt = new Receipt(); if (!ShowAll) { query = HCMIS.Repository.Queries.Receipt.SelectGetPriceListFromCostTier(MovingAverageGroupID); } else { query = HCMIS.Repository.Queries.Receipt.SelectGetPriceListFromCostTierShowAll(MovingAverageGroupID); } Receipt.LoadFromRawSql(query); Receipt.DataTable.TableName = "PriceList"; return(Receipt.DataTable); }
public DataTable GetGRVDetailsforCosting() { var receipt = new Receipt(); string query = string.Empty; if (ReceiptTypeID == ReceiptType.CONSTANTS.DELIVERY_NOTE) { bool isElectronicDeliveryNote = new Receipt(ID)._receiptInvoice.PO.IsElectronic; query = isElectronicDeliveryNote ? HCMIS.Repository.Queries.Receipt.SelectGetGRVDetailsforCostingDeliveryNoteElectronic(ID) : HCMIS.Repository.Queries.Receipt.SelectGetGRVDetailsforCostingDeliveryNoteManual(ID); } else { query = HCMIS.Repository.Queries.Receipt.SelectGetGRVDetailsforCosting(ID); } receipt.LoadFromRawSql(query); return(receipt.DataTable); }
/// <summary> /// Gets the margin by account. /// </summary> /// <param name="AccountID">The account ID.</param> /// <param name="TypeID">The type ID.</param> /// <returns></returns> public static DataView GetMarginByAccount(int AccountID, int TypeID) { if (TypeID != 0) { Receipt receiptInventory = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetMarginByAccount(AccountID, TypeID); receiptInventory.LoadFromRawSql(query); return receiptInventory.DefaultView; } else { Receipt receiptInventory = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetMarginByAccount(AccountID); receiptInventory.LoadFromRawSql(query); return receiptInventory.DefaultView; } }
public static DataTable GetPreviousStockforMovingCosting(int ReceiptID) { Receipt receipt = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetPreviousStockforMovingCosting(ReceiptID); receipt.LoadFromRawSql(query); if(BLL.Settings.UseCostTier) { query = HCMIS.Repository.Queries.Receipt.SelectGetPreviousStockforMovingCostingUseCostTier(ReceiptID); receipt.LoadFromRawSql(query); return CostingService.SetPrice(receipt.DataTable); } return receipt.DataTable; }
public static DataTable GetDiscrepancyGRVDetailsforCosting(int ReceiptID) { Receipt receipt = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetDiscrepancyGRVDetailsforCosting(ReceiptID, StorageType.Quaranteen, ShortageReasons.Constants.SHORT_LANDED, ShortageReasons.Constants.DAMAGED); receipt.LoadFromRawSql(query); return receipt.DataTable; }
public static DataView GetInventoryListByAccount(int movingAverageID, int statusID) { Receipt receiptInventory = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetInventoryListByAccount(movingAverageID, statusID); receiptInventory.LoadFromRawSql(query); return receiptInventory.DefaultView; }
public static DataTable GetItemPriceHistoryCostTierByDate(DateTime Startdate,DateTime Enddate, int userID) { var query = HCMIS.Repository.Queries.Receipt.SelectGetItemPriceHistoryByDate(Startdate, Enddate, userID); var receipt = new Receipt(); receipt.LoadFromRawSql(query); receipt.DataTable.TableName = "PriceListHistory"; return receipt.DataTable; }
public static DataView GetListOfGRVByUserIDForCosting(int userID) { Receipt receipt = new Receipt(); string query; query = HCMIS.Repository.Queries.Receipt.SelectGetListOfGRVByUserIDForCosting(userID, BLL.ReceiptConfirmationStatus.Constants.GRNF_PRINTED); receipt.LoadFromRawSql(query); return receipt.DefaultView; }
public string FacilityName(int receiptID) { string query; Receipt Receipt = new Receipt(); query = HCMIS.Repository.Queries.Receipt.SelectFacilityName(receiptID); Receipt.LoadFromRawSql(query); if(Receipt.RowCount==0) return ""; return Receipt.DataRow["FacilityName"].ToString(); }
public DataTable GetDiscrepancyForGRNF() { string query; Receipt Receipt = new Receipt(); query = HCMIS.Repository.Queries.Receipt.SelectGetDiscrepancyForGRNF(ID); Receipt.LoadFromRawSql(query); return Receipt.DataTable; }
public DataTable GetGRVDetailsforCostAnalysis(int ID) { Receipt receipt = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetGRVDetailsforCostAnalysis(ID, BLL.Settings.NoOfDigitsAfterTheDecimalPoint); receipt.LoadFromRawSql(query); return receipt.DataTable; }
public DataTable GetGRVDetailsforCosting() { var receipt = new Receipt(); string query = string.Empty; if (ReceiptTypeID == ReceiptType.CONSTANTS.DELIVERY_NOTE) { bool isElectronicDeliveryNote = new Receipt(ID)._receiptInvoice.PO.IsElectronic; query = isElectronicDeliveryNote ? HCMIS.Repository.Queries.Receipt.SelectGetGRVDetailsforCostingDeliveryNoteElectronic(ID) : HCMIS.Repository.Queries.Receipt.SelectGetGRVDetailsforCostingDeliveryNoteManual(ID); } else { query = HCMIS.Repository.Queries.Receipt.SelectGetGRVDetailsforCosting(ID); } receipt.LoadFromRawSql(query); return receipt.DataTable; }
public string GetNewInvoiceNoForConvertedDeliveryNote() { var receiptInvoice = new ReceiptInvoice(ReceiptInvoiceID); if (!receiptInvoice.IsConvertedFromDeliveryNote) { return null; } var receipt = new Receipt(); string query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetReprintedInvoice(ReceiptInvoiceID); receipt.LoadFromRawSql(query); return receipt.STVOrInvoiceNo; }
/// <summary> /// Gets the warehouse. /// </summary> /// <returns></returns> public String GetWarehouse() { Receipt receipt = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetWarehouse(ID); receipt.LoadFromRawSql(query); try { return receipt.GetColumn("WarehouseName").ToString(); } catch { return ""; } }
public static DataView GetListOfReceipt(int receiptTypeID,int receiptStatusID,int userID) { Receipt receipt = new Receipt(); string query; query = HCMIS.Repository.Queries.Receipt.GetListOfReceipt(receiptTypeID, receiptStatusID, userID); receipt.LoadFromRawSql(query); return receipt.DefaultView; }
public static DataTable GetlistOfPrints(int ID) { string query; Receipt Receipt = new Receipt(); query = HCMIS.Repository.Queries.Receipt.SelectGetlistOfPrints(ID); Receipt.LoadFromRawSql(query); return Receipt.DataTable; }
public static DataTable GetReceiptStatusList() { string query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList(); Receipt receipt = new Receipt(); receipt.LoadFromRawSql(query); System.Data.DataTable tbl = receipt.DataTable; query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList2(); receipt.FlushData(); receipt.LoadFromRawSql(query); tbl.Merge(receipt.DataTable); return tbl; }
public static DataRow GetReceiptStatusDetail(int receiptID, int receiptStatusID) { var receipt = new Receipt(); string query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusDetails(receiptID, receiptStatusID); receipt.LoadFromRawSql(query); return receipt.DataTable != null && receipt.DataTable.Rows.Count > 0 ? receipt.DataTable.Rows[0] : null; }
/// <summary> /// Gets the raw inventory countby accountand warehouse item. /// </summary> /// <param name="AccountID">The account ID.</param> /// <param name="WarehouseID">The warehouse ID.</param> /// <param name="ItemID">The item ID.</param> /// <param name="UnitID">The unit ID.</param> /// <returns></returns> public static DataView GetRawInventoryCountbyAccountandWarehouseItem(int AccountID, int WarehouseID, int ItemID, int UnitID) { Receipt receiptInventory = new Receipt(); //string query = String.Format("Select rd.ItemID,rd.UnitID,rd.ManufacturerID,iu.text Unit, vw.FullItemName , sum(rd.NoOfPack) NoOfPack,rd.PricePerPack PricePerPack,Sum(rd.NoOfPack * rd.PricePerPack)as TotalReceived, m.Name as Manufacturer,pst.Name Warehouse,cl.Name Cluster,sg.Name Account,s.StoreName SubSubAccount,sgDiv.Name SubAccount,t.Name commodityType, vw.StockCode from ReceivePallet rp join ReceiveDoc rd on rp.ReceiveID = rd.ID join receipt r on r.ID = rd.ReceiptID Join Stores s on s.ID = rd.StoreID join Manufacturers m on m.ID = rd.ManufacturerID join vwGetAllItems vw on vw.ID = rd.ItemID join PalletLocation pl on rp.PalletLocationID = pl.ID left join Supplier su on su.ID = rd.SupplierID join Receipt rt on rt.ID = rd.ReceiptID join itemUnit iu on rd.unitID = iu.ID Join Shelf sh on pl.ShelfID = sh.ID join PhysicalStore ps on Ps.ID = sh.StoreID Join PhysicalStoreType pst on pst.ID = ps.PhysicalStoreTypeID join Cluster cl on cl.ID = pst.ClusterID join StoreGroupDivision sgDiv on sgDiv.ID=s.StoreGroupDivisionID join StoreGroup sg on sg.ID = sgDiv.StoreGroupID join [type] t on t.ID = vw.TypeId where s.ID = {0} and ps.PhysicalStoreTypeID = {1} group by rd.ItemID,rd.UnitID,rd.ManufacturerId,sg.Name,sgDiv.Name, vw.FullItemName,m.Name,iu.Text,pst.Name,cl.Name,s.StoreName,t.Name, vw.StockCode,rd.PricePerPack", AccountID, WarehouseID); var query = HCMIS.Repository.Queries.Receipt.SelectGetRawInventoryCountbyAccountandWarehouseItem(AccountID, WarehouseID, ItemID, UnitID); receiptInventory.LoadFromRawSql(query); return receiptInventory.DefaultView; }
/// <summary> /// Gets the inventory list by accountand warehouse. /// </summary> /// <param name="AccountID">The account ID.</param> /// <param name="WarehouseID">The warehouse ID.</param> /// <param name="TypeID">The type ID.</param> /// <returns></returns> public static DataView GetInventoryListByAccountandWarehouse(int AccountID, int WarehouseID, int TypeID) { Receipt receiptInventory = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetInventoryListByAccountandWarehouse(AccountID, WarehouseID, TypeID, ReceiptConfirmationStatus.Constants.RECEIVE_QUANTITY_CONFIRMED, ReceiptConfirmationStatus.Constants.GRNF_PRINTED, ReceiptConfirmationStatus.Constants.PRICE_CALCULATED); receiptInventory.LoadFromRawSql(query); return receiptInventory.DefaultView; }
public static DataTable GetPriceListFromCostTier(int MovingAverageGroupID,bool ShowAll = false) { string query; Receipt Receipt = new Receipt(); if (!ShowAll) { query = HCMIS.Repository.Queries.Receipt.SelectGetPriceListFromCostTier(MovingAverageGroupID); } else { query = HCMIS.Repository.Queries.Receipt.SelectGetPriceListFromCostTierShowAll(MovingAverageGroupID); } Receipt.LoadFromRawSql(query); Receipt.DataTable.TableName = "PriceList"; return Receipt.DataTable; }
public static DataView GetInventoryCountbyInventoryPeriodID(int inventoryPeriodId,int physicalStoreId, int activityId) { Receipt receiptInventory = new Receipt(); var query = HCMIS.Repository.Queries.Receipt.SelectGetInventoryCountbyInventoryPeriodID(inventoryPeriodId, physicalStoreId, activityId); receiptInventory.LoadFromRawSql(query); return receiptInventory.DefaultView; }
public static DataTable GetPriceConfirmationListFromCostTier(int MovingAverageGroupID) { string query; Receipt Receipt = new Receipt(); query = HCMIS.Repository.Queries.Receipt.SelectGetPriceConfirmationListFromCostTier(MovingAverageGroupID, ChangeMode.PriceOverride.Id); Receipt.LoadFromRawSql(query); return Receipt.DataTable; }