public ActionResult Login(User usr) { using (EmployeeEntities1 db = new EmployeeEntities1()) { var user = db.Employees.Where(x => x.Username == usr.Username && x.Password == usr.Password).FirstOrDefault(); if (user == null) { usr.Loginerror = "Wrong username or password"; return(RedirectToAction("Index", usr)); } else { if (usr.Username == "admin") { Session["user"] = usr.Username; return(RedirectToAction("Index", "Employee")); } else { Session["user"] = usr.Username; return(RedirectToAction("Nuser", "Employee")); } } } }
public object createcontact(Registration Lvm) { try { EmployeeEntities1 db = new EmployeeEntities1(); Employeemaster Em = new Employeemaster(); if (Em.UserId == 0) { Em.UserName = Lvm.UserName; Em.LoginName = Lvm.LoginName; Em.Password = Lvm.Password; Em.Email = Lvm.Email; Em.ContactNo = Lvm.ContactNo; Em.Address = Lvm.Address; Em.IsApporved = Lvm.IsApporved; Em.Status = Lvm.Status; db.Employeemasters.Add(Em); db.SaveChanges(); return(new Response { Status = "Success", Message = "SuccessFully Saved." }); } } catch (Exception) { throw; } return(new Response { Status = "Error", Message = "Invalid Data." }); }
public IEnumerable <EmployeeDetail> Get() { using (var employeeDBEntities = new EmployeeEntities1()) { var emp = employeeDBEntities.EmployeeDetails.ToList(); return(emp); } }
// POST: api/Employee public void Post([FromBody] EmployeeDetail empDetail) { using (var employeeDBEntities = new EmployeeEntities1()) { employeeDBEntities.EmployeeDetails.Add(empDetail); employeeDBEntities.SaveChanges(); } }
public ActionResult Viewchekin(Checkin cm) { EmployeeEntities1 EE = new EmployeeEntities1(); List <Checkin> RList = EE.Checkins.ToList(); return(View(RList)); }
// GET: api/Employee/5 public EmployeeDetail Get(int id) { using (var employeeDBEntities = new EmployeeEntities1()) { var employee = employeeDBEntities.EmployeeDetails.FirstOrDefault(e => e.Id == id); if (employee == null) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound)); } return(employee); } }
public Response Login(Login Lg) { EmployeeEntities1 DB = new EmployeeEntities1(); var Obj = DB.Usp_Login(Lg.UserName, Lg.Password).ToList <Usp_Login_Result>().FirstOrDefault(); //if (Obj.Status == 0) // return new Response { Status = "Invalid", Message = "Invalid User." }; //if (Obj.Status == -1) // return new Response { Status = "Inactive", Message = "User Inactive." }; //else return(new Response { Status = "Success", Message = Lg.UserName }); }
public ActionResult Login(UserDetail user) { EmployeeEntities1 db = new EmployeeEntities1(); var userinfo = db.UserDetails.Where(s => s.UserName == user.UserName).FirstOrDefault(); if (userinfo != null) { var validuser = db.UserDetails.Where(s => s.Password == user.Password).FirstOrDefault(); if (validuser != null) { FormsAuthentication.SetAuthCookie(user.UserName, false); return(RedirectToAction("UserDashBoard")); } else { return(View()); } } return(View()); }
public ActionResult Index1(string Name) { EmployeeEntities1 entities = new EmployeeEntities1(); return(View(entities.Customers_Search(Name))); }
public ActionResult CheckIn(FormCollection form) { Checkin cm = new Checkin(); EmployeeEntities1 EE = new EmployeeEntities1(); List <Checkin> RList = EE.Checkins.ToList(); Available_Rooms = RList.Count(); cm.GuestName = form["Guestname"]; cm.contact = Convert.ToInt32(form["contact"]); cm.address = form["address"]; string RoomType = form["RoomType"]; cm.quantity = Convert.ToInt32(form["quantity"]); cm.Total_days = Convert.ToInt32(form["Total_days"]); if (rd.RoomType == "Standard" && cm.quantity < Available_Rooms) { Available_Rooms = Available_Rooms - cm.quantity; cm.bill = cm.quantity * 1000 * cm.Total_days; } else { Response.AppendToLog("Rooms quantity not available"); } if (rd.RoomType == "Premium" && cm.quantity < Available_Rooms) { Available_Rooms = Available_Rooms - cm.quantity; cm.bill = cm.quantity * 2000 * cm.Total_days; } else { Response.AppendToLog("Rooms quantity not available"); } if (rd.RoomType == "Delux" && cm.quantity < Available_Rooms) { Available_Rooms = Available_Rooms - cm.quantity; cm.bill = cm.quantity * 1000 * cm.Total_days; } else { Response.AppendToLog("Rooms quantity not available"); } if (ModelState.IsValid) { try { db.Checkins.Add(cm); db.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult item in ex.EntityValidationErrors) { // Get entry DbEntityEntry entry = item.Entry; string entityTypeName = entry.Entity.GetType().Name; // Display or log error messages foreach (DbValidationError subItem in item.ValidationErrors) { string message = "Error"; Console.WriteLine(message); } } } } return(View()); }