// GET: Izin public ActionResult Index(int?izintipId, DateTime?baslangicTS, DateTime?bitisTS) { var model = new IzinPageVM(); model.IzinTipList = IzintipSelection(); model.IzintipId = izintipId; model.BaslangicTS = baslangicTS; model.BitisTS = bitisTS; var UserId = Convert.ToInt32(User.GetUserPropertyValue("UserId")); var query = izinContext.Izinler.Where(x => x.IzinKullaniciId == UserId).AsQueryable().ToList(); if (izintipId != null) { query = query.Where(x => x.IzinTipId == izintipId).ToList(); } if (baslangicTS != null) { query = query.Where(x => x.BaslangicTarihi >= baslangicTS).ToList(); } if (bitisTS != null) { query = query.Where(x => x.BitisTarihi <= bitisTS).ToList(); } model.IzinlerimList = query; return(View(model)); }
public ActionResult TumIzinler(int?kullaniciId, DateTime?baslangicTS, DateTime?bitisTS) { var model = new IzinPageVM(); model.userList = UserSelectList(); model.UserId = kullaniciId; model.BaslangicTS = baslangicTS; model.BitisTS = bitisTS; var query = izinContext.Izinler.AsQueryable().ToList(); if (kullaniciId != null) { query = query.Where(x => x.IzinKullaniciId == kullaniciId).ToList(); } if (baslangicTS != null) { query = query.Where(x => x.BaslangicTarihi >= baslangicTS).ToList(); } if (bitisTS != null) { query = query.Where(x => x.BitisTarihi <= bitisTS).ToList(); } model.IzinlerimList = query; return(View(model)); }
public ActionResult IndexOnay(int?kullaniciId, DateTime?baslangicTS, DateTime?bitisTS) { var model = new IzinPageVM(); model.TeamUserList = TeamUserSelectList(); model.UserId = kullaniciId; model.BaslangicTS = baslangicTS; model.BitisTS = bitisTS; var UserId = Convert.ToInt32(User.GetUserPropertyValue("UserId")); var depId = izinContext.Departmanlar.FirstOrDefault(x => x.YoneticiKullaniciId == UserId).Id; var userList = izinContext.Kullanicilar.Where(x => x.DepartmanId == depId).ToList(); List <Izin> usersIzin = new List <Izin>(); if (userList.Count > 0) { foreach (var item in userList) { var query = izinContext.Izinler .Include(x => x.IzinKullanici) .Where(x => x.IzinKullaniciId == item.Id && x.DurumId == 2) .AsQueryable() .ToList(); for (int i = 0; i < query.Count; i++) { usersIzin.Add(query[i]); } } } //var query = izinContext.Izinler.Where(x => x.IzinKullaniciId == UserId).AsQueryable().ToList(); if (kullaniciId != null) { usersIzin = usersIzin.Where(x => x.IzinKullaniciId == kullaniciId).ToList(); } if (baslangicTS != null) { usersIzin = usersIzin.Where(x => x.BaslangicTarihi >= baslangicTS).ToList(); } if (bitisTS != null) { usersIzin = usersIzin.Where(x => x.BitisTarihi <= bitisTS).ToList(); } model.IzinlerimList = usersIzin; return(View(model)); }