private void btnSave_Click(object sender, EventArgs e)
{
if (txtProductname.Text == string.Empty)
{
MessageBox.Show("กรุณาเลือกชื่อสินค้า", "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtProductname.Focus();
return;
}
if (txtQty.Text == string.Empty)
{
MessageBox.Show("กรุณาระบุจำนวน", "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtQty.Focus();
return;
}
try
{
con = new OleDbConnection(cs);
con.Open();
var ct = "select ConfigID from stock where ConfigID=" + txtConfigID.Text + string.Empty;
cmd = new OleDbCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read() == true)
{
MessageBox.Show("มีข้อมูลนี้อยู่แล้ว" + "\n" + "กรุณาอัพเดทฐานข้อมูล", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
if ((rdr != null))
{
rdr.Close();
}
return;
}
auto();
con = new OleDbConnection(cs);
con.Open();
var cb = "insert into Stock(StockID,ConfigID,Quantity,Totalprice,StockDate) VALUES ('" + txtStockID.Text + "'," + txtConfigID.Text + "," + txtQty.Text + "," + txtTotalPrice.Text + ",#" + dtpStockDate.Value + "#)";
cmd = new OleDbCommand(cb);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
MessageBox.Show("บันทึกข้อมูลสำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnSave.Enabled = false;
GetData();
var frm = new frmMainMenu();
frm.GetData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
con = new OleDbConnection(cs);
con.Open();
var cb = "Update Stock set ConfigID=" + txtConfigID.Text + ",Quantity=" + txtQty.Text + ",Totalprice=" + txtTotalPrice.Text + ",StockDate= #" + dtpStockDate.Value + "# where StockID='" + txtStockID.Text + "'";
cmd = new OleDbCommand(cb);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
MessageBox.Show("ปรับปรุงข้อมูลสำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnUpdate.Enabled = false;
GetData();
var frm = new frmMainMenu();
frm.GetData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtProductname.Text == string.Empty)
{
MessageBox.Show("กรุณาเลือกชื่อสินค้า", "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtProductname.Focus();
return;
}
if (txtQty.Text == string.Empty)
{
MessageBox.Show("กรุณาระบุจำนวน", "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtQty.Focus();
return;
}
try
{
con = new OleDbConnection(cs);
con.Open();
var ct = "select ConfigID from stock where ConfigID=" + txtConfigID.Text + string.Empty;
cmd = new OleDbCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read() == true)
{
MessageBox.Show("มีข้อมูลนี้อยู่แล้ว" + "\n" + "กรุณาอัพเดทฐานข้อมูล", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
if ((rdr != null))
{
rdr.Close();
}
return;
}
auto();
con = new OleDbConnection(cs);
con.Open();
var cb = "insert into Stock(StockID,ConfigID,Quantity,Totalprice,StockDate) VALUES ('" + txtStockID.Text + "'," + txtConfigID.Text + "," + txtQty.Text + "," + txtTotalPrice.Text + ",#" + dtpStockDate.Value + "#)";
cmd = new OleDbCommand(cb);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
MessageBox.Show("บันทึกข้อมูลสำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnSave.Enabled = false;
GetData();
var frm = new frmMainMenu();
frm.GetData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
con = new OleDbConnection(cs);
con.Open();
var cb = "Update Stock set ConfigID=" + txtConfigID.Text + ",Quantity=" + txtQty.Text + ",Totalprice=" + txtTotalPrice.Text + ",StockDate= #" + dtpStockDate.Value + "# where StockID='" + txtStockID.Text + "'";
cmd = new OleDbCommand(cb);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
MessageBox.Show("ปรับปรุงข้อมูลสำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnUpdate.Enabled = false;
GetData();
var frm = new frmMainMenu();
frm.GetData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
con = new SqlConnection(cs);
con.Open();
var cb = "Update Stock set ConfigID=@a,Quantity=@b,Totalprice=@c,StockDate=@d where StockID=@e";
cmd = new SqlCommand(cb);
cmd.Parameters.AddWithValue("a", txtConfigID.Text);
cmd.Parameters.AddWithValue("b", txtQty.Text);
cmd.Parameters.AddWithValue("c", txtTotalPrice.Text);
cmd.Parameters.AddWithValue("d", dtpStockDate.Value);
cmd.Parameters.AddWithValue("e", txtStockID.Text);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
MessageBox.Show("ปรับปรุงข้อมูลสำเร็จ", string.Empty, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnUpdate.Enabled = false;
GetData();
var frm = new frmMainMenu();
frm.GetData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
