//This method deletes an infos record from database public static int Deleteinfos(DB_Helper infos) { using (SqlConnection connection = new SqlConnection(sqlConnectionString)) { connection.Open(); var affectedRows = connection.Execute("Delete from conv_infos (Partners, Associations, intitule_projet, objectifs) values (@Partners, @Associations , @intitule_projet, @objectifs)", new { Partners = infos.Partners, Associations = infos.Associations, intitule_projet = infos.intitule_projet, objectifs = infos.objectifs }); connection.Close(); return(affectedRows); } }
//This method inserts a contrat_infos record in database public int Insert(DB_Helper infos) { using (var connection = new SqlConnection(sqlConnectionString)) { connection.Open(); var affectedRows = connection.Execute("Insert into Contrat_infos (Partners, Associations, intitule_projet, objectifs) values (@Partners, @Associations , @intitule_projet, @objectifs)", new { Partners = infos.Partners, Associations = infos.Associations, intitule_projet = infos.intitule_projet, objectifs = infos.objectifs }); connection.Close(); return(affectedRows); } }
public static DB_Helper FindSingle(string id) { DB_Helper record = null; string NewGUID = System.Guid.NewGuid().ToString(); using (var connection = new SqlConnection(sqlConnectionString)) { connection.Open(); record = connection.QuerySingle <DB_Helper>("SELECT * FROM conv_infos WHERE NewGUID=@NewGUID", new { ConvID = id }); connection.Close(); } return(record); }