public void sendReqeust() { try { SqlConnection con = Connect.conn(); reqid = Connect.AI("InventoryRequest", "requestid"); con.Open(); SqlCommand cmd = new SqlCommand("Insert into InventoryRequest(requestid,itemno,itemName,quantity) Values(@reqid,@ino,@name,@quant)", con); SqlCommand cmd2 = new SqlCommand("UPDATE denyEventSell SET state = 1 WHERE eventid = @evnt", con); cmd.Parameters.Add("@reqid", System.Data.SqlDbType.Int); cmd.Parameters.Add("@ino", System.Data.SqlDbType.Int); cmd.Parameters.Add("@name", System.Data.SqlDbType.VarChar); cmd.Parameters.Add("@quant", System.Data.SqlDbType.Int); cmd.Parameters["@reqid"].Value = Convert.ToInt32(reqid); cmd.Parameters["@ino"].Value = Convert.ToInt32(txtItemNo.Text); cmd.Parameters["@name"].Value = Convert.ToString(txtItemName.Text); cmd.Parameters["@quant"].Value = Convert.ToInt32(txtQuantity.Text); int affected = cmd.ExecuteNonQuery(); cmd2.Parameters.Add("@evnt", System.Data.SqlDbType.Int); cmd2.Parameters["@evnt"].Value = Convert.ToInt32(seventid); int affected2 = cmd2.ExecuteNonQuery(); if (affected == 1 && affected2 == 1) { ino = int.Parse(txtItemNo.Text); eventid = int.Parse(seventid); MessageBox.Show("Data Inserted", "SuccessFull", MessageBoxButtons.OK, MessageBoxIcon.Information); runDataGridDeny(); } else { MessageBox.Show("Please Contact Developer Team to Fix this Error... (Error Description : Data Dosent inserted to InventoryRequest Table)", "Error Detected!", MessageBoxButtons.OK, MessageBoxIcon.Error); } con.Close(); } catch (Exception) { MessageBox.Show("Please Check Data That You Edited or Inserted", "Wrong Input Addded", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Form1_Load(object sender, EventArgs e) { this.customerPaymentTableAdapter.Fill(this.inventoryDataSet.customerPayment); txtInv.Text = Connect.AI("cusPayment", "invoiceNumber").ToString(); timer1.Start(); Time.Text = DateTime.Now.ToLongTimeString(); Date.Text = DateTime.Now.ToLongDateString(); RundataGrid(); }
public int addTxtBoxData() { try { SqlConnection con = Connect.conn(); if (txtName.Text != null && txtPrice.Text != null) { id = Connect.AI("InvtEventPack", "packid"); name = txtName.Text; price = double.Parse(txtPrice.Text); String qry = "Insert into InvtEventPack(packid,packprice,packname) VALUES(@id,@price,@name)"; con.Open(); SqlCommand cmd = new SqlCommand(qry, con); cmd.Parameters.Add("@id", System.Data.SqlDbType.Int); cmd.Parameters.Add("@price", System.Data.SqlDbType.Real); cmd.Parameters.Add("@name", System.Data.SqlDbType.VarChar); cmd.Parameters["@id"].Value = id; cmd.Parameters["@price"].Value = price; cmd.Parameters["@name"].Value = name; int status = cmd.ExecuteNonQuery(); con.Close(); return(status); } else { return(-99); } } catch (Exception) { MessageBox.Show("Please Insert Correct Data to Fileds", "Wrong Input", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Text = null; txtPrice.Text = null; return(-999); } }
public void insertInventory8(String qry, String type) { if (String.Equals(type, "insert")) { eventid = Connect.AI("EventSell", "eventid"); //auto increment code } SqlConnection con = Connect.conn(); String sql = qry; con.Open(); SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@eventid", System.Data.SqlDbType.Int); cmd.Parameters.Add("@itemCode", System.Data.SqlDbType.Int); cmd.Parameters.Add("@itemPrice", System.Data.SqlDbType.Real); cmd.Parameters.Add("@itemName", System.Data.SqlDbType.VarChar); cmd.Parameters.Add("@itemAmmt", System.Data.SqlDbType.Int); cmd.Parameters.Add("@cusid", System.Data.SqlDbType.Int); cmd.Parameters["@eventid"].Value = eventid; cmd.Parameters["@itemPrice"].Value = double.Parse(item8price.Text); cmd.Parameters["@itemName"].Value = item8N.Text; cmd.Parameters["@itemAmmt"].Value = int.Parse(range8.Text); cmd.Parameters["@itemCode"].Value = 008; cmd.Parameters["@cusid"].Value = fname_txt.Text; int execute = cmd.ExecuteNonQuery(); con.Close(); if (execute == 1) { MessageBox.Show(" ", "Succesfully Inserted....!", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnadd_Click(object sender, EventArgs e) { SqlConnection con = Connect.conn(); int id = Connect.AI("finance", "id"); String sql = "INSERT INTO finance(id,sale,expences,profit) VALUES(@id,1200,600,@profit)"; SqlCommand cmd = new SqlCommand(sql, con); con.Open(); if (id == null) { id = 0; } cmd.Parameters.Add("@id", System.Data.SqlDbType.Int); cmd.Parameters.Add("@profit", System.Data.SqlDbType.Real); double getExpences = expences(); string getSal = sales(); cmd.Parameters["@id"].Value = id; cmd.Parameters["@profit"].Value = double.Parse(txttot.Text); int exec = cmd.ExecuteNonQuery(); con.Close(); if (exec == 1) { MessageBox.Show("Data Inserted", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information); runDataGrid(); } if (exec == 1) { //Change this "Test" part as you need MessageBox.Show("Print balance sheet", "Test", MessageBoxButtons.OK, MessageBoxIcon.Information); runDataGrid(); } }
private void packInsert_Load(object sender, EventArgs e) { packLoadObj = sender; packLoadArgs = e; txtID.Text = Connect.AI("InvtEventPack", "packid").ToString(); Clear01.Visible = false; Clear02.Visible = false; Clear03.Visible = false; Clear04.Visible = false; Clear05.Visible = false; Clear06.Visible = false; Image01 = null; Image02 = null; Image03 = null; Image04 = null; Image05 = null; Image06 = null; }
//Insert Part public void insertInventory(String qry, String type) { try { if (String.Equals(type, "insert")) { reqid = Connect.AI("InvtEventSell", "ItemCode"); //auto increment code } SqlConnection con = Connect.conn(); String sql = qry; con.Open(); SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@code", System.Data.SqlDbType.Int); cmd.Parameters.Add("@price", System.Data.SqlDbType.Real); cmd.Parameters.Add("@name", System.Data.SqlDbType.VarChar); cmd.Parameters.Add("@cnt", System.Data.SqlDbType.Int); if (picBx.Image != null) { byte[] images = null; FileStream stream = new FileStream(imglocation, FileMode.Open, FileAccess.Read); BinaryReader reader = new BinaryReader(stream); images = reader.ReadBytes((int)stream.Length); cmd.Parameters.Add("@imge", System.Data.SqlDbType.Image); cmd.Parameters["@imge"].Value = images; } if (String.Equals(type, "insert")) { cmd.Parameters["@code"].Value = reqid; } else { if (txtItemNo2.Text != null) { cmd.Parameters["@code"].Value = int.Parse(txtItemNo2.Text); } else { MessageBox.Show(" ", "Item Number is Empty....!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } cmd.Parameters["@price"].Value = double.Parse(txtPrice2.Text); cmd.Parameters["@name"].Value = txtName2.Text; cmd.Parameters["@cnt"].Value = int.Parse(txtStockCnt2.Text); int execute = cmd.ExecuteNonQuery(); con.Close(); if (execute == 1) { if (String.Equals(type, "update")) { MessageBox.Show(" ", "Succesfully Updated....!", MessageBoxButtons.OK, MessageBoxIcon.Information); runDataGridInventory(); ClearAll(); } else if (String.Equals(type, "insert")) { MessageBox.Show(" ", "Succesfully Inserted....!", MessageBoxButtons.OK, MessageBoxIcon.Information); runDataGridInventory(); ClearAll(); } } else { MessageBox.Show(" ", "Error Occured....!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception) { MessageBox.Show("Please check Data That You Added ", "Wrong Input", MessageBoxButtons.OK, MessageBoxIcon.Error); ClearAll(); } }