public ResultListModel <ProductModel> GetProducts()
{
var result = new ResultListModel <ProductModel>();
try
{
using (var context = new TitchyCottageEntities())
{
List <Product> product = context.GetProducts().ToList();
result.Data = (from item in product
select new ProductModel
{
ProductID = item.ProductID,
ProductName = item.ProductName,
ProductDescription = item.ProductDescription,
Cost = item.Cost
}).ToList();
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
logger.Error(ex.Message);
}
return(result);
}
public ResultModel <ProductModel> AddOrUpdateProduct(ProductModel product)
{
var result = new ResultModel <ProductModel>();
try
{
using (var context = new TitchyCottageEntities())
{
context.AddOrUpdateProduct(product.ProductID, product.ProductName, product.ProductDescription, product.Cost);
//context.Products.Add(student);
////will execute sp_InsertStudentInfo
//context.SaveChanges();
//student.StudentName = "Edit student using SP";
////will execute sp_UpdateStudent
//context.SaveChanges();
//context.Students.Remove(student);
//will execute sp_DeleteStudentInfo
//context.SaveChanges();
result.Message = "Product has been saved successfully.";
result.success = true;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.success = false;
logger.Error(ex.Message);
}
return(result);
}
public ResultModel <ProductModel> GetProductByProductId(int productID)
{
var result = new ResultModel <ProductModel>();
try
{
using (var context = new TitchyCottageEntities())
{
Product product = context.GetProductByID(productID).FirstOrDefault();
result.Data = new ProductModel
{
ProductID = product.ProductID,
ProductName = product.ProductName,
ProductDescription = product.ProductDescription,
Cost = product.Cost
};
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
logger.Error(ex.Message);
}
return(result);
}
public ResultModel <ProductQuantityModel> GetProductQuantityByProductId(int ID)
{
var result = new ResultModel <ProductQuantityModel>();
try
{
using (var context = new TitchyCottageEntities())
{
List <ProductQuantity> productQty = context.GetProductQuantityByID(ID).ToList();
List <Product> product = context.GetProducts().ToList();
result.Data = (from qty in productQty
join p in product on qty.ProductID equals(p.ProductID)
select new ProductQuantityModel
{
ID = qty.ID,
ProductID = qty.ProductID,
ProductName = p.ProductName,
DateCode = qty.DateCode,
ExpiredDate = qty.ExpiredDate,
Lot = qty.Lot,
ManufacturerDate = qty.ManufacturerDate,
ShopInQuantity = qty.ShopInQuantity ?? 0,
SoldOutQuantity = qty.SoldOutQuantity ?? 0,
StockInQuantity = qty.StockInQuantity ?? 0,
TotalQuantity = qty.TotalQuantity ?? 0
}).ToList().FirstOrDefault();
//ProductQuantity qty = context.GetProductQuantityByID(ID).FirstOrDefault();
//result.Data = new ProductQuantityModel
//{
// ID = qty.ID,
// DateCode = qty.DateCode,
// ExpiredDate = qty.ExpiredDate,
// Lot = qty.Lot,
// ManufacturerDate = qty.ManufacturerDate,
// ProductID = qty.ProductID,
// ShopInQuantity = qty.ShopInQuantity??0,
// SoldOutQuantity = qty.SoldOutQuantity??0,
// StockInQuantity = qty.ShopInQuantity??0,
// TotalQuantity = qty.TotalQuantity??0
//};
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
logger.Error(ex.Message);
}
return(result);
}
public ResultModel <ShopTransactionModel> CheckInByShop(ShopTransactionModel Qty)
{
var result = new ResultModel <ShopTransactionModel>();
try
{
using (var context = new TitchyCottageEntities())
{
context.AddOrUpdateShopTransaction(Qty.ID, Qty.ShopID, Qty.ProductID, Qty.ProductQuantityID, Qty.Quantity, Qty.CreatedBy, null, Qty.CreatedBy, null);
result.Message = string.Concat(Qty.Quantity.ToString(), " ", "Quantity has been Checked in successfully.");
result.success = true;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.success = false;
logger.Error(ex.Message);
}
return(result);
}
public ResultModel <ProductModel> AddOrUpdateProductQuantity(ProductQuantityModel Qty)
{
var result = new ResultModel <ProductModel>();
try
{
using (var context = new TitchyCottageEntities())
{
Qty.DateCode = DateTime.Now.ToString("MMddyyyy");
context.AddOrUpdateProductQuantity(Qty.ID, Qty.ProductID, Qty.Lot, Qty.DateCode, Qty.TotalQuantity, Qty.ExpiredDate, Qty.ManufacturerDate, Qty.CreatedBy);
result.Message = string.Concat(Qty.TotalQuantity.ToString(), " ", "Quantity has been added successfully.");
result.success = true;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.success = false;
logger.Error(ex.Message);
}
return(result);
}
public ResultListModel <DistibutorDashboardResponseModel> GetShopInformationForDistibutor(DistibutorDashboardRequestModel req)
{
var result = new ResultListModel <DistibutorDashboardResponseModel>();
try
{
using (var context = new TitchyCottageEntities())
{
var data = context.GetShopInformationForDistibutor(req.DistibutorId, req.ProductName, req.Lot, req.ExpiredDate).ToList();
if (data != null && data.Any())
{
result.Data = (from item in data
select new DistibutorDashboardResponseModel
{
ExpiredDate = item.ExpiredDate,
Lot = item.Lot,
ManufacturerDate = item.ManufacturerDate,
ProductName = item.ProductName,
ShopName = item.ShopName,
SoldOutQuantity = item.SoldOutQuantity,
StockInQuantity = item.StockInQuantity,
TotalQuantity = item.TotalQuantity
}
).ToList();
}
result.success = true;
}
}
catch (Exception ex)
{
result.success = false;
logger.Error(ex.Message);
}
return(result);
}
public ResultModel <CheckOutRequestModel> CheckOutFromShop(CheckOutRequestModel Qty)
{
var result = new ResultModel <CheckOutRequestModel>();
try
{
using (var context = new TitchyCottageEntities())
{
context.CheckOutTransaction(Qty.ShopId, Qty.ProductID, Qty.ProductQuantityID, Qty.Quantity, Qty.Isreturn, Qty.CreatedBy, null);
result.Message = Qty.Isreturn ?string.Concat(Qty.Quantity.ToString(), " ", "Quantity has been Sold Out successfully.") :
string.Concat(Qty.Quantity.ToString(), " ", "Quantity has been Returned successfully.");
result.success = true;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.success = false;
logger.Error(ex.Message);
}
return(result);
}