public async Task <ResponseViewModel <QuantityViewModel> > CreateAndUpdate(QuantityViewModel QauntityObj)
{
ResponseViewModel <QuantityViewModel> ResObj = new ResponseViewModel <QuantityViewModel>();
try
{
if (QauntityObj != null)
{
bool IsNew = false;
InventoryDBContext dbContext = new InventoryDBContext(await connMethod.GetConnectionString(QauntityObj.ConnectionString));
/*Check if already exists*/
Brand_Quantity_Time_Received QuantityDBObj = dbContext.Brand_Quantity_Time_Received.Where(x => x.Inventory_Id == QauntityObj.Brand_Id).FirstOrDefault();
if (QuantityDBObj == null)
{
QuantityDBObj = new Brand_Quantity_Time_Received();
IsNew = true;
}
QuantityDBObj.Brand_Id = QauntityObj.Brand_Id;
QuantityDBObj.Quantity = QauntityObj.Quantity;
QuantityDBObj.Time_Received = QauntityObj.Time_Received;
if (IsNew)
{
await dbContext.Brand_Quantity_Time_Received.AddAsync(QuantityDBObj);
}
await dbContext.SaveChangesAsync();
QauntityObj.Inventory_Id = QuantityDBObj.Inventory_Id;
ResObj.IsSuccess = true;
List <QuantityViewModel> QuantityList = new List <QuantityViewModel>();
QuantityList.Add(QauntityObj);
ResObj.Data = QuantityList;
}
else
{
ResObj.IsSuccess = false;
ResObj.ErrorCode = 400;
ResObj.ErrorDetails = "Parameter not provided.";
}
}
catch (Exception ex)
{
ResObj.IsSuccess = false;
ResObj.ErrorCode = 500;
ResObj.ErrorDetails = ex.ToString();
}
return(ResObj);
}
public async Task <ResponseViewModel <QuantityViewModel> > Delete(QuantityViewModel QuantityObj)
{
ResponseViewModel <QuantityViewModel> ResObj = new ResponseViewModel <QuantityViewModel>();
try
{
if (QuantityObj != null)
{
InventoryDBContext dbContext = new InventoryDBContext(await connMethod.GetConnectionString(QuantityObj.ConnectionString));
/*Check if already exists*/
Brand_Quantity_Time_Received QuantityDBObj = dbContext.Brand_Quantity_Time_Received.Where(x => x.Inventory_Id == QuantityObj.Inventory_Id).FirstOrDefault();
if (QuantityDBObj != null)
{
dbContext.Brand_Quantity_Time_Received.Remove(QuantityDBObj);
await dbContext.SaveChangesAsync();
ResObj.IsSuccess = true;
}
else
{
ResObj.IsSuccess = false;
ResObj.ErrorCode = 404;
ResObj.ErrorDetails = "Record not found.";
}
}
else
{
ResObj.IsSuccess = false;
ResObj.ErrorCode = 400;
ResObj.ErrorDetails = "Parameter not provided.";
}
}
catch (Exception ex)
{
ResObj.IsSuccess = false;
ResObj.ErrorCode = 500;
ResObj.ErrorDetails = ex.ToString();
}
return(ResObj);
}
