private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
ComboBox comb = (ComboBox)sender;
ClassArt ca = (ClassArt)comb.SelectedItem;
classBiz.classArt = ca;
}
public List <ClassArt> GetAllArtFromDB()
{
List <ClassArt> listCAres = new List <ClassArt>();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetAllArtFromDB";
DataTable dataTable = MakeCallToStoredProcedure(cmd);
foreach (DataRow row in dataTable.Rows)
{
ClassArt art = new ClassArt();
art.artID = Convert.ToInt32(row["id"]);
art.picturePath = row["picturePath"].ToString();
art.pictureDescription = row["description"].ToString();
art.pictureTitel = row["titel"].ToString();
art.isAvailable = Convert.ToBoolean(row["isAvailable"]);
listCAres.Add(art);
}
return(listCAres);
}
public void SaveArtToDB()
{
using (ClassContext ccx = new ClassContext())
{
ccx.classArt.AddOrUpdate(classArt);
ccx.SaveChanges();
}
classArt = new ClassArt();
listClassArt.Clear();
}
public ClassBIZ()
{
selectedCurrency = new ClassCurrency();
selectedCustomer = new ClassCustomer();
selectedArt = new ClassArt();
listClassArt = new List <ClassArt>();
listCustomer = new List <ClassCustomer>();
Task.Run(async() => await StartCurrencyApiCall());
classFile.ReadDataFromCurrencyFile();
listCustomer = classDB.GetAllCustomerFromDB(selectedCurrency);
listClassArt = classDB.GetAllArtFromDB();
}
public ClassBiz()
{
classCurrency = new ClassCurrency();
GetAllCurrencyIdAndNames();
ClassSalesValues csv = new ClassSalesValues();
csv.classCurrency = classCurrency;
classCustomer = new ClassCustomer();
listClassArt = new List <ClassArt>(getdata.classArt.ToList() as List <ClassArt>);
classArt = new ClassArt();
listCustomer = new List <ClassCustomer>(getdata.classCustomer.ToList() as List <ClassCustomer>);
ClassSalesValues = new ClassSalesValues();
listclassSalesValues = new List <ClassSalesValues>(getdata.classSalesValues.ToList() as List <ClassSalesValues>);
}
