public JsonResult GetEquipmentsByPost()
{
using (db_inventaireContext context = new db_inventaireContext())
{
List <TempInvent> equipments = context.TempInvent.ToList();
List <EquipmentConnected> equipmentsConnected = new List <EquipmentConnected>();
foreach (TempInvent e in equipments)
{
Modele modele = context.Modele.SingleOrDefault(e2 => e2.Description.Equals(e.ModelName));
EquipmentConnected equipment = new EquipmentConnected();
if (modele == null)
{
equipment.exist = false;
}
else
{
equipment.SNDetected = modele.SnDetectable;
}
equipment.ModelDetected = e.ModelDetected;
equipment.vendorDetected = e.VendorDetected;
equipment.SN = e.Sn;
equipment.NomPost = e.NomPost;
equipment.ModelName = e.ModelName;
equipment.VendorName = e.VendorName;
equipment.Type = e.Type;
equipmentsConnected.Add(equipment);
}
return(Json(equipmentsConnected));
}
}
public JsonResult GetAllVendors()
{
using (db_inventaireContext context = new db_inventaireContext())
{
List <Vendor> vendors = context.Vendor.ToList();
return(Json(vendors));
}
}
public JsonResult GetVendor(int id)
{
using (db_inventaireContext context = new db_inventaireContext())
{
Vendor vendor = context.Vendor.FirstOrDefault(v => v.IdVendor == id);
return(Json(vendor));
}
}
public JsonResult GetAllModels()
{
using (db_inventaireContext context = new db_inventaireContext())
{
List <Modele> models = context.Modele.OrderBy(m => m.IdTypeDev).ToList();
return(Json(models));
}
}
public JsonResult GetAllTypeDevices()
{
using (db_inventaireContext context = new db_inventaireContext())
{
List <TypeDevice> types = context.TypeDevice.ToList();
return(Json(types));
}
}
public JsonResult UpdateModel([FromBody] Modele modele)
{
using (db_inventaireContext context = new db_inventaireContext())
{
context.Modele.Update(modele);
context.SaveChanges();
}
return(Json(modele));
}
public JsonResult GetTypeDevice(int id)
{
using (db_inventaireContext context = new db_inventaireContext())
{
TypeDevice type = context.TypeDevice.FirstOrDefault(t => t.IdTypeDev == id);
TypeDevice device = new TypeDevice();
device.IdTypeDev = type.IdTypeDev;
device.Description = type.Description;
return(Json(device));
}
}
public async Task <IActionResult> Login(string idUser, string password)
{
User user = new User();
bool found = false;
if (string.IsNullOrEmpty(idUser) || (string.IsNullOrEmpty(password)))
{
return(RedirectToAction(nameof(Index)));
}
using (db_inventaireContext entities = new db_inventaireContext())
{
found = entities.User.Any(u => u.Password.Equals(password) && u.IdUser.Equals(idUser));
if (found == true)
{
user = entities.User.FirstOrDefault(u => u.Password.Equals(password) && u.IdUser.Equals(idUser));
}
}
if (found == false)
{
return(RedirectToAction(nameof(Index)));
}
ClaimsIdentity identity = null;
if (user.IdUserType == 2)
{
identity = new ClaimsIdentity(new[]
{
new Claim(ClaimTypes.Name, user.IdUser),
}, CookieAuthenticationDefaults.AuthenticationScheme);
}
else if (user.IdUserType == 1)
{
identity = new ClaimsIdentity(new[]
{
new Claim(ClaimTypes.Name, user.IdUser),
new Claim(ClaimTypes.Role, "admin"),
}, CookieAuthenticationDefaults.AuthenticationScheme);
}
var principal = new ClaimsPrincipal(identity);
await HttpContext.SignInAsync(
CookieAuthenticationDefaults.AuthenticationScheme,
principal);
return(RedirectToAction("index", "Home"));
}
public JsonResult AddModel([FromBody] Modele modele)
{
using (db_inventaireContext context = new db_inventaireContext())
{
Modele model = context.Modele.Find(modele.CodeModel);
if (model == null)
{
context.Modele.Add(modele);
context.SaveChanges();
}
else
{
UpdateModel(modele);
}
return(Json(modele));
}
}
public JsonResult GetModels([FromBody] CritereModel model)
{
List <Modele> model1s = new List <Modele>();
bool all = true;
bool repeat = false;
using (db_inventaireContext context = new db_inventaireContext())
{
if (model.IdTypeDev != 0)
{
all = false;
model1s = context.Modele.Where(m => m.IdTypeDev == model.IdTypeDev).OrderBy(m => m.IdTypeDev).ToList();
if (model1s.Count() > 0)
{
repeat = true;
}
}
if (model.CodeVendor != 0)
{
all = false;
if (repeat == false)
{
model1s = context.Modele.Where(m => m.CodeVendor == model.CodeVendor).OrderBy(m => m.IdTypeDev).ToList();
}
else
{
var req = from m1 in context.Modele.ToList()
join m2 in model1s on m1.CodeModel equals m2.CodeModel
where m1.CodeVendor == model.CodeVendor
orderby m1.IdTypeDev
select m1;
model1s = req.ToList();
}
if (model1s.Count() > 0)
{
repeat = true;
}
}
if ((model.SNDetectable == 1))
{
all = false;
if (repeat == false)
{
model1s = context.Modele.Where(m => m.SnDetectable == true).OrderBy(m => m.IdTypeDev).ToList();
}
else
{
var req = from m1 in context.Modele
join m2 in model1s on m1.CodeModel equals m2.CodeModel
where m1.SnDetectable == true
orderby m1.IdTypeDev
select m1;
model1s = req.ToList();
}
if (model1s.Count() > 0)
{
repeat = true;
}
}
if (model.SNDetectable == 2)
{
all = false;
if (repeat == false)
{
model1s = context.Modele.Where(m => m.SnDetectable == false).OrderBy(m => m.IdTypeDev).ToList();
}
else
{
var req = from m1 in context.Modele
join m2 in model1s on m1.CodeModel equals m2.CodeModel
where m1.SnDetectable == false
orderby m1.IdTypeDev
select m1;
model1s = req.ToList();
}
if (model1s.Count() > 0)
{
repeat = true;
}
}
if (model.ModelDetectable == 1)
{
all = false;
if (repeat == false)
{
model1s = context.Modele.Where(m => m.ModelDetectable == true).OrderBy(m => m.IdTypeDev).ToList();
}
else
{
var req = from m1 in context.Modele
join m2 in model1s on m1.CodeModel equals m2.CodeModel
where m1.ModelDetectable == true
orderby m1.IdTypeDev
select m1;
model1s = req.ToList();
}
if (model1s.Count() > 0)
{
repeat = true;
}
}
if (model.ModelDetectable == 2)
{
all = false;
if (repeat == false)
{
model1s = context.Modele.Where(m => m.ModelDetectable == false).OrderBy(m => m.IdTypeDev).ToList();
}
else
{
var req = from m1 in context.Modele
join m2 in model1s on m1.CodeModel equals m2.CodeModel
where m1.ModelDetectable == false
orderby m1.IdTypeDev
select m1;
model1s = req.ToList();
}
if (model1s.Count() > 0)
{
repeat = true;
}
}
if (!model.Description.Equals("rien"))
{
all = false;
if (repeat == false)
{
model1s = context.Modele.Where(m => m.Description.Equals(model.Description)).OrderBy(m => m.IdTypeDev).ToList();
}
else
{
var req = from m1 in context.Modele
join m2 in model1s on m1.CodeModel equals m2.CodeModel
where m1.Description.Equals(model.Description)
orderby m1.IdTypeDev
select m1;
model1s = req.ToList();
}
if (model1s.Count() > 0)
{
repeat = true;
}
}
if (!model.Propriete.Equals("rien"))
{
all = false;
if (repeat == false)
{
model1s = context.Modele.Where(m => m.Propriete.Equals(model.Propriete)).OrderBy(m => m.IdTypeDev).ToList();
}
else
{
var req = from m1 in context.Modele
join m2 in model1s on m1.CodeModel equals m2.CodeModel
where m1.Propriete.Equals(model.Propriete)
orderby m1.IdTypeDev
select m1;
model1s = req.ToList();
}
if (model1s.Count() > 0)
{
repeat = true;
}
}
if (all == false)
{
return(Json(model1s));
}
else
{
return(GetAllModels());
}
}
}