public IHttpActionResult PostI_StockRequestItemCatalog(List <I_StockRequestItemCatalog> i_StockReqDetails)
{
foreach (I_StockRequestItemCatalog i_orderMaster in i_StockReqDetails)
{
I_StockReqDetails i_OrderDetails = new I_StockReqDetails();
i_OrderDetails = db.I_StockReqDetails.Find(i_orderMaster.ReqNo);
i_OrderDetails.Status = 2;
db.Entry(i_OrderDetails).State = EntityState.Modified;
db.SaveChanges();
break;
}
foreach (I_StockRequestItemCatalog item in i_StockReqDetails)
{
if (I_stockExists(Convert.ToInt32(item.ItemCode), item.ReqNo))
{
I_StockRequestItemCatalog i_orderMaster1 = db.I_StockRequestItemCatalog.Where(e => e.ItemCode == item.ItemCode && e.ReqNo == item.ReqNo).FirstOrDefault();
if (i_orderMaster1 != null)
{
db.I_StockRequestItemCatalog.Remove(i_orderMaster1);
db.SaveChanges();
}
db.I_StockRequestItemCatalog.Add(item);
db.SaveChanges();
}
else
{
db.I_StockRequestItemCatalog.Add(item);
db.SaveChanges();
}
}
return(CreatedAtRoute("DefaultApi", new { }, i_StockReqDetails));
}
public IHttpActionResult PutI_StockReqDetails(int id, I_StockReqDetails i_StockReqDetails)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != i_StockReqDetails.Id)
{
return(BadRequest());
}
db.Entry(i_StockReqDetails).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!I_StockReqDetailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed1(int id)
{
I_StockReqDetails i_StockReqDetails = db.I_StockReqDetails.Find(id);
db.I_StockReqDetails.Remove(i_StockReqDetails);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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 IHttpActionResult GetI_StockReqDetails(int id)
{
I_StockReqDetails i_StockReqDetails = db.I_StockReqDetails.Find(id);
if (i_StockReqDetails == null)
{
return(NotFound());
}
return(Ok(i_StockReqDetails));
}
// GET: StockReq/Create
public ActionResult Create()
{
I_StockReqDetails obj = new I_StockReqDetails();
obj.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
obj.CreatedOn = System.DateTime.Now;
obj.Date = System.DateTime.Now;
obj.TranferNo = "TRF";
ViewBag.SourceStore = new SelectList(db.Store_Details, "storeId", "storename");
ViewBag.TragetStore = new SelectList(db.Store_Details, "storeId", "storename");
return(View(obj));
}
public IHttpActionResult PostI_StockReqDetails(I_StockReqDetails i_StockReqDetails)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.I_StockReqDetails.Add(i_StockReqDetails);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = i_StockReqDetails.Id }, i_StockReqDetails));
}
public IHttpActionResult DeleteI_StockReqDetails(int id)
{
I_StockReqDetails i_StockReqDetails = db.I_StockReqDetails.Find(id);
if (i_StockReqDetails == null)
{
return(NotFound());
}
db.I_StockReqDetails.Remove(i_StockReqDetails);
db.SaveChanges();
return(Ok(i_StockReqDetails));
}
public ActionResult Edit(I_StockReqDetails i_StockReqDetails)
{
i_StockReqDetails.ModifiedBy = System.Web.HttpContext.Current.User.Identity.Name;
i_StockReqDetails.ModifiedOn = System.DateTime.Now;
if (ModelState.IsValid)
{
db.Entry(i_StockReqDetails).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SourceStore = new SelectList(db.Store_Details, "storeId", "storename", i_StockReqDetails.SourceStore);
ViewBag.TragetStore = new SelectList(db.Store_Details, "storeId", "storename", i_StockReqDetails.TragetStore);
return(View(i_StockReqDetails));
}
public ActionResult Reject(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
I_StockReqDetails i_StockReqDetails = db.I_StockReqDetails.Find(id);
i_StockReqDetails.Status = 4;// Reject
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();
return(RedirectToAction("PendingRequests"));
}
// GET: StockReq/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
I_StockReqDetails i_StockReqDetails = db.I_StockReqDetails.Find(id);
if (i_StockReqDetails == null)
{
return(HttpNotFound());
}
ViewBag.SourceStore = new SelectList(db.Store_Details, "storeId", "storename", i_StockReqDetails.SourceStore);
ViewBag.TragetStore = new SelectList(db.Store_Details, "storeId", "storename", i_StockReqDetails.TragetStore);
return(View(i_StockReqDetails));
}
public ActionResult Create(I_StockReqDetails i_StockReqDetails)
{
i_StockReqDetails.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
i_StockReqDetails.CreatedOn = System.DateTime.Now;
i_StockReqDetails.Status = 1;
if (ModelState.IsValid)
{
db.I_StockReqDetails.Add(i_StockReqDetails);
db.SaveChanges();
I_StockReqDetails i_StockTranferDetail = db.I_StockReqDetails.Find(i_StockReqDetails.Id);
i_StockTranferDetail.TranferNo = "REQ" + System.DateTime.Now.Year + "/" + System.DateTime.Now.Month + "/" + i_StockReqDetails.Id;
Edit(i_StockReqDetails);
return(RedirectToAction("Index"));
}
ViewBag.SourceStore = new SelectList(db.Store_Details, "storeId", "storename", i_StockReqDetails.SourceStore);
ViewBag.TragetStore = new SelectList(db.Store_Details, "storeId", "storename", i_StockReqDetails.TragetStore);
return(View(i_StockReqDetails));
}
