/// <summary>
/// Check and create the IsMapServer column in Databases.mdb database
/// </summary>
private void CheckNCreateIsMapServerColumnInMDBDatabase()
{
DIConnection dIConnection = null;
try
{
dIConnection = new DIConnection(DIServerType.MsAccess, string.Empty, string.Empty, Server.MapPath("../../stock/Database.mdb"),
string.Empty, string.Empty);
try
{
DataTable table = dIConnection.GetConnection().GetSchema("Columns");
var v = from r in table.AsEnumerable() where (r["TABLE_NAME"].ToString() == "MappingInformation" && r["COLUMN_NAME"].ToString() == "mapserver_used") select r;
if (v.Count() == 0)
{
dIConnection.AddColumn("mappinginformation", "mapserver_used", "Text", "False");
}
}
catch
{
}
}
catch (Exception ex)
{
Global.WriteErrorsInLogFolder("error in Registering new database");
Global.CreateExceptionString(ex, null);
}
finally
{
if (dIConnection != null)
{
dIConnection.Dispose();
dIConnection = null;
}
}
}