96
query = "INSERT INTO contract (id_contract, data_start, data_expiration,
id_company, id_client, id_product, id_employee, specification, note) VALUES
(@id_contract, @data_start, @data_expiration, @id_company, @id_client,
@id_product, @id_employee, @specification, @note)";
adapter.InsertCommand = new MySqlCommand(query, connection);
paramcoll adapter.InsertCommand.Parameters;
paramcoll.Add("@id_contract", MySqlDbTypes.Int32, 11, "id_employee");
paramcoll.Add("@date_start", MySqlDbTypes.Date, 10, "date_start");
paramcoll.Add("@data_expiration", MySqlDbTypes.Date, 10,
"data_expiration");
paramcoll.Add("@id_company", MySqlDbTypes.Int32, 11, "id_company");
paramcoll.Add("@id_client", MySqlDbTypes.Int32, 11, "id_client");
paramcoll.Add("@id_product", MySqlDbTypes.Int32, 11, "id_product");
paramcoll.Add("@id_employee", MySqlDbTypes.Int32, 11, "id_employee");
paramcoll.Add("@specification", MySqlDbTypes.VarChar, 45,
"specification");
paramcoll.Add("@note", MySqlDbTypes.VarChar, 45, "note");
/*Update*/
query = "UPDATE contract SET id_contract = @id_contract, date_start =
@date_start, data_expiration = @data_expiration, id_company = @id_company,
id_client = @id_client, id_product = @id_product, id_employee = @id_employee,
specification = @specification, note = @note WHERE id_contract = @iid_contract ";
adapter.UpdateCommand = new MySqlCommand(query, connection);
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@id_contract", MySqlDbTypes.Int32, 11, "id_contract");
param = paramcoll.Add("@iid_contract", MySqlDbTypes.Int32, 11,
"id_contract");
param.SourceVersion = DataRowVersion.Original;
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@date_start", MySqlDbTypes.Date, 10, "date_start");
param = paramcoll.Add("@idate_start", MySqlDbTypes.Date, 10,
"date_start");
param.SourceVersion = DataRowVersion.Original;
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@data_expiration", MySqlDbTypes.Date, 10,
"data_expiration");
param = paramcoll.Add("@idata_expiration", MySqlDbTypes.Date, 10,
"data_expiration");
param.SourceVersion = DataRowVersion.Original;
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@id_company", MySqlDbTypes.Int32, 11, "id_company");
param = paramcoll.Add("@iid_company", MySqlDbTypes.Int32, 11,
"id_company");
97
param.SourceVersion = DataRowVersion.Original;
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@id_client", MySqlDbTypes.Int32, 11, "id_client");
param = paramcoll.Add("@iid_client", MySqlDbTypes.Int32, 11, "id_client");
param.SourceVersion = DataRowVersion.Original;
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@id_product", MySqlDbTypes.Int32, 11, "id_product");
param = paramcoll.Add("@iid_product", MySqlDbTypes.Int32, 11,
"id_product");
param.SourceVersion = DataRowVersion.Original;
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@id_employee", MySqlDbTypes.Int32, 11, "id_employee");
param = paramcoll.Add("@iid_employee", MySqlDbTypes.Int32, 11,
"id_employee");
param.SourceVersion = DataRowVersion.Original;
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@specification", MySqlDbTypes.VarChar, 45,
"specification");
param = paramcoll.Add("@ispecification", MySqlDbTypes.VarChar, 45,
"specification");
param.SourceVersion = DataRowVersion.Original;
paramcoll adapter.UpdateCommand.Parameters;
paramcoll.Add("@note", MySqlDbTypes.VarChar, 45, "note");
param = paramcoll.Add("@inote", MySqlDbTypes.VarChar, 45, "note");
param.SourceVersion = DataRowVersion.Original;
}
}
}
}
