public bool addRoomType(RoomType rt, out string roomTypeId) { var result = roomTypeDAT.addRoomType(rt); if (result.Rows[0].ItemArray[0].ToString() == "0") { roomTypeId = result.Rows[0].ItemArray[1].ToString(); return true; } roomTypeId = ""; return false; }
public RoomTypeEdit(RoomType roomType) { InitializeComponent(); this.roomTypeBLT = new RoomTypeBLT(); this.Text = "Edit room type"; txtId.Text = roomType.Id; txtName.Text = roomType.Name; txtPrice.Text = roomType.Price.ToString(); txtDeposit.Text = roomType.Deposit.ToString(); txtNote.Text = roomType.Note; }
private void btnSave_Click(object sender, EventArgs e) { if (checkContraints()) { RoomType rt = new RoomType() { Id = txtId.Text, Name = txtName.Text.Trim(), Price = decimal.Parse(txtPrice.Text.Trim() == "" ? "0" : txtPrice.Text.Trim()), Deposit = decimal.Parse(txtDeposit.Text.Trim() == "" ? "0" : txtDeposit.Text.Trim()), Note = txtNote.Text.Trim() }; if (this.Text == "Edit room type") { //Edit if(roomTypeBLT.updateRoomType(rt)) { MessageBox.Show("Update " + txtId.Text.Trim().ToUpper() + " successfully!"); EditCompletedHandler(txtId.Text.Trim()); this.Close(); } else MessageBox.Show("Update " + txtId.Text.ToUpper() + " fail!"); } else { //Insert string id; if (roomTypeBLT.addRoomType(rt, out id)) { MessageBox.Show("Insert " + txtName.Text.Trim().ToUpper() + " successfully!\nThe new room type Id = " + id + "."); EditCompletedHandler(id); this.Close(); } else MessageBox.Show("Insert " + txtId.Text.ToUpper() + " fail! Try again later."); } } }
public DataTable addRoomType(RoomType rt) { try { int param = 4; string[] name = new string[param]; object[] value = new object[param]; name[0] = "@p_NAME"; value[0] = rt.Name; name[1] = "@p_PRICE"; value[1] = rt.Price; name[2] = "@p_DEPOSIT"; value[2] = rt.Deposit; name[3] = "@p_NOTE"; value[3] = rt.Note; return this.ExcuteStoreProcedure("ROOMTYPE_Ins", name, value); } catch (System.Exception ex) { Console.WriteLine("Message = {1}", ex.Message); } return null; }
public bool updateRoomType(RoomType rt) { return roomTypeDAT.updateRoomType(rt); }
public DataTable searchRoomType(RoomType rt) { return roomTypeDAT.searchRoomType(rt); }
private void btnEdit_Click(object sender, EventArgs e) { if (txtId.Text == string.Empty) { MessageBox.Show("You don't choose a room type to edit!", "Infomations", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { RoomType rt = new RoomType() { Id = txtId.Text, Name = txtName.Text, Price = decimal.Parse(txtPrice.Text.Trim()), Deposit = decimal.Parse(txtDeposit.Text.Trim()), Note = txtNote.Text }; RoomTypeEdit roomTypeEdit = new RoomTypeEdit(rt); roomTypeEdit.EditCompletedHandler += FormRoomTypeEdit_Completed; roomTypeEdit.ShowDialog(); } }
private void btnSearch_Click(object sender, EventArgs e) { if (btnSearch.Text == "Reset") { this.resetUI(); this.changeModeEditUI(true); } else { RoomType rt = new RoomType() { Id = txtId.Text.Trim(), Name = txtName.Text.Trim(), Price = decimal.Parse(txtPrice.Text.Trim() == "" ? "0" : txtPrice.Text.Trim()), Deposit = decimal.Parse(txtDeposit.Text.Trim() == "" ? "0" : txtDeposit.Text.Trim()), Note = txtNote.Text.Trim() }; this.dgvRoomType.DataSource = roomTypeBLT.searchRoomType(rt); } }
public DataTable searchRoomType(RoomType rt) { try { string[] names = new string[6]; object[] values = new object[6]; names[0] = "@p_ID"; values[0] = rt.Id; names[1] = "@p_NAME"; values[1] = rt.Name; names[2] = "@p_PRICE"; values[2] = rt.Price; names[3] = "@p_DEPOSIT"; values[3] = rt.Deposit; names[4] = "@p_NOTE"; values[4] = rt.Note; names[5] = "@p_TOP"; values[5] = 0; return this.ExcuteStoreProcedure("ROOMTYPE_Search", names, values); } catch (System.Exception ex) { Console.WriteLine("Message = {1}", ex.Message); } return null; }
public bool updateRoomType(RoomType rt) { try { string sql = "Update roomtype set name = N'" + rt.Name + "', price = " + rt.Price.ToString().Replace(',', '.') + ", deposit = " + rt.Deposit.ToString().Replace(',', '.') + ", note = N'" + rt.Note + "' where id = '" + rt.Id.Trim() + "'"; int result = this.ExecuteNonQuery(sql); if (result != 0) { return true; } } catch (System.Exception ex) { Console.WriteLine("Message = {1}", ex.Message); } return false; }