public DataSourceTableModel GetDataSourceTableByPrimaryKey(Int64 MasterReport_Id, string TableName)
{
DataSourceTable result = this.dataContext
.DataSourceTables
.FirstOrDefault(pk => pk.MasterReport_Id == MasterReport_Id && pk.TableName == TableName);
if (result == null)
{
return(null);
}
return(result.CopyToObject(new DataSourceTableModel()) as DataSourceTableModel);
}
public void UpdateDataSourceTable(DataSourceTableModel model)
{
DataSourceTable existing = this.dataContext
.DataSourceTables
.Where(rx => rx.MasterReport_Id == model.MasterReport_Id && rx.TableName == model.TableName)
.FirstOrDefault();
if (existing == null)
{
existing = model.CopyToObject(new DataSourceTable()) as DataSourceTable;
this.dataContext.DataSourceTables.Add(existing);
}
else
{
existing = model.CopyToObject(existing) as DataSourceTable;
}
this.dataContext.SaveChanges();
model = existing.CopyToObject(model) as DataSourceTableModel;
}
