public static Realtor GetRealtor(int?realtorID) { if (realtorID == null || realtorID == 0) { return(new Realtor()); } EstateDataAccess.EstateCompact ec = new EstateCompact(DatabaseInfo.connectionString); return((from r in ec.Realtors where r.ID == realtorID select r).First <Realtor>()); }
public static List <Realtor> GetRealtors(int?agencyID) { EstateDataAccess.EstateCompact ec = new EstateCompact(DatabaseInfo.connectionString); if (agencyID != null) { return((from r in ec.Realtors where r.AgencyID == agencyID select r).ToList <Realtor>()); } return((from r in ec.Realtors select r).ToList <Realtor>()); }
public static void UpdateRealtor(Realtor updated) { EstateDataAccess.EstateCompact ec = new EstateCompact(DatabaseInfo.connectionString); #region UPDATE QUERY if (updated.ID != 0) { Realtor current = (from r in ec.Realtors where r.ID == updated.ID select r).First <Realtor>(); current.AgencyID = updated.AgencyID; current.Appointment = updated.Appointment; current.Birthday = updated.Birthday; current.Commencement = updated.Commencement; current.ContactPhone = updated.ContactPhone; current.Discharge = updated.Discharge; current.Enabled = updated.Enabled; current.FIO = updated.FIO; current.ICQ = updated.ICQ; current.Info = updated.Info; current.LastUpdateTime = DateTime.Now; current.Login = updated.Login; current.Mail = updated.Mail; current.OfficePhone = updated.OfficePhone; current.Password = updated.Password; current.PermissionID = updated.PermissionID; current.Photo = updated.Photo; current.Remuneration = updated.Remuneration; current.Skype = updated.Skype; ec.SubmitChanges(); return; } #endregion #region INSERT QUERY updated.AgencyID = 1; // FIX: id updated.LastUpdateTime = updated.CreationTime = DateTime.Now; ec.Realtors.InsertOnSubmit(updated); ec.SubmitChanges(); #endregion }
public static void UpdateAgency(Agency updated) { EstateDataAccess.EstateCompact ec = new EstateCompact(DatabaseInfo.connectionString); Agency current = (from a in ec.Agencies where a.ID == updated.ID select a).First <Agency>(); current.About = updated.About; current.Address = updated.Address; current.Enabled = updated.Enabled; current.Foundation = updated.Foundation; current.ICQ = updated.ICQ; current.LastUpdateTime = DateTime.Now; current.Logo = updated.Logo; current.Mail = updated.Mail; current.MapUrl = updated.MapUrl; current.Name = updated.Name; current.Passage = updated.Passage; current.Phone = updated.Phone; current.SiteUrl = updated.SiteUrl; current.Skype = updated.Skype; ec.SubmitChanges(); }
public static Agency GetAgency(int agencyID) { EstateDataAccess.EstateCompact ec = new EstateCompact(DatabaseInfo.connectionString); return((from a in ec.Agencies where a.ID == agencyID select a).First <Agency>()); }