Esempio n. 1
0
        public ActionResult Create(FormCollection formCollection)
        {
            if (Session["OrganisationID"] == null)
            {
                TempData["accessError"] = "Vaše session vypršela, nebo nejste přihlášen.";
                return RedirectToAction("LogOn", "Organisation");
            }

            bool correct = true;
            CultureInfo culture = CultureInfo.CreateSpecificCulture("cs-CZ");

            foreach (var key in formCollection.AllKeys)
            {
                if (key.Contains("."))
                {
                    if (String.IsNullOrWhiteSpace(formCollection[key]))
                    {
                        this.TempData[key + "error"] = "Zadanné pole nesmí být prázdné";
                        correct = false;
                        continue;
                    }
                    else
                    {
                        this.TempData[key] = formCollection[key];
                        this.TempData[key + "error"] = "";
                        continue;
                    }
                }

                if (String.IsNullOrWhiteSpace(formCollection[key]))
                {
                    this.ViewData[key + "error"] = "Zadanné pole nesmí být prázdné";
                    correct = false;

                    continue;
                }

                if (key.Contains("S"))
                {
                    char[] delimiter = { '-' };
                    string[] identifiers = key.Split(delimiter);

                    int subsectorID = Convert.ToInt32(identifiers[1]);
                    int kpiID = Convert.ToInt32(identifiers[2]);

                    SpecialisedIdentifier kpi = db.SpecialisedIdentifiersESG.Where(i => i.SpecialisedSubsectorID == subsectorID && i.ID == kpiID).SingleOrDefault();

                    if (kpi.UnitID == 4)
                    {
                        try
                        {
                            Convert.ToInt64(formCollection[key], culture);
                        }
                        catch (FormatException ex)
                        {
                            this.ViewData[key + "error"] = "Zadaná hodnota musí mít celočíselný formát.";
                            correct = false;
                            continue;
                        }
                    }

                    if (kpi.UnitID == 3 || kpi.UnitID == 2)
                    {
                        try
                        {
                            Convert.ToDouble(formCollection[key], culture);
                        }
                        catch (FormatException ex)
                        {
                            this.ViewData[key + "error"] = "Zadaná hodnota musí být číslo.";
                            correct = false;
                            continue;
                        }
                    }

                    if (kpi.UnitID == 1)
                    {
                        double i = 0;
                        try
                        {
                            i = Convert.ToDouble(formCollection[key], culture);

                        }
                        catch (FormatException ex)
                        {
                            this.ViewData[key + "error"] = "Zadaná hodnota musí být číslo v rozsahu 0-100.";
                            correct = false;
                            continue;
                        }

                        if (i < 0 || i > 100)
                        {
                            this.ViewData[key + "error"] = "Zadaná hodnota musí být číslo v rozsahu 0-100.";
                            correct = false;
                            continue;
                        }
                    }
                    this.ViewData[key] = formCollection[key];
                }

                if (!key.Contains("S") && !key.Contains("."))
                {
                    char[] delimiter = { '-' };
                    string[] identifiers = key.Split(delimiter);

                    int kpiID = Convert.ToInt32(identifiers[1]);

                    KeyPerformanceIdentifier kpi = db.KeyPerformanceIdentifiersESG.Where(i => i.ID == kpiID).SingleOrDefault();

                    if (kpi.UnitID == 4)
                    {
                        try
                        {
                            Convert.ToInt64(formCollection[key], culture);
                        }
                        catch (FormatException ex)
                        {
                            this.ViewData[key + "error"] = "Zadaná hodnota musí mít celočíselný formát.";
                            correct = false;
                            continue;
                        }
                    }

                    if (kpi.UnitID == 3 || kpi.UnitID == 2)
                    {
                        try
                        {
                            Convert.ToDouble(formCollection[key], culture);
                        }
                        catch (FormatException ex)
                        {
                            this.ViewData[key + "error"] = "Zadaná hodnota musí být číslo.";
                            correct = false;
                            continue;
                        }
                    }

                    if (kpi.UnitID == 1)
                    {
                        double i = 0;
                        try
                        {
                            formCollection[key] = formCollection[key].Replace(".", ",");

                            i = Convert.ToDouble(formCollection[key], culture);
                        }
                        catch (FormatException ex)
                        {
                            this.ViewData[key + "error"] = "Zadaná hodnota musí být číslo v rozsahu 0-100.";
                            correct = false;
                            continue;
                        }

                        if (i < 0 || i > 100)
                        {
                            this.ViewData[key + "error"] = "Zadaná hodnota musí být číslo v rozsahu 0-100.";
                            correct = false;
                            continue;
                        }
                    }

                    this.ViewData[key] = formCollection[key];
                }
            }

            if (!correct)
            {
                ChosedIdentifiers chosedIdentifiers = new ChosedIdentifiers();

                foreach (var key in formCollection.AllKeys)
                {
                    if (key.StartsWith("S"))
                    {
                        char[] delimiter = { '-' };
                        string[] identifiers = key.Split(delimiter);

                        int subsectorID = Convert.ToInt32(identifiers[1]);
                        int kpiID = Convert.ToInt32(identifiers[2]);

                        SpecialisedSubsector subsector = db.SpecialisedSubsectorsESG.Where(s => s.ID == subsectorID).SingleOrDefault();
                        chosedIdentifiers.AddSpecialisedSubsector(subsector);

                        SpecialisedIdentifier identifier = db.SpecialisedIdentifiersESG.Where(i => i.ID == kpiID).SingleOrDefault();
                        chosedIdentifiers.AddSpecialisedIdentifierToSpecialisedSubsector(subsector, identifier);
                    }
                    else if (!key.Contains("S") && !key.Contains("."))
                    {
                        char[] delimiter = { '-' };
                        string[] identifiers = key.Split(delimiter);

                        int subsectorID = Convert.ToInt32(identifiers[0]);
                        int kpiID = Convert.ToInt32(identifiers[1]);

                        Subsector subsector = db.SubsectorsESG.Where(s => s.ID == subsectorID).SingleOrDefault();

                        chosedIdentifiers.AddSubsector(subsector);

                        KeyPerformanceIdentifier kpi = db.KeyPerformanceIdentifiersESG.Where(i => i.ID == kpiID).SingleOrDefault();

                        chosedIdentifiers.AddIdentifierToSubsector(subsector, kpi);

                    }
                }

                return View("Fill", chosedIdentifiers);
            }
            this.TempData.Clear();

            int organisationID = (int)Session["OrganisationID"];
            int representativeID = (int)Session["RepresentativeID"];

            var representative = db.RepresentativesESG.Where(o => o.ID == representativeID).SingleOrDefault();
            var organisation = db.CompaniesESG.Where(o => o.ID == organisationID).SingleOrDefault();

            Report report = new Report();
            report.NumOfViews = 0;
            report.CompanyID = organisationID;
            report.Created = DateTime.Now;
            report.RepresentativeID = representativeID;

            db.ReportsESG.Add(report);

            db.SaveChanges();

            foreach (var key in formCollection.AllKeys)
            {
                if (key.StartsWith("S"))
                {
                    char[] thirdDelimiter = { '-' };
                    string[] ids = key.Split(thirdDelimiter);

                    int specialSubSectorID = Convert.ToInt32(ids[1]);
                    int specialIdentifierID = Convert.ToInt32(ids[2]);

                    ReportedSpecialisedIdentifier rsi = new ReportedSpecialisedIdentifier();

                    rsi.ReportID = report.ID;
                    rsi.SpecialisedIdentifierID = specialIdentifierID;
                    rsi.ReportedValue = formCollection[key];

                    db.ReportedSpecialisedIdentifiersESG.Add(rsi);
                    db.SaveChanges();

                    continue;
                }

                if (key.Contains("."))
                {
                    char[] firstDelimiter = { '.' };

                    string[] ids = key.Split(firstDelimiter);

                    int firstLabelID = Convert.ToInt32(ids[0]);
                    int secondLabelID = Convert.ToInt32(ids[1]);

                    OrganisationProfileField organisationProfileField = db.OrganisationProfileFieldsESG
                                                                          .Where(opf => opf.FirstLabelID == firstLabelID && opf.SecondLabelID == secondLabelID)
                                                                          .SingleOrDefault();

                    ReportedNonIdentifier reportedNonIdentifier = new ReportedNonIdentifier();
                    reportedNonIdentifier.ReportID = report.ID;
                    reportedNonIdentifier.ReportedValue = formCollection[key];
                    reportedNonIdentifier.OrganisationProfileField = organisationProfileField;

                    db.ReportedNonIdentifiersESG.Add(reportedNonIdentifier);
                }
                else
                {
                    char[] SecondDelimiter = { '-' };
                    string[] ids = key.Split(SecondDelimiter);
                    int subSectorID = Convert.ToInt32(ids[0]);
                    int kpiID = Convert.ToInt32(ids[1]);

                    ReportedIdentifier reportedIdentifier = new ReportedIdentifier();
                    reportedIdentifier.KeyPerformanceIdentifierID = kpiID;
                    reportedIdentifier.ReportID = report.ID;
                    reportedIdentifier.SubsectorID = subSectorID;
                    reportedIdentifier.ReportedValue = formCollection[key];

                    db.ReportedIdentifiersESG.Add(reportedIdentifier);
                }

                db.SaveChanges();
            }

            TempData.Clear();

            return RedirectToAction("Index", "Home");
        }
Esempio n. 2
0
        /// <summary>
        /// Displays form fiels for chosed identifiers.
        /// </summary>
        /// <param name="formCollection">object that encapsulates chosed identifiers for reporting</param>
        public ActionResult Fill(FormCollection formCollection)
        {
            if (Session["OrganisationID"] == null)
            {
                TempData["accessError"] = "Vaše session vypršela, nebo nejste přihlášen.";
                return RedirectToAction("LogOn", "Organisation");
            }

            bool standardSubsectors = true;
            bool specialisedSubsectorsCorrect = true;

            this.TempData.Clear();

            foreach (var key in formCollection.AllKeys)
            {

                if (!key.StartsWith("S"))
                {
                    int subsectorID = Convert.ToInt32(key);
                    var subsector = db.SubsectorsESG.Where(s => s.ID == subsectorID).SingleOrDefault();

                    char[] delimiter2 = { ',' };
                    string[] identifiers2 = formCollection[key].Split(delimiter2);
                    IList<int> intIdentifiers1 = new List<int>();

                    foreach (var item in identifiers2)
                    {
                        intIdentifiers1.Add(Convert.ToInt32(item));
                        TempData[key + "-" + item] = "checked";
                    }

                    int countScope1 = subsector.KeyPerformanceIdentifiers.Where(kpi => kpi.Scope == 1).Count();

                    int countScope1Check = subsector.KeyPerformanceIdentifiers
                                                    .Where(kpi => kpi.Scope == 1)
                                                    .Where(kpi => intIdentifiers1.Contains(kpi.ID))
                                                    .Count();

                    if (countScope1 != countScope1Check)
                    {
                        standardSubsectors = false;
                    }
                }

                if (key.StartsWith("S"))
                {
                    char[] delimiter = { '-' };
                    string[] parts = key.Split(delimiter);

                    int subsectorID = Convert.ToInt32(parts[1]);
                    var subsector = db.SpecialisedSubsectorsESG.Where(s => s.ID == subsectorID).SingleOrDefault();

                    char[] delimiter2 = { ',' };
                    string[] identifiers2 = formCollection[key].Split(delimiter2);
                    IList<int> intIdentifiers = new List<int>();

                    foreach (var item in identifiers2)
                    {
                        intIdentifiers.Add(Convert.ToInt32(item));
                        TempData["S-" + subsectorID + "-" + item] = "checked";
                    }

                    int countScope1 = subsector.SpecialisedIdentifiers.Where(kpi => kpi.Scope == 1 && kpi.Activated).Count();
                    int countScope1Check = subsector.SpecialisedIdentifiers
                                                    .Where(si => si.Scope == 1 && si.Activated)
                                                    .Where(si => intIdentifiers.Contains(si.ID))
                                                    .Count();

                    if (countScope1 != countScope1Check)
                    {
                        specialisedSubsectorsCorrect = false;
                    }
                }
            }

            if (formCollection.AllKeys.Where(s => !s.StartsWith("S")).Count() == 0)
            {
                TempData["errorFound"] = "errorFound";
                TempData["notChosedStandardSubsector"] = "Musi být zvolen alespoň 1 standardní podsektor a všechny jeho identifikátory rozsahu 1.";
                return RedirectToAction("Choose");
            }

            if (!standardSubsectors || !specialisedSubsectorsCorrect)
            {
                TempData["errorFound"] = "errorFound";
                TempData["notChosedStandardSubsector"] = "Musi být zvolen alespoň 1 standardní podsektor a všechny jeho identifikátory rozsahu 1.";
                return RedirectToAction("Choose");
            }

            ChosedIdentifiers chosedIdentifiers = null;

            chosedIdentifiers = new ChosedIdentifiers();

            foreach (var key in formCollection.AllKeys)
            {
                if (key.StartsWith("S"))
                {
                    char[] delimiter1 = { '-' };
                    string[] identifiers1 = key.Split(delimiter1);

                    int specialisedSubsectorID = Convert.ToInt32(identifiers1[1]);
                    SpecialisedSubsector specialisedSubsector = db.SpecialisedSubsectorsESG.Where(ss => ss.ID == specialisedSubsectorID).SingleOrDefault();

                    chosedIdentifiers.AddSpecialisedSubsector(specialisedSubsector);

                    char[] delimiter2 = { ',' };
                    string[] identifiers2 = formCollection[key].Split(delimiter2);
                    IList<int> intIdentifiers1 = new List<int>();

                    foreach (var item in identifiers2)
                    {
                        intIdentifiers1.Add(Convert.ToInt32(item));
                    }

                    var specialisedSubsectorIdentifiers = db.SpecialisedIdentifiersESG.Where(si => intIdentifiers1.Contains(si.ID));

                    foreach (SpecialisedIdentifier item in specialisedSubsectorIdentifiers)
                    {
                        chosedIdentifiers.SpecialisedSubsectorsIdentifiers[specialisedSubsector].Add(item);
                    }

                    continue;
                }

                int subsectorID = Convert.ToInt32(key);
                Subsector subsector = db.SubsectorsESG.Where(s => s.ID == subsectorID).SingleOrDefault();

                chosedIdentifiers.AddSubsector(subsector);

                char[] delimiter = { ',' };
                string[] identifiers = formCollection[key].Split(delimiter);
                IList<int> intIdentifiers = new List<int>();

                foreach (var item in identifiers)
                {
                    intIdentifiers.Add(Convert.ToInt32(item));
                }

                var subsectorIdentifiers = db.KeyPerformanceIdentifiersESG.Where(kpi => intIdentifiers.Contains(kpi.ID));

                foreach (KeyPerformanceIdentifier item in subsectorIdentifiers)
                {
                    chosedIdentifiers.SubsectorsIdentifiers[subsector].Add(item);
                }
            }

            return View(chosedIdentifiers);
        }