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