//type_Apartment,name_Apartment,size,priceSale,priceRent,
//status_Apartment,date_create,user_create,date_update,user_update
public int updateApartment(Apartment apartment)
{
string sql = "update Apartment set type_Apartment=@Type_Apartment,name_Apartment=@Name_Apartment,size=@Size,priceSale=@PriceSale,priceRent=@PriceRent,status_Apartment=@Status_Apartment,date_update=@DateUpdate, user_update=@UserUpdate "
+ "Where id_Apartment=@IDApartment";
SqlCommand cmd = GenericDataAccess.CreateCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@Type_Apartment", apartment.typeApartment);
cmd.Parameters.AddWithValue("@Name_Apartment", apartment.nameApartment);
cmd.Parameters.AddWithValue("@Size", apartment.size);
cmd.Parameters.AddWithValue("@PriceSale", apartment.priceSale);
cmd.Parameters.AddWithValue("@PriceRent", apartment.priceRent);
cmd.Parameters.AddWithValue("@Status_Apartment", apartment.statusApartment);
cmd.Parameters.AddWithValue("@DateUpdate", apartment.dateUpdate);
cmd.Parameters.AddWithValue("@UserUpdate", apartment.userUpdate);
cmd.Parameters.AddWithValue("@IDApartment", apartment.idApartment);
return GenericDataAccess.ExecuteNoneQuery(cmd);
}
public static List<Apartment> getApartments()
{
string sql = "select * from Apartment";
SqlCommand cmd = GenericDataAccess.CreateCommand();
cmd.CommandText = sql;
DataTable dt = GenericDataAccess.ExecuteSelectCommand(cmd);
Apartment apartment;
int idApartment;
string nameApartment;
string typeApartment;
string size;
double priceSale;
double priceRent;
int statusApartment;
string dateCreate;
string userCreate;
string dateUpdate;
string userUpdate;
List<Apartment> lst = new List<Apartment>();
foreach (DataRow dr in dt.Rows)
{
idApartment = Convert.ToInt16(dr[0]);
typeApartment = dr[1].ToString();
nameApartment = dr[2].ToString();
size = dr[3].ToString();
priceSale = Convert.ToDouble(dr[4]);
priceRent = Convert.ToDouble(dr[5]);
statusApartment = Convert.ToInt16(dr[6]);
dateCreate = dr[7].ToString();
userCreate = dr[8].ToString();
dateUpdate = dr[9].ToString();
userUpdate = dr[10].ToString();
apartment = new Apartment(idApartment, nameApartment, typeApartment, size, priceSale, priceRent, statusApartment, dateCreate, userCreate, dateUpdate, userUpdate);
lst.Add(apartment);
}
return lst;
}
public int addAparment(Apartment apartment)
{
string sql = "insert into dbo.Apartment(type_Apartment,name_Apartment,size,priceSale,priceRent,status_Apartment,date_create,user_create,date_update,user_update)values( @type_Apartment, @name_Apartment,@size, @priceSale, @priceRent, @status_Apartment, @date_create, @user_create, @date_update, @user_update)";
SqlCommand cmd = GenericDataAccess.CreateCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@type_Apartment", apartment.typeApartment);
cmd.Parameters.AddWithValue("@name_Apartment", apartment.nameApartment);
cmd.Parameters.AddWithValue("@size", apartment.size);
cmd.Parameters.AddWithValue("@priceSale", apartment.priceSale);
cmd.Parameters.AddWithValue("@priceRent", apartment.priceRent);
cmd.Parameters.AddWithValue("@status_Apartment", apartment.statusApartment);
cmd.Parameters.AddWithValue("@date_create", apartment.dateCreate);
cmd.Parameters.AddWithValue("@user_create", apartment.userCreate);
cmd.Parameters.AddWithValue("@date_update", apartment.dateUpdate);
cmd.Parameters.AddWithValue("@user_update", apartment.userUpdate);
return GenericDataAccess.ExecuteNoneQuery(cmd);
}