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