//Update item
public static void Update(BookDorm bookDorm)
{
Mydatabase.sql = $"update {Helpers.tbBookDorm} SET {Helpers.colEmailOwnerBookDorm}=@EmailOwner" +
$", {Helpers.colEmailUserBookDorm} = @EmailUser" +
$", {Helpers.colIdDormBookDorm}=@Id" +
$", {Helpers.colStateBookDorm}=@State" +
$" where {Helpers.colEmailOwnerBookDorm}=@EmailOwner and {Helpers.colEmailUserBookDorm} = @EmailUser and {Helpers.colIdDormBookDorm}=@Id;";
try
{
Mydatabase.OpenConnection();
Mydatabase.cmd.CommandType = CommandType.Text;
Mydatabase.cmd.CommandText = Mydatabase.sql;
Mydatabase.cmd.Parameters.Clear();
Mydatabase.cmd.Parameters.AddWithValue("@EmailOwner", bookDorm.EmailOwner);
Mydatabase.cmd.Parameters.AddWithValue("@EmailUser", bookDorm.EmailUser);
Mydatabase.cmd.Parameters.AddWithValue("@Id", bookDorm.IdDorm);
Mydatabase.cmd.Parameters.AddWithValue("@State", bookDorm.StateDorm);
Mydatabase.cmd.ExecuteScalar();
}
catch (Exception e)
{
MessageBox.Show("Error Update Book Dorm " + e.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
Mydatabase.CloseConnection();
}
}
//Insert item
public static Boolean Insert(BookDorm bookDorm)
{
Mydatabase.sql = $"insert into {Helpers.tbBookDorm}({Helpers.colEmailOwnerBookDorm},{Helpers.colEmailUserBookDorm},{Helpers.colIdDormBookDorm},{Helpers.colStateBookDorm}) values(@EmailOwner,@EmailUser,@Id,@State);";
try
{
Mydatabase.OpenConnection();
Mydatabase.cmd.CommandType = CommandType.Text;
Mydatabase.cmd.CommandText = Mydatabase.sql;
Mydatabase.cmd.Parameters.Clear();
Mydatabase.cmd.Parameters.AddWithValue("@EmailOwner", bookDorm.EmailOwner);
Mydatabase.cmd.Parameters.AddWithValue("@EmailUser", bookDorm.EmailUser);
Mydatabase.cmd.Parameters.AddWithValue("@Id", bookDorm.IdDorm);
Mydatabase.cmd.Parameters.AddWithValue("@State", bookDorm.StateDorm);
Mydatabase.cmd.ExecuteScalar();
return(true);
}
catch (Exception e)
{
//MessageBox.Show("Error Insert Book Dorm " + e.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
finally
{
Mydatabase.CloseConnection();
}
}
//Get item
public static BookDorm GetItem(BookDorm bookDorm)
{
BookDorm dorm = new BookDorm();
Mydatabase.sql = $"select * from {Helpers.tbBookDorm} where {Helpers.colEmailOwnerBookDorm} = @EmailOwner and {Helpers.colEmailUserBookDorm}=@EmailUser and {Helpers.colIdDormBookDorm} = @Id";
try
{
Mydatabase.OpenConnection();
Mydatabase.cmd.CommandType = CommandType.Text;
Mydatabase.cmd.CommandText = Mydatabase.sql;
Mydatabase.cmd.Parameters.Clear();
Mydatabase.cmd.Parameters.AddWithValue("@EmailOwner", bookDorm.EmailOwner);
Mydatabase.cmd.Parameters.AddWithValue("@EmailUser", bookDorm.EmailUser);
Mydatabase.cmd.Parameters.AddWithValue("@Id", bookDorm.IdDorm);
Mydatabase.rd = Mydatabase.cmd.ExecuteReader();
if (Mydatabase.rd.Read())
{
dorm.EmailOwner = Mydatabase.rd.GetString(0);
dorm.EmailUser = Mydatabase.rd.GetString(1);
dorm.IdDorm = Mydatabase.rd.GetInt32(2);
dorm.StateDorm = Mydatabase.rd.GetInt16(3);
}
}
catch (Exception e)
{
MessageBox.Show("Error get infor Owner Like Dorm " + e.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
Mydatabase.CloseConnection();
}
return(dorm);
}
//Get All User booking waiting
public static List <BookDorm> GetAllWattingBook(string email, bool IsOwner)
{
List <BookDorm> list = new List <BookDorm>();
if (IsOwner)
{
Mydatabase.sql = $"select * from {Helpers.tbBookDorm} where {Helpers.colEmailOwnerBookDorm} = @Email and {Helpers.colStateBookDorm} = @State";
}
else
{
Mydatabase.sql = $"select * from {Helpers.tbBookDorm} where {Helpers.colEmailUserBookDorm} = @Email and {Helpers.colStateBookDorm} = @State";
}
try
{
Mydatabase.OpenConnection();
Mydatabase.cmd.CommandType = CommandType.Text;
Mydatabase.cmd.CommandText = Mydatabase.sql;
Mydatabase.cmd.Parameters.Clear();
Mydatabase.cmd.Parameters.AddWithValue("@Email", email);
Mydatabase.cmd.Parameters.AddWithValue("@State", 1);
Mydatabase.rd = Mydatabase.cmd.ExecuteReader();
while (Mydatabase.rd.Read())
{
BookDorm dorm = new BookDorm();
dorm.EmailOwner = Mydatabase.rd.GetString(0);
dorm.EmailUser = Mydatabase.rd.GetString(1);
dorm.IdDorm = Mydatabase.rd.GetInt32(2);
dorm.StateDorm = Mydatabase.rd.GetInt16(3);
list.Add(dorm);
}
}
catch (Exception e)
{
MessageBox.Show("Error get All List Owner Book Dorm " + e.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
Mydatabase.CloseConnection();
}
return(list);
}
