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