/// <summary> /// Get Sale Order Ref. No. and Date, GRN Ref. No. and Date, Work Desc. Ref. No and Short Name /// </summary> /// <param name="id">SaleOrderId OR SaleOrderItemId</param> /// <param name="type">0 if SaleOrderId, 1 if SaleOrderItemId</param> /// <returns>JsonResult</returns> public JsonResult GetItemBatchDetails(int id, int type) { ItemBatch model = new ItemBatchRepository().GetItemBatchDetails(id, type); return(Json(new { WorkDescRefNo = model.WorkDescrRefNo + " - " + model.WorkDescrShortName, SaleOrderRefNo = model.SaleOrderRefNo + " - " + model.SaleOrderDate, GRNRefNo = model.GRNNo + " - " + model.GRNDate.ToString("dd MMMM yyyy") }, JsonRequestBehavior.AllowGet)); }
public ActionResult Reserve(int id = 0, int item = 0)//SOI id and material id is received here { if (id != 0 && item != 0) { var items = new ItemBatchRepository().GetItemBatchForReservation(id, item); return(View(items)); } else { TempData["success"] = ""; TempData["error"] = "That was an invalid request. Please try again."; return(RedirectToAction("PendingReservation")); } }
public ActionResult Delete(int id = 0, int type = 0)//type=0 means GRNItemId, type=1 means OpeningStockId { try { var model = new ItemBatchRepository().DeleteItemBatch(id, type, UserID, OrganizationId); string ref_no = string.Empty; foreach (var item in model) { ref_no += ", " + item.SerialNo; } TempData["success"] = "Deleted Successfully (" + ref_no.Substring(2) + ")"; return(RedirectToAction("Index")); } catch (Exception) { TempData["error"] = "Some error occurred while deleting. Please try again."; return(RedirectToAction("Edit", new { id = id, type = type })); } }
public ActionResult Create(int id = 0, int type = 0) { try { if (id != 0) { ItemBatch model = new ItemBatch(); if (type == 0) { model = new ItemBatchRepository().GetGRNItem(grnItemId: id); } else if (type == 1) { model = new ItemBatchRepository().GetOpeningStockItem(OpeningStockItemId: id); } model.isOpeningStock = type; List <ItemBatch> list = new List <ItemBatch>(); for (int i = 0; i < model.Quantity; i++) { list.Add(model); } return(View(list)); } throw new NullReferenceException(); } catch (NullReferenceException) { TempData["success"] = ""; TempData["error"] = "Some required data was missing. Please try again"; } catch (SqlException sx) { TempData["success"] = ""; TempData["error"] = "Some error occured while connecting to database. Check your network connection and try again|" + sx.Message; } catch (Exception) { TempData["success"] = ""; TempData["error"] = "Some error occured. Please try again"; } return(RedirectToAction("Pending")); }
public ActionResult Create(IList <ItemBatch> model) { HashSet <string> temp = new HashSet <string>(); foreach (var item in model) { temp.Add(item.SerialNo); } if (temp.Count != model.Count) { TempData["error"] = "Serial numbers cannot be same. Please enter different serial numbers."; return(View(model)); } foreach (ItemBatch item in model) { item.CreatedBy = UserID.ToString(); item.OrganizationId = OrganizationId; item.CreatedDate = DateTime.Now; } try { string existingSerialNos = new ItemBatchRepository().IsSerialNoExists(model.Select(m => m.SerialNo).ToList()); if (existingSerialNos == null) { new ItemBatchRepository().InsertItemBatch(model); TempData["success"] = "Saved successfully"; TempData["error"] = ""; return(RedirectToAction("Pending", new { type = model[0].isOpeningStock })); } TempData["error"] = existingSerialNos + " already exists."; } catch (Exception ex) { TempData["success"] = ""; TempData["error"] = "Some error occured while connecting to database. Check your network connection and try again|" + ex.Message; } return(View(model)); }