public ActionResult CreateVendors()
{
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;
return(View());
}
public ActionResult GetItems(int?id)
{
IProcure obj = new Procure();
var ap = (from d in obj.Getitems()
where d.ItemId == id
select new
{
d.ItemId,
d.ItemName,
d.ItemPrice,
d.StorageLocation,
d.ReorderPoint
}).Select(c => new ProcureVM()
{
ItemId = c.ItemId,
ItemName = c.ItemName,
ItemPrice = (decimal)c.ItemPrice,
StorageLocation = c.StorageLocation,
ReorderPoint = (int)c.ReorderPoint
}).FirstOrDefault();
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;
return(PartialView("EditItemsPartial", ap));
}
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 ActionResult GetSLforEdit(int?id)
{
IProcure obj = new Procure();
var ap = (from d in obj.GetSL()
where d.SLId == id
select new
{
d.SLId,
d.City,
d.StorageLocation
}).Select(c => new ProcureVM()
{
SlId = c.SLId,
StorageLocation = c.StorageLocation
}).FirstOrDefault();
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;
return(PartialView("EditStorageLocationPartial", ap));
}
public decimal getExp()
{
IEmployeeRepository obj = new EmployeeRepository();
IProcure repo = new Procure();
int month = DateTime.Now.Month;
int year = DateTime.Now.Year;
decimal id;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString))
{
con.Open();
var check = repo.Getexp().Where(x => x.Month == month.ToString() && x.Year == year).FirstOrDefault();
if (check != null)
{
String s = "select Sum(Amount) as Total from tblExpenses where Month=" + month + " and Year=" + year + "";
SqlCommand smd = new SqlCommand(s, con);
id = (decimal)smd.ExecuteScalar();
}
else
{
id = 0;
}
}
return(id);
}
public ActionResult ReturnReport(int?id)
{
IProcure obj = new Procure();
var data = (from doc in obj.GetDoc()
join v in obj.GetVendor() on doc.VendorId equals v.VendorId
where doc.DocumentNo == id
select new
{
doc.DocumentNo,
doc.Docno,
doc.CreationDate,
doc.CreatedBy,
doc.Reasonofreturn,
v.VendorName,
doc.GRReferencenoforReturn
}).Select(x => new ProcureVM()
{
Grno = x.Docno,
Createdon = (DateTime)x.CreationDate,
Createdby = x.CreatedBy,
VendorName = x.VendorName,
Reasonofreturn = x.Reasonofreturn,
grref = (int)x.GRReferencenoforReturn,
IRDetails = GetReturnDetails(id)
}).FirstOrDefault();
Report _report = new Report();
byte[] abytes = _report.PrepareReturnReport(data);
return(File(abytes, "application/pdf"));
}
public ActionResult PRReport(int?id)
{
IProcure obj = new Procure();
var data = (from doc in obj.GetDoc()
join v in obj.GetVendor() on doc.VendorId equals v.VendorId
where doc.DocumentNo == id
select new
{
doc.DocumentNo,
doc.Docno,
doc.CreationDate,
doc.CreatedBy,
v.VendorName,
doc.ItemRequestedDate
}).Select(x => new ProcureVM()
{
Grno = x.Docno,
Createdon = (DateTime)x.CreationDate,
Createdby = x.CreatedBy,
VendorName = x.VendorName,
RequestedDate = (DateTime)x.ItemRequestedDate,
IRDetails = GetPRDetails(id)
}).FirstOrDefault();
Report _report = new Report();
byte[] abytes = _report.PreparePRReport(data);
return(File(abytes, "application/pdf"));
}
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 JsonResult GetStockList()
{
IProcure obj = new Procure();
var Data = (from i in obj.Getitems()
select new
{
i.ItemName,
i.Availablestock,
i.Qualityinspectionstock
}).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetitemtypeList()
{
IProcure obj = new Procure();
var Data = (from type in obj.Getitemtype()
select new
{
type.ItemType,
type.Id
}).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDocList()
{
IProcure obj = new Procure();
var Data = (from doc in obj.GetDoc()
join t in obj.GetDoctypes() on doc.DTypeId equals t.TypeId
where doc.DTypeId != 6
select new
{
doc.Docno,
t.DocumentType,
doc.DocumentNo
}).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetSlList()
{
IProcure obj = new Procure();
var Data = (from Sl in obj.GetSL()
select new
{
Sl.City,
Sl.StorageLocation,
Sl.SLId
}).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDoctypeList()
{
IProcure obj = new Procure();
var Data = (from d in obj.GetDoctypes()
select new
{
d.TypeId,
d.DocumentType,
d.DocumentName,
d.NumberRangefrom,
d.NumberRangeTo
}).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult ViewItems()
{
IProcure obj = new Procure();
var ItemType = obj.Getitemtype().ToList();
var SL = obj.GetSL().ToList();
SelectList list = new SelectList(ItemType, "ItemType", "ItemType");
ViewBag.getItemtypelist = list;
SelectList lists = new SelectList(SL, "StorageLocation", "StorageLocation");
ViewBag.getSLlist = lists;
return(View());
}
public JsonResult PostQuantityItemsRejected(int GrDocno, int item, int qty)
{
IProcure obj = new Procure();
if (item == 0)
{
return(Json(new { message = "Please Add Quantity greater than zero" }, JsonRequestBehavior.AllowGet));
}
else
{
obj.updategrlineforrdquality(GrDocno, item, qty);
obj.Save();
return(Json(JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetReturnlistforGR()
{
IProcure repo = new Procure();
var Data = (from u in repo.GetDoc()
join doctype in repo.GetDoctypes() on u.DTypeId equals doctype.TypeId
join v in repo.GetVendor() on u.VendorId equals v.VendorId
where u.DocStatus == "Complete" && u.DTypeId == 5 && (u.Status == "InProgress" || u.Status == "Partial Delivery")
select new
{
u.DocumentNo,
u.Docno,
doctype.DocumentType,
v.VendorName,
u.DeliveryDate
}).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetitemList()
{
IProcure obj = new Procure();
var Data = (from item in obj.Getitems()
join type in obj.Getitemtype() on item.TypeId equals type.Id
select new
{
type.ItemType,
item.ItemName,
item.StorageLocation,
item.ItemPrice,
item.ItemId
}).ToList();
return(Json(new { data = Data }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetItemTypes(int?id)
{
IProcure obj = new Procure();
var ap = (from d in obj.Getitemtype()
where d.Id == id
select new
{
d.Id,
d.ItemType
}).Select(c => new ProcureVM()
{
Id = c.Id,
ItemType = c.ItemType
}).FirstOrDefault();
return(PartialView("EditItemTypePartial", ap));
}
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 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 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 GetDocTypes(int?id)
{
IProcure obj = new Procure();
var ap = (from d in obj.GetDoctypes()
where d.TypeId == id
select new
{
d.TypeId,
d.DocumentType,
d.DocumentName,
d.NumberRangefrom,
d.NumberRangeTo
}).Select(c => new ProcureVM()
{
TypeId = c.TypeId,
DocType = c.DocumentType,
Docnumberfrom = (int)c.NumberRangefrom,
DocnumberTo = (int)c.NumberRangeTo
}).FirstOrDefault();
return(PartialView("SetDocRangePartial", ap));
}
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());
}
