private void cmdAdd_Click(object sender, EventArgs e) { if (txtdepcode.Text.Trim() == "") { MessageBox.Show("กรุณาป้อนรหัสแผนกก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtdepcode.Focus(); return; } if (txtdepname.Text.Trim() == "") { MessageBox.Show("กรุณาป้อนชื่อแผนกก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtdepname.Focus(); return; } foreach (DataGridViewRow row in dgvDepartmentList.Rows) { string pid = row.Cells["depCode"].Value.ToString(); if (txtdepcode.Text.Trim().Equals(pid)) { MessageBox.Show("รหัสแผนกนี้มีอยู่แล้ว !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtdepcode.Focus(); return; } } try { Department department = new Department(); department.ID = 0; department.depCode = txtdepcode.Text.Trim(); department.depName = txtdepname.Text.Trim(); int result = departmentService.CreateDepartment(department); if (result > -1) { clear(); int col = dgvDepartmentList.Columns.Count; if (col != 5) { ShowDataDefult(); } else { Showdata(); } } } catch (Exception ex) { MessageBox.Show("ไม่สามารถบันทึกได้ " + ex.Message); } }
public int DeleteDepartment(Department _deldepartment) { int result = -1; try { conn = db.openConn(); tr = conn.BeginTransaction(); sb = new StringBuilder(); sb.Remove(0, sb.Length); sb.Append(" DELETE tbDepartment "); sb.Append(" WHERE (ID='" + _deldepartment.ID + "')"); 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 CreateDepartment(Department newDepartment) { int result = -1; try { conn = db.openConn(); tr = conn.BeginTransaction(); sb = new StringBuilder(); sb.Remove(0, sb.Length); sb.Append("INSERT INTO tbDepartment(depCode,depName)"); sb.Append(" VALUES (@depCode,@depName)"); string sqlsave; sqlsave = sb.ToString(); comm = new SqlCommand(); comm.Connection = conn; comm.Transaction = tr; comm.CommandText = sqlsave; comm.Parameters.Clear(); comm.Parameters.Add("@depCode", SqlDbType.NVarChar).Value = newDepartment.depCode; comm.Parameters.Add("@depName", SqlDbType.NVarChar).Value = newDepartment.depName; comm.ExecuteNonQuery(); tr.Commit(); result = 1; } catch (Exception ex) { tr.Rollback(); conn.Close(); return result; throw ex; } finally { conn.Close(); } return result; }
private void dgvDepartmentList_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == -1) { return; } string linkedit = Convert.ToString(dgvDepartmentList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()); tid = Convert.ToInt32(dgvDepartmentList.Rows[e.RowIndex].Cells["ID"].Value.ToString()); string tcode = Convert.ToString(dgvDepartmentList.Rows[e.RowIndex].Cells["depCode"].Value.ToString()); string tname = Convert.ToString(dgvDepartmentList.Rows[e.RowIndex].Cells["depName"].Value.ToString()); if (linkedit.Equals("แก้ไข")) { txtdepcode.Text = tcode; txtdepname.Text = tname; } else if (linkedit.Equals("ลบ")) { if (MessageBox.Show("คุณต้องการลบแผนก รหัส : " + tcode + " ใช่หรือไม่?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { Department department = new Department(); department.ID = tid; int result = departmentService.DeleteDepartment(department); if (result > -1) { clear(); MessageBox.Show("ลบข้อมูลเรียบร้อย !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Warning); Showdata(); tid = 0; } } } }
private void cmdSave_Click(object sender, EventArgs e) { if (tid == 0) { MessageBox.Show("กรุณาป้อนเลือกแผนกก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtdepcode.Focus(); return; } try { Department department = new Department(); department.ID = tid; department.depCode = txtdepcode.Text.Trim(); department.depName = txtdepname.Text.Trim(); int result = departmentService.UpdateDepartment(department); if (result > -1) { int col = dgvDepartmentList.Columns.Count; if (col != 5) { ShowDataDefult(); } else { Showdata(); } } } catch (Exception ex) { MessageBox.Show("ไม่สามารถบันทึกได้ " + ex.Message); } }
public List<Department> getDepartmentAll() { Department department = null; List<Department> departments = new List<Department>(); try { conn = db.openConn(); sb = new StringBuilder(); sb.Remove(0, sb.Length); sb.Append(" SELECT ID,depCode,depName FROM tbDepartment "); string sql; sql = sb.ToString(); comm = new SqlCommand(); comm.CommandText = sql; comm.CommandType = CommandType.Text; comm.Connection = conn; dr = comm.ExecuteReader(); if (dr.HasRows) { DataTable dt = new DataTable(); dt.Load(dr); foreach (DataRow drw in dt.Rows) { department = new Department(); department.ID = Convert.ToInt32(drw["ID"].ToString()); department.depCode = drw["depCode"].ToString(); department.depName = drw["depName"].ToString(); departments.Add(department); } } dr.Close(); } catch (Exception ex) { dr.Close(); conn.Close(); return null; throw ex; } finally { conn.Close(); } return departments; }