private void CreateConnectionObject()
{
if (this.dataAccessConnection == null)
{
ReportConnection connection = this.repo.GetConnection(this.masterReport_Id);
this.dataAccessConnection = connection.CopyToObject(new DatabaseModel()) as DatabaseModel;
}
this.data = new DataAccess(this.dataAccessConnection);
}
public ReportConnectionModel GetReportConnectionByPrimaryKey(Int64 MasterReport_Id, string ReportConnectionName)
{
ReportConnection result = this.dataContext
.ReportConnections
.FirstOrDefault(pk => pk.MasterReport_Id == MasterReport_Id && pk.ReportConnectionName == ReportConnectionName);
if (result == null)
{
return(null);
}
return(result.CopyToObject(new ReportConnectionModel()) as ReportConnectionModel);
}
public ReportConnectionModel GetProductionOrConnectionModel(long masterReport_Id)
{
ReportConnection result = base.dataContext
.ReportConnections
.FirstOrDefault(d => d.IsProductionConnection == true &&
d.IsActive == true);
if (result == null)
{
return(null);
}
return(result.CopyToObject(new ReportConnectionModel()) as ReportConnectionModel);
}
public void UpdateReportConnection(ReportConnectionModel model)
{
ReportConnection existing = this.dataContext
.ReportConnections
.Where(rx => rx.MasterReport_Id == model.MasterReport_Id && rx.ReportConnectionName == model.ReportConnectionName)
.FirstOrDefault();
if (existing == null)
{
existing = model.CopyToObject(new ReportConnection()) as ReportConnection;
this.dataContext.ReportConnections.Add(existing);
}
else
{
existing = model.CopyToObject(existing) as ReportConnection;
}
this.dataContext.SaveChanges();
model = existing.CopyToObject(model) as ReportConnectionModel;
}
