public bool savePR(ProcureVM model) { var user = System.Web.HttpContext.Current.Session["UserName"].ToString(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString)) { con.Open(); String s = "INSERT INTO [dbo].[tblDocument]([DTypeId],[CreationDate],[CreatedBy],[DocStatus],[Status],[ItemName]) VALUES (@DTypeId,@createdDate,@createdby,@docstatus,@status,@item)"; SqlCommand smd = new SqlCommand(s, con); smd.Parameters.AddWithValue("@DTypeId", 1); smd.Parameters.AddWithValue("@createdDate", DateTime.Now); smd.Parameters.AddWithValue("@createdby", user); smd.Parameters.AddWithValue("@docstatus", "InComplete"); smd.Parameters.AddWithValue("@status", "Pending"); smd.Parameters.AddWithValue("@item", model.ItemsID); int x = smd.ExecuteNonQuery(); if (x > 0) { int rId = getDocumentNo(); insertIntoCommonTable(model, rId); return(true); } else { return(false); } } }
public ActionResult CreateVendors(ProcureVM model) { IProcure obj = new Procure(); var ItemType = obj.Getitemtype().ToList(); var vendortype = new SelectList(new[] { new { ID = "1", Name = "Local" }, new { ID = "2", Name = "Foreign" } }, "Name", "Name", "1" ); ViewBag.getVendortypelist = vendortype; SelectList list = new SelectList(ItemType, "Id", "ItemType"); ViewBag.getItemtypelist = list; IEnumerable <ProcureVM> listofItems = (from items in obj.Getitems() select new ProcureVM() { ItemId = items.ItemId, ItemName = items.ItemName }).ToList(); ViewBag.Getitem = listofItems; var add = obj.addvendor(model.VendorName, model.Contact, model.TypeId, model.Address, model.VendorType); obj.Addvendors(add); obj.Save(); TempData["SuccessMessage1"] = "Successfully Created"; return(View()); }
public List <ProcureVM> getPODocData(int?Docno) { List <ProcureVM> a = new List <ProcureVM>(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString)) { con.Open(); String s = "select doc.DocumentNo,doc.CreationDate,doc.CreatedBy,v.VendorName,v.Contact,v.Address from tblDocument doc inner join tblDocDetails det on doc.DocumentNo=det.POReference inner join tblVendors v on det.VendorId=v.VendorId where doc.DTypeId=3 and doc.DocumentNo=@id"; SqlCommand smd = new SqlCommand(s, con); smd.Parameters.AddWithValue("@id", Docno); SqlDataReader sdr = smd.ExecuteReader(); while (sdr.Read()) { ProcureVM r = new ProcureVM(); r.DocNo = Convert.ToInt32(sdr["DocumentNo"]); r.Createdon = Convert.ToDateTime(sdr["CreationDate"]).Date; r.Createdby = sdr["CreatedBy"].ToString(); r.VendorName = sdr["VendorName"].ToString(); r.Contact = sdr["Contact"].ToString(); r.Address = sdr["Address"].ToString(); a.Add(r); } return(a); } }
public tblDocument CreatePRItems(ProcureVM model) { var user = System.Web.HttpContext.Current.Session["UserName"].ToString(); var add = new tblDocument() { CreationDate = DateTime.Now, CreatedBy = user, }; return(add); }
public ActionResult EditItemType(ProcureVM model) { IProcure obj = new Procure(); obj.UpdateItemType(model.Id, model.ItemType); obj.Save(); TempData["SuccessMessage1"] = "Successfully Updated"; return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); }
public void insertIntoCommonTable(ProcureVM model, int DId) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString)) { con.Open(); for (int i = 0; i < model.requestedMaterialArray.Length; i++) { String s = "INSERT INTO [dbo].[tblDocDetails] ([DocumentNo],[ItemName],[Quantity],[TotalPrice]) VALUES (@Did,@m,@qty,@price)"; SqlCommand sd = new SqlCommand(s, con); sd.Parameters.AddWithValue("@Did", DId); sd.Parameters.AddWithValue("@m", model.requestedMaterialArray[i]); sd.Parameters.AddWithValue("@qty", 0); sd.Parameters.AddWithValue("@price", 0); sd.ExecuteNonQuery(); } } }
public ActionResult CreateItemType(ProcureVM model) { IProcure obj = new Procure(); var check = obj.Getitemtype().Where(x => x.ItemType == model.ItemType).FirstOrDefault(); if (check == null) { var add = obj.AddItemtype(model.ItemType); obj.AddTypes(add); obj.Save(); TempData["SuccessMessage1"] = "Successfully Created"; } else { TempData["ErrorMessage1"] = "ItemType" + model.ItemType + " already exists"; } return(View()); }
public ActionResult CreateStorageLocation(ProcureVM model) { IProcure obj = new Procure(); var checkduplicate = obj.GetSL().Where(x => x.City == model.City && x.StorageLocation == model.StorageLocation).FirstOrDefault(); if (checkduplicate == null) { var add = obj.AddSL(model.City, model.StorageLocation); obj.AddStore(add); obj.Save(); var add1 = obj.addslinstock(add.SLId); obj.addstocksl(add1); obj.Save(); var cityname = new SelectList(new[] { new { ID = "1", Name = "Lahore" }, new { ID = "2", Name = "Islamabad" }, new { ID = "2", Name = "Karachi" } }, "Name", "Name", "1" ); ViewBag.getcitylist = cityname; TempData["SuccessMessage1"] = "Successfully Created"; return(RedirectToAction("ViewStorageLocation", "Admin")); } else { var cityname = new SelectList(new[] { new { ID = "1", Name = "Lahore" }, new { ID = "2", Name = "Islamabad" }, new { ID = "2", Name = "Karachi" } }, "Name", "Name", "1" ); ViewBag.getcitylist = cityname; TempData["ErrorMessage1"] = "Storage Location" + model.StorageLocation + " already exists in City " + model.City + ""; } return(View()); }
public ActionResult SetDocRange(ProcureVM model) { IProcure obj = new Procure(); var checkrangeduplicate = obj.GetDoctypes().Where(x => x.DocumentType == "PR").Where(b => b.NumberRangefrom == model.Docnumberfrom || b.NumberRangeTo == model.DocnumberTo).FirstOrDefault(); var checkrangeduplicate1 = obj.GetDoctypes().Where(x => x.DocumentType == "PO").Where(b => b.NumberRangefrom == model.Docnumberfrom || b.NumberRangeTo == model.DocnumberTo).FirstOrDefault(); if (checkrangeduplicate == null || checkrangeduplicate1 == null) { obj.UpdateDocType(model.TypeId, model.Docnumberfrom, model.DocnumberTo); obj.Save(); TempData["UpdateMessage3"] = "Successfully Updated"; } else { TempData["ErrorMessage1"] = "Document Number Range matches other Document Number Range"; } return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult EditItems(ProcureVM model) { IProcure obj = new Procure(); var ItemType = obj.Getitemtype().ToList(); var SL = obj.GetSL().ToList(); SelectList list = new SelectList(ItemType, "Id", "ItemType"); ViewBag.getItemtypelist = list; SelectList lists = new SelectList(SL, "StorageLocation", "StorageLocation"); ViewBag.getSLlist = lists; obj.UpdateItem(model.ItemId, model.ItemName, model.TypeId, model.StorageLocation, model.ItemPrice, model.ReorderPoint); obj.Save(); TempData["SuccessMessage1"] = "Successfully Updated"; return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult EditSL(ProcureVM model) { IProcure obj = new Procure(); var cityname = new SelectList(new[] { new { ID = "1", Name = "Lahore" }, new { ID = "2", Name = "Islamabad" }, new { ID = "2", Name = "Karachi" } }, "Name", "Name", "1" ); ViewBag.getcitylist = cityname; obj.UpdateSL(model.SlId, model.City, model.StorageLocation); obj.Save(); TempData["SuccessMessage1"] = "Successfully Updated"; return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateItems(ProcureVM model, FormCollection form) { IProcure obj = new Procure(); SetDocNumber doc = new SetDocNumber(); var ItemType = obj.Getitemtype().ToList(); var SL = obj.GetSL().ToList(); var valide = obj.Getitems().Where(x => x.ItemName == model.ItemName).FirstOrDefault(); var validatetype = obj.Getitems().Where(x => x.TypeId == model.TypeId && x.ItemName == model.ItemName).FirstOrDefault(); if (valide == null && validatetype == null) { SelectList list = new SelectList(ItemType, "Id", "ItemType"); ViewBag.getItemtypelist = list; SelectList lists = new SelectList(SL, "StorageLocation", "StorageLocation"); ViewBag.getSLlist = lists; var chkconsume = form["getonetime"]; var isconusmable = Convert.ToInt32(chkconsume); var add = obj.Additem(model.TypeId, model.ItemName, model.StorageLocation, isconusmable, model.ReorderPoint, model.ItemPrice); obj.Additems(add); obj.Save(); TempData["SuccessMessage1"] = "Successfully Created"; } else { SelectList list = new SelectList(ItemType, "ItemType", "ItemType"); ViewBag.getItemtypelist = list; SelectList lists = new SelectList(SL, "StorageLocation", "StorageLocation"); ViewBag.getSLlist = lists; TempData["ErrorMessage1"] = "Item" + model.ItemName + " already exists in Item Type " + model.ItemType + ""; } return(View()); }