public string UpdateInventoryItemDetails([FromBody]classInventoryItemsDetails objItem)
{
string IsSuccessOrError = string.Empty;
string message = string.Empty;
//IsSuccessOrError = "UpdateInventoryItemDetails : " + objItem.IdDetails.ToString();
try
{
InventoryItemtbl inventoryDetails;
using (var ctx = new InventoryManagementDBEntities())
{
IsSuccessOrError = "ErrorBeforeNull : objItem.IdDetails" + objItem;
inventoryDetails = ctx.InventoryItemtbls.Where(s => s.InventoryItemId == objItem.IdDetails).FirstOrDefault();
IsSuccessOrError = "hi";
}
//2. change student name in disconnected mode (out of ctx scope)
if (inventoryDetails != null)
{
IsSuccessOrError = "ErrorAfterNull";
inventoryDetails.DateOfBuying = objItem.DateOfBuying;
inventoryDetails.Location = objItem.Location;
inventoryDetails.Price = objItem.Price;
inventoryDetails.Quantity = objItem.Quantity;
inventoryDetails.UnitType = objItem.UnitType;
//save modified entity using new Context
using (var dbCtx = new InventoryManagementDBEntities())
{
IsSuccessOrError = "ErrorUpdateNull";
//3. Mark entity as modified
dbCtx.Entry(inventoryDetails).State = System.Data.Entity.EntityState.Modified;
//4. call SaveChanges
dbCtx.SaveChanges();
IsSuccessOrError = "Success";
}
}
}
catch (Exception ex)
{
// IsSuccessOrError = "Error" + ex.Message + ": Inner Exception : " + ex.InnerException;
return IsSuccessOrError;
}
return IsSuccessOrError + ";" + message;
}
public string DeleteInventoryItem([FromUri]int Id)
{
string message = string.Empty;
try
{
InventoryList inventoryItemToDelete;
//1. Get student from DB
using (var ctx = new InventoryManagementDBEntities())
{
inventoryItemToDelete = ctx.InventoryLists.Where(s => s.InventoryListId == Id).FirstOrDefault<InventoryList>();
}
using (var dbctx = new InventoryManagementDBEntities())
{
List<InventoryItemtbl> inventoryItemDetails = dbctx.InventoryItemtbls.Where(p => p.InventoryListId == Id).ToList<InventoryItemtbl>();
//foreach(InventoryItemtbl obj in inventoryItemDetails)
//{
// InventoryItemtbl item = obj;
dbctx.InventoryItemtbls.RemoveRange(inventoryItemDetails);
// dbctx.Entry(item).State = System.Data.Entity.EntityState.Deleted;
dbctx.SaveChanges();
// message = "Success";
//}
}
//Create new context for disconnected scenario
using (var newContext = new InventoryManagementDBEntities())
{
newContext.Entry(inventoryItemToDelete).State = System.Data.Entity.EntityState.Deleted;
newContext.SaveChanges();
message = "Success";
}
}
catch (Exception ex)
{
message = "Error" + ex.Message;
return message;
}
return message;
}
public string DeleteInventoryItemDetails([FromUri]int id)
{
string message = string.Empty;
try
{
InventoryItemtbl inventoryItemDetailsToDelete;
//1. Get student from DB
using (var ctx = new InventoryManagementDBEntities())
{
inventoryItemDetailsToDelete = ctx.InventoryItemtbls.Where(s => s.InventoryItemId == id).FirstOrDefault<InventoryItemtbl>();
}
//Create new context for disconnected scenario
using (var newContext = new InventoryManagementDBEntities())
{
newContext.Entry(inventoryItemDetailsToDelete).State = System.Data.Entity.EntityState.Deleted;
newContext.SaveChanges();
message = "Success";
}
}
catch (Exception)
{
message = "Error";
return message;
}
return message;
}
public string AddInventoryItemDetails([FromBody]classInventoryItemsDetails objItem)
{
string IsSuccessOrError = string.Empty;
string message = string.Empty;
try
{
using (var dbCtx = new InventoryManagementDBEntities())
{
InventoryItemtbl entity = new InventoryItemtbl();
entity.DateOfBuying = objItem.DateOfBuying;
// entity.InventoryItemId = objItem.IdDetails;
entity.InventoryListId = objItem.IdItem;
entity.Location = objItem.Location;
entity.Price = objItem.Price;
entity.Quantity = objItem.Quantity;
entity.UnitType = objItem.UnitType;
dbCtx.InventoryItemtbls.Add(entity);
dbCtx.SaveChanges();
List<InventoryItemtbl> obj = dbCtx.InventoryItemtbls.Where(p => p.InventoryListId == objItem.IdItem).ToList<InventoryItemtbl>();
int totalPrice = 0;
int totalQuantity = 0;
foreach (InventoryItemtbl data in obj)
{
totalQuantity = totalQuantity + Convert.ToInt32(data.Quantity);
totalPrice = totalPrice + (Convert.ToInt32(data.Quantity) * Convert.ToInt32(data.Price));
}
//if (obj != null)
//{
// item.IdDetails = obj.InventoryItemId;
// item.IdItem = obj.InventoryListId;
// // item.IdUser = obj.UserId;
// item.Location = obj.Location;
// item.UnitType = obj.UnitType;
// item.Price = obj.Price;
// item.Quantity = obj.Quantity.ToString();
// item.DateOfBuying = obj.DateOfBuying;
// return item;
//}
InventoryList list = new InventoryList();
list.InventoryListId = objItem.IdItem;
list.ItemName = objItem.ItemName;
list.TotalCost = totalPrice;
list.TotalItems = totalQuantity;
dbCtx.Entry(list).State = System.Data.Entity.EntityState.Modified;
dbCtx.SaveChanges();
IsSuccessOrError = "Success";
message = "Item has been added successfully.";
}
//using (var dbCtxInv = new InventoryManagementDBEntities())
//{
// InventoryList list = new InventoryList();
// list.TotalCost = 40000;
// var inventoryListsData = dbCtxInv.InventoryLists;
// InventoryList inventoryList = inventoryListsData.Where(p => p.InventoryListId == objItem.IdItem).FirstOrDefault<InventoryList>();
// list.ItemName = inventoryList.ItemName;
// dbCtxInv.Entry(list).State = System.Data.Entity.EntityState.Modified;
// dbCtxInv.SaveChanges();
//}
}
catch (Exception ex)
{
message = "Error While adding item in Database." + ex.Message + "inner : " + ex.InnerException + "Id : " + objItem.IdItem + "Name : " + objItem.ItemName;
IsSuccessOrError = "Error";
return IsSuccessOrError + ";" + message;
}
return IsSuccessOrError + ";" + message;
}
