public ActionResult Edit(I_OrderDetails i_OrderDetails)
{
if (ModelState.IsValid)
{
i_OrderDetails.ModifiedBy = System.Web.HttpContext.Current.User.Identity.Name;
i_OrderDetails.ModifiedOn = System.DateTime.Now;
db.Entry(i_OrderDetails).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StoreId = new SelectList(db.Store_Details, "storeId", "storename", i_OrderDetails.StoreId);
return(View(i_OrderDetails));
}
public IHttpActionResult DeleteI_OrderDetails(int id)
{
I_OrderDetails i_OrderDetails = db.I_OrderDetails.Find(id);
if (i_OrderDetails == null)
{
return(NotFound());
}
db.I_OrderDetails.Remove(i_OrderDetails);
db.SaveChanges();
return(Ok(i_OrderDetails));
}
// GET: OrderDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
I_OrderDetails i_OrderDetails = db.I_OrderDetails.Find(id);
if (i_OrderDetails == null)
{
return(HttpNotFound());
}
return(View(i_OrderDetails));
}
public IHttpActionResult PostOrderItems(List <I_OrderItemCatalog> i_orderMasters)
{
try
{
foreach (I_OrderItemCatalog i_orderMaster in i_orderMasters)
{
I_OrderDetails i_OrderDetails = new I_OrderDetails();
i_OrderDetails = db.I_OrderDetails.Find(i_orderMaster.OrderId);
i_OrderDetails.Status = i_orderMaster.Status;
i_OrderDetails.VendorId = i_orderMaster.Vendor;
db.Entry(i_OrderDetails).State = EntityState.Modified;
db.SaveChanges();
break;
}
foreach (I_OrderItemCatalog i_orderMaster in i_orderMasters)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (I_OrderExists(Convert.ToInt32(i_orderMaster.ItemsId), i_orderMaster.OrderId))
{// Status =1 Ordered
//Status = 0 Saved
//Status =-99 Deleted
I_OrderItemCatalog i_orderMaster1 = db.I_OrderItemCatalog.Where(e => e.ItemsId == i_orderMaster.ItemsId && e.OrderId == i_orderMaster.OrderId && e.Status != -99).FirstOrDefault();
if (i_orderMaster1 != null)
{
db.I_OrderItemCatalog.Remove(i_orderMaster1);
db.SaveChanges();
}
db.I_OrderItemCatalog.Add(i_orderMaster);
db.SaveChanges();
}
else
{
db.I_OrderItemCatalog.Add(i_orderMaster);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw;
}
return(Ok());
}
public ActionResult OrderItemCatalog(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
I_OrderDetails i_OrderDetails = db.I_OrderDetails.Find(id);
if (i_OrderDetails == null)
{
return(HttpNotFound());
}
ViewBag.StoreId = new SelectList(db.Store_Details, "storeId", "storename", i_OrderDetails.StoreId);
return(View(i_OrderDetails));
}
public ActionResult Create(I_OrderDetails i_OrderDetails)
{
if (ModelState.IsValid)
{
i_OrderDetails.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
i_OrderDetails.CreatedOn = System.DateTime.Now;
db.I_OrderDetails.Add(i_OrderDetails);
db.SaveChanges();
I_OrderDetails i_OrderDetail = db.I_OrderDetails.Find(i_OrderDetails.Id);
i_OrderDetail.OrderNo = "ORD" + System.DateTime.Now.Year + "/" + System.DateTime.Now.Month + "/" + i_OrderDetails.Id;
i_OrderDetail.ModifiedBy = System.Web.HttpContext.Current.User.Identity.Name;
i_OrderDetail.ModifiedOn = System.DateTime.Now;
db.Entry(i_OrderDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StoreId = new SelectList(db.Store_Details, "storeId", "storename", i_OrderDetails.StoreId);
return(View(i_OrderDetails));
}
public IHttpActionResult Post(I_RecievingItemCatalog i_RecievingItemCatalog)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
string[] arr = i_RecievingItemCatalog.OrderIds.Split(',');
foreach (var item in arr)
{
I_OrderDetails obj = new I_OrderDetails();
obj = db.I_OrderDetails.Where(x => x.OrderNo == item).SingleOrDefault();
obj.Status = 2;// 2 for Choose for Recieving pending
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
}
db.I_RecievingItemCatalog.Add(i_RecievingItemCatalog);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = i_RecievingItemCatalog.Id }, i_RecievingItemCatalog));
}
public IHttpActionResult PostI_StockTransferItemCatalog(List <I_StockTransferItemCatalog> i_StockReqDetails)
{
int ReqNo = 0;
int orderId = 0;
foreach (I_StockTransferItemCatalog i_orderMaster in i_StockReqDetails)
{
I_StockTranferDetails i_OrderDetails = new I_StockTranferDetails();
ReqNo = i_orderMaster.ReqNo;
i_OrderDetails = db.I_StockTranferDetails.Find(i_orderMaster.ReqNo);
i_OrderDetails.Status = 2;
db.Entry(i_OrderDetails).State = EntityState.Modified;
db.SaveChanges();
I_OrderDetails objOrd = new I_OrderDetails();
objOrd.DeliveryDate = i_OrderDetails.Date;
objOrd.Status = 1;
objOrd.OrderNo = "TRA";
objOrd.StoreId = i_OrderDetails.TragetStore;
objOrd.TranferNo = i_OrderDetails.TranferNo;
objOrd.Reference = "Created against Transfer No " + i_OrderDetails.TranferNo;
objOrd.CreatedBy = i_OrderDetails.CreatedBy;
objOrd.CreatedOn = i_OrderDetails.CreatedOn;
db.I_OrderDetails.Add(objOrd);
db.SaveChanges();
orderId = objOrd.Id;
I_OrderDetails i_OrderDetail = db.I_OrderDetails.Find(objOrd.Id);
i_OrderDetail.OrderNo = "ORD" + System.DateTime.Now.Year + "/" + System.DateTime.Now.Month + "/" + i_OrderDetails.Id;
db.Entry(i_OrderDetail).State = EntityState.Modified;
db.SaveChanges();
break;
}
foreach (I_StockTransferItemCatalog item in i_StockReqDetails)
{
if (I_stockTransExists(Convert.ToInt32(item.ItemCode), item.ReqNo))
{
I_StockTransferItemCatalog i_orderMaster1 = db.I_StockTransferItemCatalog.Where(e => e.ItemCode == item.ItemCode && e.ReqNo == item.ReqNo).FirstOrDefault();
if (i_orderMaster1 != null)
{
db.I_StockTransferItemCatalog.Remove(i_orderMaster1);
db.SaveChanges();
}
db.I_StockTransferItemCatalog.Add(item);
db.SaveChanges();
I_OrderItemCatalog obj = new I_OrderItemCatalog();
obj.ItemName = item.ItemName;
obj.ItemsId = item.ItemCode;
obj.Qty = item.Qty;
obj.Status = 1;
obj.Price = db.I_StockInventory.Where(x => x.ItemId == item.ItemCode).Average(i => i.Price);
obj.OrderId = orderId;
obj.TotalSum = obj.Price * obj.Qty;
obj.Unit = item.UnitId;
obj.Vendor = 0;
obj.FixedorVariable = db.I_InventoryItemMaster.Where(x => x.ItemCode == item.ItemCode).Select(i => i.FixedorVariable).SingleOrDefault();;
obj.Createdby = item.CreatedBy;
obj.CreatedOn = item.CreatedOn;
db.I_OrderItemCatalog.Add(obj);
db.SaveChanges();
}
else
{
db.I_StockTransferItemCatalog.Add(item);
db.SaveChanges();
I_OrderItemCatalog obj = new I_OrderItemCatalog();
obj.ItemName = item.ItemName;
obj.ItemsId = item.ItemCode;
obj.Qty = item.Qty;
obj.Status = 1;
obj.Price = db.I_StockInventory.Where(x => x.ItemId == item.ItemCode).Average(i => i.Price);
obj.OrderId = orderId;
obj.TotalSum = obj.Price * obj.Qty;
obj.Unit = item.UnitId;
obj.Vendor = 0;
obj.FixedorVariable = db.I_InventoryItemMaster.Where(x => x.Id == item.ItemCode).Select(i => i.FixedorVariable).SingleOrDefault();;
obj.Createdby = item.CreatedBy;
obj.CreatedOn = item.CreatedOn;
db.I_OrderItemCatalog.Add(obj);
db.SaveChanges();
}
}
return(CreatedAtRoute("DefaultApi", new { }, i_StockReqDetails));
}
