internal void UpdateArtInTown(TableArtInTown ArtInTown) { SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); } catch (SqlException se) { return; } SqlCommand cmd = new SqlCommand("Update Art_in_Town" + " Set Number = @Number, Requisition = @Requisition, Production = @Prod where IdArticle = @IdArticle AND IdTown = @IdTown", conn); SqlParameter param = new SqlParameter(); param.ParameterName = "@Number"; param.Value = ArtInTown.GetNumber(); param.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@Requisition"; param.Value = ArtInTown.GetRequisition(); param.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@Prod"; param.Value = ArtInTown.GetProduction(); param.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@IdArticle"; param.Value = ArtInTown.GetIdArticle(); param.SqlDbType = SqlDbType.VarChar; cmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@IdTown"; param.Value = ArtInTown.GetId(); param.SqlDbType = SqlDbType.VarChar; cmd.Parameters.Add(param); try { cmd.ExecuteNonQuery(); } catch (SqlException se) { return; } conn.Close(); conn.Dispose(); }
public static TableArtInTown ZnajdzTowarWMiescie(string idt, string idm) { TableArtInTown towar = tableArtInTown.Select(n => n).Where(x => x.GetId() == idm && x.GetIdArticle() == idt).FirstOrDefault(); return(towar); }