public void Update() { if (Convert.ToInt32(pid_txt.Tag) != 0 || Convert.ToInt32(oid_cmb.Tag) != 0 || Convert.ToInt32(bc_txt.Tag) != 0 || Convert.ToInt32(val_txt.Tag) != 0 || Convert.ToInt32(pd_dtp.Tag) != 0 || Convert.ToInt32(pt_cmb.Tag) != 0) { conn.DBopen(); try { conn.SqlQuery("UPDATE GmntPayment SET [ord_id] = '" + oid_cmb.Text + "',[buyer_code] = '" + bc_txt.Text + "',[val_USD] = '" + val_txt.Text + "',[val_LKR] = '" + lkr_txt.Text + "',[paydate] = '" + Convert.ToDateTime(pd_dtp.Text) + "',[payment_terms] = '" + pt_cmb.Text + "' WHERE [payment_id] = '" + pid_txt.Text + "'"); conn.InsQryEx(); MessageBox.Show("Updated Successfully !"); RefreshGrid(); } catch (Exception er) { MessageBox.Show(er.Message); } finally { conn.DBclose(); } } else { MessageBox.Show("Please slect a field"); } }
private void insertData() { conn.DBopen(); try { decimal rup = Convert.ToDecimal(cost_txt.Text) * Currency.getCurrencyRate("USD", "LKR"); conn.SqlQuery("INSERT INTO Gmnt_sample ([Samp_id], [ord_id], [Buyer_code], [cost_USD], [cost_LKR], [Delivered_date],[fashion_sketch] ) VALUES ('" + sam_txt.Text + "','" + oid_cmb.Text + "','" + bc_txt.Text + "','" + cost_txt.Text + "','" + rup + "','" + Convert.ToDateTime(date_dtp.Text) + "','" + fp_txt.Text + "')"); conn.InsQryEx(); MessageBox.Show("Added Successfully "); } catch (Exception er) { MessageBox.Show(er.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } conn.DBclose(); }
public void Update() { if (Convert.ToInt32(bc_cmb.Tag) != 0 || Convert.ToInt32(oDate.Tag) != 0 || Convert.ToInt32(rDate.Tag) != 0 || Convert.ToInt32(cDate.Tag) != 0 || Convert.ToInt32(hs_txt.Tag) != 0 || Convert.ToInt32(yes_rad.Tag) != 0 || Convert.ToInt32(no_rad.Tag) != 0 || Convert.ToInt32(ov_txt.Tag) != 0 || Convert.ToInt32(ar_cmb.Tag) != 0 || Convert.ToInt32(ci_cmb.Tag) != 0) { con.DBopen(); string stat = ChkTrans(); try { con.SqlQuery("UPDATE Orders SET [Buyer_code] = '" + bc_cmb.Text + "',[ord_date] = '" + Convert.ToDateTime(oDate.Text) + "',[req_ship_date] = '" + Convert.ToDateTime(rDate.Text) + "',[conf_ship_date] = '" + Convert.ToDateTime(cDate.Text) + "',[hs_code] = '" + hs_txt.Text + "',[order_val] = '" + ov_txt.Text + "',[trans_split] = '" + stat + "',[article] = '" + ar_cmb.Text + "',[ci_no] = '" + ci_cmb.Text + "' WHERE [ord_id] = '" + id_txt.Text + "'"); con.InsQryEx(); MessageBox.Show("Updated Successfully !"); RefreshGrid(); } catch (Exception er) { MessageBox.Show(er.Message); } finally { con.DBclose(); } } else { MessageBox.Show("Please select a field"); } }
private void add_Click(object sender, EventArgs e) { if (addCliEmpty() == -1) { addCliEmptyErr(); } else if (Validation.valEml(eml_txt.Text) == false) { MessageBox.Show("Invalid Email !", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); e11.ForeColor = System.Drawing.Color.Red; e11.Text = "Enter a Valid Email Address"; } else if (Validation.valTel(phn_txt) == false) { MessageBox.Show("Invalid Phone Number !", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); e9.ForeColor = System.Drawing.Color.Red; e9.Text = "Enter a 10 Digit Phone Number !"; } else { con.DBopen(); try { con.SqlQuery("INSERT INTO Buyer ([buyer_code],[company],[address],[country],[email]) values ('" + bc_txt.Text + "','" + cmp_txt.Text + "','" + st1_txt.Text + "','" + cntry_cmb.Text + "','" + eml_txt.Text + "')"); con.InsQryEx(); con.SqlQuery("INSERT INTO BuyerPhone ([buyer_code],[phone]) values (@code,@num)"); con.cmd.Parameters.AddWithValue("@code", bc_txt.Text); con.cmd.Parameters.Add("@num", SqlDbType.Text); con.cmd.Parameters["@num"].Value = phc_txt.Text + ' ' + phn_txt.Text; con.InsQryEx(); MessageBox.Show("Added Successfully "); } catch (Exception error) { MessageBox.Show(error.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } con.DBclose(); } }
private void button1_Click(object sender, EventArgs e) { try { String strBLOBFilePath = @"C:\Users\BHAGI\Pictures\Screenshots\b.png"; FileStream fsBLOBFile = new FileStream(strBLOBFilePath, FileMode.Open, FileAccess.Read); Byte[] bytBLOBData = new Byte[fsBLOBFile.Length]; fsBLOBFile.Read(bytBLOBData, 0, bytBLOBData.Length); fsBLOBFile.Close(); conn.SqlQuery("INSERT INTO login Values('bolt','bole','1234','" + bytBLOBData + "')"); conn.InsQryEx(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void Delete(string sId) { conn.DBopen(); try { conn.SqlQuery("DELETE FROM GmntPayment WHERE [payment_id] = '" + sId + "'"); conn.InsQryEx(); MessageBox.Show("Deleted Succesfully!"); } catch (Exception er) { MessageBox.Show(er.Message); } finally { conn.DBclose(); } }
public void Delete(string oId) { con.DBopen(); try { con.SqlQuery("DELETE FROM Orders WHERE [ord_id] = '" + oId + "'"); con.InsQryEx(); MessageBox.Show("Deleted Succesfully!"); } catch (Exception er) { MessageBox.Show(er.Message); } finally { con.DBclose(); } }
private void add_Click(object sender, EventArgs e) { if (addOrdEmpyt() == -1) { addOrdEmptyErr(); } else { ChkHs(); ChkCi(); } /* if(ts_cmb.Text == "Yes") * { * b = true; * } * else * { * b = false; * }*/ if (addOrdEmpyt() == 0 || ChkHs() == 0 || ChkCi() == 0) { con.DBopen(); string stat = ChkTrans(); try { con.SqlQuery("INSERT INTO Orders ([ord_id],[buyer_code],[ord_date],[req_ship_date],[conf_ship_date],[hs_code],[order_val],[trans_split],[article],[ci_no]) values ('" + id_txt.Text + "','" + bc_cmb.Text + "','" + Convert.ToDateTime(oDate.Text) + "','" + Convert.ToDateTime(rDate.Text) + "','" + Convert.ToDateTime(cDate.Text) + "','" + hs_txt.Text + "','" + double.Parse(ov_txt.Text) + "','" + stat + "','" + ar_cmb.Text + "','" + ci_cmb.Text + "')"); con.InsQryEx(); MessageBox.Show("Added Successfully "); } catch (Exception error) { MessageBox.Show(error.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } con.DBclose(); } }
public void Update() { if ((costUsd_txt.Tag != null && Convert.ToInt32(costUsd_txt.Tag) != 0) || Convert.ToInt32(oid_cmb.Tag) != 0 || Convert.ToInt32(date_dtp.Tag) != 0 || Convert.ToInt32(pic_pb.Tag) != 0 || Convert.ToInt32(sat_cmb.Tag) != 0) { chkUsd = Convert.ToInt32(costUsd_txt.Tag); ordId = Convert.ToInt32(oid_cmb.Tag); dateTag = Convert.ToInt32(date_dtp.Tag); picTag = Convert.ToInt32(pic_pb.Tag); staTag = Convert.ToInt32(sat_cmb.Tag); conn.DBopen(); try { conn.SqlQuery("UPDATE Gmnt_sample SET [ord_id] = '" + oid_cmb.Text + "',[Buyer_code] = '" + bc_txt.Text + "',[cost_USD] = '" + costUsd_txt.Text + "',[cost_LKR] = '" + costLkr_txt.Text + "',[Delivered_date] = '" + Convert.ToDateTime(date_dtp.Text) + "',[samp_status] = '" + sat_cmb.Text + "',[fashion_sketch] = '" + imgLoc + "' WHERE [Samp_id] = '" + sam_txt.Text + "'"); conn.InsQryEx(); MessageBox.Show("Updated Successfully !"); RefreshGrid(); } catch (Exception er) { MessageBox.Show(er.Message); } finally { conn.DBclose(); } } else { MessageBox.Show("Please slect a field"); chkUsd = 0; ordId = 0; dateTag = 0; picTag = 0; staTag = 0; } }
private void addPayDet() { conn.DBopen(); decimal rup = Convert.ToDecimal(val_txt.Text) * Currency.getCurrencyRate("USD", "LKR"); try { conn.SqlQuery("INSERT INTO GmntPayment ([payment_id],[ord_id],[buyer_code],[val_USD],[val_LKR],[paydate],[payment_terms]) values ('" + pid_txt.Text + "','" + oid_cmb.Text + "','" + bc_txt.Text + "','" + val_txt.Text + "','" + rup + "','" + Convert.ToDateTime(pd_dtp.Text) + "','" + pt_cmb.Text + "')"); conn.InsQryEx(); MessageBox.Show("Added Successfully "); ClearTextBoxes(); } catch (Exception er) { MessageBox.Show(er.Message); } finally { conn.DBclose(); } }