//can code the
public static Account getAccountByUsernameDetail(string username)
{
Account ac = new Account();
string sql = "SELECT * FROM dbo.Account WHERE userName = @username ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@username", SqlDbType.NVarChar)
};
param[0].Value = username;
DataTable a = DataAccess.ReadDataBySQLWithParameter(sql, param);
foreach (DataRow dr in a.Rows)
{
ac.Name = dr["name"].ToString();
ac.UserName = dr["userName"].ToString();
ac.PassWord = dr["passWord"].ToString();
ac.MoneyBuy = float.Parse((string.IsNullOrEmpty(dr["moneyBuy"].ToString()))?"0": dr["moneyBuy"].ToString());
ac.Place = dr["diaChi"].ToString();
ac.Phone = dr["phone"].ToString();
ac.Gmail = dr["gmail"].ToString();
ac.Gender = Convert.ToBoolean(dr["gender"].ToString());
ac.DOB = Convert.ToDateTime(dr["DOB"].ToString());
ac.Thearts = TheartDAO.getTheartByID(Convert.ToInt32(dr["idRap"].ToString()));
ac.Areax = AreaDAO.getAreaByID(Convert.ToInt32(dr["idKhuVuc"].ToString()));
ac.GroupMemBerx = GroupMemberDAO.getGroupMemberById(Convert.ToInt32(dr["idNhomThanhVien"].ToString()));
}
return(ac);
}
public static List <Theart_Room> getAllRapPhong()
{
List <Theart_Room> list = new List <Theart_Room>();
string sql = "SELECT rp.idRap,rp.idPhong,rp.numberMaxGhe,rp.note FROM dbo.Rap_Phong ";
DataTable dt = DataAccess.ReadDataBySQL(sql);
foreach (DataRow dr in dt.Rows)
{
Theart_Room tr = new Theart_Room();
tr.Theartx = TheartDAO.getTheartByID(Convert.ToInt32(dr["idRap"].ToString()));
tr.Roomx = RoomDAO.getRoomByID(Convert.ToInt32(dr["idPhong"].ToString()));
tr.NumberMaxSeat = Convert.ToInt32(dr["numberMaxGhe"].ToString());
tr.Note = dr["note"].ToString();
tr.SeatTypes = SeatTypeDAO.getAllSeatTypeByIdRapIdPhong(tr.Theartx.ID, tr.Roomx.ID);
list.Add(tr);
}
return(list);
}
public static Theart_Room getAllRapPhongByID(int idRap, int idPhong)
{
string sql = "SELECT rp.idRap,rp.idPhong,rp.numberMaxGhe,rp.note FROM dbo.Rap_Phong AS rp" +
" WHERE rp.idRap = @idRap AND rp.idPhong = @idPhong";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@idRap", SqlDbType.Int),
new SqlParameter("@idPhong", SqlDbType.Int)
};
param[0].Value = idRap;
param[1].Value = idPhong;
DataTable dt = DataAccess.ReadDataBySQLWithParameter(sql, param);
Theart_Room tr = new Theart_Room();
foreach (DataRow dr in dt.Rows)
{
tr.Theartx = TheartDAO.getTheartByID(Convert.ToInt32(dr["idRap"].ToString()));
tr.Roomx = RoomDAO.getRoomByID(Convert.ToInt32(dr["idPhong"].ToString()));
tr.NumberMaxSeat = Convert.ToInt32(dr["numberMaxGhe"].ToString());
tr.Note = dr["note"].ToString();
tr.SeatTypes = SeatTypeDAO.getAllSeatTypeByIdRapIdPhong(tr.Theartx.ID, tr.Roomx.ID);
}
return(tr);
}