public IEnumerable <Overtech.DataModels.Store.ScaleBrand> ListStoreScaleBrands(long storeId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStore = dal.CreateParameter("StoreId", storeId);
return(dal.List <Overtech.DataModels.Store.ScaleBrand>("STR_LST_STORESCALES_SP", prmStore).ToList());
}
}
public DataTable DrillCountPerformanceDetail(int StoreId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStoreId = dal.CreateParameter("StoreId", StoreId);
return(dal.ExecuteDataset("WHS_RPT_DRILLCOUNTPERFDETAIL_SP", prmStoreId).Tables[0]);
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Announcement.NotificationStatus Find(string notificationStatusName)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmNotificationStatusName = dal.CreateParameter("NotificationStatusName", notificationStatusName);
return(dal.Read <Overtech.DataModels.Announcement.NotificationStatus>("ANN_SEL_FINDNOTIFICATIONSTATUS_SP", prmNotificationStatusName));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Warehouse.Supplier Find(string supplierName)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmSupplierName = dal.CreateParameter("SupplierName", supplierName);
return(dal.Read <Overtech.DataModels.Warehouse.Supplier>("WHS_SEL_FINDSUPPLIER_SP", prmSupplierName));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.StoreUpload.Status Find(string name)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmName = dal.CreateParameter("Name", name);
return(dal.Read <Overtech.DataModels.StoreUpload.Status>("SUP_SEL_FINDSTATUS_SP", prmName));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Product.BarcodeTypeInt Find(string barcodeType)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmBarcodeType = dal.CreateParameter("BarcodeType", barcodeType);
return(dal.Read <Overtech.DataModels.Product.BarcodeTypeInt>("PRD_SEL_FINDBARCODETYPEINT_SP", prmBarcodeType));
}
}
public DataTable StoreCategorySale(long storeId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStoreId = dal.CreateParameter("StoreId", storeId);
return(dal.ExecuteDataset("SLS_LST_STORECATEGORYSALE_SP", prmStoreId).Tables[0]);
}
}
/*Section="Method-ListProductProperties"*/
public IEnumerable <ProductProperty> ListProductProperties(long productId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmProduct = dal.CreateParameter("Product", productId);
return(dal.List <ProductProperty>("PRD_LST_PROPERTY_SP", prmProduct).ToList());
}
}
/*Section="Method-ListProductBarcodes"*/
public IEnumerable <ProductBarcode> ListProductBarcodes(long productId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmProduct = dal.CreateParameter("Product", productId);
return(dal.List <ProductBarcode>("PRD_LST_BARCODE_SP", prmProduct).ToList());
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Sale.PosTrxType Find(string trxType)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmTrxType = dal.CreateParameter("TrxType", trxType);
return(dal.Read <Overtech.DataModels.Sale.PosTrxType>("SLS_SEL_FINDPOSTRXTYPE_SP", prmTrxType));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Product.Product Find(string name)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmName = dal.CreateParameter("Name", name);
return(dal.Read <Overtech.DataModels.Product.Product>("PRD_SEL_FINDPRODUCT_SP", prmName));
}
}
/*Section="Method-ListStoreCashRegisters"*/
public IEnumerable <StoreCashRegister> ListStoreCashRegisters(long storeId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStore = dal.CreateParameter("Store", storeId);
return(dal.List <StoreCashRegister>("STR_LST_CASHREGISTER_SP", prmStore).ToList());
}
}
/*Section="Method-ListStoreScaless"*/
public IEnumerable <StoreScales> ListStoreScaless(long storeId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStore = dal.CreateParameter("Store", storeId);
return(dal.List <StoreScales>("STR_LST_SCALE_SP", prmStore).ToList());
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Store.Store Find(string name)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmName = dal.CreateParameter("Name", name);
return(dal.Read <Overtech.DataModels.Store.Store>("STR_SEL_FINDSTORE_SP", prmName));
}
}
/*Section="CustomCodeRegion"*/
#region Customized
// Keep your custom code in this region.
public IEnumerable <Overtech.DataModels.Warehouse.ProductShipmentUnit> ListProductShipmentUnit(long productId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmProduct = dal.CreateParameter("Product", productId);
return(dal.List <Overtech.DataModels.Warehouse.ProductShipmentUnit>("WHS_LST_PRODUCTSHIPMENTUNIT_SP", prmProduct).ToList());
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Product.SeasonType Find(string seasonTypeName)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmSeasonTypeName = dal.CreateParameter("SeasonTypeName", seasonTypeName);
return(dal.Read <Overtech.DataModels.Product.SeasonType>("PRD_SEL_FINDSEASONTYPE_SP", prmSeasonTypeName));
}
}
public IEnumerable <ProductionContent> ListProductionContentswithStocks(long productionId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmProduction = dal.CreateParameter("ProductionId", productionId);
return(dal.List <ProductionContent>("WHS_LST_PRODUCTIONCONTENTSTOCK_SP", prmProduction).ToList());
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Warehouse.GatheringType Find(string gatheringTypeName)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmGatheringTypeName = dal.CreateParameter("GatheringTypeName", gatheringTypeName);
return(dal.Read <Overtech.DataModels.Warehouse.GatheringType>("WHS_SEL_FINDGATHERINGTYPE_SP", prmGatheringTypeName));
}
}
/// <summary>
/// Store Dashboardda stock değerlerini göstermek için...
/// </summary>
/// <param name="storeId"></param>
/// <returns></returns>
public DataTable StoreDashboardStockInfo(long storeId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStoreId = dal.CreateParameter("StoreId", storeId);
return(dal.ExecuteDataset("INV_LST_STORESTOCK_SP", prmStoreId).Tables[0]);
}
}
/*Section="CustomCodeRegion"*/
#region Customized
// Keep your custom code in this region.
public IEnumerable <StoreProperty> ListStoreProperties(long storeId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStore = dal.CreateParameter("Store", storeId);
return(dal.List <StoreProperty>("STR_LST_PROPERTY_SP", prmStore).ToList());
}
}
public IEnumerable <SaleCustomer> ListSaleCustomers(long saleId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmSaleId = dal.CreateParameter("Sale", saleId);
return(dal.List <SaleCustomer>("SLS_LST_SALECUSTOMER_SP", prmSaleId).ToList());
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Store.CashRegisterModel Find(string name)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmName = dal.CreateParameter("Name", name);
return(dal.Read <Overtech.DataModels.Store.CashRegisterModel>("STR_SEL_FINDCASHREGISTERMODEL_SP", prmName));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Announcement.NotificationGroup Find(string groupName)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmGroupName = dal.CreateParameter("GroupName", groupName);
return(dal.Read <Overtech.DataModels.Announcement.NotificationGroup>("ANN_SEL_FINDNOTIFICATIONGROUP_SP", prmGroupName));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Accounting.FirmType Find(string name)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmName = dal.CreateParameter("Name", name);
return(dal.Read <Overtech.DataModels.Accounting.FirmType>("ACC_SEL_FINDFIRMTYPE_SP", prmName));
}
}
public IEnumerable <StockTakingSchedule> ActiveStoreSchedules(long storeId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStoreId = dal.CreateParameter("StoreId", storeId);
return(dal.List <StockTakingSchedule>("WHS_LST_STORESCHEDULES_SP", prmStoreId).ToList());
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Warehouse.ShipmentPackageType Find(string packageTypeName)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmPackageTypeName = dal.CreateParameter("PackageTypeName", packageTypeName);
return(dal.Read <Overtech.DataModels.Warehouse.ShipmentPackageType>("WHS_SEL_FINDPACKAGETYPE_SP", prmPackageTypeName));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Warehouse.ReturnReason Find(string reasonName)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmReasonName = dal.CreateParameter("ReasonName", reasonName);
return(dal.Read <Overtech.DataModels.Warehouse.ReturnReason>("WHS_SEL_FINDRETURNREASON_SP", prmReasonName));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Warehouse.ProductShipmentUnit Find(string product)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmProduct = dal.CreateParameter("Product", product);
return(dal.Read <Overtech.DataModels.Warehouse.ProductShipmentUnit>("WHS_SEL_FINDPRODUCTSHIPMENTUNIT_SP", prmProduct));
}
}
/*Section="Method-Find"*/
public Overtech.DataModels.Product.SuperGroup1 Find(string superGroup1Name)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmSuperGroup1Name = dal.CreateParameter("SuperGroup1Name", superGroup1Name);
return(dal.Read <Overtech.DataModels.Product.SuperGroup1>("PRD_SEL_FINDSUPERGROUP1_SP", prmSuperGroup1Name));
}
}
public IEnumerable <Overtech.DataModels.Store.CashRegisterBrand> ListStoreCashRegisterBrands(long storeId)
{
using (IDAL dal = this.DAL)
{
IUniParameter prmStore = dal.CreateParameter("StoreId", storeId);
return(dal.List <Overtech.DataModels.Store.CashRegisterBrand>("STR_LST_STORECASHREGISTERS_SP", prmStore).ToList());
}
}
