public bool addExecuteQuery(Boxcs x) { string str = string.Format("insert into Book values(@customer,@allmoney,@phone,@cardid,@rid,@time,@dqtime,@notes)"); SqlParameter customer = new SqlParameter(); customer.ParameterName = "@customer"; customer.SqlDbType = System.Data.SqlDbType.NVarChar; customer.Size = 20; customer.Value = x.Name; SqlParameter allmoney = new SqlParameter(); allmoney.ParameterName = "@allmoney"; allmoney.SqlDbType = System.Data.SqlDbType.Money; allmoney.Value = x.Money; SqlParameter phone = new SqlParameter(); phone.ParameterName = "@phone"; phone.SqlDbType = System.Data.SqlDbType.NChar; phone.Size = 10; phone.Value = x.Phone; SqlParameter cardid = new SqlParameter(); cardid.ParameterName = "@cardid"; cardid.SqlDbType = System.Data.SqlDbType.NVarChar; cardid.Size = 20; cardid.Value = x.Cardid; SqlParameter time = new SqlParameter(); time.ParameterName = "@time"; time.SqlDbType = System.Data.SqlDbType.DateTime; time.Value = x.Yutime; SqlParameter dqtime = new SqlParameter(); dqtime.ParameterName = "@dqtime"; dqtime.SqlDbType = System.Data.SqlDbType.DateTime; dqtime.Value = x.Dqtime; SqlParameter rid = new SqlParameter(); rid.ParameterName = "@rid"; rid.SqlDbType = System.Data.SqlDbType.Int; rid.Size = 32; rid.Value = x.Roomid; SqlParameter notes = new SqlParameter(); notes.ParameterName = "@notes"; notes.SqlDbType = System.Data.SqlDbType.NVarChar; notes.Size = 50; notes.Value = x.Notes; return(SqlHelper.B_sqlhelper.ExecuteQuery(str, new SqlParameter[] { customer, allmoney, phone, cardid, rid, time, dqtime, notes })); }
public bool updateExecuteQuery(Boxcs x) { return(new DAL.B_dal().updateExecuteQuery(x)); }
public bool addExecuteQuery(Boxcs x) { return(new DAL.B_dal().addExecuteQuery(x)); }
public bool updateExecuteQuery(Boxcs x) { string str = string.Format("update Book set B_Customer=@customer,B_AllMoney=@allmoney,B_Phone=@phone,B_Cardid=@cardid,R_ID=@rid,B_time=@time,B_daoqitime=@dqtime,B_Notes=@notes where B_ID=@id"); SqlParameter customer = new SqlParameter(); customer.ParameterName = "@customer"; customer.SqlDbType = System.Data.SqlDbType.NVarChar; customer.Size = 20; customer.Value = x.Name; SqlParameter allmoney = new SqlParameter(); allmoney.ParameterName = "@allmoney"; allmoney.SqlDbType = System.Data.SqlDbType.Money; allmoney.Value = x.Money; SqlParameter phone = new SqlParameter(); phone.ParameterName = "@phone"; phone.SqlDbType = System.Data.SqlDbType.NChar; phone.Size = 11; phone.Value = x.Phone; SqlParameter cardid = new SqlParameter(); cardid.ParameterName = "@cardid"; cardid.SqlDbType = System.Data.SqlDbType.NVarChar; cardid.Size = 20; cardid.Value = x.Cardid; SqlParameter rid = new SqlParameter(); rid.ParameterName = "@rid"; rid.SqlDbType = System.Data.SqlDbType.Int; rid.Size = 32; rid.Value = x.Roomid; SqlParameter time = new SqlParameter(); time.ParameterName = "@time"; time.SqlDbType = System.Data.SqlDbType.DateTime; time.Value = x.Yutime; SqlParameter dqtime = new SqlParameter(); dqtime.ParameterName = "@dqtime"; dqtime.SqlDbType = System.Data.SqlDbType.DateTime; dqtime.Value = x.Dqtime; SqlParameter notes = new SqlParameter(); notes.ParameterName = "@notes"; notes.SqlDbType = System.Data.SqlDbType.NVarChar; notes.Size = 100; notes.Value = x.Notes; SqlParameter id = new SqlParameter(); id.ParameterName = "@id"; id.SqlDbType = System.Data.SqlDbType.Int; id.Size = 32; id.Value = x.Id; return(SqlHelper.B_sqlhelper.ExecuteQuery(str, new SqlParameter[] { id, customer, allmoney, phone, cardid, rid, time, dqtime, notes })); }
private void bbutadd_Click(object sender, EventArgs e) { if (btxtname.Text != "" && Btxtmoney.Text != null && btxtcardid.Text != "" && btxtphone.Text != "" && bcomroomid.Text != "" && bcomroomtype.Text != "") { if (this.bcomroomtype.Text == "Single Room".Trim() || bcomroomtype.Text == "Double Room".Trim() || bcomroomtype.Text == "Luxury Room ".Trim() || bcomroomtype.Text == "Three-Bedroom".Trim() || bcomroomtype.Text == "Presidential Room".Trim()) { string flag2 = BLL.B_bll.selectRoomid(this.bcomroomid.Text); if (flag2 == "Empty") { if (Regex.IsMatch(this.btxtphone.Text, rgphone)) { if (Regex.IsMatch(this.btxtcardid.Text, rgcardid) || Regex.IsMatch(this.btxtcardid.Text, rgcardid1)) { if (this.bdqtime.Value > this.btxttime.Value) { bool flag1 = BLL.B_bll.selectcarid(this.btxtcardid.Text.ToString()); if (!flag1) { Boxcs bx = new Boxcs(); bx.Name = this.btxtname.Text.ToString(); bx.Money = double.Parse(this.Btxtmoney.Text); bx.Phone = this.btxtphone.Text.ToString(); bx.Cardid = this.btxtcardid.Text.ToString(); bx.Yutime = this.btxttime.Text.ToString(); bx.Dqtime = this.bdqtime.Text.ToString(); bx.Roomid = int.Parse(bcomroomid.Text); bx.Notes = this.btxtnotes.Text.ToString(); bool flag = new BLL.B_bll().addExecuteQuery(bx); if (!flag) { MessageBox.Show("Add Failed"); } else { MessageBox.Show("Add Successful"); bool bflag = new BLL.B_bll().updataR_status(int.Parse(bcomroomid.Text.ToString())); clear(); } } else { MessageBox.Show("IC No repeated!!!"); this.btxtcardid.Text = ""; } } else { MessageBox.Show("Ceeck out must greater than Check in!!"); } } else { MessageBox.Show("IC Wrong!!!"); this.btxtcardid.Text = ""; } } else { MessageBox.Show("Contact No Wrong!!!!"); this.btxtphone.Text = ""; } } else { MessageBox.Show("Room No Wrong!"); } } else { MessageBox.Show("Room Type Wrong!!"); this.bcomroomtype.Text = ""; } } else { MessageBox.Show("No Empty Field!!"); } dataGridView1.Columns.Clear(); DataSet ds = new DataSet(); ds = BLL.B_bll.dataread(); dgv(); dataGridView1.DataSource = ds.Tables[0]; }
private void bbutupdate_Click(object sender, EventArgs e) { if (this.btxtcardid.Text != "") { if (btxtname.Text != "" && Btxtmoney.Text != null && btxtcardid.Text != "" && btxtphone.Text != "" && bcomroomid.Text != "" && bcomroomtype.Text != "") { if (this.bcomroomtype.Text == "Single Room".Trim() || bcomroomtype.Text == "Double Room".Trim() || bcomroomtype.Text == "Luxury Room ".Trim() || bcomroomtype.Text == "three-Bedroom".Trim() || bcomroomtype.Text == "Presidential Room".Trim()) { string flag2 = BLL.B_bll.selectRoomid(this.bcomroomid.Text); if (flag2 == "Empty Room ") { if (Regex.IsMatch(this.btxtphone.Text, rgphone)) { if (Regex.IsMatch(this.btxtcardid.Text, rgcardid) || Regex.IsMatch(this.btxtcardid.Text, rgcardid1)) { if (this.bdqtime.Value > this.btxttime.Value) { Boxcs bx = new Boxcs(); bx.Id = int.Parse(this.Btxtid.Text); bx.Name = this.btxtname.Text.ToString(); bx.Money = double.Parse(this.Btxtmoney.Text); bx.Phone = this.btxtphone.Text.ToString(); bx.Cardid = this.btxtcardid.Text.ToString(); bx.Yutime = this.btxttime.Text.ToString(); bx.Dqtime = this.bdqtime.Text.ToString(); bx.Roomid = int.Parse(bcomroomid.Text); bx.Notes = this.btxtnotes.Text.ToString(); DialogResult dr = MessageBox.Show("Confirm Change!!!", "Remind", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk); if (dr == DialogResult.Yes) { bool flag = new BLL.B_bll().updateExecuteQuery(bx); if (!flag) { MessageBox.Show("Change Failed"); } else { MessageBox.Show("Change Successful"); } clear(); } } else { MessageBox.Show("Validation data must Greater than Booking date!!"); } } else { MessageBox.Show("IC No Wrong!!!"); this.btxtcardid.Text = ""; } } else { MessageBox.Show("Contact No Wrong"); this.btxtphone.Text = ""; } } else { MessageBox.Show("Room No Wrong!"); } } else { MessageBox.Show("Room Type Wrong!!!"); this.bcomroomtype.Text = ""; } } else { MessageBox.Show("No Empty Field!!!!"); } dataGridView1.Columns.Clear(); DataSet ds = new DataSet(); ds = BLL.B_bll.dataread(); dgv(); dataGridView1.DataSource = ds.Tables[0]; } else { MessageBox.Show("Pls select to change !!!!"); } }