public void GetFranchiseeDataForUpdate(int labId, out FranchiseeTenant outfranchiseeTenant,
out FranchiseeConfiguration outfranchiseeConfiguration)
{
outfranchiseeTenant = null;
outfranchiseeConfiguration = null;
outfranchiseeTenant = _franchiseeTenantRepository.GetById(labId);
if (outfranchiseeTenant != null)
{
// change the connection
var connectionString = PersistenceHelper.GenerateConnectionString(outfranchiseeTenant.Server, outfranchiseeTenant.Database, outfranchiseeTenant.UserName, outfranchiseeTenant.Password);
_franchiseeConfigurationRepository.ChangeConnectionString(connectionString);
outfranchiseeConfiguration = _franchiseeConfigurationRepository.FirstOrDefault();
}
}
public int SetupFranchisee(FranchiseeTenant franchiseeTenant, FranchiseeConfiguration franchiseeConfiguration)
{
using (var scope = new TransactionScope())
{
//Add Franchise
ValidateBusinessRules(franchiseeTenant);
_franchiseeTenantRepository.Add(franchiseeTenant);
_franchiseeTenantRepository.Commit();
int i = 0;
var connectionString = PersistenceHelper.GenerateConnectionString(franchiseeTenant.Server,
franchiseeTenant.Database, franchiseeTenant.UserName, franchiseeTenant.Password);
var database = franchiseeTenant.Database;
// Create franchisee configuaration
// Check franchisee configuaration has exists
#region
_franchiseeConfigurationRepository.DeleteAllFranchiseeConfigurationBySqlString(database);
var franchiseeId = PasswordHelper.HashString(franchiseeTenant.Id.ToString(), franchiseeTenant.Name);
var licenseKey = franchiseeTenant.LicenseKey;
var franchiseeContact = franchiseeConfiguration.FranchiseeContact;
var primaryContactPhone = franchiseeConfiguration.PrimaryContactPhone;
var primaryContactEmail = franchiseeConfiguration.PrimaryContactEmail;
var primaryContactFax = franchiseeConfiguration.PrimaryContactFax;
var primaryContactCellNumber = franchiseeConfiguration.PrimaryContactCellNumber;
var name = franchiseeConfiguration.Name;
var city = franchiseeConfiguration.City;
var state = franchiseeConfiguration.State;
var zip = franchiseeConfiguration.Zip;
var address1 = franchiseeConfiguration.Address1;
var address2 = franchiseeConfiguration.Address2;
var officePhone = franchiseeConfiguration.OfficePhone;
var faxNumber = franchiseeConfiguration.FaxNumber;
var industryId = franchiseeConfiguration.IndustryId;
var logo = franchiseeConfiguration.Logo;
var franchiseeconfig = new FranchiseeConfiguration
{
FranchiseeId = franchiseeId,
LicenseKey = licenseKey,
FranchiseeContact = franchiseeContact,
PrimaryContactPhone = primaryContactPhone,
PrimaryContactEmail = primaryContactEmail,
PrimaryContactFax = primaryContactFax,
PrimaryContactCellNumber = primaryContactCellNumber,
Name = name,
City = city,
State = state,
Zip = zip,
Address1 = address1,
Address2 = address2,
OfficePhone = officePhone,
FaxNumber = faxNumber,
Logo = logo,
IndustryId = industryId
};
_franchiseeConfigurationRepository.AddFranchiseeConfigurationBySqlString(franchiseeconfig, database);
#endregion
// Create a franchisee admin role
#region
_userRoleRepository.ChangeConnectionString(connectionString);
var franchiseeAdminRole = _userRoleRepository.FirstOrDefault(o => o.AppRoleName == AppRole.GlobalAdmin.ToString());
var idFranchiseeAdminRole = 0;
if (franchiseeAdminRole == null)
{
// Create franchisee admin role
var franchiseeAdminRoleAdd = new UserRole
{
Name = "Franchisee Admin",
AppRoleName = AppRole.GlobalAdmin.ToString(),
UserRoleFunctions = new List <UserRoleFunction>()
};
// Create list userRoleFunction for franchisee admin
var objListDocumentType = _userRoleRepository.GetAllDocumentType();
foreach (var documentType in objListDocumentType)
{
var objViewAdd = new UserRoleFunction
{
DocumentTypeId = documentType.Id,
SecurityOperationId = (int)OperationAction.View
};
franchiseeAdminRoleAdd.UserRoleFunctions.Add(objViewAdd);
//Implement View insert
var objInsertAdd = new UserRoleFunction
{
DocumentTypeId = documentType.Id,
SecurityOperationId = (int)OperationAction.Add,
};
franchiseeAdminRoleAdd.UserRoleFunctions.Add(objInsertAdd);
//Implement View update
var objUpdateAdd = new UserRoleFunction
{
DocumentTypeId = documentType.Id,
SecurityOperationId = (int)OperationAction.Update,
};
franchiseeAdminRoleAdd.UserRoleFunctions.Add(objUpdateAdd);
//Implement View delete
var objDeleteAdd = new UserRoleFunction
{
DocumentTypeId = documentType.Id,
SecurityOperationId = (int)OperationAction.Delete,
};
franchiseeAdminRoleAdd.UserRoleFunctions.Add(objDeleteAdd);
var objProcessAdd = new UserRoleFunction
{
DocumentTypeId = documentType.Id,
SecurityOperationId = (int)OperationAction.Process,
};
franchiseeAdminRoleAdd.UserRoleFunctions.Add(objProcessAdd);
}
_userRoleRepository.Add(franchiseeAdminRoleAdd);
_userRoleRepository.Commit();
idFranchiseeAdminRole = franchiseeAdminRoleAdd.Id;
}
else
{
idFranchiseeAdminRole = franchiseeAdminRole.Id;
}
#endregion
// Create franchisee admin user
// Check user admin has exists
#region
_userRepository.ChangeConnectionString(connectionString);
var isExistsUserFranchiseeAdmin = _userRepository.CheckExist(o => o.UserRoleId == idFranchiseeAdminRole);
if (!isExistsUserFranchiseeAdmin)
{
var randomPassword = "******";
string username = franchiseeTenant.Name.Replace(" ", "");
var password = PasswordHelper.HashString(randomPassword, username);
var phoneNumber = franchiseeConfiguration.PrimaryContactPhone; // "1111111111";
var email = franchiseeConfiguration.PrimaryContactEmail; // "*****@*****.**";
var cellPhone = franchiseeConfiguration.PrimaryContactCellNumber; // "1111111111";
// Create user franchisee admin
var userFranchiseeAdmin = new User
{
UserName = username,
Password = password,
UserRoleId = idFranchiseeAdminRole,
IsActive = true,
FirstName = "Admin",
LastName = "Franchisee",
HomePhone = phoneNumber,
MobilePhone = cellPhone,
Email = email,
};
_userRepository.AddUserBySqlString(userFranchiseeAdmin, database);
}
#endregion
scope.Complete();
return(franchiseeTenant.Id);
}
}
public byte[] UpdateFranchisee(FranchiseeTenant franchiseeTenant,
FranchiseeConfiguration franchiseeConfiguration)
{
using (var scope = new TransactionScope())
{
ValidateBusinessRules(franchiseeTenant);
_franchiseeTenantRepository.Update(franchiseeTenant);
_franchiseeTenantRepository.Commit();
// change the connection
var connectionString = PersistenceHelper.GenerateConnectionString(franchiseeTenant.Server, franchiseeTenant.Database, franchiseeTenant.UserName, franchiseeTenant.Password);
var database = franchiseeTenant.Database;
_franchiseeConfigurationRepository.ChangeConnectionString(connectionString);
_franchiseeConfigurationRepository.DeleteAllFranchiseeConfigurationBySqlString(database);
// Create franchisee configuaration
//Add new Franchisee Configuration
var franchiseeId = PasswordHelper.HashString(franchiseeTenant.Id.ToString(), franchiseeTenant.Name);
var licenseKey = franchiseeTenant.LicenseKey;
var franchiseeContact = franchiseeConfiguration.FranchiseeContact;
var primaryContactPhone = franchiseeConfiguration.PrimaryContactPhone;
var primaryContactEmail = franchiseeConfiguration.PrimaryContactEmail;
var primaryContactFax = franchiseeConfiguration.PrimaryContactFax;
var primaryContactCellNumber = franchiseeConfiguration.PrimaryContactCellNumber;
var name = franchiseeConfiguration.Name;
var city = franchiseeConfiguration.City;
var state = franchiseeConfiguration.State;
var zip = franchiseeConfiguration.Zip;
var address1 = franchiseeConfiguration.Address1;
var address2 = franchiseeConfiguration.Address2;
var officePhone = franchiseeConfiguration.OfficePhone;
var faxNumber = franchiseeConfiguration.FaxNumber;
var logo = franchiseeConfiguration.Logo;
var industryId = franchiseeConfiguration.IndustryId;
var franchiseeconfig = new FranchiseeConfiguration
{
FranchiseeId = franchiseeId,
LicenseKey = licenseKey,
FranchiseeContact = franchiseeContact,
PrimaryContactPhone = primaryContactPhone,
PrimaryContactEmail = primaryContactEmail,
PrimaryContactFax = primaryContactFax,
PrimaryContactCellNumber = primaryContactCellNumber,
Name = name,
City = city,
State = state,
Zip = zip,
Address1 = address1,
Address2 = address2,
OfficePhone = officePhone,
FaxNumber = faxNumber,
Logo = logo,
IndustryId = industryId
};
_franchiseeConfigurationRepository.AddFranchiseeConfigurationBySqlString(franchiseeconfig, database);
scope.Complete();
return(franchiseeTenant.LastModified);
}
}
