public DataSet delete(ProductEN producto_borrado, int i)
{
string s;
s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlConnection c = new SqlConnection(s);
DataSet virtdb = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from Product", c);
da.Fill(virtdb, "product");
DataTable t = new DataTable();
t = virtdb.Tables["product"];
t.Rows[i].Delete();
SqlCommandBuilder cbuilder = new SqlCommandBuilder(da);
da.Update(virtdb, "product");
}
catch (Exception ex)
{
ex.ToString();
Console.WriteLine("ERROR Deleting the product");
}
finally
{
c.Close();
}
return(virtdb);
}
//Copy constructor
public OrderEN(int orderId, ClientEN client, ProductEN product, DateTime date, String address, int postalCode)
{
this.orderId = orderId;
this.client = client;
this.product = product;
this.date = date;
this.address = address;
this.postalCode = postalCode;
}
public DataSet addProduct(ProductEN producto_nuevo)
{
String str;
str = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlConnection c = new SqlConnection(str);
DataSet virtdb = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from Product", c);
da.Fill(virtdb, "product");
DataTable dt = new DataTable();
dt = virtdb.Tables["product"];
DataRow newRow = dt.NewRow();
newRow[0] = producto_nuevo.Id;
newRow[1] = producto_nuevo.Price;
newRow[2] = producto_nuevo.Color;
newRow[3] = producto_nuevo.FilepathPicture;
newRow[4] = producto_nuevo.Name;
newRow[5] = producto_nuevo.Brand;
dt.Rows.Add(newRow);
SqlCommandBuilder cbuilder = new SqlCommandBuilder(da);
da.Update(virtdb, "product");
}
catch (Exception ex)
{
ex.ToString();
Console.WriteLine("ERROR adding the new product");
}
finally
{
c.Close();
}
return(virtdb);
}
public DataSet update(ProductEN producto_actualizado, int i)
{
string s;
s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlConnection c = new SqlConnection(s);
DataSet virtdb = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from Product'", c);
da.Fill(virtdb, "product");
DataTable t = new DataTable();
t = virtdb.Tables["product"];
t.Rows[i]["Id"] = producto_actualizado.Id;
t.Rows[i]["Price"] = producto_actualizado.Price;
t.Rows[i]["Color"] = producto_actualizado.Color;
t.Rows[i]["FilepathPicture"] = producto_actualizado.FilepathPicture;
t.Rows[i]["Name"] = producto_actualizado.Name;
t.Rows[i]["Brand"] = producto_actualizado.Brand;
SqlCommandBuilder cbuilder = new SqlCommandBuilder(da);
da.Update(virtdb, "product");
}
catch (Exception ex)
{
ex.ToString();
Console.WriteLine("ERROR Updating the product");
}
finally
{
c.Close();
}
return(virtdb);
}
public DataSet read(ProductEN producto_leido)
{
string s;
s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlConnection c = new SqlConnection(s);
DataSet virtdb = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from Product", c);
da.Fill(virtdb, "product");
}
catch (Exception ex)
{
ex.ToString();
Console.WriteLine("ERROR showing the product");
}
finally
{
c.Close();
}
return(virtdb);
}