public bool Edit_KindofRoom(Kind_of_room_DTO kor)
{
string query = " exec USP_UpdateKindofRoom @id , @name , @price , @people";
int x = Connect.Instance.ExecuteNonQuery(query, new object[] { kor.Id, kor.Name, kor.Price, kor.People });
return(x == 1);
}
public bool Edit_KindofRoom(Kind_of_room_DTO kor)
{
try
{
return(Kind_of_room_DAO.Instance.Edit_KindofRoom(kor));
}
catch
{
throw new Exception("Error!");
}
}
private Kind_of_room_DTO Set_KoR()
{
Kind_of_room_DTO kor = new Kind_of_room_DTO();
if (this.choose_kor != 0)
{
kor.Id = this.Choose_kor;
}
kor.Name = txt_name.Text;
kor.Price = (decimal)nud_price.Value;
kor.People = (int)nud_people.Value;
return(kor);
}
public List <Kind_of_room_DTO> Get_List()
{
string query = "exec USP_GetList_Kindofroom";
DataTable table = Connect.Instance.ExecuteQuery(query);
List <Kind_of_room_DTO> list_kind_of_room = new List <Kind_of_room_DTO>();
foreach (DataRow item in table.Rows)
{
Kind_of_room_DTO kof = new Kind_of_room_DTO(item);
list_kind_of_room.Add(kof);
}
return(list_kind_of_room);
}
