Ejemplo n.º 1
0
 public AdministratorViewModel(OstaleFunkcionalnostiViewModel p)
 {
     NovaNovost   = new Novost(DateTime.Today, null, "", "");
     NoviKandidat = new Kandidat();
     //this.Sistem = new GlasackiSistem();
     Parent                      = p;
     this.Sistem                 = Parent.Sistem;
     kojaStranka                 = new Stranka();
     ListaKandidata              = new List <Kandidat>();
     ListaNovosti                = new List <Novost>();
     INS                         = new NavigationService();
     Login                       = new RelayCommand <object>(registrujAdmina, potvrdi);
     DodavanjeKandidata          = new RelayCommand <object>(dodajKandidata, boolDodaj);
     DodavanjeNovosti            = new RelayCommand <object>(dodajNovost, boolDodaj);
     BrisanjeKandidata           = new RelayCommand <object>(obrisiKandidata, boolDodaj);
     BrisanjeNovosti             = new RelayCommand <object>(obrisiNovost, boolDodaj);
     IzmjenaKandidata            = new RelayCommand <object>(promjenaKandidata, boolDodaj);
     IzmjenaNovosti              = new RelayCommand <object>(promjenaNovosti, boolDodaj);
     Odjava                      = new RelayCommand <object>(odjava, boolDodaj);
     OtvoriPretraguK             = new RelayCommand <object>(pretragaK, boolDodaj);
     OtvoriPretraguN             = new RelayCommand <object>(pretragaN, boolDodaj);
     PretragaNovosti             = new RelayCommand <object>(nadjiNovosti, boolDodaj);
     PretragaKandidata           = new RelayCommand <object>(nadjiKandidate, boolDodaj);
     UcitajSliku                 = new RelayCommand <object>(dodajSliku, boolDodaj);
     NoviKandidat.ErrorsChanged += Vm_ErrorsChanged;
 }
Ejemplo n.º 2
0
        public async Task <IHttpActionResult> PutStranka(int id, Stranka stranka)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != stranka.Id)
            {
                return(BadRequest());
            }

            db.Entry(stranka).State = EntityState.Modified;

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!StrankaExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Ejemplo n.º 3
0
 public DataSource()
 {
     Glasac         g1  = DajSveGlasace()[0];
     GlasackiSistem gs1 = DajSveGlasackeSisteme()[0];
     Stranka        s1  = DajSveStranke()[0];
     Ulica          u1  = DajSveUlice()[0];
     Novost         n1  = DajSveNovosti()[0];
 }
        private void SaveLastEventStatusToStranka(int idStatus, int idStranka)
        {
            Stranka str = context.Stranka.Where(s => s.idStranka == idStranka).FirstOrDefault();

            if (str != null)
            {
                str.LastStatusID = idStatus;
                str.tsLastStatus = DateTime.Now;
                context.SaveChanges();
            }
        }
Ejemplo n.º 5
0
        public async Task <IHttpActionResult> GetStranka(int id)
        {
            Stranka stranka = await db.Strankas.FindAsync(id);

            if (stranka == null)
            {
                return(NotFound());
            }

            return(Ok(stranka));
        }
Ejemplo n.º 6
0
        public async Task <IHttpActionResult> PostStranka(Stranka stranka)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.Strankas.Add(stranka);
            await db.SaveChangesAsync();

            return(CreatedAtRoute("DefaultApi", new { id = stranka.Id }, stranka));
        }
Ejemplo n.º 7
0
        public async Task <IHttpActionResult> DeleteStranka(int id)
        {
            Stranka stranka = await db.Strankas.FindAsync(id);

            if (stranka == null)
            {
                return(NotFound());
            }

            db.Strankas.Remove(stranka);
            await db.SaveChangesAsync();

            return(Ok(stranka));
        }
Ejemplo n.º 8
0
 public IActionResult DodajStranku(Stranka s)
 {
     context.Stranka.Add(s);
     context.SaveChanges();
     return(View("Index"));
 }
Ejemplo n.º 9
0
        private string ConstructTemplate(List <Avtomatika> list, string parentTemplate)
        {
            try
            {
                string       templatePath          = (AppDomain.CurrentDomain.BaseDirectory + ConfigurationManager.AppSettings["EMPLOYEE_PARTIAL_TEMPLATE"].ToString()).Replace("\"", "\\");
                StreamReader reader                = new StreamReader(templatePath);
                string       clientPartialTemplate = reader.ReadToEnd();
                reader.Close();

                clientPartialTemplate = clientPartialTemplate.Replace("$%ServerTag%$", ConfigurationManager.AppSettings["ServerTag"].ToString());

                string concatenateTemplate = "";

                var groupByClient = list.GroupBy(ag => ag.Dogodek.idStranka).ToList();
                //DataTypesHelper.LogThis("*****ConstructTemplate before first foreach*****");
                foreach (var item in groupByClient)//Number of clients
                {
                    //DataTypesHelper.LogThis("*****ConstructTemplate IN first foreach*****" + " clientID : " + item.Key.Value.ToString() + " Dogodek : " + item.Select(o => o.Dogodek).FirstOrDefault().idDogodek);

                    Stranka stranka = item.Select(o => o.Dogodek).FirstOrDefault().Stranka;

                    if (stranka == null)
                    {
                        break;                 //če stranka ne obstaja v bazi zaključimo for zanko in vrenmo template
                    }
                    concatenateTemplate += ReplaceDefaultValuesInTemplate(stranka, clientPartialTemplate);
                    int itemCount = 1;
                    //DataTypesHelper.LogThis("*****ConstructTemplate before second foreach - number of clients: *****" + groupByClient.Count.ToString());
                    foreach (var avtomatika in item.ToList())
                    {
                        if (avtomatika.Dogodek.Kategorija != null)//če so določene posamezne kategorije na katerih je bil zaznan padec prodaje
                        {
                            //DataTypesHelper.LogThis("*****ConstructTemplate IN second foreach***** EVENT ID" + avtomatika.DogodekID.ToString() + " : items: " + item.ToList().Count.ToString() + " clientID : " + item.Key.Value.ToString() + " employeeID : " + avtomatika.OsebaID.ToString());
                            int index = concatenateTemplate.IndexOf("##INSERT_CATEGORIES_HERE##");
                            //DataTypesHelper.LogThis("*****1 - indexOF method***** : " + index.ToString());
                            if (avtomatika.Equals(item.ToList().Last()) && (itemCount % 2 != 0 || item.ToList().Count == 1))
                            {
                                //DataTypesHelper.LogThis("*****2 - Dogodek Values: ***** : " + avtomatika.Dogodek.idDogodek.ToString() + " - " + avtomatika.Dogodek.Kategorija.Naziv);

                                concatenateTemplate = concatenateTemplate.Insert(index, "<div class='catFullWidth'>" + avtomatika.Dogodek.Kategorija.Naziv + "<br />" + " <strong>PADEC</strong></div>");
                                break;
                            }
                            //DataTypesHelper.LogThis("*****3 - after if***** : ");

                            if (itemCount % 2 == 0)
                            {
                                concatenateTemplate = concatenateTemplate.Insert(index, "<div class='catOneHalfRight'>" + avtomatika.Dogodek.Kategorija.Naziv + "<br />" + " <strong>PADEC</strong></div>");
                            }
                            else
                            {
                                concatenateTemplate = concatenateTemplate.Insert(index, "<div class='catOneHalfLeft'>" + avtomatika.Dogodek.Kategorija.Naziv + "<br />" + " <strong>PADEC</strong></div>");
                            }
                            //DataTypesHelper.LogThis("*****4 - before itemCount++***** : " + itemCount.ToString());
                        }
                        itemCount++;
                    }
                    //DataTypesHelper.LogThis("*****ConstructTemplate AFTER first foreach*****");
                    concatenateTemplate = concatenateTemplate.Replace("##INSERT_CATEGORIES_HERE##", "");
                }

                return(concatenateTemplate);
            }
            catch (Exception ex)
            {
                DataTypesHelper.LogThis("*****Error - ***** : " + ex.Message + " " + ex.InnerException.Message + " " + ex.StackTrace);
                throw new Exception("", ex);
            }
        }
        public ChartRenderModel GetDataForChartFromSQLFunction(int clientID, int categorieID, int period, int type, DateTime?dateFROM = null, DateTime?dateTO = null)
        {
            try
            {
                ChartRenderModel model = new ChartRenderModel();

                Stranka    stranka    = context.Stranka.Where(s => s.idStranka.Equals(clientID)).FirstOrDefault();
                Kategorija kategorija = context.Kategorija.Where(k => k.idKategorija.Equals(categorieID)).FirstOrDefault();

                //if the dates FROM and TO are not set, then we set the dates based on period
                if (dateFROM == null && dateTO == null)
                {
                    switch (period)
                    {
                    case (int)Enums.ChartRenderPeriod.LETNO:
                        dateTO   = DateTime.Now;
                        dateFROM = new DateTime(dateTO.Value.AddYears(-5).Year, 1, 1);
                        break;

                    case (int)Enums.ChartRenderPeriod.MESECNO:
                        dateTO   = DateTime.Now;
                        dateFROM = new DateTime(dateTO.Value.AddYears(-3).Year, 1, 1);
                        break;
                    }
                }


                List <IzrisGrafa_Result> list = context.IzrisGrafa(stranka.KodaStranke, kategorija.Koda, type, period, dateFROM, dateTO).ToList();

                var query = from db in list
                            select new ChartRenderSimple
                {
                    Datum        = db.Datum.Value,
                    EnotaMere    = db.EnotaMere,
                    IzpisGrafaID = -1,
                    KategorijaID = db.KategorijaID.Value,
                    Obdobje      = db.Obdobje.Value,
                    Opis         = db.Opis,
                    StrankaID    = db.StrankaID.Value,
                    Tip          = db.Tip.Value,
                    Vrednost     = db.Vrednost.Value
                };


                model.chartRenderData = query.ToList();

                if (model.chartRenderData.Count > 0)
                {
                    DateTime min = model.chartRenderData.Min(crd => crd.Datum);
                    DateTime max = model.chartRenderData.Max(crd => crd.Datum);
                    if (period == 2)//Year chart render
                    {
                        if (model.chartRenderData.Count > 0)
                        {
                            model.chartRenderData[model.chartRenderData.Count - 1].Datum = model.chartRenderData[model.chartRenderData.Count - 1].Datum.AddMonths(11);
                        }
                        max = max.AddMonths(12);
                    }
                    model.EventList = eventRepo.GetEventsByClientIDAndCategorieID(clientID, categorieID, min, max);
                }
                else
                {
                    model.EventList = new List <EventSimpleModel>();
                }

                return(model);
            }
            catch (Exception ex)
            {
                throw new Exception(ValidationExceptionError.res_06, ex);
            }
        }