public ActionResult SideBar()
{
try
{
if (Session["KisiTanimlayici"].ToString() == "Admin")
{
OptagricEntities DB = new OptagricEntities();
string temp1 = Session["AdminEmail"].ToString();
string temp2 = Session["AdminPassword"].ToString();
Administration girisYapanAdmin = DB.Administration.Where(x => x.Email == temp1 && x.Password == temp2).First();
return(View(girisYapanAdmin));
}
else
{
OptagricEntities DB = new OptagricEntities();
string temp1 = Session["UserEmail"].ToString();
string temp2 = Session["UserPassword"].ToString();
Customer girisYapanCustomer = DB.Customer.Where(x => x.Email == temp1 && x.Password == temp2).First();
return(View(girisYapanCustomer));
}
}
catch (Exception)
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız.";
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult PredictionPureValues()
{
using (OptagricEntities DB = new OptagricEntities())
{
ViewBag.TypeLabes = DB.Predictions.Select(x => x.Type).ToList();
ViewBag.PrecipitationRates = DB.Predictions.Select(x => x.PA_Precipitatation).ToList();
ViewBag.CroppedProductionRates = DB.Predictions.Select(x => x.PU_CropProduction).ToList();
ViewBag.CropDestruction = DB.Predictions.Select(x => x.PK_Disaster).ToList();
ViewBag.WaterConsumption = DB.Predictions.Select(x => x.PT_WaterConsumption).ToList();
}
Session["KisiTanimlayici"] = "Customer";
return(View());
}
public ActionResult CurrentCropYieldAmount()
{
OptagricEntities DB = new OptagricEntities();
var subFieldContentInformation = DB.SubRegion.Select(x => x.CroppedProductAmount);
var subFieldContentName = DB.SubRegion.Select(x => x.Name);
ViewBag.CropAmountCorrection = DB.SubRegion.ToList();
ViewBag.SFCI = subFieldContentInformation;
ViewBag.SFCN = subFieldContentName;
Session["KisiTanimlayici"] = "Customer";
return(View());
}
public ActionResult SubRegion_ContentHandler(string inputSubRegionName, string selectedCropFieldID, string selectedCropTypeID, string inputCroppedProductAmount, string inputSoilWaterContent) //Statik olarak veri girdisi
//Var olan bir tarlaya yeni bir ekim alanı eklersin
//böylece yeni tahminler için Azure ML ' e girdi sağlamış olursun
//bu girdiler eklenen her sensörün gönderdiği değerleri temsil etmektedir.
{
if (Session["KisiTanimlayici"].ToString() == "Customer")
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız.";
return(RedirectToAction("Index", "Login"));
}
else
{
OptagricEntities DB = new OptagricEntities();
ViewBag.CropFields = DB.CropField.ToList();
ViewBag.CropType = DB.CropType.ToList();
try
{
if (inputSubRegionName != null && selectedCropFieldID != null && selectedCropTypeID != null && inputCroppedProductAmount != null && inputSoilWaterContent != null)
{
SubRegion eklenecek = new SubRegion
{
Name = inputSubRegionName,
CF_ID = Convert.ToInt32(selectedCropFieldID),
CropTypeID = Convert.ToInt32(selectedCropTypeID),
CroppedProductAmount = Convert.ToInt32(inputCroppedProductAmount),
SoilWaterContent = Convert.ToInt32(inputSoilWaterContent),
};
DB.SubRegion.Add(eklenecek);
DB.SaveChanges();
//ActionLogs(tut, "Insert", "SubRegion_ContentHandler");
string p1 = this.ControllerContext.RouteData.Values["action"].ToString();
string p2 = this.ControllerContext.RouteData.Values["controller"].ToString();
CRUD_Logs(p1, Session["CurrentUserGuid"].ToString(), "INSERT", eklenecek.Name + " / " + p1 + " / " + p2);
TempData["SubRegionSuccess"] = "Ekleme Başarılı";
return(View());
}
else
{
return(View());
}
}
catch (Exception)
{
TempData["SubRegionError"] = "Lütfen Değeleri Uygun Giriniz";
return(View());
}
}
}
public ActionResult AddCropType(string inputCropLeafAreaIndex, string inputCropTypeName, string gidenBasari = "")
{
if (Session["KisiTanimlayici"].ToString() == "Customer")
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız.";
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
if (inputCropTypeName != null && inputCropLeafAreaIndex != "" && Convert.ToDouble(inputCropLeafAreaIndex) < 10)
{
OptagricEntities DB = new OptagricEntities();
CropType eklenecekNesne = new CropType
{
LeafAreaIndex = Convert.ToDouble(inputCropLeafAreaIndex),
Name = inputCropTypeName
};
DB.CropType.Add(eklenecekNesne);
DB.SaveChanges();
//ActionLogs(Session["CurrentUserGuid"].ToString(), "Insert", "AddCropType");
//Aşağıdakilerde çalıştırılacak SİLME
//CRUD_Logs("AddCropType", Session["CurrentUserGuid"].ToString(), "Insert", "AddCropType" + " " + "AdminPanel_CRUD");
string p1 = this.ControllerContext.RouteData.Values["action"].ToString();
string p2 = this.ControllerContext.RouteData.Values["controller"].ToString();
CRUD_Logs(p1, Session["CurrentUserGuid"].ToString(), "INSERT", eklenecekNesne.Name + " / " + p1 + " / " + p2);
TempData["AddCropTypeSuccess"] = "Ekleme Başarılı";
return(View());
}
else
{
TempData["AddCropTypeError"] = "Lütfen Değeleri Giriniz.Float değerleri girmek için ayraç olarak virgül kullanınız";
return(View());
}
}
catch (Exception)
{
TempData["AddCropTypeError"] = "Lütfen Değeleri Uygun Giriniz";
return(View());
}
}
}
public ActionResult UserRoter(string SendedUserEmail, string SendedUserPassword)
{
OptagricEntities DB = new OptagricEntities();
try
{
Customer girisYapanKullanici = DB.Customer.Where(x => x.Email == SendedUserEmail && x.Password == SendedUserPassword).First();
return(RedirectToAction("IndexCustomerCapsulation", "Home", new { userGelecekEmail = SendedUserEmail, userGelecekPassword = SendedUserPassword }));
}
catch (Exception)
{
TempData["GirisHatasiKullanici"] = "Kullanıcı ID veya PW yanlış girildi.";
return(View("Index"));
}
}
public ActionResult Roter(string SendedEmail, string SendedPassword)
{
OptagricEntities DB = new OptagricEntities();
List <Administration> yetkililer = DB.Administration.ToList();
//Administration nesne = yetkililer.Where(x=>x.Password==SendedPassword && x.Email==SendedEmail).First();
if (!yetkililer.Count(x => x.Password == SendedPassword && x.Email == SendedEmail).Equals(0))
{
Administration nesne = yetkililer.Where(x => x.Password == SendedPassword && x.Email == SendedEmail).First();
return(RedirectToAction("IndexAdminCapsulation", "Home", new { administrationGelecekEmail = nesne.Email.ToString(), administrationGelecekPassword = nesne.Password.ToString() }));
}
else
{
TempData["GirisHatasi"] = "Kullanıcı ID veya PW yanlış girildi.";
return(View("Index"));
}
}
public ActionResult IndexCustomer(string activeUser)
{
if (Session["UserEmail"] == null || Session["UserPassword"] == null)
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız";
return(RedirectToAction("Index", "Login"));
}
else//Giriş Yapılmış İse
{
OptagricEntities DB = new OptagricEntities();
ViewBag.ControlFlagHumidity = DB.ProcessFlags.Where(x => x.ProcessName == "HumidityHardwareSignal").First();
ViewBag.ControlFlagTemperature = DB.ProcessFlags.Where(x => x.ProcessName == "TemperatureHardwareSignal").First();
Session["KisiTanimlayici"] = "Customer";
return(View());
}
}
public ActionResult IndexCustomerCapsulation(string userGelecekEmail, string userGelecekPassword)
{
Session["KisiTanimlayici"] = "Customer";
if (userGelecekEmail == null && userGelecekPassword == null)//Giriş Yapılmamış İse
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız";
return(RedirectToAction("Index", "Login"));
}
else//Giriş Yapılmış İse
{
Session["UserEmail"] = userGelecekEmail;
Session["UserPassword"] = userGelecekPassword;
OptagricEntities DB = new OptagricEntities();
Customer girisYapanCustomer = DB.Customer.Where(x => x.Email == userGelecekEmail.ToString() && x.Password == userGelecekPassword.ToString()).First();
Session["CurrentUserGuid"] = girisYapanCustomer.UID;
return(RedirectToAction("IndexCustomer", new { activeUser = girisYapanCustomer.Name + " " + girisYapanCustomer.Surname }));
}
}
public ActionResult ProcessFlag(string gidenID, string processFlagDesiredValue)
{
if (Session["KisiTanimlayici"].ToString() == "")
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız.";
return(RedirectToAction("Index", "Login"));
}
else
{
OptagricEntities DB = new OptagricEntities();
ViewBag.ProcessFlagList = DB.ProcessFlags.ToList();
int gelenID = Convert.ToInt32(gidenID);
if (processFlagDesiredValue != null && gelenID != -1)
{
bool FlagStatus = Boolean.Parse(processFlagDesiredValue);
try
{
ProcessFlags degisecek = DB.ProcessFlags.Where(x => x.ID == gelenID).First();
degisecek.ProcessFlagStatus = FlagStatus;
DB.ProcessFlags.Attach(degisecek);
DB.Entry(degisecek).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
TempData["ProcessFlagUpdate"] = "Guncelleme Basarili";
return(View());
}
catch (Exception)
{
TempData["ProcessFlagUpdateError"] = "Guncelleme Basarisiz";
return(View());
}
}
else
{
return(View());
}
}
}
public ActionResult CRUD_Logs(string donulecekYer, string gelenAdminID, string gelenProcessType, string gelenModelName)
{
if (Session["KisiTanimlayici"].ToString() == "Admin")
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız.";
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
if (gelenAdminID != null && gelenProcessType != null && gelenModelName != null)
{
OptagricEntities DB = new OptagricEntities();
Panel_CRUD_Process_Logs ekle = new Panel_CRUD_Process_Logs
{
CustomerID = new Guid(gelenAdminID.ToString()),
ProcessType = gelenProcessType,
ModelName = gelenModelName,
Date = DateTime.Now
};
DB.Panel_CRUD_Process_Logs.Add(ekle);
DB.SaveChanges();
TempData["LogSuccess"] = "Admin Log Ekleme Başarılı";
Session["KisiTanimlayici"] = "Customer";
return(RedirectToAction(donulecekYer.ToString(), "AdminPanel_CRUD"));
}
else
{
TempData["LogError"] = "Lütfen Değeleri Uygun Giriniz";
Session["KisiTanimlayici"] = "Customer";
return(RedirectToAction(donulecekYer.ToString(), "AdminPanel_CRUD"));
}
}
catch (Exception)
{
TempData["LogError"] = "Lütfen Değeleri Uygun Giriniz CATCH";
return(RedirectToAction(donulecekYer.ToString(), "AdminPanel_CRUD"));
}
}
}
public ActionResult IndexAdminCapsulation(string administrationGelecekEmail, string administrationGelecekPassword)
{
Session["KisiTanimlayici"] = "Admin";
if (administrationGelecekEmail == null)//Giriş Yapılmamış İse
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız";
return(RedirectToAction("Index", "Login"));
}
else//Giriş Yapılmış İse
{
Session["AdminEmail"] = administrationGelecekEmail.ToString();
Session["AdminPassword"] = administrationGelecekPassword;
OptagricEntities DB = new OptagricEntities();
Administration girisYapanAdmin = DB.Administration.Where(x => x.Email == administrationGelecekEmail.ToString() && x.Password == administrationGelecekPassword.ToString()).First();
Session["CurrentUserGuid"] = girisYapanAdmin.ID;
//return View("Index");
return(RedirectToAction("IndexAdmin", new { activeUser = girisYapanAdmin.Name + " " + girisYapanAdmin.Surname }));
}
}
public ActionResult AdministrationUpdate(string inputName, string inputSurname, string inputEmail, string currentPassword, string newPassword, string newPasswordVerification)
{
if (Session["KisiTanimlayici"].ToString() == "Customer")
{
TempData["SecurityWall_Home"] = "Güvenlik Duvarına Takıldınız.";
return(RedirectToAction("Index", "Login"));
}
else
{
OptagricEntities DB = new OptagricEntities();
Guid temp = new Guid(Session["CurrentUserGuid"].ToString());
ViewBag.currentAdmin = DB.Administration.Where(x => x.ID == temp).First();
string tempedPassword = ViewBag.currentAdmin.Password;
string tempedName = ViewBag.currentAdmin.Name;
string tempedSurname = ViewBag.currentAdmin.Surname;
string tempedEmail = ViewBag.currentAdmin.Email;
if (inputName != null || inputSurname != null || inputEmail != null || currentPassword != null || newPassword != null || newPasswordVerification != null)
{
Administration yonetici = ViewBag.currentAdmin;
if (currentPassword != null && newPassword != null && newPasswordVerification != null && currentPassword != "" && newPassword != "" && newPasswordVerification != "")//Password Changer Control
{
yonetici = ViewBag.currentAdmin;
if (yonetici.Password == currentPassword && newPassword == newPasswordVerification && newPassword != null)
{
yonetici.Password = newPassword;
}
DB.Administration.Attach(yonetici);
DB.Entry(yonetici).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
string p1 = this.ControllerContext.RouteData.Values["action"].ToString();
string p2 = this.ControllerContext.RouteData.Values["controller"].ToString();
CRUD_Logs(p1, Session["CurrentUserGuid"].ToString(), "UPDATE", tempedPassword + "-->" + yonetici.Password + " / " + p1 + " / " + p2);
}
if (inputName != null && inputName != "")//Name Changer Control
{
yonetici = ViewBag.currentAdmin;
yonetici.Name = inputName;
DB.Administration.Attach(yonetici);
DB.Entry(yonetici).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
string p1 = this.ControllerContext.RouteData.Values["action"].ToString();
string p2 = this.ControllerContext.RouteData.Values["controller"].ToString();
CRUD_Logs(p1, Session["CurrentUserGuid"].ToString(), "UPDATE", tempedName + "-->" + yonetici.Name + " / " + p1 + " / " + p2);
}
if (inputSurname != null && inputSurname != "")//Surname Changer Control
{
yonetici = ViewBag.currentAdmin;
yonetici.Surname = inputSurname;
DB.Administration.Attach(yonetici);
DB.Entry(yonetici).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
string p1 = this.ControllerContext.RouteData.Values["action"].ToString();
string p2 = this.ControllerContext.RouteData.Values["controller"].ToString();
CRUD_Logs(p1, Session["CurrentUserGuid"].ToString(), "UPDATE", tempedSurname + "-->" + yonetici.Surname + " / " + p1 + " / " + p2);
}
if (inputEmail != null && inputEmail != "")//Email Changer Control
{
yonetici = ViewBag.currentAdmin;
yonetici.Email = inputEmail;
DB.Administration.Attach(yonetici);
DB.Entry(yonetici).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
string p1 = this.ControllerContext.RouteData.Values["action"].ToString();
string p2 = this.ControllerContext.RouteData.Values["controller"].ToString();
CRUD_Logs(p1, Session["CurrentUserGuid"].ToString(), "UPDATE", tempedEmail + "-->" + yonetici.Email + " / " + p1 + " / " + p2);
}
TempData["Degislik"] = "Degisiklik Basarili";
ViewBag.currentAdmin = yonetici;
Session["AdminEmail"] = ViewBag.currentAdmin.Email;
Session["AdminPassword"] = ViewBag.currentAdmin.Password;
return(View());
}
else
{
TempData["Degislik"] = "Degisiklik Yapılmadi";
return(View());
}
}
}
