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