// 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));
}
