public bool insertData(costingdetail k) { bool stat = false; Connection ConnG = new Connection(); try { ConnG.Konek(); strQuery = new MySql.Data.MySqlClient.MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "INSERT INTO tblcostingdetail VALUES(@COSTINGNO,@ID,@COSTID,@DESCRIPTION,@WIDTH,@USAG,@CONSUMPTION,@UOMID," + "@PRICE,@AMOUNT,@CURRENCY,@KURS,@ALLOWANCE,@APPROVE,@APPROVEDATE,@APPROVEBY)"; strQuery.Parameters.AddWithValue("@COSTINGNO", k.COSTINGNO); strQuery.Parameters.AddWithValue("@ID", k.ID); strQuery.Parameters.AddWithValue("@COSTID", k.COSTID); strQuery.Parameters.AddWithValue("@DESCRIPTION", k.DESCRIPTION); strQuery.Parameters.AddWithValue("@WIDTH", k.WIDTH); strQuery.Parameters.AddWithValue("@USAG", k.USAG); strQuery.Parameters.AddWithValue("@CONSUMPTION", k.CONSUMPTION); strQuery.Parameters.AddWithValue("@UOMID", k.UOMID); strQuery.Parameters.AddWithValue("@PRICE", k.PRICE); strQuery.Parameters.AddWithValue("@AMOUNT", k.AMOUNT); strQuery.Parameters.AddWithValue("@CURRENCY", k.CURRENCY); strQuery.Parameters.AddWithValue("@KURS", k.KURS); strQuery.Parameters.AddWithValue("@ALLOWANCE", k.ALLOWANCE); strQuery.Parameters.AddWithValue("@APPROVE", k.APPROVE); strQuery.Parameters.AddWithValue("@APPROVEDATE", k.APPROVEDATE); strQuery.Parameters.AddWithValue("@APPROVEBY", k.APPROVEBY); strQuery.ExecuteNonQuery(); stat = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { ConnG.Putus(); } return(stat); }
public bool updateData(costingdetail k) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySql.Data.MySqlClient.MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "UPDATE tblcostingdetail SET COSTID=@COSTID,DESCRIPTION=@DESCRIPTION,WIDTH=@WIDTH,USAG=@USAG,CONSUMPTION=@CONSUMPTION,UOMID=@UOMID," + "PRICE=@PRICE,AMOUNT=@AMOUNT,CURRENCY=@CURRENCY,KURS=@KURS,ALLOWANCE=@ALLOWANCE,APPROVE=@APPROVE,APPROVEDATE=@APPROVEDATE,APPROVEBY=@APPROVEBY WHERE COSTINGNO=@COSTINGNO AND ID=@ID"; strQuery.Parameters.AddWithValue("@COSTINGNO", k.COSTINGNO); strQuery.Parameters.AddWithValue("@ID", k.ID); strQuery.Parameters.AddWithValue("@COSTID", k.COSTID); strQuery.Parameters.AddWithValue("@DESCRIPTION", k.DESCRIPTION); strQuery.Parameters.AddWithValue("@WIDTH", k.WIDTH); strQuery.Parameters.AddWithValue("@USAG", k.USAG); strQuery.Parameters.AddWithValue("@CONSUMPTION", k.CONSUMPTION); strQuery.Parameters.AddWithValue("@UOMID", k.UOMID); strQuery.Parameters.AddWithValue("@PRICE", k.PRICE); strQuery.Parameters.AddWithValue("@AMOUNT", k.AMOUNT); strQuery.Parameters.AddWithValue("@CURRENCY", k.CURRENCY); strQuery.Parameters.AddWithValue("@KURS", k.KURS); strQuery.Parameters.AddWithValue("@ALLOWANCE", k.ALLOWANCE); strQuery.Parameters.AddWithValue("@APPROVE", k.APPROVE); strQuery.Parameters.AddWithValue("@APPROVEDATE", k.APPROVEDATE); strQuery.Parameters.AddWithValue("@APPROVEBY", k.APPROVEBY); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch { } return(stat); }