public void Delete(NoteDataCriteria criteria)
{
var data = MockDb.Notes
.Where(row => row.NoteId == criteria.NoteId)
.Single();
MockDb.Notes.Remove(data);
}
public void Delete(NoteDataCriteria criteria)
{
var data = MockDb.Notes
.Where(row => row.NoteId == criteria.NoteId)
.Single();
MockDb.Notes.Remove(data);
}
private void DataPortal_Delete(NoteDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <INoteDataFactory>();
dalFactory.Delete(criteria);
}
}
public NoteData Fetch(NoteDataCriteria criteria)
{
var data = MockDb.Notes
.Where(row => row.NoteId == criteria.NoteId)
.Single();
data = this.Fetch(data);
return data;
}
public NoteData Fetch(NoteDataCriteria criteria)
{
var data = MockDb.Notes
.Where(row => row.NoteId == criteria.NoteId)
.Single();
data = this.Fetch(data);
return(data);
}
public void Delete(NoteDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var note = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Notes.DeleteObject(note);
ctx.ObjectContext.SaveChanges();
}
}
public void Delete(NoteDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var note = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Notes.DeleteObject(note);
ctx.ObjectContext.SaveChanges();
}
}
public NoteData Fetch(NoteDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var note = this.Fetch(ctx, criteria)
.Single();
var noteData = new NoteData();
this.Fetch(note, noteData);
return(noteData);
}
}
public NoteData Fetch(NoteDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var note = this.Fetch(ctx, criteria)
.Single();
var noteData = new NoteData();
this.Fetch(note, noteData);
return noteData;
}
}
private void DataPortal_Fetch(NoteDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <INoteDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
public NoteData[] FetchInfoList(NoteDataCriteria criteria)
{
var query = MockDb.Notes
.AsQueryable();
var notes = query.AsQueryable();
var data = new List<NoteData>();
foreach (var note in notes)
{
data.Add(this.Fetch(note));
}
return data.ToArray();
}
public NoteData[] FetchInfoList(NoteDataCriteria criteria)
{
var query = MockDb.Notes
.AsQueryable();
var notes = query.AsQueryable();
var data = new List <NoteData>();
foreach (var note in notes)
{
data.Add(this.Fetch(note));
}
return(data.ToArray());
}
private void DataPortal_Fetch(NoteDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<INoteDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild<NoteInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
private void DataPortal_Fetch(NoteDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <INoteDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild <NoteInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
public NoteData[] FetchLookupInfoList(NoteDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var notes = this.Fetch(ctx, criteria)
.AsEnumerable();
var noteDataList = new List <NoteData>();
foreach (var note in notes)
{
var noteData = new NoteData();
this.Fetch(note, noteData);
noteDataList.Add(noteData);
}
return(noteDataList.ToArray());
}
}
public NoteData[] FetchLookupInfoList(NoteDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var notes = this.Fetch(ctx, criteria)
.AsEnumerable();
var noteDataList = new List<NoteData>();
foreach (var note in notes)
{
var noteData = new NoteData();
this.Fetch(note, noteData);
noteDataList.Add(noteData);
}
return noteDataList.ToArray();
}
}
private IQueryable <Note> Fetch(
Csla.Data.ObjectContextManager <ApplicationEntities> ctx,
NoteDataCriteria criteria)
{
IQueryable <Note> query = ctx.ObjectContext.Notes
.Include("Source")
.Include("CreatedByUser")
.Include("ModifiedByUser");
if (criteria.NoteId != null)
{
query = query.Where(row => row.NoteId == criteria.NoteId);
}
if (criteria.Body != null)
{
query = query.Where(row => row.Body == criteria.Body);
}
if (criteria.IsArchived != null)
{
query = query.Where(row => row.IsArchived == criteria.IsArchived);
}
if (criteria.SourceId != null)
{
query = query.Where(row => criteria.SourceId.Contains(row.SourceId));
}
if (criteria.SourceTypeId != null)
{
query = query.Where(row => row.SourceTypeId == criteria.SourceTypeId);
}
if (criteria.CreatedBy != null)
{
query = query.Where(row => row.CreatedBy == criteria.CreatedBy);
}
if (criteria.CreatedDate != null &&
criteria.CreatedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.CreatedDate >= criteria.CreatedDate.DateFrom);
}
if (criteria.CreatedDate != null &&
(criteria.CreatedDate.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.CreatedDate <= criteria.CreatedDate.DateTo);
}
if (criteria.ModifiedBy != null)
{
query = query.Where(row => row.ModifiedBy == criteria.ModifiedBy);
}
if (criteria.ModifiedDate != null &&
criteria.ModifiedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.ModifiedDate >= criteria.ModifiedDate.DateFrom);
}
if (criteria.ModifiedDate != null &&
(criteria.ModifiedDate.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.ModifiedDate <= criteria.ModifiedDate.DateTo);
}
if (criteria.Text != null)
{
query = query.Where(row => row.Body.Contains(criteria.Text));
}
if (criteria.SortBy != null)
{
query = query.OrderBy(string.Format(
"{0} {1}",
criteria.SortBy,
criteria.SortOrder == ListSortDirection.Ascending ? "ASC" : "DESC"));
}
if (criteria.SkipRecords != null)
{
query = query.Skip(criteria.SkipRecords.Value);
}
if (criteria.MaximumRecords != null)
{
query = query.Take(criteria.MaximumRecords.Value);
}
return(query);
}
internal static Note FetchNote(NoteDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <Note>(criteria));
}
internal static NoteInfoList FetchNoteInfoList(NoteDataCriteria criteria)
{
return Csla.DataPortal.Fetch<NoteInfoList>(criteria);
}
internal static void DeleteNote(NoteDataCriteria criteria)
{
Csla.DataPortal.Delete <Note>(criteria);
}
public static NoteInfoList NoteFetchInfoList(NoteDataCriteria criteria)
{
return NoteInfoList.FetchNoteInfoList(criteria);
}
internal static void DeleteNote(NoteDataCriteria criteria)
{
Csla.DataPortal.Delete<Note>(criteria);
}
private IQueryable<Note> Fetch(
Csla.Data.ObjectContextManager<ApplicationEntities> ctx,
NoteDataCriteria criteria)
{
IQueryable<Note> query = ctx.ObjectContext.Notes
.Include("Source")
.Include("CreatedByUser")
.Include("ModifiedByUser");
if (criteria.NoteId != null)
{
query = query.Where(row => row.NoteId == criteria.NoteId);
}
if (criteria.Body != null)
{
query = query.Where(row => row.Body == criteria.Body);
}
if (criteria.IsArchived != null)
{
query = query.Where(row => row.IsArchived == criteria.IsArchived);
}
if (criteria.SourceId != null)
{
query = query.Where(row => criteria.SourceId.Contains(row.SourceId));
}
if (criteria.SourceTypeId != null)
{
query = query.Where(row => row.SourceTypeId == criteria.SourceTypeId);
}
if (criteria.CreatedBy != null)
{
query = query.Where(row => row.CreatedBy == criteria.CreatedBy);
}
if (criteria.CreatedDate != null
&& criteria.CreatedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.CreatedDate >= criteria.CreatedDate.DateFrom);
}
if (criteria.CreatedDate != null
&& (criteria.CreatedDate.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.CreatedDate <= criteria.CreatedDate.DateTo);
}
if (criteria.ModifiedBy != null)
{
query = query.Where(row => row.ModifiedBy == criteria.ModifiedBy);
}
if (criteria.ModifiedDate != null
&& criteria.ModifiedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.ModifiedDate >= criteria.ModifiedDate.DateFrom);
}
if (criteria.ModifiedDate != null
&& (criteria.ModifiedDate.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.ModifiedDate <= criteria.ModifiedDate.DateTo);
}
if (criteria.Text != null)
{
query = query.Where(row => row.Body.Contains(criteria.Text));
}
if (criteria.SortBy != null)
{
query = query.OrderBy(string.Format(
"{0} {1}",
criteria.SortBy,
criteria.SortOrder == ListSortDirection.Ascending ? "ASC" : "DESC"));
}
if (criteria.SkipRecords != null)
{
query = query.Skip(criteria.SkipRecords.Value);
}
if (criteria.MaximumRecords != null)
{
query = query.Take(criteria.MaximumRecords.Value);
}
return query;
}
internal static Note FetchNote(NoteDataCriteria criteria)
{
return Csla.DataPortal.Fetch<Note>(criteria);
}
private void DataPortal_Fetch(NoteDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<INoteDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
private void DataPortal_Delete(NoteDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<INoteDataFactory>();
dalFactory.Delete(criteria);
}
}
public static NoteInfoList NoteFetchInfoList(NoteDataCriteria criteria)
{
return(NoteInfoList.FetchNoteInfoList(criteria));
}
internal static NoteInfoList FetchNoteInfoList(NoteDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <NoteInfoList>(criteria));
}
