public int[] AllKataloziId(int id, LogedUserTypeEnum userType)
{
if(userType == LogedUserTypeEnum.Poedinec)
return _db.Katalozi.Where(x => x.IdPoedinci == id).Select(x => x.IdKatalozi).ToArray();
else
return _db.Katalozi.Where(x => x.IdKompanii == id).Select(x => x.IdKatalozi).ToArray();
}
public ActionResult ChangePassword(LogedUserTypeEnum userType = 0)
{
//validate the userType parameter
if ((int)userType > 1)
return RedirectToAction("Login");
var model = new ChangePasswordModel();
model.UserType = userType;
return View(model);
}
public List<Katalozi> AllKatalozi(int id, LogedUserTypeEnum userType)
{
if (userType == LogedUserTypeEnum.Poedinec)
{
return _db.Katalozi.Include(x => x.Kategorii).Where(x => x.IdPoedinci == id).ToList();
}
else
{
return _db.Katalozi.Include(x => x.Kategorii).Where(x => x.IdKompanii == id).ToList();
}
}
public List<ViewProizvodiKategorii> IzlistajProizvodiKategorii(int roditelId, int id, LogedUserTypeEnum userType)
{
List<ViewProizvodiKategorii> list = new List<ViewProizvodiKategorii>();
List<Kategorii> kategorii = kategorijaQ.IzlistajSporedRoditelId(roditelId, id, userType);
foreach(Kategorii item in kategorii)
{
list.Add(
new ViewProizvodiKategorii()
{
MVKategorija=item,
MVVkupnoPodkategorii=kategorijaQ.PresmetajKategoriiSporedId(item.IdKategorii),
MVVkupnoProizvodi = kategorijaQ.PresmetajProizvodiSporedId(item.IdKategorii)
}
);
}
return list;
}
public List<KatalogViewModel> IzlistajKatalozi(int id, LogedUserTypeEnum userType)
{
int [] distinctKataloziId = AllKataloziId(id, userType);//distinctKatalozi();
int kataloziIdLength = distinctKataloziId.Length;
var katalozi = new List<KatalogViewModel>();
for (int i = 0; i < kataloziIdLength; i++) {
int ? katalogId = distinctKataloziId[i];
katalozi.Add(new KatalogViewModel {
IdKatalog = katalogId,
NazivNaKatalog=_db.Katalozi.Find(katalogId).NazivNaKatalog,
Trees = _db.Kategorii
.Where(x => x.IdKatalozi == katalogId)
.Select(x => new TreeViewModel
{
id = x.IdKategorii.ToString(),
parent = (x.RoditelId == null) ? "#" : x.RoditelId.ToString(),
text = x.NazivNaKategorija
})
as IEnumerable<TreeViewModel>
});
}
return katalozi;
}
public void DodadiPortfolio(int idKatalog, int idKorisnik, LogedUserTypeEnum userType)
{
string nazivNaWebSite = "";
if (userType == Helpers.Enumerations.LogedUserTypeEnum.Poedinec)
{
Poedinci poedinec = _db.Poedinci.Find(idKorisnik);
nazivNaWebSite = poedinec.Ime + " " + poedinec.Prezime;
}
else
{
Kompanii kompanija = _db.Kompanii.Find(idKorisnik);
nazivNaWebSite = kompanija.NazivNaKompanija;
}
WebSiteSettings wsettings = new WebSiteSettings
{
IdKatalozi = idKatalog,
FontFamily = "OpenSans-Regular",
FontColor1 = "darkBlueDarker",
FontColor2 = "greenLighter",
BGPocetna = "/Areas/Portfolio/Images/HomeBackgroundImage.jpg",
BGZaNas = "white",
BGFZaNas = "/Areas/Portfolio/Images/AboutFooter.jpg",
BGPortfolio = "white",
BGFPortfolio = "/Areas/Portfolio/Images/AboutFooter.jpg",
BGContact = "lightGreyLighter",
BGMenu = "lightGreyLighter",
BGFooter = "lightGreyLighter",
Naziv = nazivNaWebSite,
SodrzinaZaNasF = "The details are not details , they make the design",
SodrzinaPortfolioF = "The details are not details , they make the design",
Objaven = false
};
_db.WebSiteSettings.Add(wsettings);
_db.SaveChanges();
}
public List<ViewKataloziKategorii> IzlistajKatalozi(int id, LogedUserTypeEnum userType)
{
string stringpom;
List<Katalozi> katalozi = AllKatalozi(id, userType);
List<ViewKataloziKategorii> kataloziIkategorii = new List<ViewKataloziKategorii>();
foreach(var katalog in katalozi)
{
stringpom = ConvertStringListToString(katalog.Kategorii
.Where(x => x.RoditelId == null)
.Select(x => x.NazivNaKategorija)
.ToList());
kataloziIkategorii.Add(new ViewKataloziKategorii
{
IdKatalog = katalog.IdKatalozi,
Naziv = katalog.NazivNaKatalog,
Opis = katalog.OpisNaKatalog,
DataNaKreiranje = katalog.DataNaKreiranje,
ViewKategorii = stringpom
});
}
return kataloziIkategorii.ToList();
}
public KataloziIdINaziv[] KataloziIdINaziv(int id, LogedUserTypeEnum userType)
{
if(userType == LogedUserTypeEnum.Poedinec)
return _db.Katalozi.Where(x => x.IdPoedinci == id)
.Select(x => new KataloziIdINaziv { idkatalozi = x.IdKatalozi, naziv = x.NazivNaKatalog })
.ToArray();
else
return _db.Katalozi.Where(x => x.IdKompanii == id)
.Select(x => new KataloziIdINaziv { idkatalozi = x.IdKatalozi, naziv = x.NazivNaKatalog })
.ToArray();
}
public List<Kategorii> IzlistajSporedRoditelId(int roditelId, int id, LogedUserTypeEnum userType)
{
if (roditelId == 0)
{
if(userType == LogedUserTypeEnum.Poedinec)
return _db.Kategorii.Include(x => x.Katalozi).Where(x => x.RoditelId == null && x.Katalozi.IdPoedinci == id).ToList();
else
return _db.Kategorii.Include(x => x.Katalozi).Where(x => x.RoditelId == null && x.Katalozi.IdKompanii == id).ToList();
}
else
{
if(userType == LogedUserTypeEnum.Poedinec)
return _db.Kategorii.Include(x => x.Katalozi).Where(x => x.RoditelId == roditelId && x.Katalozi.IdPoedinci == id).ToList();
else
return _db.Kategorii.Include(x => x.Katalozi).Where(x => x.RoditelId == roditelId && x.Katalozi.IdKompanii == id).ToList();
}
}
public ViewPoraki InicijalizirajViewPoraki(int userId, LogedUserTypeEnum userType)
{
List<ViewKlienti> klienti = new List<ViewKlienti>();
if(userType == LogedUserTypeEnum.Poedinec)
{
var user = _db.Poedinci.FirstOrDefault(x => x.IdPoedinci == userId);
if(user != null)
{
klienti = user.Klienti.GroupBy(k => k.Ime.Substring(0, 1)).Select(kl => new ViewKlienti
{
Karakter = kl.Key.ToUpper(),
Klienti = kl.OrderBy(obj => obj.Ime).ToList()
}).ToList();
}
}
else if(userType == LogedUserTypeEnum.Kompanija)
{
var kompanija = _db.Kompanii.FirstOrDefault(x => x.IdKompanii == userId);
if(kompanija != null)
{
klienti = kompanija.Klienti.GroupBy(k => k.Ime.Substring(0, 1)).Select(kl => new ViewKlienti
{
Karakter = kl.Key.ToUpper(),
Klienti = kl.OrderBy(obj => obj.Ime).ToList()
}).ToList();
}
}
return new ViewPoraki
{
Body = "",
Subject = "",
KlientiGrupirani = klienti
};
}
public List<Poraki> GetSocuvaniPoraki(int userId, LogedUserTypeEnum userType)
{
var poraki = new List<Poraki>();
if(userType == LogedUserTypeEnum.Poedinec)
{
poraki = _db.Poraki.Where(x => x.IdPoedinci == userId && x.IsSent == false && x.IsDeleted == false && x.IsReceived == false).ToList();
}
else if(userType == LogedUserTypeEnum.Kompanija)
{
poraki = _db.Poraki.Where(x => x.IdKompanii == userId && x.IsSent == false && x.IsDeleted == false && x.IsReceived == false).ToList();
}
return poraki;
}
public MailPageViewModel GetPoraki(int userId, LogedUserTypeEnum userType)
{
var poraki = new MailPageViewModel();
if(userType == LogedUserTypeEnum.Poedinec)
{
poraki.IsprateniPoraki = _db.Poraki.Where(x => x.IdPoedinci == userId && x.IsSent == true && x.IsDeleted == false && x.IsReceived == false).ToList();
poraki.IzbrishaniPoraki = _db.Poraki.Where(x => x.IdPoedinci == userId && x.IsDeleted == true).ToList();
poraki.SocuvaniPoraki = _db.Poraki.Where(x => x.IdPoedinci == userId && x.IsSent == false && x.IsDeleted == false && x.IsReceived == false).ToList();
poraki.PrimeniPoraki = _db.Poraki.Where(x => x.IdPoedinci == userId && x.IsSent == false && x.IsDeleted == false && x.IsReceived == true).ToList();
}
else if(userType == LogedUserTypeEnum.Kompanija)
{
poraki.IsprateniPoraki = _db.Poraki.Where(x => x.IdKompanii == userId && x.IsSent == true && x.IsDeleted == false && x.IsReceived == false).ToList();
poraki.IzbrishaniPoraki = _db.Poraki.Where(x => x.IdKompanii == userId && x.IsDeleted == true).ToList();
poraki.SocuvaniPoraki = _db.Poraki.Where(x => x.IdKompanii == userId && x.IsSent == false && x.IsDeleted == false && x.IsReceived == false).ToList();
poraki.PrimeniPoraki = _db.Poraki.Where(x => x.IdKompanii == userId && x.IsSent == false && x.IsDeleted == false && x.IsReceived == true).ToList();
}
return poraki;
}
public List<Poraki> GetIzbrishaniPoraki(int userId, LogedUserTypeEnum userType)
{
var poraki = new List<Poraki>();
if(userType == LogedUserTypeEnum.Poedinec)
{
poraki = _db.Poraki
.Include(x => x.Klienti)
.Where(x => x.IdPoedinci == userId && x.IsDeleted == true)
.ToList();
}
else if(userType == LogedUserTypeEnum.Kompanija)
{
poraki = _db.Poraki
.Include(x => x.Klienti)
.Where(x => x.IdKompanii == userId && x.IsDeleted == true)
.ToList();
}
return poraki;
}
public List<Poraki> GetIsprateniPoraki(int userId, LogedUserTypeEnum userType)
{
List<Poraki> poraki = new List<Poraki>();
if(userType == LogedUserTypeEnum.Poedinec)
{
poraki = _db.Poraki
.Include(x => x.Klienti)
.Where(x => x.IdPoedinci == userId && x.IsSent == true && x.IsDeleted == false && x.IsReceived == false)
.ToList();
}
else if(userType == LogedUserTypeEnum.Kompanija)
{
poraki = _db.Poraki
.Include(x => x.Klienti)
.Where(x => x.IdKompanii == userId && x.IsSent == true && x.IsDeleted == false && x.IsReceived == false)
.ToList();
}
return poraki;
}
