//------------------------------------------------------------------------------------------------------------------------------------------- static public company GetCompany(UInt64 companyRecordId) { using (fischerhomesEntities context = new fischerhomesEntities()) { return((from p in context.companies select p).FirstOrDefault()); } }
//------------------------------------------------------------------------------------------------------------------------------------------- virtual public Boolean Update(activity record) { using (fischerhomesEntities context = new fischerhomesEntities()) { try { activity original = GetByRecordId(record.ActivityRecordId); if (original == null) { context.activities.Add(record); context.SaveChanges(); return(false); } DbEntityEntry entity = context.Entry(original); if (entity.State != EntityState.Unchanged) { return(false); } context.Entry(original).CurrentValues.SetValues(record); context.SaveChanges(); } catch { return(false); } } // Return Success return(true); }
//------------------------------------------------------------------------------------------------------------------------------------------- virtual public activity GetByRecordId(Decimal recordId) { using (fischerhomesEntities context = new fischerhomesEntities()) { return((from p in context.activities where p.ActivityRecordId == recordId select p).FirstOrDefault()); } }
//------------------------------------------------------------------------------------------------------------------------------------------- virtual public List <activity> GetList() { using (fischerhomesEntities context = new fischerhomesEntities()) { return((from p in context.activities where p.CompanyRecordId == tableCompanyRecordId orderby p.ActivityId select p).ToList()); } }
//------------------------------------------------------------------------------------------------------------------------------------------- virtual public Boolean Delete(activity record) { activity original = null; using (fischerhomesEntities context = new fischerhomesEntities()) { try { if ((original = context.activities.Find(record.ActivityRecordId)) == null) { context.Entry(original).CurrentValues.SetValues(record); } context.activities.Remove(original); context.SaveChanges(); } catch (Exception ex) { log.WriteError("Delete Activity", ex); return(false); } } return(true); }
//------------------------------------------------------------------------------------------------------------------------------------------- static public UInt64 GetTableReferenceId(UInt64 companyRecordId, String tableName) { using (fischerhomesEntities context = new fischerhomesEntities()) { companytablereference tableReference = (from p in context.companytablereferences where p.CompanyRecordId == companyRecordId && p.TableName == tableName select p).FirstOrDefault(); if (tableReference == null) { return(0); } return((UInt64)tableReference.TableCompanyRecordId); } }
//------------------------------------------------------------------------------------------------------------------------------------------- static public String GetCompanyName(UInt64 companyRecordId) { using (fischerhomesEntities context = new fischerhomesEntities()) { company c = (from p in context.companies select p).FirstOrDefault(); if (c == null) { return(String.Empty); } return(c.Description); } }