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