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