// GET: PurchaseOrder/Details/5
public ActionResult OrderDetails(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.PurchaseOrders.Where(x => x.PurchaseOrderId == id).FirstOrDefault()));
}
}
// GET: Item/Details/5
public ActionResult ItemDetails(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.Items.Where(x => x.ItemId == id).FirstOrDefault()));
}
}
// GET: PurchaseOrderItems
public ActionResult PurchaseItems()
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.PurchaseOrderItems.ToList()));
}
}
// GET: Item
public ActionResult getItems()
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.Items.ToList()));
}
}
// GET: Policy
public ActionResult Policies()
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.Policies.ToList()));
}
}
public ActionResult saveuser(int id, string propertyName, string value)
{
var status = false;
var message = "";
//Update data to database
using (sithar_dbEntities1 dc = new sithar_dbEntities1())
{
var user = dc.ConstructorRequests.Find(id);
if (user != null)
{
dc.Entry(user).Property(propertyName).CurrentValue = value;
dc.SaveChanges();
status = true;
}
else
{
message = "Error!";
}
}
var response = new { value = value, status = status, message = message };
JObject o = JObject.FromObject(response);
return(Content(o.ToString()));
}
// GET: Log/Edit/5
public ActionResult EditLog(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.Logs.Where(x => x.LogId == id).FirstOrDefault()));
}
}
// GET: AuthEmployee/Delete/5
public ActionResult DeleteEmployee(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.AuthEmployees.Where(x => x.AuthEmployeeId == id).FirstOrDefault()));
}
}
// GET: SiteItemQuantity
public ActionResult SiteItemQty()
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.SiteItemQuantities.ToList()));
}
}
// GET: AuthEmployee
public ActionResult getEmployees()
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.AuthEmployees.ToList()));
}
}
// GET: Policy/Delete/5
public ActionResult DeletePolicy(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.Policies.Where(x => x.PolicyId == id).FirstOrDefault()));
}
}
// GET: ConstructorRequest
public ActionResult getConRequest()
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.ConstructorRequests.ToList()));
}
}
// GET: GoodReceipt/Details/5
public ActionResult getDetails(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.GoodReceipts.Where(x => x.GoodReceiptId == id).FirstOrDefault()));
}
}
// GET: SupplierItemPrice/Edit/5
public ActionResult EditSupItemPrice(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.SupplierItemPrices.Where(x => x.SupplierItemPriceId == id).FirstOrDefault()));
}
}
// GET: PurchaseOrderItems/Edit/5
public ActionResult UpdatePurchaseItem(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.PurchaseOrderItems.Where(x => x.PurchaseOrderItemsId == id).FirstOrDefault()));
}
}
// GET: Supplier
public ActionResult getSuppliers()
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.Suppliers.ToList()));
}
}
// GET: ConstructorRequest/Delete/5
public ActionResult DeleteRequest(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.ConstructorRequests.Where(x => x.ConstructorRequestId == id).FirstOrDefault()));
}
}
// GET: Supplier/Delete/5
public ActionResult DeleteSupplier(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.Suppliers.Where(x => x.SupplierId == id).FirstOrDefault()));
}
}
// GET: SiteItemQuantity/Edit/5
public ActionResult UpdateSiteItemQty(int id)
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.SiteItemQuantities.Where(x => x.SiteItemQuantityId == id).FirstOrDefault()));
}
}
// GET: GoodReceipt
public ActionResult getReceipts()
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
return(View(db.GoodReceipts.ToList()));
}
}
// GET: SupplierItemPrice/Create
public ActionResult AddSupItemPrice()
{
SupplierItemPrice sip = new SupplierItemPrice();
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
sip.ItemCollection = db.Items.ToList <Item>();
}
return(View(sip));
}
// GET: PurchaseOrderItems/Create
public ActionResult AddPurchaseItem()
{
PurchaseOrderItem poi = new PurchaseOrderItem();
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
poi.ItemCollection = db.Items.ToList <Item>();
}
return(View(poi));
}
// GET: SiteItemQuantity/Create
public ActionResult AddSiteItemQty()
{
SiteItemQuantity siq = new SiteItemQuantity();
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
siq.ItemCollection = db.Items.ToList <Item>();
}
return(View(siq));
}
// GET: ShowData
public ActionResult MultiData()
{
sithar_dbEntities1 obj = new sithar_dbEntities1();
var MyModel = new Multiple();
MyModel.pol = obj.Policies.ToList();
MyModel.conreq = obj.ConstructorRequests.ToList();
return(View(MyModel));
}
public ActionResult UpdateSiteItemQty(int id, SiteItemQuantity siq)
{
try
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
db.Entry(siq).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
// TODO: Add update logic here
return(RedirectToAction("SiteItemQty"));
}
catch
{
return(View());
}
}
public ActionResult UpdateSupplier(int id, Supplier sup)
{
try
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
db.Entry(sup).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
// TODO: Add update logic here
return(RedirectToAction("getSuppliers"));
}
catch
{
return(View());
}
}
public ActionResult AddSupplier(Supplier sup)
{
try
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
db.Suppliers.Add(sup);
db.SaveChanges();
}
// TODO: Add insert logic here
return(RedirectToAction("getSuppliers"));
}
catch
{
return(View());
}
}
public ActionResult AddPolicy(Policy pol)
{
try
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
db.Policies.Add(pol);
db.SaveChanges();
}
// TODO: Add insert logic here
return(RedirectToAction("Policies"));
}
catch
{
return(View());
}
}
public ActionResult IssueReceipt(GoodReceipt gr)
{
try
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
db.GoodReceipts.Add(gr);
db.SaveChanges();
}
// TODO: Add insert logic here
return(RedirectToAction("Initial"));
}
catch
{
return(View());
}
}
public ActionResult UpdatePolicy(int id, Policy pol)
{
try
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
db.Entry(pol).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
// TODO: Add update logic here
return(RedirectToAction("Policies"));
}
catch
{
return(View());
}
}