// GET: OperatorLogReport
public ActionResult Index(OperatorLogParameters parameters)
{
var User = _dBUsersService.GetAllDBUsers();
var TCode = _codeOperationService.GetAllCodeOperation();
var Liste = _reportService.OperatorLogReport(parameters);
var model = new OperatorLogListViewModel
{
Kullanici_Adi = User.Select(a => new SelectListItem
{
Text = (a.Adi + " " + a.Soyadi),
Value = a.Kullanici_Adi
}),
Code_Operation = TCode.Select(a => new SelectListItem
{
Text = a.Operasyon,
Value = a.TKod.ToString()
}),
OperatorLogList = Liste
};
TempData["Operator"] = Liste;
TempData["DateAndTime"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
TempData["DateAndTimeView"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
return(View(model));
}
public ActionResult Total(RefectoryParameters parameters)
{
var Total = _reportService.YemekhaneRaporuTotal(parameters, CurrentSession.User);
var Groups = _doorGroupsMasterService.GetAllDoorGroupsMaster();
var Email = _emailSettingsService.GetAllEMailSetting().FirstOrDefault();
var Sikterler = _sirketService.GetAllSirketler(x => dbSirketList.Contains(x.Sirket_No)); //_reportService.SirketListesi(user);
var Departmanlar = _departmanService.GetAllDepartmanlar(x => dbDepartmanList.Contains(x.Departman_No)); //_reportService.DepartmanListesi(user);
var AltDepartman = _altDepartmanService.GetAllAltDepartman(x => x.Departman_No == parameters.Departman_No && dbAltDepartmanList.Contains(x.Alt_Departman_No));
var Bolumler = _bolumService.GetAllBolum(x => x.Alt_Departman_No == parameters.Alt_Departman_No && x.Departman_No == parameters.Departman_No);
var Birimler = _birimService.GetAllBirim(x => x.Departman_No == parameters.Departman_No && x.Alt_Departman_No == parameters.Alt_Departman_No && x.Bolum_No == parameters.Bolum_No);
ViewBag.Kapi_Grup_No = new SelectList(_doorGroupsMasterService.GetAllDoorGroupsMaster(), "Kapi_Grup_No", "Kapi_Grup_Adi", Email.Kapi_Grup_No);
var model = new RefectoryListViewModel
{
Group_ID = Groups.Select(a => new SelectListItem
{
Text = a.Kapi_Grup_Adi,
Value = a.Kapi_Grup_No.ToString()
}),
Sirket_No = Sikterler.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Sirket_No.ToString()
}),
Departman_No = Departmanlar.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Departman_No.ToString()
}),
Alt_Departman_No = AltDepartman.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Alt_Departman_No.ToString()
}),
Bolum_No = Bolumler.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Bolum_No.ToString()
}),
Birim_No = Birimler.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Birim_No.ToString()
}),
ToplamGecis = Total,
EmailSettings = Email,
User = user
};
TempData["UserAccessCountTotal"] = Total;
TempData["DateAndTime"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
TempData["DateAndTimeView"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
return(View(model));
}
// GET: OutherReport
public ActionResult Index(OutherReportParameters parameters)
{
var liste = _reportService.GetDigerGecisListesi(parameters);
var panel = _panelSettingsService.GetAllPanelSettings(x => x.Panel_IP1 != null && x.Panel_IP1 != 0 && x.Panel_TCP_Port != 0 && x.Panel_ID != 0 && dbPanelList.Contains((int)x.Panel_ID));
var model = new DigerGecisRaporListViewModel
{
DigerGecisListesi = liste,
Panel = panel.Select(a => new SelectListItem
{
Text = a.Panel_Name,
Value = a.Panel_ID.ToString()
})
};
TempData["DigerGecis"] = liste;
TempData["DateAndTime"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
TempData["DateAndTimeView"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
return(View(model));
}
// GET: UndefinedUserReport
public ActionResult Index(TanimsizReportParameters parameters)
{
var list = _reportService.GetTanimsizListesi(parameters);
var PanelName = _panelSettingsService.GetAllPanelSettings(x => x.Panel_IP1 != null && x.Panel_IP1 != 0 && x.Panel_TCP_Port != 0 && x.Panel_ID != 0 && dbPanelList.Contains((int)x.Panel_ID));
var model = new TanimsizKullaniciListViewModel
{
Liste = list,
Panel = PanelName.Select(x => new SelectListItem
{
Text = x.Panel_Name,
Value = x.Panel_ID.ToString()
})
};
TempData["Tanimsiz"] = list;
TempData["DateAndTime"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
TempData["DateAndTimeView"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
return(View(model));
}
// GET: VisitorReport
public ActionResult Index(VisitorReportParameters parameters)
{
List <Visitors> visitors = new List <Visitors>();
var liste = _reportService.GetZiyaretciListesi(parameters);
var panel = _panelSettingsService.GetAllPanelSettings(x => x.Panel_IP1 != 0 && x.Panel_IP1 != 0 && x.Panel_TCP_Port != 0 && x.Panel_ID != 0 && dbPanelList.Contains((int)x.Panel_ID));
visitors = _visitorsService.GetAllVisitors();
var groupsdetail = _groupMasterService.GetAllGroupsMaster();
var globalBolgeAdi = _globalZoneService.GetAllGlobalZones();
var model = new VisitorsList
{
ComplexVisitorsListesi = liste,
Panel = panel.Select(a => new SelectListItem
{
Text = a.Panel_Name,
Value = a.Panel_ID.ToString()
}),
Visitors = visitors,
Gecis_Grubu = groupsdetail.Select(a => new SelectListItem
{
Text = a.Grup_Adi,
Value = a.Grup_No.ToString()
}),
Global_Kapi_Bolgesi = globalBolgeAdi.Select(a => new SelectListItem
{
Text = a.Global_Bolge_Adi,
Value = a.Global_Bolge_No.ToString()
}),
};
TempData["VisitorsList"] = liste;
TempData["DateAndTime"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
TempData["DateAndTimeView"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
return(View(model));
}
// GET: ReportPersonelEski
public ActionResult OldStaff(ActiveUserReportParameters parameters)
{
var panel = _panelSettingsService.GetAllPanelSettings(x => x.Panel_IP1 != null && x.Panel_IP1 != 0 && x.Panel_TCP_Port != 0 && x.Panel_ID != 0 && dbPanelList.Contains((int)x.Panel_ID));
var groupsdetail = _groupMasterService.GetAllGroupsMaster();
var globalBolgeAdi = _globalZoneService.GetAllGlobalZones();
var departmanlar = _departmanService.GetAllDepartmanlar(x => dbDepartmanList.Contains(x.Departman_No)); // _departmanService.GetByKullaniciAdi(user.Kullanici_Adi);
var bloklar = _bloklarService.GetAllBloklar();
var sirketler = _sirketService.GetAllSirketler(x => dbSirketList.Contains(x.Sirket_No)); // _sirketService.GetByKullaniciAdi(user.Kullanici_Adi);
var groupMaster = _groupMasterService.GetAllGroupsMaster();
var visitors = _visitorsService.GetAllVisitors();
var liste = _reportService.GetReportPersonelListsEski(parameters, CurrentSession.User);
var eskiKullanicilar = _reportService.GetReportPersonelListsEski(null, CurrentSession.User);
var alddepartmanlar = _altDepartmanService.GetAllAltDepartman(x => x.Departman_No == parameters.Departman && dbAltDepartmanList.Contains(x.Alt_Departman_No));
var unvanlar = _unvanService.GetAllUnvan();
var bolumler = _bolumService.GetAllBolum(x => x.Alt_Departman_No == parameters.AltDepartman && x.Departman_No == parameters.Departman);
var birimler = _birimService.GetAllBirim(x => x.Departman_No == parameters.Departman && x.Alt_Departman_No == parameters.AltDepartman && x.Bolum_No == parameters.Bolum);
var model = new ReportPersonelViewModel
{
ReportPersonel = liste,
Kullanıcı = null,
EskiKullanicilar = eskiKullanicilar,
Panel = panel.Select(a => new SelectListItem
{
Text = a.Panel_Name,
Value = a.Panel_ID.ToString()
}),
Global_Kapi_Bolgesi = globalBolgeAdi.Select(a => new SelectListItem
{
Text = a.Global_Bolge_Adi,
Value = a.Global_Bolge_No.ToString()
}),
Departman = departmanlar.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Departman_No.ToString()
}),
Blok = bloklar.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Blok_No.ToString()
}),
Sirket = sirketler.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Sirket_No.ToString()
}),
Gecis_Grubu = groupMaster.Select(a => new SelectListItem
{
Text = a.Grup_Adi,
Value = a.Grup_No.ToString()
}),
AltDepartman = alddepartmanlar.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Alt_Departman_No.ToString()
}),
Unvan = unvanlar.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Unvan_No.ToString()
}),
Bolum = bolumler.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Bolum_No.ToString()
}),
Birim_No = birimler.Select(a => new SelectListItem
{
Text = a.Adi,
Value = a.Birim_No.ToString()
})
};
TempData["ReportPersonel"] = liste;
TempData["DateAndTime"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
TempData["DateAndTimeView"] = ReportParamatersDateAndTime.ParametersDateAndTimeBindForReport(parameters.Baslangic_Tarihi, parameters.Bitis_Tarihi, parameters.Baslangic_Saati, parameters.Bitis_Saati);
return(View(model));
}
