public Stats GetSupplierStats(int workshop_id) { OfferQuery offerQuery = new OfferQuery(language); System.Data.DataTable dataTable = new System.Data.DataTable(); dataTable = conn_db.ReadTable(offerQuery.GetSupplierStats(workshop_id)); if (dataTable.Rows.Count == 0) { throw new EmptyViewException(language); } Stats stats = new Stats(); foreach (System.Data.DataRow row in dataTable.Rows) { //if (row["OFFERTYPE"].ToString() == Enums.OfferType.offerNotAccepted.ToString()) // try { stats.offerNotAccepted = Convert.ToInt32(row["OFFERCOUNT"].ToString()); } catch { stats.offerNotAccepted = 0; } //if (row["OFFERTYPE"].ToString() == Enums.OfferType.offerAccepted.ToString()) // try { stats.offerAccepted = Convert.ToInt32(row["OFFERCOUNT"].ToString()); } catch { stats.offerAccepted = 0; } //if (row["OFFERTYPE"].ToString() == Enums.OfferType.offerIsFixing.ToString()) // try { stats.offerIsFixing = Convert.ToInt32(row["OFFERCOUNT"].ToString()); } catch { stats.offerIsFixing = 0; } //if (row["OFFERTYPE"].ToString() == Enums.OfferType.offerFinishFixing.ToString()) // try { stats.offerFinishFixing = Convert.ToInt32(row["OFFERCOUNT"].ToString()); } catch { stats.offerFinishFixing = 0; } stats.CONFIRMED = Convert.ToInt32(row["ORDERCOUNT"].ToString()); } return(stats); }