public ActionResult EnterCompound(string compName, float compWeight, int compQuant)
{
Work_Order work = new Work_Order();
work.custWeight = compWeight;
work.Quantity = compQuant;
ViewBag.whatever = Session["CustomerID"];
work.CustomerID = ViewBag.whatever;
// work.LTNumber = random.Next(100000, 999999);
Compounds comp = new Compounds();
//comp.LTNumber = work.LTNumber;
comp.compoundName = compName;
db.Work_Order.Add(work);
//db.Compounds.Add(comp);
//db.SaveChanges();
Session["CompNames"] = comp.compoundName;
ViewBag.compoundName = comp.compoundName;
return(RedirectToAction("EnterAssay"));
}
public ActionResult DeleteConfirmed(int id)
{
Work_Order work_Order = db.Work_Order.Find(id);
db.Work_Order.Remove(work_Order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "OrderID,CustomerID,LTNumber,Status,dateArrived,dateDue,custWeight,actualWeight,Quantity")] Work_Order work_Order)
{
if (ModelState.IsValid)
{
db.Entry(work_Order).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(work_Order));
}
// GET: Work_Order/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Work_Order work_Order = db.Work_Order.Find(id);
if (work_Order == null)
{
return(HttpNotFound());
}
return(View(work_Order));
}
public JsonResult TopluMesajGonder(string mesaj)
{
try
{
User_Details yonetici_bilgileri = Session["User_Details"] as User_Details;
List <PC_Details> ekli_bilgisayarlar = db.PC_Details.Where(x => x.User_Id == yonetici_bilgileri.id).ToList();
foreach (var item in ekli_bilgisayarlar)
{
Work_Order wo_varmi = db.Work_Order.Where(x => x.Hardware_Id == item.Hardware_Id && x.Work_ == "Alert_Message").FirstOrDefault();
if (wo_varmi != null)
{
wo_varmi.Query_ = mesaj;
wo_varmi.Result_ = false;
wo_varmi.Active_ = true;
wo_varmi.Datetime_ = DateTime.Now;
db.SaveChanges();
}
else
{
Work_Order is_emri_mesaj = new Work_Order();
is_emri_mesaj.Hardware_Id = item.Hardware_Id;
is_emri_mesaj.Work_ = "Alert_Message";
is_emri_mesaj.Query_ = mesaj;
is_emri_mesaj.Result_ = false;
is_emri_mesaj.Active_ = true;
is_emri_mesaj.Datetime_ = DateTime.Now;
db.Work_Order.Add(is_emri_mesaj);
db.SaveChanges();
}
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public string isEmri_Kapat(string Hardware_id, string isemri__, string yol = null, string cmd_output = null)
{
Work_Order isEmri_ = db.Work_Order.Where(x => x.Hardware_Id == Hardware_id && x.Work_ == isemri__ && x.Active_ == true && x.Result_ == false).FirstOrDefault();
try
{
switch (isemri__)
{
case "Screen_Capture":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
Screen_Capture image_ = new Screen_Capture();
image_.Hardware_Id = Hardware_id;
image_.Img_Url = yol;
image_.Datetime_ = DateTime.Now;
db.Screen_Capture.Add(image_);
db.SaveChanges();
return("Ok");
case "Screen_Record":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
Screen_Record video_ = new Screen_Record();
video_.Hardware_Id = Hardware_id;
video_.Video_Url = yol;
video_.Datetime_ = DateTime.Now;
db.Screen_Record.Add(video_);
db.SaveChanges();
return("Ok");
case "App_Run":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
return("Ok");
case "App_Stop":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
return("Ok");
case "Browser_Histories":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
//Aynı ANDA KAYIT YAPINCA DESKTOPDA BUG OLUYOR DUZELTİLECEK
//browser historye yol yaılıyor
Browser_Histories bh_check = db.Browser_Histories.Where(x => x.Hardware_Id == Hardware_id).FirstOrDefault();
if (bh_check == null)
{
Browser_Histories b_h = new Browser_Histories();
b_h.Hardware_Id = Hardware_id;
b_h.Title_ = "";
b_h.Url_ = yol;
b_h.Sync_Time_ = DateTime.Now;
db.Browser_Histories.Add(b_h);
}
else
{
string xmlPath = HttpContext.Current.Server.MapPath(bh_check.Url_).Replace("\\Panel", "");
File.Delete(xmlPath);
bh_check.Hardware_Id = Hardware_id;
bh_check.Title_ = "";
bh_check.Url_ = yol;
bh_check.Sync_Time_ = DateTime.Now;
}
db.SaveChanges();
return("Ok");
case "Cmd":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
cmd_output_ cmd_ = new cmd_output_();
cmd_.Hardware_Id = Hardware_id;
cmd_.Query_ = yol;
cmd_.CMD_Output_Text = cmd_output;
cmd_.Datetime_ = DateTime.Now;
cmd_.Status_ = true;
db.cmd_output_.Add(cmd_);
db.SaveChanges();
return("Ok");
case "Banned_App_Add":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
Banned_App banlandin = new Banned_App();
banlandin.Hardware_Id = Hardware_id;
banlandin.P_Name = yol;
var banned_title_ = db.PC_App_Locations.Where(x => x.Process_Name_ == yol).FirstOrDefault();
banlandin.Title_ = banned_title_.App_Name;
banlandin.Datetime_ = DateTime.Now;
db.Banned_App.Add(banlandin);
db.SaveChanges();
//Banned app için tablo olusturulacak
return("Ok");
case "Banned_App_Remove":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
Banned_App banned_disable = db.Banned_App.Where(x => x.Hardware_Id == Hardware_id && x.P_Name == yol).FirstOrDefault();
db.Banned_App.Remove(banned_disable);
db.SaveChanges();
return("Ok");
case "Wallpaper_Change":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
return("Ok");
case "Time_Limit":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
return("Ok");
case "Alert_Message":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
return("Ok");
case "Install_App":
isEmri_.Active_ = false;
isEmri_.Result_ = true;
isEmri_.Datetime_ = DateTime.Now;
db.SaveChanges();
return("Ok");
default:
return("Hatali_Emir");
}
}
catch (Exception xx)
{
return("Hata" + xx.ToString());
}
}
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 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());
}
