public string giris(string username, string password, string Hardware_Id) { User_Details UserTable = db.User_Details.Where(x => x.User_Name == username && x.User_Pass == password).FirstOrDefault(); if (UserTable != null) { PC_Details pc_varmi = db.PC_Details.Where(x => x.Hardware_Id == Hardware_Id).FirstOrDefault(); if (pc_varmi == null) { PC_Details PC_Details = new PC_Details(); PC_Details.User_Id = UserTable.id; PC_Details.Hardware_Id = Hardware_Id; PC_Details.Status_ = true; PC_Details.Last_Sync = DateTime.Now; db.PC_Details.Add(PC_Details); db.SaveChanges(); return("Pc_Eklendi");//Kullanıcı id si bu olan kayıt giriş yaptı ve bilgisayarı ekledı } else { pc_varmi.Status_ = true; pc_varmi.Last_Sync = DateTime.Now; db.SaveChanges(); return("Normal_Giris");//Kullanıcıya Ait Bilgisayar Var Normal Giriş Yap. } } else { return("Kullanici_Bulunamadi");//Kullanıcı Bulunamadı. } }
public void pc_information(string thardwareid, string tDomain_User_Name, string tVersion_, double tMemory_Size_Gb, string tProcessor_Name, string tMotherboard_Info) { PC_Details temp_pc_detail = db.PC_Details.Where(x => x.Hardware_Id == thardwareid).FirstOrDefault(); if (temp_pc_detail != null) { temp_pc_detail.Domain_User_Name = tDomain_User_Name.Replace("\\", "-"); temp_pc_detail.Version_ = tVersion_; temp_pc_detail.Memory_Size_Gb = tMemory_Size_Gb; temp_pc_detail.Processor_Name = tProcessor_Name; temp_pc_detail.Motherboard_Info = tMotherboard_Info; db.SaveChanges(); } }
public string girisSonrasiKontrol(string hardware_id) { PC_Details PC_Detailss = db.PC_Details.Where(x => x.Hardware_Id == hardware_id).SingleOrDefault(); if (PC_Detailss != null) { PC_Detailss.Online = true; db.SaveChanges(); return("Ok"); } else { return("Giris_Ekrani"); } }
public string ayarKontrol(string username, string password, string hardware_id) { User_Details User_Detailss = db.User_Details.Where(x => x.User_Name == username && x.User_Pass == password).FirstOrDefault(); if (User_Detailss != null) { PC_Details PC_DetailsS = db.PC_Details.Where(x => x.Hardware_Id == hardware_id).FirstOrDefault(); if (PC_DetailsS != null) { return("AyarAc"); } else { return("PcEslesmedi"); } } else { //bulunamadı return("Bulunamadi"); } }
public void kullanimlari_esitle(string thardwareid, DataTable sys_table, DataTable app_table) { PC_Details temp_pc_detail = db.PC_Details.Where(x => x.Hardware_Id == thardwareid).FirstOrDefault(); if (temp_pc_detail != null) { foreach (DataRow item in sys_table.Rows) { System_Usage temp_sys_usage_data = new System_Usage(); temp_sys_usage_data.Hardware_Id = thardwareid; temp_sys_usage_data.Cpu = Convert.ToDouble(item[2]); temp_sys_usage_data.Memory = Convert.ToDouble(item[3]); temp_sys_usage_data.Network_Rec = Convert.ToDouble(item[4]); temp_sys_usage_data.Network_Out = Convert.ToDouble(item[5]); temp_sys_usage_data.IO_Read = Convert.ToDouble(item[6]); temp_sys_usage_data.IO_Write = Convert.ToDouble(item[7]); temp_sys_usage_data.Datetime_ = Convert.ToDateTime(item[8]); temp_sys_usage_data.Sync = true; db.System_Usage.Add(temp_sys_usage_data); } foreach (DataRow item in app_table.Rows) { App_Usage temp_app_usage_data = new App_Usage(); temp_app_usage_data.Hardware_Id = thardwareid; temp_app_usage_data.Process_Name = item[2].ToString(); temp_app_usage_data.Process_Windows_Title = item[3].ToString(); temp_app_usage_data.Cpu = Convert.ToDouble(item[4]); temp_app_usage_data.Memory = Convert.ToDouble(item[5]); temp_app_usage_data.Network_Rec = Convert.ToDouble(item[6]); temp_app_usage_data.Network_Out = Convert.ToDouble(item[7]); temp_app_usage_data.IO_Read = Convert.ToDouble(item[8]); temp_app_usage_data.IO_Write = Convert.ToDouble(item[9]); temp_app_usage_data.Datetime_ = Convert.ToDateTime(item[10]); temp_app_usage_data.Sync = true; db.App_Usage.Add(temp_app_usage_data); } db.SaveChanges(); } }
public ActionResult GirisIslemi(User_Details uye) { User_Details uye_temp = db.User_Details.Where(x => x.User_Name == uye.User_Name && x.User_Pass == uye.User_Pass).FirstOrDefault(); if (uye_temp != null) { PC_Details Current_PC = db.PC_Details.Where(x => x.User_Id == uye_temp.id).FirstOrDefault(); if (Current_PC != null) { Session["Current_PC_Hw_id"] = Current_PC.Hardware_Id; Session["PC_Details"] = Current_PC; } Session["User_Details"] = uye_temp; bilgisayari_varmi(); return(Redirect("/Panel")); } else { return(Redirect("/Panel/Giris")); } }
public ActionResult is_kaydi(int?gorev, string yol, int?limit_dakika) { string hw_id = Session["Current_PC_Hw_id"].ToString(); if (gorev == 1)//screen capture { try { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "Screen_Capture").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "Screen_Capture"; yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } catch { } } else if (gorev == 2)//screen record { try { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "Screen_Record").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "Screen_Record"; yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } catch { } } else if (gorev == 3)//uygulama baslat { try { PC_Details pc_det = db.PC_Details.Where(x => x.Hardware_Id == hw_id).FirstOrDefault(); if (pc_det != null && pc_det.Online == true) { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "App_Run").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "App_Run"; yeni_is.Query_ = yol; yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Query_ = yol; kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } else { //PC KAPALI UYASIRISI } } catch { } } else if (gorev == 4)//uygulama sonlandir { try { PC_Details pc_det = db.PC_Details.Where(x => x.Hardware_Id == hw_id).FirstOrDefault(); if (pc_det != null && pc_det.Online == true) { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "App_Stop").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "App_Stop"; yeni_is.Query_ = yol; yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Query_ = yol; kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } else { //PC KAPALI UYASIRISI } } catch { } } else if (gorev == 5)//uygulama engelle { try { PC_Details pc_det = db.PC_Details.Where(x => x.Hardware_Id == hw_id).FirstOrDefault(); if (pc_det != null) { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "Banned_App_Add").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "Banned_App_Add"; yeni_is.Query_ = yol; if (limit_dakika != -1) { yeni_is.Temp_ = limit_dakika; } else { yeni_is.Temp_ = -1; } yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Query_ = yol; if (limit_dakika != -1) { kayit_.Temp_ = limit_dakika; } else { kayit_.Temp_ = -1; } kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } else { //PC KAPALI UYASIRISI } } catch { } } else if (gorev == 6)//uygulama engel kaldır { try { PC_Details pc_det = db.PC_Details.Where(x => x.Hardware_Id == hw_id).FirstOrDefault(); if (pc_det != null) { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "Banned_App_Remove").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "Banned_App_Remove"; yeni_is.Query_ = yol; yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Query_ = yol; kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } else { //PC KAPALI UYASIRISI } } catch { } } else if (gorev == 7)// cmd execute query { try { PC_Details pc_det = db.PC_Details.Where(x => x.Hardware_Id == hw_id).FirstOrDefault(); if (pc_det != null) { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "Cmd").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "Cmd"; yeni_is.Query_ = yol; yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Query_ = yol; kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } else { //PC KAPALI UYASIRISI } } catch { } } else if (gorev == 8)// cmd execute query { try { PC_Details pc_det = db.PC_Details.Where(x => x.Hardware_Id == hw_id).FirstOrDefault(); if (pc_det != null) { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "Browser_Histories").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "Browser_Histories"; yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } else { //PC KAPALI UYASIRISI } } catch { } } else if (gorev == 9)//Uygulama Kur { try { PC_Details pc_det = db.PC_Details.Where(x => x.Hardware_Id == hw_id).FirstOrDefault(); if (pc_det != null) { Work_Order kayit_ = db.Work_Order.Where(x => x.Hardware_Id == hw_id && x.Work_ == "Install_App").FirstOrDefault(); if (kayit_ == null) { Work_Order yeni_is = new Work_Order(); yeni_is.Hardware_Id = hw_id; yeni_is.Work_ = "Install_App"; yeni_is.Query_ = yol; yeni_is.Result_ = false; yeni_is.Active_ = true; yeni_is.Datetime_ = DateTime.Now; db.Work_Order.Add(yeni_is); db.SaveChanges(); } else { kayit_.Query_ = yol; kayit_.Result_ = false; kayit_.Active_ = true; kayit_.Datetime_ = DateTime.Now; db.SaveChanges(); } } else { //PC KAPALI UYASIRISI } } catch { } } else { } return(RedirectToAction("EkranYakala", "Panel")); }
public ActionResult Rapor(int?id) { if (Session["User_Details"] == null) { return(Redirect("Giris")); } bilgisayari_varmi(); string hwid = Session["Current_PC_Hw_id"].ToString(); //-Tarih Hesaplanıyor-// DateTime aralik = DateTime.Now; if (id != null && id != 0 && id > 0) { aralik = aralik.AddDays(-Convert.ToInt32(id)); } else { aralik = Convert.ToDateTime("01.01.1970 00:00:00"); } //--Genel-APP CPU-RAM--NETWORK-DİSK KULLANIMI--// int item_count = 1; #region sistem_kullanim_cpu_chart List <JS_Chart_Data_Model> js_data_list_cpu = new List <JS_Chart_Data_Model>(); List <JS_Chart_Data_Model> js_data_list_ram = new List <JS_Chart_Data_Model>(); List <JS_Chart_Data_Model> js_data_list_disk = new List <JS_Chart_Data_Model>(); foreach (var item in db.System_Usage.Where(x => x.Hardware_Id == hwid && x.Datetime_ > aralik).ToList()) { JS_Chart_Data_Model cpu = new JS_Chart_Data_Model(); cpu.x = item_count; cpu.y = Math.Round(Convert.ToDouble(item.Cpu), 2); cpu.label = Convert.ToString(String.Format("{0:T}", item.Datetime_)); js_data_list_cpu.Add(cpu); JS_Chart_Data_Model ram = new JS_Chart_Data_Model(); ram.x = item_count; ram.y = Math.Round(Convert.ToDouble(item.Memory), 2); ram.label = Convert.ToString(String.Format("{0:T}", item.Datetime_)); js_data_list_ram.Add(ram); JS_Chart_Data_Model disk = new JS_Chart_Data_Model(); disk.x = item_count; disk.y = Math.Round(Convert.ToDouble(item.IO_Read + item.IO_Write), 2); disk.label = Convert.ToString(String.Format("{0:T}", item.Datetime_)); js_data_list_disk.Add(disk); item_count++; } //--Chart Genel Verileri Hazırlanıyor--// TempData["js_data__sys_cpu"] = JsonConvert.SerializeObject(js_data_list_cpu); TempData["js_data__sys_ram"] = JsonConvert.SerializeObject(js_data_list_ram); TempData["js_data__sys_disk"] = JsonConvert.SerializeObject(js_data_list_disk); item_count = 0; //--Max Genel Verileri Hazırlanıyor--// TempData["max_sys_cpu"] = js_data_list_cpu.Sum(x => x.y) / js_data_list_cpu.Count(); TempData["max_sys_ram"] = js_data_list_ram.Sum(x => x.y) / js_data_list_ram.Count(); TempData["max_sys_disk"] = js_data_list_disk.Sum(x => x.y) / js_data_list_disk.Count(); #endregion sistem_kullanim_cpu_chart #region uygulama_kullanim_cpu_chart List <JS_Chart_Data_Model> js_data_list_cpu_app = new List <JS_Chart_Data_Model>(); List <JS_Chart_Data_Model> js_data_list_ram_app = new List <JS_Chart_Data_Model>(); List <JS_Chart_Data_Model> js_data_list_disk_app = new List <JS_Chart_Data_Model>(); //--Uygulama Verileri Hzırlanıyor--// var app_usage_list_query = (from cc in db.App_Usage.Where(x => x.Hardware_Id == hwid && x.Datetime_ > aralik).ToList() group cc by cc.Process_Name into newgroup //add where clause select new { process_name = newgroup.Key, app_cpu = newgroup.Sum(c => c.Cpu) / newgroup.Count(), app_ram = newgroup.Sum(c => c.Memory) / newgroup.Count(), app_disk = (newgroup.Sum(c => c.IO_Read) + newgroup.Sum(c => c.IO_Write)) / newgroup.Count(), }).ToList(); foreach (var item in app_usage_list_query.OrderByDescending(x => x.app_cpu)) { JS_Chart_Data_Model app_cpu_item = new JS_Chart_Data_Model(); app_cpu_item.x = item_count; app_cpu_item.y = Math.Round(Convert.ToDouble(item.app_cpu), 2); app_cpu_item.label = item.process_name; js_data_list_cpu_app.Add(app_cpu_item); item_count++; } item_count = 1; foreach (var item in app_usage_list_query.OrderByDescending(x => x.app_ram)) { JS_Chart_Data_Model app_ram_item = new JS_Chart_Data_Model(); app_ram_item.x = item_count; app_ram_item.y = Math.Round(Convert.ToDouble(item.app_ram), 1); app_ram_item.label = item.process_name; js_data_list_ram_app.Add(app_ram_item); item_count++; } item_count = 1; foreach (var item in app_usage_list_query.OrderByDescending(x => x.app_disk)) { JS_Chart_Data_Model app_disk_item = new JS_Chart_Data_Model(); app_disk_item.x = item_count; app_disk_item.y = Convert.ToDouble(item.app_disk); app_disk_item.label = item.process_name; js_data_list_disk_app.Add(app_disk_item); item_count++; } TempData["js_data__app_cpu"] = JsonConvert.SerializeObject(js_data_list_cpu_app); TempData["js_data__app_ram"] = JsonConvert.SerializeObject(js_data_list_ram_app); TempData["js_data__app_disk"] = JsonConvert.SerializeObject(js_data_list_disk_app); //--Max Uygulama Verileri Hazırlanıyor--// var temp_cpu = app_usage_list_query.Where(x => x.app_cpu == (app_usage_list_query.Max(c => c.app_cpu))).FirstOrDefault(); if (temp_cpu != null) { TempData["max_app_cpu"] = temp_cpu.app_cpu; TempData["max_app_cpu_process_name"] = temp_cpu.process_name; } var temp_ram = app_usage_list_query.Where(x => x.app_ram == (app_usage_list_query.Max(c => c.app_ram))).FirstOrDefault(); if (temp_ram != null) { TempData["max_app_ram"] = temp_ram.app_cpu; TempData["max_app_ram_process_name"] = temp_ram.process_name; } var temp_disk = app_usage_list_query.Where(x => x.app_disk == (app_usage_list_query.Max(c => c.app_disk))).FirstOrDefault(); if (temp_disk != null) { TempData["max_app_disk"] = temp_disk.app_cpu; TempData["max_app_disk_process_name"] = temp_disk.process_name; } #endregion uygulama_kullanim_cpu_chart #region genel_istatistik_veriler //double rapor_genel_data_cpuxx = Convert.ToDouble(db.System_Usage.Where(x => x.Hardware_Id == hwid).Sum(x => x.Cpu) / db.System_Usage.Where(x => x.Hardware_Id == hwid).Count()); var rapor_genel_data = (from cc in db.System_Usage.Where(x => x.Hardware_Id == hwid && x.Datetime_ > aralik).ToList() group cc by cc.Hardware_Id into newgroup //add where clause select new { process_name = newgroup.Key, sys_cpu = newgroup.Sum(c => c.Cpu) / newgroup.Count(), sys_ram = newgroup.Sum(c => c.Memory) / newgroup.Count(), sys_net = (newgroup.Sum(c => c.Network_Rec) + newgroup.Sum(c => c.Network_Out)) / newgroup.Count(), sys_disk = (newgroup.Sum(c => c.IO_Read) + newgroup.Sum(c => c.IO_Write)) / newgroup.Count(), }).FirstOrDefault(); if (rapor_genel_data != null) { rapor_genel_data_model rapor_genel_temp_data_item = new rapor_genel_data_model(); rapor_genel_temp_data_item.sys_cpu = rapor_genel_data.sys_cpu; rapor_genel_temp_data_item.sys_ram = rapor_genel_data.sys_ram; rapor_genel_temp_data_item.sys_net = rapor_genel_data.sys_net; rapor_genel_temp_data_item.sys_disk = rapor_genel_data.sys_disk; TempData["rapor_genel_temp_data_item"] = rapor_genel_temp_data_item; } #endregion genel_istatistik_veriler #region app_istatistik_veriler List <rapor_genel_data_model> rapor_data_app_list = new List <rapor_genel_data_model>(); var rapor_app_data = (from cc in db.App_Usage.Where(x => x.Hardware_Id == hwid && x.Datetime_ > aralik).ToList() group cc by cc.Process_Name into newgroup //add where clause select new { process_name = newgroup.Key, app_cpu = newgroup.Sum(c => c.Cpu) / newgroup.Count(), app_ram = newgroup.Sum(c => c.Memory) / newgroup.Count(), app_net = (newgroup.Sum(c => c.Network_Rec) + newgroup.Sum(c => c.Network_Out)) / newgroup.Count(), app_disk = (newgroup.Sum(c => c.IO_Read) + newgroup.Sum(c => c.IO_Write)) / newgroup.Count() }).ToList(); if (rapor_app_data != null) { foreach (var item in rapor_app_data) { rapor_genel_data_model temp_data = new rapor_genel_data_model(); temp_data.process_name = item.process_name; temp_data.sys_cpu = item.app_cpu; temp_data.sys_ram = item.app_ram; temp_data.sys_net = item.app_net; temp_data.sys_disk = item.app_disk; rapor_data_app_list.Add(temp_data); } TempData["rapor_data_app_list"] = rapor_data_app_list; } #endregion app_istatistik_veriler #region pc_information PC_Details rapor_pc_inf_temp_data = db.PC_Details.Where(x => x.Hardware_Id == hwid).FirstOrDefault(); if (rapor_pc_inf_temp_data != null) { TempData["rapor_pc_inf_temp_data"] = rapor_pc_inf_temp_data; } #endregion pc_information return(View()); }
public ActionResult TemelKontrol(int?saat, int?dakika, HttpPostedFileBase file = null) { if (Session["User_Details"] == null) { return(Redirect("Giris")); } bilgisayari_varmi(); string hwid = Session["Current_PC_Hw_id"].ToString(); PC_Details Current_PC = db.PC_Details.Where(x => x.Hardware_Id == hwid).FirstOrDefault(); ViewData["bg"] = Current_PC.Bg_Url; //img process if (file != null) { decimal filesize = 0; try { var supportedTypes = new[] { ".jpg", ".jpeg", ".png" }; var fileExt = System.IO.Path.GetExtension(file.FileName); if (!supportedTypes.Contains(fileExt)) { ViewData["mesaj"] = "File Extension Is InValid - Only Upload WORD/PDF/EXCEL/TXT File"; } else if (file.ContentLength / 1024 / 1024 > 5) { ViewData["mesaj"] = "File size Should Be UpTo " + filesize + "KB"; } else { string filename = Session["Current_PC_Hw_id"].ToString() + DateTime.Now.Millisecond.ToString() + fileExt; string savepath = Path.Combine(Server.MapPath("~/temp/bg"), filename); file.SaveAs(savepath); Current_PC.Bg_Url = filename; Work_Order wo_varmi = db.Work_Order.Where(x => x.Hardware_Id == hwid && x.Work_ == "Wallpaper_Change").FirstOrDefault(); if (wo_varmi != null) { wo_varmi.Query_ = filename; wo_varmi.Result_ = false; wo_varmi.Active_ = true; wo_varmi.Datetime_ = DateTime.Now; } else { Work_Order wo = new Work_Order(); wo.Hardware_Id = hwid; wo.Work_ = "Wallpaper_Change"; wo.Query_ = filename; wo.Result_ = false; wo.Active_ = true; wo.Datetime_ = DateTime.Now; db.Work_Order.Add(wo); } db.SaveChanges(); return(RedirectToAction("TemelKontrol")); } } catch (Exception ex) { ViewData["mesaj"] = "Upload Container Should Not Be Empty or Contact Admin" + ex.Message; } } if (saat != null && dakika != null) { Current_PC.Time_Limit_Minutes = (saat * 60) + dakika; Work_Order wo_varmi = db.Work_Order.Where(x => x.Hardware_Id == hwid && x.Work_ == "Time_Limit").FirstOrDefault(); if (wo_varmi != null) { wo_varmi.Query_ = ((saat * 60) + dakika).ToString(); wo_varmi.Result_ = false; wo_varmi.Active_ = true; wo_varmi.Datetime_ = DateTime.Now; } else { Work_Order wo = new Work_Order(); wo.Hardware_Id = hwid; wo.Work_ = "Time_Limit"; wo.Query_ = ((saat * 60) + dakika).ToString(); wo.Result_ = false; wo.Active_ = true; wo.Datetime_ = DateTime.Now; db.Work_Order.Add(wo); } db.SaveChanges(); } return(View()); }
// GET:POST Panel public ActionResult Index(string baslangic, string bitis, string baslangic_app, string bitis_app)//DASHBOARD { if (Session["User_Details"] == null) { return(Redirect("Giris")); } bilgisayari_varmi(); User_Details uye_temp = Session["User_Details"] as User_Details; if (Session["Current_PC_Hw_id"] == null) { PC_Details Current_PC = db.PC_Details.FirstOrDefault(); if (Current_PC != null) { Session["Current_PC_Hw_id"] = Current_PC.Hardware_Id; } } if (Session["Current_PC_Hw_id"] != null) { string hwid = Session["Current_PC_Hw_id"].ToString(); //Tarih Aralığı Ayarlanıyor DateTime q_baslangic = Convert.ToDateTime("01/01/1970 00:00:00"); DateTime q_bitis = DateTime.Now; DateTime q_baslangic_app = Convert.ToDateTime("01/01/1970 00:00:00"); DateTime q_bitis_app = DateTime.Now; if (!string.IsNullOrEmpty(baslangic) && !string.IsNullOrEmpty(bitis)) { q_baslangic = Convert.ToDateTime(baslangic); q_bitis = Convert.ToDateTime(bitis); TempData["Gosterilen_Aralik_System"] = q_baslangic.ToString() + " ile " + q_bitis.ToString(); } else { q_baslangic = Convert.ToDateTime("01/01/1970 00:00:00"); q_bitis = DateTime.Now; TempData["Gosterilen_Aralik_System"] = "Tüm Zamanlar"; } if (!string.IsNullOrEmpty(baslangic_app) && !string.IsNullOrEmpty(bitis_app)) { q_baslangic_app = Convert.ToDateTime(baslangic_app); q_bitis_app = Convert.ToDateTime(bitis_app); TempData["Gosterilen_Aralik_App"] = q_baslangic_app.ToString() + " ile " + q_bitis_app.ToString(); } else { q_baslangic_app = Convert.ToDateTime("01/01/1970 00:00:00"); q_bitis_app = DateTime.Now; TempData["Gosterilen_Aralik_App"] = "Tüm Zamanlar"; } //--Genel CPU-RAM-DİSK KULLANIMI--// int item_count = 1; #region sistem_kullanim_cpu List <JS_Chart_Data_Model> js_data_list_cpu = new List <JS_Chart_Data_Model>(); List <JS_Chart_Data_Model> js_data_list_ram = new List <JS_Chart_Data_Model>(); List <JS_Chart_Data_Model> js_data_list_disk = new List <JS_Chart_Data_Model>(); foreach (var item in db.System_Usage.Where(x => x.Hardware_Id == hwid && x.Datetime_ >= q_baslangic && x.Datetime_ <= q_bitis).ToList()) { JS_Chart_Data_Model cpu = new JS_Chart_Data_Model(); cpu.x = item_count; cpu.y = Math.Round(Convert.ToDouble(item.Cpu), 2); cpu.label = Convert.ToString(String.Format("{0:T}", item.Datetime_)); js_data_list_cpu.Add(cpu); JS_Chart_Data_Model ram = new JS_Chart_Data_Model(); ram.x = item_count; ram.y = Math.Round(Convert.ToDouble(item.Memory), 2); ram.label = Convert.ToString(String.Format("{0:T}", item.Datetime_)); js_data_list_ram.Add(ram); JS_Chart_Data_Model disk = new JS_Chart_Data_Model(); disk.x = item_count; disk.y = Math.Round(Convert.ToDouble(item.IO_Read + item.IO_Write), 2); disk.label = Convert.ToString(String.Format("{0:T}", item.Datetime_)); js_data_list_disk.Add(disk); item_count++; } TempData["js_data__sys_cpu"] = JsonConvert.SerializeObject(js_data_list_cpu); TempData["js_data__sys_ram"] = JsonConvert.SerializeObject(js_data_list_ram); TempData["js_data__sys_disk"] = JsonConvert.SerializeObject(js_data_list_disk); item_count = 0; //--Max Genel Verileri Hazırlanıyor--// TempData["max_sys_cpu"] = js_data_list_cpu.Sum(x => x.y) / js_data_list_cpu.Count(); TempData["max_sys_ram"] = js_data_list_ram.Sum(x => x.y) / js_data_list_ram.Count(); TempData["max_sys_disk"] = js_data_list_disk.Sum(x => x.y) / js_data_list_disk.Count(); #endregion sistem_kullanim_cpu #region uygulama_kullanim_cpu List <JS_Chart_Data_Model> js_data_list_cpu_app = new List <JS_Chart_Data_Model>(); List <JS_Chart_Data_Model> js_data_list_ram_app = new List <JS_Chart_Data_Model>(); List <JS_Chart_Data_Model> js_data_list_disk_app = new List <JS_Chart_Data_Model>(); var app_usage_list_query = (from cc in db.App_Usage.Where(x => x.Hardware_Id == hwid && x.Datetime_ >= q_baslangic_app && x.Datetime_ <= q_bitis_app).ToList() group cc by cc.Process_Name into newgroup //add where clause select new { process_name = newgroup.Key, app_cpu = newgroup.Sum(c => c.Cpu) / newgroup.Count(), app_ram = newgroup.Sum(c => c.Memory) / newgroup.Count(), app_disk = (newgroup.Sum(c => c.IO_Read) + newgroup.Sum(c => c.IO_Write)) / newgroup.Count(), }).ToList(); foreach (var item in app_usage_list_query.OrderByDescending(x => x.app_cpu)) { JS_Chart_Data_Model app_cpu_item = new JS_Chart_Data_Model(); app_cpu_item.x = item_count; app_cpu_item.y = Math.Round(Convert.ToDouble(item.app_cpu), 2); app_cpu_item.label = item.process_name; js_data_list_cpu_app.Add(app_cpu_item); item_count++; } item_count = 1; foreach (var item in app_usage_list_query.OrderByDescending(x => x.app_ram)) { JS_Chart_Data_Model app_ram_item = new JS_Chart_Data_Model(); app_ram_item.x = item_count; app_ram_item.y = Math.Round(Convert.ToDouble(item.app_ram), 1); app_ram_item.label = item.process_name; js_data_list_ram_app.Add(app_ram_item); item_count++; } item_count = 1; foreach (var item in app_usage_list_query.OrderByDescending(x => x.app_disk)) { JS_Chart_Data_Model app_disk_item = new JS_Chart_Data_Model(); app_disk_item.x = item_count; app_disk_item.y = Convert.ToDouble(item.app_disk); app_disk_item.label = item.process_name; js_data_list_disk_app.Add(app_disk_item); item_count++; } TempData["js_data__app_cpu"] = JsonConvert.SerializeObject(js_data_list_cpu_app); TempData["js_data__app_ram"] = JsonConvert.SerializeObject(js_data_list_ram_app); TempData["js_data__app_disk"] = JsonConvert.SerializeObject(js_data_list_disk_app); //--Max Uygulama Verileri Hazırlanıyor--// var temp_cpu = app_usage_list_query.Where(x => x.app_cpu == (app_usage_list_query.Max(c => c.app_cpu))).FirstOrDefault(); if (temp_cpu != null) { TempData["max_app_cpu"] = temp_cpu.app_cpu; TempData["max_app_cpu_process_name"] = temp_cpu.process_name; } var temp_ram = app_usage_list_query.Where(x => x.app_ram == (app_usage_list_query.Max(c => c.app_ram))).FirstOrDefault(); if (temp_ram != null) { TempData["max_app_ram"] = temp_ram.app_cpu; TempData["max_app_ram_process_name"] = temp_ram.process_name; } var temp_disk = app_usage_list_query.Where(x => x.app_disk == (app_usage_list_query.Max(c => c.app_disk))).FirstOrDefault(); if (temp_disk != null) { TempData["max_app_disk"] = temp_disk.app_cpu; TempData["max_app_disk_process_name"] = temp_disk.process_name; } #endregion uygulama_kullanim_cpu } return(View()); }