//public int TotalRecords { get; set; }
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var model = new AttributeMappingSource().GetModel(typeof(DataClassesDataContext));
using (Broker.LoggingDataAccess.LoggingDataContext dc = new LoggingDataContext())
{
string ColName = "";
List <Broker.LoggingDataAccess.DBTranslatedColumnName> columnList = new List <Broker.LoggingDataAccess.DBTranslatedColumnName>();
foreach (var mt in model.GetTables())
{
foreach (var dm in mt.RowType.PersistentDataMembers)
{
if (dm.DbType != null)
{
ColName = dm.MappedName;
//bool contains = false;
//foreach (Broker.LoggingDataAccess.DBTranslatedColumnName item in columnList)
//{
// if (item.Name == ColName)
// {
// contains = true;
// }
//}
//if (!contains)
//{
if (dc.DBTranslatedColumnNames.Where(c => c.Name == ColName).FirstOrDefault() == null)
{
Broker.LoggingDataAccess.DBTranslatedColumnName newColumn = new Broker.LoggingDataAccess.DBTranslatedColumnName();
newColumn.Name = ColName;
newColumn.NameMKD = string.Empty;
dc.DBTranslatedColumnNames.InsertOnSubmit(newColumn);
dc.SubmitChanges();
}
}
}
}
//TotalRecords = dc.DBTranslatedColumnNames.Count();
gvTables.DataSource = dc.DBTranslatedColumnNames;
gvTables.DataBind();
}
}
}
internal static bool DeleteWithCascase <T>(System.Data.Linq.DataContext ctx, T entity) where T : class, INotifyPropertyChanged
{
//Get the primary key of the context
var pkey = GetPrimaryKey <T>();
//Get foreign keys
var fkeys = GetForeignKeys <T>();
//get the model for the ctx
var model = new AttributeMappingSource().GetModel(ctx.GetType());
//Get the table for the given entity
var eTable = ctx.GetTable <T>();
foreach (var modelTable in model.GetTables())
{
//Loop tables and delete
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!(IsPostBack))
{
var model = new AttributeMappingSource().GetModel(typeof(DataClassesDataContext));
List <TableDetail> tableDetails = new List <TableDetail>();
List <MetaTable> temp = model.GetTables().ToList();
for (int i = 0; i < temp.Count; i++)
{
string tableName = temp[i].TableName;
string prefix = tableName.Substring(0, 3);
string tableWithoutPrefix = tableName.Substring(4);
string tableNameInDB = "[" + prefix + "].[" + tableWithoutPrefix + "]";
using (Broker.LoggingDataAccess.LoggingDataContext dc = new LoggingDataContext())
{
TableDetail newDetail = new TableDetail();
newDetail.Name = tableWithoutPrefix;
newDetail.Index = i;
newDetail.Insert = true;
newDetail.Delete = true;
newDetail.Select = true;
newDetail.Update = true;
DBLoggingIgnoredTable tempIgnoredTable = dc.DBLoggingIgnoredTables.Where(c => c.TableName == tableWithoutPrefix).FirstOrDefault();
if (tempIgnoredTable != null)
{
int ignoredTableID = tempIgnoredTable.ID;
foreach (DBLoggingIgnoredTableActivity item in dc.DBLoggingIgnoredTableActivities.Where(c => c.DbLoggingIgnoredTableID == ignoredTableID).ToList())
{
switch (item.ActivityTypeID)
{
case 1:
{
newDetail.Insert = false;
break;
}
case 2:
{
newDetail.Delete = false;
break;
}
case 3:
{
newDetail.Select = false;
break;
}
case 4:
{
newDetail.Update = false;
break;
}
default:
break;
}
}
}
tableDetails.Add(newDetail);
}
}
gvTables.DataSource = tableDetails;
gvTables.DataBind();
}
}
