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