public static List<UserAcct> Convert() { var db = new ExistingDataDataContext(); var users = db.users.Select(user => new UserAcct() { SourceId = user.userid, UserName = user.username ?? user.firstname + user.lastname, LastName = user.lastname, FirstName = user.firstname, Title = user.title, Password = user.passwords ?? "password", Phone = user.phonenum ?? "530-555-5555", DateCreated = user.datejoined ?? DateTime.Now, PiId = (int) user.piid, User = true, IsActive = user.valid.ToLower() == "yes" }).ToList(); users.AddRange(db.pis.Select(pi => new UserAcct() { SourceId = pi.piid, UserName = pi.piemail, LastName = pi.pilastname, FirstName = pi.pifirstname, Title = pi.pititle, Password = pi.pipassword, Phone = pi.piphonenum, Fax = pi.pifax, DateCreated = pi.pidatejoined ?? DateTime.Now, Pi = true, UniversityId = pi.universityid, DepartmentId = pi.departmentid })); users.AddRange(db.staffs.Select(st => new UserAcct() { SourceId = (int)st.staffid, UserName = st.staffemail, LastName = st.stafflast, FirstName = st.stafffirst, Title = st.stafftitle, Password = st.staffpassword, Staff = true } )); return users; }
public static List<RechargeAcct> Recharge() { var db = new ExistingDataDataContext(); var recharge = db.recharges.Select( a => new RechargeAcct() { SourceId = a.rechargeid, AccountNum = a.accountnum, Description = a.description, Start = a.datestart ?? DateTime.Now, End = a.dateend, IsValid = a.valid.ToLower() == "yes", PiId = a.piid }).ToList(); return recharge; }