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