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); } }