public SeverityInfo selectBySeverityID(int SeverityID) { using (OTMDataContext db = new OTMDataContext()) { var ID = (from a in db.Severities where a.SeverityID == SeverityID select a).FirstOrDefault(); SeverityInfo sinfo = new SeverityInfo(); sinfo.SeverityID = ID.SeverityID; sinfo.SeverityLevel = ID.SeverityLevel; return(sinfo); } }
public List <SeverityInfo> SelectAllSeverityInfo() { List <SeverityInfo> slist = new List <SeverityInfo>(); SeverityInfo sinfo; using (OTMDataContext db = new OTMDataContext()) { var source = (from a in db.Severities select a).ToList(); foreach (var obj in source) { sinfo = new SeverityInfo(); sinfo.SeverityID = obj.SeverityID; sinfo.SeverityLevel = obj.SeverityLevel; slist.Add(sinfo); } } return(slist); }