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;
}
