public int DeleteSoftwareById(int Id)
{
SoftwaresDBEntities entities = new SoftwaresDBEntities();
Software software = new Software();
software.Id = Id;
entities.Entry(software).State = EntityState.Deleted;
int Retval = entities.SaveChanges();
return(Retval);
}
public int AddSoftware(string Name, string Version, string LicenceType, int Rank)
{
SoftwaresDBEntities entities = new SoftwaresDBEntities();
List list = new List();
list.Name = Name;
list.Rank = Rank;
list.Version = Version;
list.LicenceType = LicenceType;
entities.Lists.Add(list);
int Retval = entities.SaveChanges();
return(Retval);
}
public int UpdateSoftware(int Id, string Name, string Version, string LicenceType, int Rank)
{
SoftwaresDBEntities entities = new SoftwaresDBEntities();
List software = new List();
software.Id = Id;
software.Name = Name;
software.Rank = Rank;
software.Version = Version;
software.LicenceType = LicenceType;
entities.Entry(software).State = EntityState.Modified;
int Retval = entities.SaveChanges();
return(Retval);
}
public Software GetSoftwareById(int id)
{
SoftwaresDBEntities entities = new SoftwaresDBEntities();
var softwares = from k in entities.Lists where k.Id == id select k;
Software usr = new Software();
foreach (var item in softwares)
{
usr.Id = item.Id;
usr.Name = item.Name;
usr.Rank = (int)item.Rank;
usr.Version = item.Version;
usr.LicenceType = item.LicenceType;
}
return(usr);
}
public List <Software> GetSoftwares()
{
List <Software> userlst = new List <Software>();
SoftwaresDBEntities entities = new SoftwaresDBEntities();
var softwares = from k in entities.Lists select k;
foreach (var item in softwares)
{
Software usr = new Software();
usr.Id = item.Id;
usr.Name = item.Name;
usr.Version = item.Version;
usr.Rank = (int)item.Rank;
usr.LicenceType = item.LicenceType;
userlst.Add(usr);
}
return(userlst);
}
