protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
AuthConfig.RegisterAuth();
Singleton.Edition = PinnaFaceEdition.WebEdition;
Singleton.BuildType = BuildType.Production;
Singleton.SeedDefaults = true;
Singleton.UseServerDateTime = true;//TO Handle Datetime.Now from serverornot
/**************/
Singleton.SystemVersionDate = DbCommandUtil.GetCurrentDatabaseVersion();
if (!ValidateProduct())
{
LogUtil.LogError(ErrorSeverity.Critical, "ValidateProduct",
"Higher Database Version", "", "");
return;
}
/*****************/
IEnumerable <ListDTO> aa = new ListService().GetAll();
new InitializeObjects().InitializeWebSecurity();
Container = new UnityContainer();
Container.RegisterType <IDbContext, PinnaFaceServerDBContext>(new ContainerControlledLifetimeManager());
Container.RegisterType <IUnitOfWork, UnitOfWork>();
}
private void ConfigureContainer()
{
switch (Singleton.Edition)
{
case PinnaFaceEdition.CompactEdition:
Singleton.SqlceFileName = PathUtil.GetDatabasePath();
Singleton.PhotoStorage = PhotoStorage.FileSystem;
break;
case PinnaFaceEdition.ServerEdition:
Singleton.SqlceFileName = "PinnaFaceDbProd"; //"PinnaFaceDb25";//munahan_pfdbtest1";//"PinnaFaceDb25";//PinnaFaceDbProd
Singleton.PhotoStorage = PhotoStorage.Database;
break;
}
Singleton.UseServerDateTime = false; //TO Handle Datetime.Now from serverornot
Singleton.BuildType = BuildType.Production;
Singleton.SeedDefaults = true;
Singleton.SystemVersionDate = DbCommandUtil.GetCurrentDatabaseVersion(); //Whenever System is updated change the number to higher value
Container.RegisterType <IDbContext, PinnaFaceDbContext>(new ContainerControlledLifetimeManager());
Container.RegisterType <IUnitOfWork, UnitOfWork>();
Container.RegisterType <MainViewModel>();
}
public void Sync() //(object sender, DoWorkEventArgs e)
{
Singleton.SystemVersionDate = DbCommandUtil.GetCurrentDatabaseVersion();
var productionDbVersion = Convert.ToInt32(DbCommandUtil.GetCurrentDbVersion());
var systemVersionDate = Convert.ToInt32(Singleton.SystemVersionDate);
if (systemVersionDate < productionDbVersion)
{
LogUtil.LogError(ErrorSeverity.Critical, "ValidateProduct",
"Higher Database Version", UserName, Agency);
return;
}
LogUtil.LogError(ErrorSeverity.Critical, "Sync", "Started", UserName, Agency);
AgencyWithAgentsUtility.InsertAgencyNamesonAddressesandAttachments();
if (!AgencyWithAgentsUtility.InsertAgencyWithAgents(UserName, Agency))
{
return;
}
if (!AgencyWithAgentsUtility.InsertUserWithAgencyWithAgents(UserName, Agency))
{
return;
}
IUnitOfWork sourceUnitOfWork = new UnitOfWork(
new DbContextFactory().Create());
IUnitOfWork destinationUnitOfWork = new UnitOfWorkServer(
new ServerDbContextFactory().Create());
var agency = sourceUnitOfWork.Repository <AgencyDTO>()
.Query()
.Get()
.FirstOrDefault();
//Setting = sourceUnitOfWork.Repository<SettingDTO>()
// .Query()
// .Get(1)
// .FirstOrDefault();
try
{
//if (Setting != null)
//{
// LastFromServerSyncDate = Setting.LastFromServerSyncDate != null
// ? (DateTime) Setting.LastFromServerSyncDate
// : DbCommandUtil.GetCurrentSqlDate(false).AddYears(-1);//If it is for first time collect all last one year data
// LastToServerSyncDate = Setting.LastToServerSyncDate != null
// ? (DateTime) Setting.LastToServerSyncDate
// : DbCommandUtil.GetCurrentSqlDate(false).AddYears(-1);
//}
//else
//{
LastFromServerSyncDate = DbCommandUtil.GetCurrentSqlDate(false).AddYears(-10);
LastToServerSyncDate = DbCommandUtil.GetCurrentSqlDate(false).AddYears(-10);
//}
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Sync DbCommandUtil.GetCurrentSqlDate(true)",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
}
LogUtil.LogError(ErrorSeverity.Info, "Sync To Server",
"Started", UserName, Agency);
#region Sync To Server
ToServerSyncing = true;
LastServerSyncDate = LastToServerSyncDate; //.AddMinutes(-10);//-10 Minutes should be syncronized with MonitorTimerElapsed
try
{
if (!SyncUsers2(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncAgencies2(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
Singleton.Agency = destinationUnitOfWork.Repository <AgencyDTO>()
.Query().Filter(a => a.RowGuid == agency.RowGuid)
.Get()
.FirstOrDefault();
if (!SyncAddresses(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncAttachments(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncRequiredDocuments(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncVisaSponsors(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncVisaConditions(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncEducation(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncExperiences(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncHawala(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncInsurance(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncLabour(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncEmbassy(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncFlight(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncAgencies(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncForeignAgents(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncAgencyWithAgents(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncSettings(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncProductActivations(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncVisas(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncEmployees(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncRelatives(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncComplains(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncComplainRemarks(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncEmployees2(sourceUnitOfWork, destinationUnitOfWork, false))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncUsers(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncMemberships(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncRoles(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncUsersInRoles(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
if (!SyncUserWithAgencyWithAgentDTO(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
//Sync Setting
try
{
if (!_errorsFound && _updatesFound)
{
var setUnitOfWork = new UnitOfWork(new DbContextFactory().Create());
SettingDTO set = setUnitOfWork.Repository <SettingDTO>().Query().Get(1).FirstOrDefault();
if (set != null)
{
set.LastToServerSyncDate = DbCommandUtil.GetCurrentSqlDate(false); //.AddHours(-1);
}
setUnitOfWork.Repository <SettingDTO>().SimpleUpdate(set);
setUnitOfWork.Commit();
setUnitOfWork.Dispose();
}
else
{
LogUtil.LogError(ErrorSeverity.Critical, "Sync To Server",
"No Updates Found", UserName, Agency);
}
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Update Setting.LastToServerSyncDate",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
}
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Sync General Method",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
}
finally
{
try
{
sourceUnitOfWork.Dispose();
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Sync General sourceUnitOfWork.Dispose",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
}
}
#endregion
LogUtil.LogError(ErrorSeverity.Info, "Sync To Server", "Completed", UserName, Agency);
#region Dispose UoW
try
{
sourceUnitOfWork.Dispose();
destinationUnitOfWork.Dispose();
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Dispose Unit of Work Method",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
}
#endregion
LogUtil.LogError(ErrorSeverity.Info, "Sync From Server", "Started", UserName, Agency);
#region Sync From Server
ToServerSyncing = false;
Singleton.Agency = agency;
try
{
LastServerSyncDate = LastFromServerSyncDate; //.AddMinutes(-10);
//-10 Minutes should be syncronized with MonitorTimerElapsed
sourceUnitOfWork = new UnitOfWorkServer(new ServerDbContextFactory().Create());
destinationUnitOfWork = new UnitOfWork(new DbContextFactory().Create());
if (!SyncSettings(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncProductActivations(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncAddresses(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncVisaSponsors(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncVisaConditions(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncVisas(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncEmployees(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncComplains(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncComplainRemarks(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncEmployees2(sourceUnitOfWork, destinationUnitOfWork, true))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncRoles(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
destinationUnitOfWork = GetNewUow2(destinationUnitOfWork);
if (!SyncUsersInRoles(sourceUnitOfWork, destinationUnitOfWork))
{
return;
}
////destinationUnitOfWork = GetNewUow(destinationUnitOfWork);
//Sync Setting
try
{
if (!_errorsFound && _updatesFound)
{
var setUnitOfWork = new UnitOfWork(new DbContextFactory().Create());
SettingDTO set = setUnitOfWork.Repository <SettingDTO>().Query().Get(1).FirstOrDefault();
if (set != null)
{
set.LastFromServerSyncDate = DbCommandUtil.GetCurrentSqlDate(false); //.AddHours(-1);
}
setUnitOfWork.Repository <SettingDTO>().SimpleUpdate(set);
setUnitOfWork.Commit();
setUnitOfWork.Dispose();
}
else
{
LogUtil.LogError(ErrorSeverity.Critical, "Sync From Server",
"No Updates Found", UserName, Agency);
}
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Update Setting.LastFromServerSyncDate",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
}
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Sync From Server General Method",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
}
finally
{
try
{
sourceUnitOfWork.Dispose();
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Sync From Server General sourceUnitOfWork.Dispose()",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
}
}
#endregion
LogUtil.LogError(ErrorSeverity.Info, "Sync From Server",
"Completed", UserName, Agency);
}