public bool insertData(eximdocdetail k) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "INSERT INTO tbleximdocdetail (TRANSNO,ID,NOAJU,ITEMSID,STYLEID,CURRENCY,PRICE,KURS,TOTAL) " + "VALUES (@TRANSNO,@ID,@NOAJU,@ITEMSID,@STYLEID,@CURRENCY,@PRICE,@KURS,@TOTAL)"; strQuery.Parameters.AddWithValue("@TRANSNO", k.TRANSNO); strQuery.Parameters.AddWithValue("@ID", k.ID); strQuery.Parameters.AddWithValue("@NOAJU", k.NOAJU); strQuery.Parameters.AddWithValue("@ITEMSID", k.ITEMSID); strQuery.Parameters.AddWithValue("@STYLEID", k.STYLEID); strQuery.Parameters.AddWithValue("@CURRENCY", k.CURRENCY); strQuery.Parameters.AddWithValue("@PRICE", k.PRICE); strQuery.Parameters.AddWithValue("@KURS", k.KURS); strQuery.Parameters.AddWithValue("@TOTAL", k.TOTAL); strQuery.ExecuteNonQuery(); stat = true; ConnG.Putus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }
public bool updateData(eximdocdetail k, string TRANSNO1, int ID1) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "UPDATE tbleximdocdetail SET TRANSNO=@TRANSNO,ID=@ID,NOAJU=@NOAJU,ITEMSID=@ITEMSID,STYLEID=@STYLEID,CURRENCY=@CURRENCY,PRICE=@PRICE,KURS=@KURS,TOTAL=@TOTAL" + " WHERE TRANSNO=@TRANSNO1 AND ID=@ID1"; //key strQuery.Parameters.AddWithValue("@TRANSNO1", TRANSNO1); strQuery.Parameters.AddWithValue("@ID1", ID1); //en key strQuery.Parameters.AddWithValue("@TRANSNO", k.TRANSNO); strQuery.Parameters.AddWithValue("@ID", k.ID); strQuery.Parameters.AddWithValue("@NOAJU", k.NOAJU); strQuery.Parameters.AddWithValue("@ITEMSID", k.ITEMSID); strQuery.Parameters.AddWithValue("@STYLEID", k.STYLEID); strQuery.Parameters.AddWithValue("@CURRENCY", k.CURRENCY); strQuery.Parameters.AddWithValue("@PRICE", k.PRICE); strQuery.Parameters.AddWithValue("@KURS", k.KURS); strQuery.Parameters.AddWithValue("@TOTAL", k.TOTAL); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }