public int createOrder(Models.CreateOrderReq obj)
{
try
{
EFModels.NTECommerceDBContext context = new EFModels.NTECommerceDBContext();
var result = context.Orders
.FromSqlRaw($"EXEC CreateOrder {obj.CustomerId}, {obj.ItemId}, {obj.AddressId}, {obj.Quantity}")
.ToList();
return(result.FirstOrDefault().Id);
}
catch (Exception ex)
{
throw ex;
}
}
public int createUpdateCustomer(Models.CreateUpdateCustomerReq obj)
{
try
{
EFModels.NTECommerceDBContext context = new EFModels.NTECommerceDBContext();
var result = context.Customers
.FromSqlRaw($"EXEC CreateUpdateCustomer {obj.Id}, '{obj.FirstName}', '{obj.LastName}', '{obj.EmailAddress}', '{obj.Password}', '{obj.PhoneNumber}'")
.ToList();
return(result.FirstOrDefault().Id);
}
catch (Exception ex)
{
throw ex;
}
}
public List <EFModels.Order> getOrders(int pageIndex, int pageSize)
{
List <EFModels.Order> data = new List <EFModels.Order>();
try
{
EFModels.NTECommerceDBContext context = new EFModels.NTECommerceDBContext();
var result = context.Orders
.FromSqlRaw("EXEC GetOrders " + pageIndex + ", " + pageSize)
.ToList();
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
