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