public ActionResult Home(HomeClientModelView SenorName)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
string ClientEmail = Session["UserId"].ToString();
Resetings reset = new Resetings();
Senzors senzor = new Senzors();
try
{
senzor = db.senzors.FirstOrDefault(s => s.Name == SenorName.SenzorName);
reset.SenzorsId = senzor.id;
reset.BateryLevel = senzor.BateryLevel;
reset.ResetDate = DateTime.Now;
reset.HasChecked = true;
db.resetings.Add(reset);
db.SaveChanges();
}
catch (Exception e)
{
ViewBag.Error = "Something went wrong finding the senzor";
}
}
return(Home());
}
public ActionResult Edit()
{
AssignedSenzor senzorClients = new AssignedSenzor(true);
using (ApplicationDbContext db = new ApplicationDbContext())
{
var clients = db.client.ToList();
foreach (var c in clients)
{
Clients client = new Clients();
List <string> senzors = new List <string>();
try
{
senzors = db.senzors.Where(s => s.ClientId == c.id).Select(d => d.Name).ToList();
senzorClients.assignedSenzor.Add(c.Email, senzors);
}
catch (Exception e)
{
Senzors senzor = new Senzors();
senzor.Name = "No senzor assigned to the user";
senzors.Add(senzor.Name);
senzorClients.assignedSenzor.Add(c.Email, senzors);
}
}
}
return(View(senzorClients));
}
public ActionResult Home()
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
string ClientEmail = Session["UserId"].ToString();
HomeClientModelView home = new HomeClientModelView();
Senzors senzor = new Senzors();
try
{
var client = db.client.FirstOrDefault(c => c.Email == ClientEmail);
home.Email = ClientEmail;
home.FirstName = client.FirstName;
home.LastName = client.LastName;
home.ImagePath = client.PathImage;
home.senzors = db.senzors.Where(s => s.ClientId == client.id).ToList();
if (home.senzors.Count() > 0)
{
string KeySenzor = "";
foreach (var reset in home.senzors)
{
List <string> SenzorInfo = new List <string>();
Resetings reseting = new Resetings();
KeySenzor = reset.Name;
//SenzorInfo.Add(reset.Name);
SenzorInfo.Add(reset.BateryLevel.ToString());
try
{
// reseting = db.resetings.LastOrDefault(r => r.SenzorsId == reset.id);
var getall = db.resetings.GroupBy(r => r.SenzorsId).Select(p => p.FirstOrDefault(w => w.id == p.Max(m => m.id)))
.OrderBy(p => p.SenzorsId).ToList();
reseting = getall.Where(s => s.SenzorsId == reset.id).FirstOrDefault();
SenzorInfo.Add(reseting.BateryLevel.ToString());
SenzorInfo.Add(reseting.HasChecked.ToString());
}
catch (Exception e)
{
SenzorInfo.Add("TBD");
SenzorInfo.Add("New Senzor");
}
home.SenzorInfo.Add(KeySenzor, SenzorInfo);
}
}
return(View(home));
}
catch (Exception e)
{
ViewBag.Error = "";
}
return(View(home));
}
}
public ActionResult AddSenzor(SenzorAdd NewSenzor)
{
if (!ModelState.IsValid)
{
return(View(NewSenzor));
}
using (ApplicationDbContext db = new ApplicationDbContext())
{
Clients client = new Clients();
string clientEmail = "";
var CheckSenzorName = db.senzors.Where(S => S.Name == NewSenzor.NameOfSenzor);
if (CheckSenzorName.Count() > 0)
{
ViewBag.Error = "Name exist";
return(View());
}
try
{
clientEmail = db.client.FirstOrDefault(c => c.Email == "*****@*****.**").FirstName;
client = db.client.First(c => c.Email == "*****@*****.**");
}
catch (Exception e)
{
Clients MasterClient = new Clients();
MasterClient.Email = "*****@*****.**";
MasterClient.FirstName = "Master";
MasterClient.LastName = "Master";
MasterClient.Password = "******";
client = db.client.Add(MasterClient);
db.SaveChanges();
}
Senzors senzor = new Senzors();
senzor.Clients = client;
senzor.ClientId = client.id;
senzor.Name = NewSenzor.NameOfSenzor;
senzor.ValueType = NewSenzor.ValueType;
senzor.BateryLevel = 100;
db.senzors.Add(senzor);
db.SaveChanges();
}
return(RedirectToAction("/Index"));
}
public ActionResult Index(AssignedSenzor assigned)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
Clients client = new Clients();
client = db.client.FirstOrDefault(c => c.Email == assigned.EmailClient);
if (client != null)
{
Senzors senzor = new Senzors();
senzor = db.senzors.First(s => s.Name == assigned.SenzorName);
if (senzor != null)
{
senzor.ClientId = client.id;
senzor.Clients = client;
db.Entry(senzor).State = EntityState.Modified;
db.SaveChanges();
}
}
}
return(Index());
}
public ActionResult Edit(AssignedSenzor senzorClients)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
try
{
Clients client = new Clients();
client = db.client.FirstOrDefault(c => c.Email == senzorClients.EmailClient);
Senzors senzor = new Senzors();
senzor = db.senzors.FirstOrDefault(s => s.Name == senzorClients.SenzorName);
senzor.ClientId = 1;
db.Entry(senzor).State = EntityState.Modified;
db.SaveChanges();
}
catch (Exception e)
{
ViewBag.Error = "On error has occur while trying to remove the senzor";
}
}
return(Edit());
}
