public ActionResult Approve(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
I_StockReqDetails i_StockReqDetails = db.I_StockReqDetails.Find(id);
i_StockReqDetails.Status = 3; // Approve
i_StockReqDetails.ModifiedBy = System.Web.HttpContext.Current.User.Identity.Name;
i_StockReqDetails.ModifiedOn = System.DateTime.Now;
db.Entry(i_StockReqDetails).State = EntityState.Modified;
db.SaveChanges();
I_StockTranferDetails obj = new I_StockTranferDetails();
obj.SourceStore = i_StockReqDetails.SourceStore;
obj.TragetStore = i_StockReqDetails.TragetStore;
obj.Reference = "Againest Request No " + i_StockReqDetails.TranferNo;
obj.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
obj.CreatedOn = System.DateTime.Now;
obj.Date = i_StockReqDetails.Date;
obj.TranferNo = "TRN";
obj.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
obj.CreatedOn = System.DateTime.Now;
obj.Status = 1;
db.I_StockTranferDetails.Add(obj);
db.SaveChanges();
I_StockTranferDetails i_StockTranferDetail = db.I_StockTranferDetails.Find(obj.Id);
i_StockTranferDetail.TranferNo = "TRN" + System.DateTime.Now.Year + "/" + System.DateTime.Now.Month + "/" + obj.Id;
db.Entry(i_StockTranferDetail).State = EntityState.Modified;
db.SaveChanges();
List <I_StockRequestItemCatalog> i_StockRequestItemCatalog = new List <I_StockRequestItemCatalog>();
i_StockRequestItemCatalog = db.I_StockRequestItemCatalog.Where(x => x.ReqNo == id).ToList();
I_StockTransferItemCatalog objtransfer;
foreach (I_StockRequestItemCatalog item in i_StockRequestItemCatalog)
{
objtransfer = new I_StockTransferItemCatalog();
objtransfer.ItemCode = item.ItemCode;
objtransfer.ItemName = item.ItemName;
objtransfer.ReqNo = obj.Id;
objtransfer.ReqQty = item.Qty;
objtransfer.UnitId = item.UnitId;
objtransfer.UnitName = item.UnitName;
objtransfer.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
objtransfer.CreatedOn = System.DateTime.Now;
db.I_StockTransferItemCatalog.Add(objtransfer);
db.SaveChanges();
}
return(RedirectToAction("PendingRequests"));
}
public JsonResult DeleteConfirmed(List <int> id)
{
foreach (int item in id)
{
I_StockTransferItemCatalog i_StockTransDetails = db.I_StockTransferItemCatalog.Find(item);
db.I_StockTransferItemCatalog.Remove(i_StockTransDetails);
db.SaveChanges();
}
return(Json("Success"));
}
public async Task <ActionResult> AddItems(List <I_StockTransferItemCatalog> StockRequest)
{
bool success = false;
List <I_StockTransferItemCatalog> objNew = new List <I_StockTransferItemCatalog>();
I_StockTransferItemCatalog obj;
foreach (I_StockTransferItemCatalog objItem in StockRequest)
{
obj = new I_StockTransferItemCatalog();
obj.ItemCode = objItem.ItemCode;
obj.ItemName = (objItem.ItemName);
obj.UnitId = (objItem.UnitId);
obj.UnitName = objItem.UnitName;
obj.Status = 1;
obj.Qty = Convert.ToDecimal(objItem.Qty);
obj.ReqQty = Convert.ToDecimal(objItem.ReqQty);
obj.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
obj.CreatedOn = System.DateTime.Now;
obj.ReqNo = objItem.ReqNo;
objNew.Add(obj);
}
url = uri + "/api/APIStockReqDetails/PostI_StockTransferItemCatalog";
client.BaseAddress = new Uri(url);
HttpResponseMessage responseMessage = await client.PostAsJsonAsync(url, objNew);
if (responseMessage.IsSuccessStatusCode)
{
success = true;
}
if (success)
{
return(Json(new
{
success = true
},
JsonRequestBehavior.AllowGet));
}
return(Json(new
{
success = false
},
JsonRequestBehavior.AllowGet));
}
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));
}