public void SaveBySp(List <Model.Helper.SPHelper.Category.SpHelper_Category_Insert> listCategoryInsert) { using (var context = new DTO.EF.OnlineShoppingEntities()) { try { Parameters = Model.Helper.SPHelper.Category.SpHelper_Category.SetInsertParameters(listCategoryInsert); context.Database.ExecuteSqlCommand(Model.Helper.SPHelper.Category.SpHelper_Category.USP_Category_Insert, Parameters); SpMessage = Parameters[1].Value.ToString(); Model.Helper.ModelHelper.DatabaseSpMessage(SpMessage); } catch (Exception ex) { //throw; Model.Helper.ModelHelper.DatabaseExceptionHandeler(ex.Message); SpMessage = Parameters[1].Value.ToString(); Model.Helper.ModelHelper.DatabaseSpMessage(SpMessage);; } finally { if (context != null) { context.Dispose(); } } } }
public List <Helper.SPHelper.Category.SpHelper_Category_Select> SelectBySp(List <Model.Helper.SPHelper.Category.SpHelper_Category_Select> listCategorySelect) { using (var context = new DTO.EF.OnlineShoppingEntities()) { List <Helper.SPHelper.Category.SpHelper_Category_Select> list_Category = new List <Helper.SPHelper.Category.SpHelper_Category_Select>(); try { Parameters = Model.Helper.SPHelper.Category.SpHelper_Category.SetSelectParameters(listCategorySelect); list_Category = context.Database.SqlQuery <Helper.SPHelper.Category.SpHelper_Category_Select> (Model.Helper.SPHelper.Category.SpHelper_Category.USP_Category_Select, Parameters).ToList(); SpMessage = Parameters[1].Value.ToString(); Model.Helper.ModelHelper.DatabaseSpMessage(SpMessage); } catch (Exception ex) { //throw; Model.Helper.ModelHelper.DatabaseExceptionHandeler(ex.Message); SpMessage = Parameters[1].Value.ToString(); Model.Helper.ModelHelper.DatabaseSpMessage(SpMessage);; } finally { if (context != null) { context.Dispose(); } } return(list_Category); } }
public List <Helper.SPHelper.Category.SpHelper_Category_Select> SelectBySp() { using (var context = new DTO.EF.OnlineShoppingEntities()) { List <Helper.SPHelper.Category.SpHelper_Category_Select> list_Category = new List <Helper.SPHelper.Category.SpHelper_Category_Select>(); try { list_Category = context.Database.SqlQuery <Helper.SPHelper.Category.SpHelper_Category_Select> (Model.Helper.SPHelper.Category.SpHelper_Category.Usp_Category_List).ToList(); } catch (Exception ex) { //throw; Model.Helper.ModelHelper.DatabaseExceptionHandeler(ex.Message); } finally { if (context != null) { context.Dispose(); } } return(list_Category); } }
public List <Helper.SPHelper.Product.SpHelper_Product_Select> SelectBySp(List <Model.Helper.SPHelper.Product.SpHelper_Product_Select> listProductSelect) { using (var context = new DTO.EF.OnlineShoppingEntities()) { List <Helper.SPHelper.Product.SpHelper_Product_Select> list_Product = new List <Helper.SPHelper.Product.SpHelper_Product_Select>(); try { list_Product = context.Database.SqlQuery <Helper.SPHelper.Product.SpHelper_Product_Select> (Model.Helper.SPHelper.Product.SpHelper_Product.USP_Product_Select, Model.Helper.SPHelper.Product.SpHelper_Product.SetSelectParameters(listProductSelect)).ToList(); } catch (Exception ex) { //throw; Model.Helper.ModelHelper.DatabaseExceptionHandeler(ex.Message); } finally { if (context != null) { context.Dispose(); } } return(list_Product); } }
public void SaveBySp(List <Model.Helper.SPHelper.Product.SpHelper_Product_Insert> listProductInsert) { using (var context = new DTO.EF.OnlineShoppingEntities()) { try { context.Database.ExecuteSqlCommand( Model.Helper.SPHelper.Product.SpHelper_Product.USP_Product_Insert, Model.Helper.SPHelper.Product.SpHelper_Product.SetInsertParameters(listProductInsert)); } catch (Exception ex) { //throw; Model.Helper.ModelHelper.DatabaseExceptionHandeler(ex.Message); } finally { if (context != null) { context.Dispose(); } } } }