public List <AnSLAView> GetApps()
{
var db = new AppListContext();
var appList = db.ApplicationList.Include(a => a.InfraSlas);
List <AnSLAView> myList = new List <AnSLAView>();
foreach (AppListDal.Model.ApplicationList app in appList)
{
AnSLAView asv = new AnSLAView();
asv.Applicaiton = app.Application;
asv.Availability = app.InfraSlas.Availability;
asv.CloudOnPrem = app.InfraSlas.CloudOnPremSaas;
asv.DB = app.InfraSlas.Db;
asv.ID = app.InfraSlas.Id;
asv.InfrComments = app.InfraSlas.InfraComment;
asv.MnthlyDwnTme = app.InfraSlas.MnthlyDwnTmeMax;
asv.OS = app.InfraSlas.Os;
asv.PriorityLevel = app.InfraSlas.PriorityLevel;
myList.Add(asv);
}
return(myList);
}
public List <AnSecurityView> GetApps()
{
var db = new AppListContext();
var appList = db.ApplicationList.Include(a => a.SecurityCompliance);
List <AnSecurityView> myList = new List <AnSecurityView>();
foreach (AppListDal.Model.ApplicationList app in appList)
{
AnSecurityView asv = new AnSecurityView();
asv.Applicaiton = app.Application;
asv.DtPrvcyAppvl = app.SecurityCompliance.DataPrivacyApproval;
asv.DPQCCmpltPrrForFusion = app.SecurityCompliance.DpqcmpltePriorForFusionChanages;
asv.DPQCCmpltPrrToFusion = app.SecurityCompliance.DpqcmpltePriorToFusion;
asv.EMEAIGoLiveDate = app.SecurityCompliance.EmeaigoLiveDate;
asv.GDPR = app.SecurityCompliance.Gdprcriticality;
asv.ID = app.SecurityCompliance.Id;
asv.ITSecurityApproval = app.SecurityCompliance.ItSecurityApproval;
asv.MasterDataReq = app.SecurityCompliance.MasterDataReq;
asv.WCApprovalRequired = app.SecurityCompliance.WcapprovalRequired;
asv.WCApprovalSent = app.SecurityCompliance.WcquestionaireSent;
asv.WCApproved = app.SecurityCompliance.Wcapproved;
asv.WCComplete = app.SecurityCompliance.WcquestionaireComplete;
myList.Add(asv);
}
return(myList);
}
public List<AnApplicationView> GetApps()
{
var db = new AppListContext();
var appList = db.ApplicationList;
List<AnApplicationView> myList = new List<AnApplicationView>();
foreach(AppListDal.Model.ApplicationList app in appList)
{
AnApplicationView aap = new AnApplicationView();
aap.Application = app.Application;
aap.ApplicationDescription = app.ApplicationDescription;
aap.AppType = app.ApplicationType;
aap.ArchLayer = app.ArchitectureLayer;
aap.BusinessOwner = app.BusinessOwner;
aap.EnterprisevsPlantSpecific = app.EnterprisevsPlantSpecific;
aap.FunctionalArea = app.FunctionalArea;
aap.ID = app.Id;
aap.ITOwner = app.Itowner;
aap.LocationUsed = app.LocationUsed;
aap.Path = app.Path;
aap.TechOwner = app.TechOwner;
aap.TypesOfUser = app.TypesofUsers;
myList.Add(aap);
}
return myList;
}
public void DeleteData()
{
AppListDal.Model.AppListContext context = new AppListContext();
//int id = aplist.Id;
//AppListDal.Model.ApplicationList appD = new AppListDal.Model.ApplicationList();
// appD.Id = aplist.Id;
context.Remove(aplist);
//context.Remove<AppListDal.Model.ApplicationList>(aplist);
context.SaveChanges();
}
public GetAnApp(string id)
{
var db = new AppListContext();
int i = Convert.ToInt32(id);
var pps = db.ApplicationList.Where(a => a.Id == i).Include(a => a.InfraSlas).Include(a => a.SecurityCompliance).Include(a => a.Strategy);
//var pps = db.ApplicationList.Where(a => a.Id == i);
AnApp = pps.First();
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
var db = new AppListContext();
var appList = db.ApplicationList.Include(a => a.Strategy).Include(b => b.SecurityCompliance);
foreach (ApplicationList app in appList)
{
Console.WriteLine("ID: {0}, {1}, BO: {2}", app.Id, app.Application, app.BusinessOwner);
if (!String.IsNullOrEmpty(app.Strategy.Sap))
{
Console.WriteLine(" {0}", app.Strategy.Sap);
Console.WriteLine(" Work Councel Questionaire Complet:{0} ", app.SecurityCompliance.WcquestionaireComplete);
}
}
var pps = db.ApplicationList.Where(a => a.Id == 120).Include(a => a.Strategy).Include(b => b.SecurityCompliance).Include(s => s.Arch);
foreach (ApplicationList anApp in pps)
{
Console.WriteLine("ID: {0}, {1}, BO: {2}", anApp.Id, anApp.Application, anApp.BusinessOwner);
if (!String.IsNullOrEmpty(anApp.Strategy.Sap))
{
Console.WriteLine(" {0}", anApp.Strategy.Sap);
Console.WriteLine(" Work Councel Questionaire Complet:{0} ", anApp.SecurityCompliance.WcquestionaireComplete);
}
}
var colNames = db.TbleColumn;
foreach (TbleColumn tc in colNames)
{
Console.WriteLine("{0}, {1}, {3}, {2}", tc.Id, tc.ColumnName, tc.Definition, tc.Table);
}
Console.ReadKey();
}
public List <AnStrategyView> GetApps()
{
var db = new AppListContext();
var appList = db.ApplicationList.Include(a => a.Strategy);
List <AnStrategyView> myList = new List <AnStrategyView>();
foreach (AppListDal.Model.ApplicationList app in appList)
{
AnStrategyView asv = new AnStrategyView();
asv.Applicaiton = app.Application;
asv.FusionStrategy = app.Strategy.FusionStrategy;
asv.ID = app.Strategy.Id;
asv.Integrated = app.Strategy.Integrated;
asv.LegacyOriginator = app.Strategy.LegacyOriginator;
asv.SAP = app.Strategy.Sap;
asv.SAPArea = app.Strategy.Saparea;
asv.SAPIntegration = app.Strategy.Sapintegration;
myList.Add(asv);
}
return(myList);
}
public void ChangeData()
{
AppListDal.Model.AppListContext context = new AppListContext();
context.Update <AppListDal.Model.ApplicationList>(aplist);
context.SaveChanges();
}
