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