Example #1
0
        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);
        }