public static bool DeleteMD_SuDungPhong(MD_SuDungPhong mdsdp) { var cm = CreateCommand(); cm.CommandText = @"Exec update_row_MD_SuDungPhong @ID"; cm.Parameters.Add(new SqlParameter("@ID", mdsdp.ID)); int rs = cm.ExecuteNonQuery(); cn.Close(); return(rs > 0); }
public static MD_SuDungPhong Read(SqlDataReader reader) { var bc = new MD_SuDungPhong() { ID = reader.GetString(iID), MaPhong = reader.GetString(iMaPhong), NgayBatDau = reader.GetDateTime(iNgayBatDau), NgayKetThuc = reader.GetDateTime(iNgayKetThuc), MatDo = reader.GetInt32(iMatDo) }; return(bc); }
public static bool ThemMD_SuDungPhong(MD_SuDungPhong mdsdp) { var cm = CreateCommand(); cm.CommandText = @"Exec add_row_MD_SuDungPhong @ID, @MaPhong, @NgayBatDau, @NgayKetThuc, @MatDo"; cm.Parameters.Add(new SqlParameter("@ID", mdsdp.ID)); cm.Parameters.Add(new SqlParameter("@MaPhong", mdsdp.MaPhong)); cm.Parameters.Add(new SqlParameter("@NgayBatDau", mdsdp.NgayBatDau)); cm.Parameters.Add(new SqlParameter("@NgayKetThuc", mdsdp.NgayKetThuc)); cm.Parameters.Add(new SqlParameter("@MatDo", mdsdp.MatDo)); int rs = cm.ExecuteNonQuery(); cn.Close(); return(rs > 0); }
public static bool UpdateMD_SuDungPhong(MD_SuDungPhong mdsdp) { var cm = CreateCommand(); cm.CommandText = @"Exec update_row_MD_SuDungPhong @ID, @MP, @NBD, @NKT, @MD"; cm.Parameters.Add(new SqlParameter("@ID", mdsdp.ID)); cm.Parameters.Add(new SqlParameter("@MP", mdsdp.MaPhong)); cm.Parameters.Add(new SqlParameter("@NBD", mdsdp.NgayBatDau)); cm.Parameters.Add(new SqlParameter("@NKT", mdsdp.NgayKetThuc)); cm.Parameters.Add(new SqlParameter("@MD", mdsdp.MatDo)); int rs = cm.ExecuteNonQuery(); cn.Close(); return(rs > 0); }
public static List <MD_SuDungPhong> DSMD_SuDungPhong() { var lmdsdp = new List <MD_SuDungPhong>(); var cm = CreateCommand(); cm.CommandText = @"SELECT * FROM MD_SUDUNGPHONG"; var reader = cm.ExecuteReader(); while (reader.Read()) { lmdsdp.Add(MD_SuDungPhong.Read(reader)); } cn.Close(); return(lmdsdp); }