private void btnDelete_Click(object sender, EventArgs e)
{
var Member = new clsMember ();
Member.Mem_ID = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Mem_ID"].Value.ToString().Trim();
Member.Mem_Name = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Mem_Name"].Value.ToString().Trim();
Member.Share_Member = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Share_Member"].Value.ToString().Trim();
Member.Phone = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Phone"].Value.ToString().Trim();
Member.Status = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Status"].Value.ToString().Trim();
Member.Address = dgvView.Rows[dgvView.CurrentRow.Index].Cells["Address"].Value.ToString().Trim();
Member.M_User = dgvView.Rows[dgvView.CurrentRow.Index].Cells["M_User"].Value.ToString().Trim();
Member.M_Pass = dgvView.Rows[dgvView.CurrentRow.Index].Cells["M_Pass"].Value.ToString().Trim();
//if (lblUser.Text == Cells["M_User"].Value.ToString())
//{
// MessageBox.Show("กำลังใช้งาน ไม่สามารถลบได้", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
if (MessageBox.Show("ต้องการลบข้อมูลใช่หรือไม่", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (clsDELETE.MEMBER(Member) == true)
{
MessageBox.Show("ลบข้อมูลสำเร็จ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("ลบข้อมูลไม่สำเร็จ", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
}
btnSearch_Click(sender, e);
}
public static Boolean MEMBER(clsMember M)
{
try
{
StringBuilder sb = new StringBuilder();
sb.Remove(0, sb.ToString().Length);
sb.Append(" INSERT INTO MEMBER ");
//sb.Append(" ( Mem_ID ");
sb.Append(" ( Mem_Name ");
sb.Append(" ,Share_Member ");
sb.Append(" ,Phone ");
sb.Append(" ,Status ");
sb.Append(" ,Address )");
sb.Append(" VALUES ");
//sb.Append(" ('" + M.Mem_ID + "' ");
sb.Append(" ('" + M.Mem_Name + "' ");
sb.Append(" ,'" + M.Share_Member + "' ");
sb.Append(" ,'" + M.Phone + "' ");
sb.Append(" ,'" + M.Status + "' ");
sb.Append(" ,'" + M.Address + "') ");
clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString());
return true;
}
catch (Exception ex) { return false; throw ex; }
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName .Text.Trim() == "")
{
MessageBox.Show("กรุณาระบุชื่อ!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (txtTel .Text.Trim() == "")
{
MessageBox.Show("กรุณระบุเบอร์โทรศัพท์!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (txtAddress .Text.Trim() == "")
{
MessageBox.Show("กรุณาระบุที่อยู่!", "การดำเนินการ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
try
{
//ค่าที่รับมา
var Member = new clsMember();
Member.Mem_ID = this.txtID.Text.Trim();
Member.Mem_Name = this.txtName.Text.Trim();
Member.Share_Member = this.cbbShere.Text.Trim();
Member.Phone = this.txtTel.Text.Trim();
Member.Status = this.cboStatus.Text.Trim();
Member.Address = this.txtAddress.Text.Trim();
Member.M_User = this.txtUser.Text.Trim();
Member.M_Pass = this.txtPass.Text.Trim();
if (FUNCTION == "INSERT")
{
if (clsINSERT.MEMBER(Member) == true)
{
MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
if (clsUPDATE.MEMBER(Member) == true)
{
MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("เกิดข้อผิดพลาด", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
this.Close();
}
public static Boolean MEMBER(clsMember M)
{
try
{
StringBuilder sb = new StringBuilder();
sb.Remove(0, sb.ToString().Length);
sb.Append(" DELETE ");
sb.Append(" FROM MEMBER ");
sb.Append(" WHERE Mem_ID = '" + M.Mem_ID + "'");
clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString());
return true;
}
catch (Exception ex) { return false; throw ex; }
}
public static Boolean MEMBER(clsMember M)
{
try
{
StringBuilder sb = new StringBuilder();
sb.Remove(0, sb.ToString().Length);
sb.Append(" UPDATE MEMBER ");
sb.Append(" SET Mem_Name = '" + M.Mem_Name + "' ");
sb.Append(" ,Share_Member = '" + M.Share_Member + "' ");
sb.Append(" ,Phone = '" + M.Phone + "'");
sb.Append(" ,Status = '" + M.Status + "'");
sb.Append(" ,Address = '" + M.Address+ "' ");
sb.Append(" WHERE Mem_ID = '" + M.Mem_ID + "' ");
clsGlobal.SQLQUERY.MS_ExecuteNonQuery(sb.ToString());
return true;
}
catch (Exception ex) { return false; throw ex; }
}
