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