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());
}
