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