public static Boolean Delete(string maID)
{
SqlCommand cmd = new SqlCommand("delete Manager where maID=@maID");
cmd.Parameters.AddWithValue("@maID", maID);
return(DAO.UpdateTable(cmd));
}
public static Boolean Delete(int requestID)
{
SqlCommand cmd = new SqlCommand("delete Request where requestID=@requestID");
cmd.Parameters.AddWithValue("@requestID", requestID);
return(DAO.UpdateTable(cmd));
}
public static Boolean Delete(int id)
{
SqlCommand cmd = new SqlCommand("delete HistoryPayment where id=@id");
cmd.Parameters.AddWithValue("@id", id);
return(DAO.UpdateTable(cmd));
}
public static Boolean DeleteRoom(string roomName)
{
SqlCommand cmd = new SqlCommand("delete Room where roomName=@roomName");
cmd.Parameters.AddWithValue("@roomName", roomName);
return(DAO.UpdateTable(cmd));
}
public static Boolean Delete(string stuID)
{
SqlCommand cmd = new SqlCommand("delete Student where stuID=@stuID");
cmd.Parameters.AddWithValue("@stuID", stuID);
return(DAO.UpdateTable(cmd));
}
public static bool Delete(ElectricityWaterBills ewb)
{
string sql = "delete ElectricityWaterBills where id = @id";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@id", ewb.Id);
return(DAO.UpdateTable(cmd));
}
public static Boolean DeleteBedNo(string roomName, int bedNo)
{
SqlCommand cmd = new SqlCommand("delete Bed where bedNo=@bedNo AND roomName=@roomName");
cmd.Parameters.AddWithValue("@bedNo", bedNo);
cmd.Parameters.AddWithValue("@roomName", roomName);
return(DAO.UpdateTable(cmd));
}
public static bool Delete(HistoryBook hb)
{
string sql = "delete HistoryBook where bookID = @bookID";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@bookID", hb.BookID);
return(DAO.UpdateTable(cmd));
}
public static bool Delete(Account a)
{
string sql = "delete Account where username = @username and type = @type";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@username", a.Username);
cmd.Parameters.AddWithValue("@type", a.Type);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Account a) // Co update quyen cua user ko?
{
string sql = "update Account set [password] = @password where username = @username and type = @type";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@password", a.Password);
cmd.Parameters.AddWithValue("@username", a.Username);
cmd.Parameters.AddWithValue("@type", a.Type);
return(DAO.UpdateTable(cmd));
}
// Unused
public static bool Insert(Account a)
{
string sql = "insert into Account (username, [password], [type]) values(@username, @password, @type)";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@username", a.Username);
cmd.Parameters.AddWithValue("@password", a.Password);
cmd.Parameters.AddWithValue("@type", a.Type);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Request b)
{
SqlCommand cmd = new SqlCommand("update Request set maID=@maID,dateReply=@dateReply,reply=@reply where requestID=@requestID");
cmd.Parameters.AddWithValue("@maID", b.MaID);
cmd.Parameters.AddWithValue("@dateReply", b.DateReply);
cmd.Parameters.AddWithValue("@reply", b.Reply);
cmd.Parameters.AddWithValue("@requestID", b.RequestID);
return(DAO.UpdateTable(cmd));
}
public static bool Update(ElectricityWaterBills ewb)
{
string sql = "update ElectricityWaterBills set soDien = @soDien, soNuoc = @soNuoc, paid = @paid where id = @id";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@id", ewb.Id);
cmd.Parameters.AddWithValue("@soDien", ewb.SoDien);
cmd.Parameters.AddWithValue("@soNuoc", ewb.SoNuoc);
cmd.Parameters.AddWithValue("@paid", ewb.Paid);
return(DAO.UpdateTable(cmd));
}
public static bool Update(AvailibleBookingTime abt)
{
string sql = "update AvailibleBookingTime set [from] = @from, [to] = @to where adID = @adID";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@from", abt.From);
cmd.Parameters.AddWithValue("@to", abt.To);
cmd.Parameters.AddWithValue("@adID", abt.AdID);
return(DAO.UpdateTable(cmd));
}
public static bool Update(HistoryPayment b)
{
SqlCommand cmd = new SqlCommand("update HistoryPayment set datePay=@datePay, type = @type, moneyPay = @moneyPay,roomName = @roomName where id=@id");
cmd.Parameters.AddWithValue("@datePay", b.DatePay);
cmd.Parameters.AddWithValue("@type", b.Type);
cmd.Parameters.AddWithValue("@moneyPay", b.MoneyPay);
cmd.Parameters.AddWithValue("@roomName", b.RoomName);
cmd.Parameters.AddWithValue("@id", b.Id);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Room b)
{
SqlCommand cmd = new SqlCommand("update Room set gender=@gender,price=@price where roomName=@roomName;update Bed set status=@status where roomName=@roomName1 AND bedNo=@bedNo;");
cmd.Parameters.AddWithValue("@roomName", b.RoomName);
cmd.Parameters.AddWithValue("@gender", b.Gender);
cmd.Parameters.AddWithValue("@price", b.Price);
cmd.Parameters.AddWithValue("@roomName1", b.RoomName);
cmd.Parameters.AddWithValue("@bedNo", b.BedNo);
cmd.Parameters.AddWithValue("@status", b.BedStatus);
return(DAO.UpdateTable(cmd));
}
// Get by month year??
public static bool Insert(ElectricityWaterBills ewb)
{
string sql = "insert into ElectricityWaterBills (roomName, monthYear, soDien, soNuoc, paid) values (@roomName, @monthYear, @soDien, @soNuoc, @paid)";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@roomName", ewb.RoomName);
cmd.Parameters.AddWithValue("@monthYear", ewb.MonthYear);
cmd.Parameters.AddWithValue("@soDien", ewb.SoDien);
cmd.Parameters.AddWithValue("@soNuoc", ewb.SoNuoc);
cmd.Parameters.AddWithValue("@paid", ewb.Paid);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Manager b)
{
SqlCommand cmd = new SqlCommand("update Manager set dob=@dob,gender=@gender,mail=@mail,phoneNumber=@phoneNumber,name=@name where maID=@maID");
cmd.Parameters.AddWithValue("@dob", b.Dob);
cmd.Parameters.AddWithValue("@gender", b.Gender);
cmd.Parameters.AddWithValue("@mail", b.Mail);
cmd.Parameters.AddWithValue("@phoneNumber", b.PhoneNumber);
cmd.Parameters.AddWithValue("@name", b.Name);
cmd.Parameters.AddWithValue("@maID", b.MaID);
return(DAO.UpdateTable(cmd));
}
public static bool Insert(HistoryBook hb)
{
string sql = "insert into HistoryBook (stuID, dateBook, roomName, bedNo, [status], dateExpiry) values (@stuID, @dateBook, @roomName, @bedNo, @status, @dateExpiry)";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@stuID", hb.StuID);
cmd.Parameters.AddWithValue("@dateBook", hb.DateBook);
cmd.Parameters.AddWithValue("@roomName", hb.RoomName);
cmd.Parameters.AddWithValue("@bedNo", hb.BedNo);
cmd.Parameters.AddWithValue("@status", hb.Status);
cmd.Parameters.AddWithValue("@dateExpiry", hb.DateExpiry);
return(DAO.UpdateTable(cmd));
}
public static bool Update(HistoryBook hb)
{
string sql = "update HistoryBook set stuID = @stuID, dateBook = @dateBook, roomName = @roomName, bedNo = @bedNo, [status] = @status, dateExpiry = @dateExpiry where bookID = @bookID";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@stuID", hb.StuID);
cmd.Parameters.AddWithValue("@dateBook", hb.DateBook);
cmd.Parameters.AddWithValue("@roomName", hb.RoomName);
cmd.Parameters.AddWithValue("@bedNo", hb.BedNo);
cmd.Parameters.AddWithValue("@status", hb.Status);
cmd.Parameters.AddWithValue("@dateExpiry", hb.DateExpiry);
cmd.Parameters.AddWithValue("@bookID", hb.BookID);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Student b)
{
SqlCommand cmd = new SqlCommand("update Student set name=@name, dob=@dob,gender=@gender,roomName=@roomName,bedNo=@bedNo,bookingDate=@bookingDate,moneyAccount=@moneyAccount,debt=@debt where stuID=@stuID");
cmd.Parameters.AddWithValue("@name", b.Name);
cmd.Parameters.AddWithValue("@dob", b.Dob);
cmd.Parameters.AddWithValue("@gender", b.Gender);
cmd.Parameters.AddWithValue("@roomName", b.RoomName);
cmd.Parameters.AddWithValue("@bedNo", b.BedNo);
cmd.Parameters.AddWithValue("@bookingDate", b.BookingDate);
cmd.Parameters.AddWithValue("@moneyAccount", b.MoneyAccount);
cmd.Parameters.AddWithValue("@debt", b.Debt);
cmd.Parameters.AddWithValue("@stuID", b.StuID);
return(DAO.UpdateTable(cmd));
}