public GRNItemList GetGRNItem(int?GIId) { PetaPoco.Database db = null; var dbConn = DataContext.Database.Connection; GRNItemList user = new GRNItemList(); try { using (DataContext) { dbConn.Open(); db = new PetaPoco.Database(dbConn); db.EnableAutoSelect = false; user = db.Query <GRNItemList>("exec usp_GetGRNItem " + "@GIId", new { GIId = GIId }).FirstOrDefault(); dbConn.Close(); } } catch (Exception ex) { throw; } finally { if (dbConn != null) { dbConn.Close(); } } return(user); }
public JsonResult GetRMItemsDetails(int?GIId) { StoreService service = new StoreService(); GRNItemList user = new GRNItemList(); user = service.GetGRNItem(GIId); return(Json(new { up = user.GIUnitPrice, pq = user.GIPendingQuantity, qty = user.GIReceivedQuantity, }, JsonRequestBehavior.AllowGet)); }
public ActionResult QRGenaration(int?GIId) { StoreService service = new StoreService(); QR qr = new QR(); GRNItemList gi = new GRNItemList(); gi = service.GetGRNItem(GIId); qr.GIId = GIId; qr.GRNId = gi.GRNId; qr.PONo = gi.PONo; qr.GIReceivedQuantity = gi.GIReceivedQuantity; return(View("QRGenaration", qr)); }
public ActionResult AddGRNItem(int?GIId) { StoreService service = new StoreService(); GRNItemList Product = new GRNItemList(); ViewBag.Purchase = new SelectList(AllPOs(), "Value", "Text"); if (GIId != null) { Product = service.GetGRNItem(GIId); } ViewBag.PIItem = new SelectList(AllPOItem(Product.POId), "Value", "Text"); return(PartialView("_AddGRNItem", Product)); }
public int UpdateGRNItem(GRNItemList user) { int id = 0; try { id = _repository.UpdateGRNItem(user); } catch (Exception ex) { throw ex; } return(id); }
public GRNItemList GetGRNItem(int?GIId) { GRNItemList user = new GRNItemList(); try { user = _repository.GetGRNItem(GIId); } catch (Exception ex) { throw; } return(user); }
public ActionResult SaveGRNItem(GRNItemList product) { int id = 0; StoreService service = new StoreService(); try { if (product.GIId > 0) { id = service.UpdateGRNItem(product); return(Json(new { Status = true, Id = id, Message = "Record updated successfully" }, JsonRequestBehavior.AllowGet)); } else { id = service.AddGRNItem(product); return(Json(new { Status = true, Id = id, Message = "Record added successfully" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { Status = false, Message = "Error Occured" }, JsonRequestBehavior.AllowGet)); } }
public int AddGRNItem(GRNItemList user) { int id = 0; PetaPoco.Database db = null; var dbConn = DataContext.Database.Connection; try { dbConn.Open(); db = new PetaPoco.Database(dbConn); db.EnableAutoSelect = false; id = db.ExecuteScalar <int>("declare @@ret INT; exec @@ret = usp_AddGRNItem " + " @POId,@GRNId,@PIId,@GIDescription,@GIReceivedQuantity,@GIUnitPrice; select @@ret;", new { @POId = user.POId, @GRNId = user.GRNId, @PIId = user.PIId, @GIDescription = user.GIDescription, @GIReceivedQuantity = user.GIReceivedQuantity, @GIUnitPrice = user.GIUnitPrice }); } catch (Exception ex) { } finally { if (dbConn != null) { dbConn.Close(); } } return(id); }