// GET: Leave public ActionResult Index() { using (inventorymgtEntities inventorymgtEntities = new inventorymgtEntities()) { return(View(inventorymgtEntities.leaves.ToList())); } }
// GET: Attendance public ActionResult Index() { using (inventorymgtEntities inventorymgtEntities = new inventorymgtEntities()) { return(View(inventorymgtEntities.attendance_emp.ToList())); } }
// GET: Trainer/Edit/5 public ActionResult Edit(int id) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { return(View(dbModel.trainers.Where(x => x.PaymentID == id).FirstOrDefault())); } }
public ActionResult addOrEdit(user userModel) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { if (dbModel.users.Any(x => x.email == userModel.email)) { ViewBag.DuplicateMsg = "Your Email is already exist."; return(View("addOrEdit", userModel)); } if (userModel.gender == "Male") { userModel.img_path = "~/image/male.png"; } else if (userModel.gender == "Female") { userModel.img_path = "~/image/female.png"; } dbModel.users.Add(userModel); dbModel.SaveChanges(); } ViewBag.SuccessMessage = "Registration Successful."; ModelState.Clear(); user user = new user(); return(View("addOrEdit", user)); }
// GET: Attendance/Details/5 public ActionResult Details(int id) { using (inventorymgtEntities inventorymgtEntities = new inventorymgtEntities()) { return(View(inventorymgtEntities.attendance_emp.Where(x => x.empId == id).FirstOrDefault())); } }
// GET: Leave/Edit/5 public ActionResult Edit(int id) { using (inventorymgtEntities inventorymgtEntities = new inventorymgtEntities()) { return(View(inventorymgtEntities.leaves.Where(x => x.empId == id).FirstOrDefault())); } }
public ActionResult Verify(Inventory_management.Models.login userModel) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { var pass = userModel.password_; var userDetails = dbModel.users.Where(x => x.email == userModel.username).FirstOrDefault(); if (userDetails == null) { userModel.status_ = "Invalid User Credentials."; return(View("Login", userModel)); } else if (userDetails.email.Equals("*****@*****.**") && userDetails.password_.Equals("1202")) { return(View("~/Views/Search/Index.cshtml")); } else { Session["userID"] = userDetails.regId; Session["user"] = userDetails.fname; return(View("Welcome")); } } }
// GET: Schedule/Edit/5 public ActionResult Edit(int id) { using (inventorymgtEntities db = new inventorymgtEntities()) { return(View(db.schedules.Where(x => x.ID == id).FirstOrDefault())); } }
public ActionResult Details(user user) { try { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { string filename = user.fname.ToLower() + "_" + user.lname.ToLower(); string extension = Path.GetExtension(user.ImageFile.FileName); filename = filename + DateTime.Now.ToString("yymmssfff") + extension; user.img_path = "~/image/" + filename; filename = Path.Combine(Server.MapPath("~/image/"), filename); user.ImageFile.SaveAs(filename); dbModel.Entry(user).State = EntityState.Modified; dbModel.SaveChanges(); } return(RedirectToAction("Details", new { id = user.regId })); } catch (Exception e) { Response.Write(e.StackTrace.ToString()); return(RedirectToAction("Details", new { id = user.regId })); } }
public ActionResult Reorder() { using (inventorymgtEntities in1 = new inventorymgtEntities()) { return(View(in1.inventories.ToList().Where(x => x.quantity < 5 && x.catergory.Equals("Store")))); } }
// GET: Inventory/Delete/5 public ActionResult Delete(int id) { using (inventorymgtEntities invtModel = new inventorymgtEntities()) { return(View(invtModel.inventories.Where(x => x.itemCode == id).FirstOrDefault())); } }
// GET: Member/Details/5 public ActionResult Details(int id) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { return(View(dbModel.members.Where(x => x.PaymentId == id).FirstOrDefault())); } }
// GET: Schedule/Delete/5 public ActionResult Delete(int id = 0) { using (inventorymgtEntities mv = new inventorymgtEntities()) { return(View(mv.schedules.Where(x => x.ID == id).FirstOrDefault())); } }
//new Comment added //DBMod dbs = new DBMod(); //public ActionResult New() //{ // var employeelist = dbs.employees.ToList(); // var viewModel = new NewScheduleViewModel // { // employeeType = employeelist // }; // return View(viewModel); //} //private static List<SelectListItem> Getemployee() //{ // DBMod db = new DBMod(); // List<SelectListItem> employeelist = (from e in db.employees.AsEnumerable() // where e.Shift == "Morning" // select new SelectListItem // { // Text = e.Name, // Value = e.EmpID.ToString() // }).ToList(); // employeelist.Insert(0, new SelectListItem { Text = "Select Trainer", Value = "" }); // return employeelist; //} // GET: Schedule public ActionResult Index() { using (inventorymgtEntities mv = new inventorymgtEntities()) { return(View(mv.schedules.ToList())); } }
// GET: Employee/Edit/5 public ActionResult Edit(int id) { using (inventorymgtEntities empModel = new inventorymgtEntities()) { return(View(empModel.employees.Where(x => x.empId == id).FirstOrDefault())); } }
// GET: Employee public ActionResult Index() { using (inventorymgtEntities employeeModels = new inventorymgtEntities()) { return(View(employeeModels.employees.ToList())); } }
public ActionResult Edit(int id, schedule sc) { try { using (inventorymgtEntities db = new inventorymgtEntities()) { db.Entry(sc).State = EntityState.Modified; if (sc.Image == null) { var scheduleContext = db.Entry(sc); scheduleContext.State = EntityState.Modified; var clientValues = scheduleContext.CurrentValues.Clone().ToObject(); scheduleContext.Reload(); scheduleContext.CurrentValues.SetValues(clientValues); var currentValues = scheduleContext.Entity; var databaseValues = (schedule)scheduleContext.OriginalValues.ToObject(); scheduleContext.Entity.Image = databaseValues.Image; } db.SaveChanges(); } // TODO: Add update logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Attendance(int id) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { var userDetails = dbModel.users.Where(x => x.regId == id).FirstOrDefault(); var atndDetails = dbModel.attendances.Where(x => x.user_ == id).FirstOrDefault(); //if (DateTime.Now.Date > atndDetails.date_) DateTime dt = DateTime.Parse(atndDetails.date_); if (DateTime.Now.Date.CompareTo(dt) > 0) { atndDetails.status_ = "false"; dbModel.Entry(atndDetails).State = EntityState.Modified; dbModel.SaveChanges(); } int cdays = (int)atndDetails.no_of_days; Session["username"] = userDetails.fname + " " + userDetails.lname; Session["userId"] = userDetails.regId; Session["progress"] = (100 / 45) * cdays; Session["rDays"] = 45 - cdays; return(View(dbModel.attendances.Where(x => x.user_ == id).FirstOrDefault())); } }
// GET: Bill/Edit/5 public ActionResult Edit(int id) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { return(View(dbModel.bills.Where(x => x.billId == id).FirstOrDefault())); } }
// GET: Inventory/Delete/5 public ActionResult Delete(int id) { using (inventorymgtEntities dbmodel = new inventorymgtEntities()) { return(View(dbmodel.inventory_pay.Where(x => x.paymentId == id).FirstOrDefault())); } }
// GET: Inventory public ActionResult Index() { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { return(View(dbModel.inventory_pay.ToList())); } }
public ActionResult Details(int id) { using (inventorymgtEntities employeeModels = new inventorymgtEntities()) { //return View(employeeModels.salaries.ToList()); return(View()); } }
public ActionResult getUsers() { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { var users = dbModel.users.OrderBy(model => model.fname).ToList(); return(Json(new { data = users }, JsonRequestBehavior.AllowGet)); } }
// GET: Member public ActionResult Index() { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { // List<bill> lst = new List<bill>(); // lst = dbModel.bills.ToList(); return(View(dbModel.members.ToList())); } }
// GET: Bill public ActionResult Index() { using (inventorymgtEntities dbmodel = new inventorymgtEntities()) { List <bill> lst = new List <bill>(); lst = dbmodel.bills.ToList(); return(View(lst)); } }
// GET: Schedule/Details/5 public ActionResult Details(int id) { schedule sc = new schedule(); using (inventorymgtEntities db = new inventorymgtEntities()) { sc = db.schedules.Where(m => m.ID == id).FirstOrDefault(); } return(View(sc)); }
public ActionResult Attendance(int id) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { var userDetails = dbModel.users.Where(x => x.regId == id).FirstOrDefault(); var atndDetails = dbModel.attendances.Where(x => x.user_ == id).FirstOrDefault(); //if (DateTime.Now.Date > atndDetails.date_) DateTime dt = DateTime.Parse(atndDetails.date_); if (DateTime.Now.Date.CompareTo(dt) > 0) { atndDetails.status_ = "false"; dbModel.Entry(atndDetails).State = EntityState.Modified; dbModel.SaveChanges(); } int cdays = (int)atndDetails.no_of_days; int sPlan = 0; if (userDetails != null && userDetails.shedule != null) { if (userDetails.shedule.ToString() == "D30") { sPlan = 30; } else if (userDetails.shedule.ToString() == "D40") { sPlan = 40; } else if (userDetails.shedule.ToString() == "D45") { sPlan = 45; } else { sPlan = 50; } } Session["username"] = userDetails.fname + " " + userDetails.lname; Session["userId"] = userDetails.regId; Session["progress"] = ((double)cdays / (double)sPlan) * 100 /*/(100 / 45) * cdays*/; Session["rDays"] = sPlan - cdays; return(View(dbModel.attendances.Where(x => x.user_ == id).FirstOrDefault())); } }
public ActionResult viewUser(int id) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { var usr = dbModel.users.Where(a => a.regId == id).FirstOrDefault(); if (usr != null) { return(View(usr)); } else { return(HttpNotFound()); } } }
public ActionResult deleteUser(int id) { bool status = false; using (inventorymgtEntities dbModel = new inventorymgtEntities()) { var usr = dbModel.users.Where(a => a.regId == id).FirstOrDefault(); if (usr != null) { dbModel.users.Remove(usr); dbModel.SaveChanges(); status = true; } return(RedirectToAction("Index")); } }
public ActionResult Create(inventory invent) { try { using (inventorymgtEntities invtModel = new inventorymgtEntities()) { invtModel.inventories.Add(invent); invtModel.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }