public void AddApplicationTableField(ApplicationTableField applicationTableField)
{
applicationTableField.LastModified = DateTime.UtcNow;
applicationTableField.LastModifiedBy = "System";
applicationTableField.RecordAdded = DateTime.UtcNow;
applicationTableField.RecordAddedBy = "System";
applicationTableField.IsDeleted = false;
context.ApplicationTableFields.Add(applicationTableField);
context.SaveChanges();
}
private List<ViewModels.ApplicationTableAndFieldsViewModel> PopulateList(string Mode)
{
List<ViewModels.ApplicationTableAndFieldsViewModel> RetValue = new List<ViewModels.ApplicationTableAndFieldsViewModel>();
var query = from p in context.ApplicationTables select p;
if (Mode == "Active")
{
query = from p in context.ApplicationTables
where p.IsDeleted == false
orderby p.Description
select p;
}
else if (Mode =="All")
{
query = from p in context.ApplicationTables
orderby p.Description
select p;
}
else
{
query = from p in context.ApplicationTables
where p.IsDeleted == true
orderby p.Description
select p;
}
foreach (var item in query)
{
ViewModels.ApplicationTableAndFieldsViewModel m = new ViewModels.ApplicationTableAndFieldsViewModel();
m.ParentTableID = item.ApplicationTableID;
m.Description = item.Description;
m.ApplicationTableFields = new List<ApplicationTableField>();
var query2 = from c in context.ApplicationTableFields
where c.ApplicationTableID == m.ParentTableID && c.IsDeleted == false
orderby c.Description
select c;
foreach (var c_item in query2)
{
ApplicationTableField ct = new ApplicationTableField();
ct.ApplicationTableFieldID = c_item.ApplicationTableFieldID;
ct.Description = c_item.Description;
ct.ApplicationTableID = c_item.ApplicationTableID;
ct.FieldType = c_item.FieldType;
ct.IsAudited = c_item.IsAudited;
ct.LastModified = c_item.LastModified;
ct.LastModifiedBy = c_item.LastModifiedBy;
ct.RecordAdded = c_item.RecordAdded;
ct.RecordAddedBy = c_item.RecordAddedBy;
m.ApplicationTableFields.Add(ct);
}
RetValue.Add(m);
}
return RetValue;
}