public List <IDevices> ListOfDevices()
{
Devices dev = new Devices();
Models.ITventoryEntities ent = new Models.ITventoryEntities();
List <IDevices> komputery = new List <IDevices>();
komputery.AddRange(ent.Devices.Select(x => new ComputerViewModel()
{
Id = x.dev_id,
GAno = x.dev_GAno,
SilesiaNo = x.dev_SilesiaNo
}));
return(komputery);
}
// public string CdRomSn { get; set; }
#endregion
#region Pola dodatkowe 4
#endregion
#region Save
public string SaveToDatabase()
{
try
{
Devices dev = new Devices();
Models.ITventoryEntities ent = new Models.ITventoryEntities();
if (Id != null && Id != 0)
{
dev = ent.Devices.Where(x => x.dev_id == Id).FirstOrDefault();
}
dev.dev_GAno = GAno;
dev.dev_SilesiaNo = SilesiaNo;
dev.dev_Nazwa = NazwaKomputera;
//dev.dev_status = Status;
dev.dev_uzyt = Użytkownicy;
//dev.dev_typ = Typ;
//dev.dev_producent = Producent;
dev.dev_model = Model;
dev.dev_pn = PartNumber;
dev.dev_sn = SerialNumber;
//dev.dev_dostawca = Dostawca;
dev.dev_dataZakupu = DataZakupu.Value;
dev.dev_nrFaktury = NumerFaktury;
if (Id == null || Id == 0)
{
ent.Devices.Add(dev);
}
ent.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return("");
}
public List <IDevices> ListOfDevices(string filter)
{
Devices dev = new Devices();
Models.ITventoryEntities ent = new Models.ITventoryEntities();
IDevices test = new ComputerViewModel();
List <IDevices> komputery = new List <IDevices>();
komputery.AddRange(ent.Devices.Where(x => x.dev_Nazwa.Contains(filter)).Select(x => new ComputerViewModel()
{
Id = x.dev_id,
GAno = x.dev_GAno,
SilesiaNo = x.dev_SilesiaNo
}));
//List<IDevices> komputery = ent.Devices.Select(x => new ComputerViewModel()
//{
// Id = x.dev_id,
// GAno = x.dev_GAno,
// SilesiaNo = x.dev_SilesiaNo
//}).ToList();
return(komputery);
}
