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); }