private void cmdSave_Click(object sender, EventArgs e) { if (txtamount.Text.Trim() == "") { MessageBox.Show("กรุณาป้อนจำนวนโบนัส ก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtamount.Focus(); return; } Bonus _bonus = new Bonus(); Person _p = new Person(); _p.psnCode = txtpsnCode.Text.Trim(); _bonus.person = _p; _bonus.amount = Convert.ToInt32(txtamount.Text.Trim()); _bonus.bdate = DateTime.Now; int result = bonusService.CreateBonus(_bonus); if (result > -1) { Console.WriteLine("Insert Complete"); lblresult.Visible = true; lblresult.Text = " บันทึกเรียบร้อย "; //MessageBox.Show("บันทึกข้อมูล เรียบร้อยแล้ว !!!", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { Console.WriteLine("Insert Not Complete"); lblresult.Visible = true; lblresult.Text = " ไม่สามารถบันทึกข้อมูลได้"; //MessageBox.Show("ไม่สามารถบันทึกข้อมูล เรียบร้อยแล้ว !!!", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public int UpdateBonus(Bonus _bonus) { int result = -1; try { conn = db.openConn(); tr = conn.BeginTransaction(); sb = new StringBuilder(); sb.Remove(0, sb.Length); sb.Append(" UPDATE tbBonus "); sb.Append(" SET amount='" + _bonus.amount + "',"); sb.Append(" bdate='" + _bonus.bdate + "'"); sb.Append(" WHERE (psnCode='" + _bonus.person.psnCode + "')"); string sqlUpdate; sqlUpdate = sb.ToString(); comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = sqlUpdate; comm.Transaction = tr; comm.Parameters.Clear(); comm.ExecuteNonQuery(); tr.Commit(); result = 1; } catch (Exception ex) { tr.Rollback(); conn.Close(); return result; throw ex; } finally { conn.Close(); } return result; }
public int CreateBonus(Bonus newBonus) { int result = -1; try { conn = db.openConn(); tr = conn.BeginTransaction(); sb = new StringBuilder(); sb.Remove(0, sb.Length); sb.Append("INSERT INTO tbBonus(psnCode,amount,bdate)"); sb.Append(" VALUES (@psnCode,@amount,@bdate)"); string sqlsave; sqlsave = sb.ToString(); comm = new SqlCommand(); comm.Connection = conn; comm.Transaction = tr; comm.CommandText = sqlsave; comm.Parameters.Clear(); comm.Parameters.Add("@psnCode", SqlDbType.NVarChar).Value = newBonus.person.psnCode; comm.Parameters.Add("@amount", SqlDbType.NVarChar).Value = newBonus.amount; comm.Parameters.Add("@bdate", SqlDbType.DateTime).Value = newBonus.bdate; comm.ExecuteNonQuery(); tr.Commit(); result = 1; } catch (Exception ex) { tr.Rollback(); conn.Close(); return result; throw ex; } finally { conn.Close(); } return result; }