public ClientAudit GetByPK(Guid clientAuditGuid)
{
if (Guid.Empty == clientAuditGuid)
{ return new ClientAudit(); }
try
{
ClientAudit daClientAudit = new ClientAudit();
using (PSS2012DataContext context = this.DataContext)
{
daClientAudit = (
from items in context.ClientAudits
where items.ClientAuditGuid == clientAuditGuid
select items).SingleOrDefault();
}
if (null == daClientAudit)
{
throw new DataAccessException("ClientAudit no longer exists.");
}
return daClientAudit;
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public List<ClientAudit> GetAllWithUndefined()
{
ClientAudit undefinedClientAudit = new ClientAudit()
{
ClientAuditGuid = Guid.Empty,
ClientGuid = Guid.Empty,
ClientID = 0,
ClientName = "Undefined",
PhoneNumber = null,
Email = null,
Address = null,
CityStateZipGuid = Guid.Empty,
PaymentInfoGuid = Guid.Empty,
FederatedID = null,
FederatedKey = null,
FederatedIDProvider = null,
Username = null,
HashedPassword = null,
DateModified = default(DateTime),
AccountPaused = null
};
List<ClientAudit> response = this.GetAll().ToList();
response.Add(undefinedClientAudit);
return response;
}
/// <summary>
/// Inserts clientAudit data entity into the data store.
/// </summary>
/// <param name="entity">The clientAudit data entity to insert.</param>
/// <returns>The clientAudit identifier.</returns>
public ClientAudit Insert(ClientAudit entity)
{
//@@NEW - changed return type to entity type.
try
{
using (PSS2012DataContext context = DataContext)
{
entity.ClientAuditGuid = Guid.NewGuid();
//@@NEW
entity.DateModified = DateTime.Now;
context.ClientAudits.InsertOnSubmit(entity);
context.SubmitChanges();
}
//@@NEW - returning full entity.
return entity;
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public static DA.ClientAudit ToDataEntity(this BE.ClientAudit beClientAudit)
{
DA.ClientAudit clientAuditResult = new DA.ClientAudit()
{
ClientAuditGuid = beClientAudit.ClientAuditGuid,
ClientGuid = beClientAudit.ClientGuid,
ClientID = beClientAudit.ClientID,
ClientName = beClientAudit.ClientName,
PhoneNumber = beClientAudit.PhoneNumber,
Email = beClientAudit.Email,
Address = beClientAudit.Address,
CityStateZipGuid = beClientAudit.CityStateZipGuid,
PaymentInfoGuid = beClientAudit.PaymentInfoGuid,
FederatedID = beClientAudit.FederatedID,
FederatedKey = beClientAudit.FederatedKey,
FederatedIDProvider = beClientAudit.FederatedIDProvider,
Username = beClientAudit.Username,
HashedPassword = beClientAudit.HashedPassword,
DateModified = beClientAudit.DateModified,
AccountPaused = beClientAudit.AccountPaused,
IsWaiverd=beClientAudit.IsWaiverd,
FreeDays=beClientAudit.FreeDays,
Credits=beClientAudit.Credits,
IsSuspended=beClientAudit.IsSuspended,
IsFlagged=beClientAudit.IsFlagged,
IsActive=beClientAudit.IsActive
};
return clientAuditResult;
}
