public ActionResult Update(string id, string name, DateTime birth, string sex, string password, string rpassword) { HOTELEntities db = new HOTELEntities(); if (id != "" && password != "" && rpassword == password) { bool isHaved = false; foreach (user u in db.users) { if (u.userid.Replace(" ", "") == id) { isHaved = true; break; } } if (isHaved == false) { user tmp = new user(); tmp.userid = id; tmp.username = name; tmp.userpassword = password; tmp.userbirth = birth; tmp.usersex = sex; db.users.Add(tmp); db.SaveChanges(); } } return(RedirectToAction("Index", "Home")); }
//Constructer public AdministratorView(administrator administrator) { HOTELEntities db = new HOTELEntities(); id = administrator.administratorid.Replace(" ", ""); name = administrator.administratorname; birth = administrator.administratorbirth.ToString().Replace("12:00:00 AM", string.Empty); sex = administrator.administratorsex; authorizationID = administrator.authorizationid; password = administrator.administratorpassword; authorizationName = db.authorizations.Find(administrator.authorizationid).authorizationname; }
//Static Method (Function) /// <summary> /// Get administrator back from database and insert to a List<AdministratorView> /// </summary> /// <returns></returns> public static List <AdministratorView> PullAdministrator(int count) { HOTELEntities db = new HOTELEntities(); List <administrator> tmp = db.administrators.ToList(); List <AdministratorView> administrators = new List <AdministratorView>(); foreach (administrator a in tmp) { AdministratorView ticketView = new AdministratorView(a); administrators.Add(ticketView); } return(administrators); }
//Static Method (Function) /// <summary> /// Get ticked back from database and insert to a List<TicketView> /// </summary> /// <returns></returns> public static List <TicketView> PullTicket(int count) { HOTELEntities db = new HOTELEntities(); List <ticket> tmp = db.tickets.OrderByDescending(t => t.datestart).Take(count).ToList(); List <TicketView> tickets = new List <TicketView>(); foreach (ticket t in tmp) { TicketView ticketView = new TicketView(t); tickets.Add(ticketView); } return(tickets); }
//Constructer public TicketView(ticket ticket) { HOTELEntities db = new HOTELEntities(); id = ticket.ticketid; date = ticket.ticketdate.ToShortDateString(); dateStart = ticket.datestart.ToShortDateString(); dateEnd = ticket.expectdateend.ToString().Replace("12:00:00 AM", string.Empty); hotelID = ticket.hotelid; hotelName = db.hotels.Find(ticket.hotelid).hotelname; userID = ticket.userid; userName = db.users.Find(ticket.userid).username; }