/// <summary> /// Gets Categories from DB /// </summary> /// <returns></returns> public List <category> getCaregories() { using (InventoryDBEntities2 db = new InventoryDBEntities2()) { return(db.categories.ToList()); } }
protected void Application_Start() { InventoryDBEntities2 context = new InventoryDBEntities2(); StockDetailsManager SDM = new StockDetailsManager(context); AreaRegistration.RegisterAllAreas(); RouteConfig.RegisterRoutes(RouteTable.Routes); }
public StockDetailsManager(InventoryDBEntities2 context) { _Context = context; CustomSchedular.IntervalInDays(00, 00, 1, () => { updateStockDetails(); }); }
/// <summary> /// Update StockDetails in DB /// </summary> public void updateStockDetails() { var UTD = new UserDefinedType(); using (var DB = new InventoryDBEntities2()) { DataTable _DataTable = UTD.GenerateDataTable(); SqlParameter Parameter = new SqlParameter("@StockInput", _DataTable); Parameter.TypeName = "dbo.tblStockDetails"; DB.Database.ExecuteSqlCommand("exec usp_UpdateStockDetails @StockInput", Parameter); } //DbContext contextDB = new DbContext("ConnectionString"); //var procedure = new USPUpdateStockDetails() //{ // userDefinedType = utdList //}; //contextDB.Database.ExecuteStoredProcedure(procedure); }