public void UpdateKontur(KonturItem item)
{
using (IDbConnection conn = new SQLiteConnection(this.db_.GetDefaultConnectionString()))
{
conn.Execute("update db_konturs set Name=@name, vNorma=@vNorma, TipSh=@TipSh, ZavN=@ZavN, KodSchSbut=@KodSchSbut where phone=@phone and n=@n", item);
}
}
public int InsertKontur(KonturItem item)
{
using (IDbConnection conn = new SQLiteConnection(this.db_.GetDefaultConnectionString()))
{
return(conn.ExecuteScalar <int>("insert into db_konturs (phone,N, Name,vNorma, TipSh, ZavN, KodSchSbut) values(@phone,@N,@Name,@vNorma, @TipSh, @ZavN, @KodSchSbut);", item));
}
}
