internal IEnumerable <RDepartmentType> GetDepartmentType(string OCODE) { using (var _context = new ERPSSL_INVEntities()) { var ParamempID = new SqlParameter("@OCODE", OCODE); string SP_SQL = "Inv_GetDepartmentType @OCODE"; return((_context.ExecuteStoreQuery <RDepartmentType>(SP_SQL, ParamempID)).ToList()); } }
public IEnumerable <StoreInCharge> GetStoreIncharge( ) { using (var _context = new ERPSSL_INVEntities()) { return((from emp in _context.HRM_PersonalInformations select new StoreInCharge { Eid = emp.EID, Store_fullname = emp.FirstName + "-" + emp.LastName }).ToList()); } }
internal List <productsDetails> Rpt_GetAllProducts() { try { using (var _context = new ERPSSL_INVEntities()) { string SP_SQL = "INV_ProductReports_RPT "; return((_context.ExecuteStoreQuery <productsDetails>(SP_SQL)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
public List <SuplierDetails> Rpt_GetAllSupplier() { try { using (var _context = new ERPSSL_INVEntities()) { string SP_SQL = "INV_SuplierReports_RPT "; return((_context.ExecuteStoreQuery <SuplierDetails>(SP_SQL)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
public List <productsDetails> Rpt_GetStockBy_ReOrderQty() { try { using (var _context = new ERPSSL_INVEntities()) { string SP_SQL = "INV_FullStockReportsBy_ReOrderQty_RPT"; return((_context.ExecuteStoreQuery <productsDetails>(SP_SQL)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
internal List <GINStoreReqR> GetAll_DistinctApprovedStoreReq() { try { using (var _context = new ERPSSL_INVEntities()) { string SP_SQL = "PRQ_GetAll_DistinctApprovedStoreReq"; return((_context.ExecuteStoreQuery <GINStoreReqR>(SP_SQL)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
public static List <string> SearchSupplier(string prefixText, int count) { using (var _context = new ERPSSL_INVEntities()) { var InsList = from la in _context.Inv_Supplier where la.SupplierName.Contains(prefixText) select la; List <String> clsList = new List <String>(); foreach (var clsName in InsList) { clsList.Add(clsName.SupplierName); } return(clsList); } }
public static List <string> SearchChallanNo(string prefixText, int count) { using (var _context = new ERPSSL_INVEntities()) { var BuyCen = from By in _context.Inv_BuyCentral where (By.RefNo_ChallanNo.Contains(prefixText)) select By; List <String> refList = new List <String>(); foreach (var RefNos in BuyCen) { refList.Add(RefNos.RefNo_ChallanNo); } return(refList); } }
public Inv_Buy GetBuyBarcodeAndComanyCode(string Barcode, string CompanyCode) { using (ERPSSL_INVEntities ctx = new ERPSSL_INVEntities()) { try { Inv_Buy buy = ctx.Inv_Buy.Where(bc => bc.BarCode == Barcode && bc.CompanyCode == CompanyCode).FirstOrDefault <Inv_Buy>(); return(buy); } catch (Exception ex) { throw ex; } } }
internal List <ProductLog> Rpt_GetAllProduct(string OCODE) { try { using (var _context = new ERPSSL_INVEntities()) { var ocode = new SqlParameter("@OCODE", OCODE); string SP_SQL = "INV_Product_Update_Log @OCODE"; return((_context.ExecuteStoreQuery <ProductLog>(SP_SQL, ocode)).ToList()); } } catch (Exception) { throw; } }
public List <productsDetails> Rpt_GetStockBy_Store(string StoreCode) { try { using (var _context = new ERPSSL_INVEntities()) { var store = new SqlParameter("@StoreCode", StoreCode); string SP_SQL = "INV_FullStockReportsBy_Store_RPT @StoreCode"; return((_context.ExecuteStoreQuery <productsDetails>(SP_SQL, store)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
internal List <PRQ_PurchaseOrders> GetAllPurchaseOrderByPONo(string PONo) { try { using (var _context = new ERPSSL_INVEntities()) { var PONO = new SqlParameter("@PONo", PONo); string SP_SQL = "PRQ_GetWorkOrdersToRcvProduct_ByPONo @PONo"; return((_context.ExecuteStoreQuery <PRQ_PurchaseOrders>(SP_SQL, PONO)).ToList()); } } catch (Exception) { throw; } }
internal List <PRQ_PurchaseOrders> GetAllPurchaseOrder(string PurchaseType) { try { using (var _context = new ERPSSL_INVEntities()) { var type = new SqlParameter("@PurchaseType", PurchaseType); string SP_SQL = "PRQ_GetDistinctWorkOrdersToRcvProduct @PurchaseType"; return((_context.ExecuteStoreQuery <PRQ_PurchaseOrders>(SP_SQL, type)).ToList()); } } catch (Exception) { throw; } }
internal List <Inv_BuyCentral> GetAllPiNoLC() { try { using (var _context = new ERPSSL_INVEntities()) { var PiNo = (from LC in _context.Inv_BuyCentral select LC).OrderBy(x => x.Id).DistinctBy(x => x.PI_No); return(PiNo.ToList()); } } catch (Exception ex) { throw ex; } }
internal List <Inv_BuyCentral> GetAllMAsterLC() { try { using (var _context = new ERPSSL_INVEntities()) { var MasterLC = (from LC in _context.Inv_BuyCentral select LC).OrderBy(x => x.Id).DistinctBy(x => x.MasterLCNo); return(MasterLC.ToList()); } } catch (Exception) { throw; } }
internal List <DeleveryProductR> PRQ_GetSelectedProductToDeliverByReqNo(string reqno, string Ocode) { try { using (var _context = new ERPSSL_INVEntities()) { var ocode = new SqlParameter("@OCODE", Ocode); var ParamsalRequsNo = new SqlParameter("@Req", reqno); string SP_SQL = "PRQ_GetSelectedProductToDeliverByReqNo @OCODE,@Req"; return((_context.ExecuteStoreQuery <DeleveryProductR>(SP_SQL, ocode, ParamsalRequsNo)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
internal List <productsDetails> GetAllProductByGroupId(int groupID, string OCODE) { try { using (var _context = new ERPSSL_INVEntities()) { var groupid = new SqlParameter("@GroupID", groupID); var oCode = new SqlParameter("@OCODE", OCODE); string SP_SQL = "INV_RPT_ProductListByGroupID @GroupID,@OCODE"; return((_context.ExecuteStoreQuery <productsDetails>(SP_SQL, groupid, oCode)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
internal List <productsDetails> GetAllGroupProductByEID(string EID, string OCODE) { try { using (var _context = new ERPSSL_INVEntities()) { var eid = new SqlParameter("@EID", EID); var ocode = new SqlParameter("@OCODE", OCODE); string SP_SQL = "Inv_GetAllUserwiseCategory_Product @EID,@OCODE"; return((_context.ExecuteStoreQuery <productsDetails>(SP_SQL, eid, ocode)).ToList()); } } catch (Exception) { throw; } }
internal int AddTempToStoreReq(string ReqNo) { try { using (var _context = new ERPSSL_INVEntities()) { var ParamempID2 = new SqlParameter("@ReqNo", ReqNo); string SP_SQL = "PRQ_AddStore_Requisition @ReqNo"; _context.ExecuteStoreCommand(SP_SQL, ParamempID2); return(1); } } catch (Exception) { throw; } }
public List <productsDetails> Rpt_GetFullStockDetailsByDate(string FromDate, string ToDate, string OCODE) { try { using (var _context = new ERPSSL_INVEntities()) { var DateForm = new SqlParameter("@FromDate", FromDate); var DateTo = new SqlParameter("@ToDate", ToDate); var OCode = new SqlParameter("@OCODE", OCODE); string SP_SQL = "Inv_Rpt_StockDetails_ByDate @FromDate,@ToDate,@OCODE "; return((_context.ExecuteStoreQuery <productsDetails>(SP_SQL, DateForm, DateTo, OCode)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
public List <productsDetails> Rpt_GetStockBy_Store_Product(string StoreCode, string productGroupId, string ProductId) { try { using (var _context = new ERPSSL_INVEntities()) { var store = new SqlParameter("@StoreCode", StoreCode); var group = new SqlParameter("@ProductGroupId", productGroupId); var product = new SqlParameter("@ProductId", ProductId); string SP_SQL = "INV_FullStockReportsBy_Store_Product_RPT @StoreCode,@ProductGroupId,@ProductId"; return((_context.ExecuteStoreQuery <productsDetails>(SP_SQL, store, group, product)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
internal IEnumerable <RReturn> GetReturnFromSupplier_ByDate(string OCODE, DateTime Fromdate, DateTime Todate) { try { using (var _context = new ERPSSL_INVEntities()) { var ParamempID1 = new SqlParameter("@OCODE", OCODE); var ParamempID2 = new SqlParameter("@FROMDATE", Fromdate); var ParamempID3 = new SqlParameter("@TODATE", Todate); string SP_SQL = "Inv_Rpt_ReturnFromSupplier_ByDate @OCODE,@FROMDATE,@TODATE"; return((_context.ExecuteStoreQuery <RReturn>(SP_SQL, ParamempID1, ParamempID2, ParamempID3)).ToList()); } } catch (Exception) { throw; } }
internal int AddPurchaseRequisition_ForNewItem(string productName, string description) { try { using (var _context = new ERPSSL_INVEntities()) { var ParamempID1 = new SqlParameter("@ProductName", productName); var ParamempID2 = new SqlParameter("@Description", description); string SP_SQL = "PRQ_AddPurchaseRequisition_ForNewItem @ProductName,@Description"; _context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2); return(1); } } catch (Exception) { throw; } }
public int UpdateInv_RChallan_Temp(string ChallanNo, string barcode, double receiveQty) { try { using (var _context = new ERPSSL_INVEntities()) { var Parma1 = new SqlParameter("@ChallanNo", ChallanNo); var Param2 = new SqlParameter("@BarCode", barcode); var Param3 = new SqlParameter("@ReceiveQuantity", receiveQty); //var Param5 = new SqlParameter("@ChalanTotal", total); string SP_SQL = "Inv_RChallan_Temp_Update @ChallanNo,@BarCode"; _context.ExecuteStoreCommand(SP_SQL, Parma1, Param2, Param3); return(1); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
internal List <Inv_Return_Temp> GetTempReturn(string p, Guid userId) { List <Inv_Return_Temp> list = new List <Inv_Return_Temp>(); using (ERPSSL_INVEntities ctx = new ERPSSL_INVEntities()) { try { // ctx.Configuration.ProxyCreationEnabled = false; list = (from c in ctx.Inv_Return_Temp //join r in ctx.Inv_ProductGroup on c.ProductGroup equals r.GroupId where c.OCode == p && c.EditUser == userId select c).ToList(); return(list); } catch (Exception ex) { throw ex; } } }
internal List <Inv_Damage_Temp> GetTempDanmage(string p, string challanNo) { List <Inv_Damage_Temp> list = new List <Inv_Damage_Temp>(); using (ERPSSL_INVEntities ctx = new ERPSSL_INVEntities()) { try { // ctx.Configuration.ProxyCreationEnabled = false; list = (from c in ctx.Inv_Damage_Temp //join r in ctx.Inv_ProductGroup on c.ProductGroup equals r.GroupId where c.OCode == p && c.ChallanNo == challanNo select c).ToList(); return(list); } catch (Exception ex) { throw ex; } } }
public List <productsDetails> Rpt_GetFullStockDetailsByDate_Product_WithStore(string FromDate, string ToDate, string OCODE, string GroupId, string ProductId, string storeCode) { try { using (var _context = new ERPSSL_INVEntities()) { var DateForm = new SqlParameter("@FromDate", FromDate); var DateTo = new SqlParameter("@ToDate", ToDate); var OCode = new SqlParameter("@OCODE", OCODE); var groupId = new SqlParameter("@GroupId", GroupId); var productId = new SqlParameter("@ProductId", ProductId); var Store = new SqlParameter("@StoreCode", storeCode); string SP_SQL = "Inv_Rpt_StockDetails_ByDate_Product_WithStore @FromDate,@ToDate,@OCODE,@GroupId,@ProductId,@StoreCode "; return((_context.ExecuteStoreQuery <productsDetails>(SP_SQL, DateForm, DateTo, OCode, groupId, productId, Store)).ToList()); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
public int Update_IChalanTemp(Guid UserId, string barcode, double delivaryQty) { try { using (var _context = new ERPSSL_INVEntities()) { var Parma1 = new SqlParameter("@UserId", UserId); var Param2 = new SqlParameter("@BarCode", barcode); var Param3 = new SqlParameter("@DeliveryQty", delivaryQty); string SP_SQL = "Inv_IChallan_Temp_Update @UserId,@BarCode,@DeliveryQty"; _context.ExecuteStoreCommand(SP_SQL, Parma1, Param2, Param3); return(1); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
public int UpdateInv_RChallanmrr_Temp(string ChallanNo, string barcode, double receiveQty, double ActualQty, double freeQty, DateTime PDate) { try { using (var _context = new ERPSSL_INVEntities()) { var Parma1 = new SqlParameter("@ChallanNo", ChallanNo); var Param2 = new SqlParameter("@BarCode", barcode); var Param3 = new SqlParameter("@ReceiveQuantity", receiveQty); var PurDate = new SqlParameter("@PurchaseDate", PDate); var Param4 = new SqlParameter("@ActualQty", ActualQty); var Param5 = new SqlParameter("@FreeQty", freeQty); string SP_SQL = "Inv_RChallan_Tempmrr_Update @ChallanNo,@BarCode,@ReceiveQuantity,@ActualQty,@FreeQty,@PurchaseDate"; _context.ExecuteStoreCommand(SP_SQL, Parma1, Param2, Param3, Param4, Param5, PurDate); return(1); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }