public UserRoleFunction Get(long UserRolesID, long FunctionID)
{
UserRoleFunction objUserRoleFunction = new UserRoleFunction();
UserRole_DL objUserRole = new UserRole_DL(Connection);
SystemFunction_DL objSystemFunction = new SystemFunction_DL(Connection);
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_UserRoleID", UserRolesID),
new SqlParameter("@Original_FuncID", FunctionID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPADD_Unit", paramList);
objUserRoleFunction.SystemFunction = objSystemFunction.Get(Convert.ToInt64(dt.Rows[0]["FuncID"]));
objUserRoleFunction.UserRole = objUserRole.Get(Convert.ToInt64(dt.Rows[0]["UserRoleID"]));
return(objUserRoleFunction);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private List <UserRoleFunction> ProcessMappingFromUserRoleGrid(string userRoleFunctionDataParam)
{
var userRoleFunctionData = JsonConvert.DeserializeObject <List <UserRoleFunctionGridVo> >(userRoleFunctionDataParam);
var objResult = new List <UserRoleFunction>();
var listUpdate = userRoleFunctionData;
if (listUpdate != null && listUpdate.Count != 0)
{
foreach (var userRoleFunctionGridVo in listUpdate)
{
var objViewAdd = new UserRoleFunction
{
DocumentTypeId = userRoleFunctionGridVo.Id,
SecurityOperationId = (int)OperationAction.View,
IsDeleted = !userRoleFunctionGridVo.IsView
};
objResult.Add(objViewAdd);
//Implement View insert
var objInsertAdd = new UserRoleFunction
{
DocumentTypeId = userRoleFunctionGridVo.Id,
SecurityOperationId = (int)OperationAction.Add,
IsDeleted = !userRoleFunctionGridVo.IsInsert
};
objResult.Add(objInsertAdd);
//Implement View update
var objUpdateAdd = new UserRoleFunction
{
DocumentTypeId = userRoleFunctionGridVo.Id,
SecurityOperationId = (int)OperationAction.Update,
IsDeleted = !userRoleFunctionGridVo.IsUpdate
};
objResult.Add(objUpdateAdd);
//Implement View delete
var objDeleteAdd = new UserRoleFunction
{
DocumentTypeId = userRoleFunctionGridVo.Id,
SecurityOperationId = (int)OperationAction.Delete,
IsDeleted = !userRoleFunctionGridVo.IsDelete
};
objResult.Add(objDeleteAdd);
var objProcessAdd = new UserRoleFunction
{
DocumentTypeId = userRoleFunctionGridVo.Id,
SecurityOperationId = (int)OperationAction.Process,
IsDeleted = !userRoleFunctionGridVo.IsProcess
};
objResult.Add(objProcessAdd);
}
}
return(objResult);
}
public int Add(UserRoleFunction obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@UserRoleID", obj.UserRole),
new SqlParameter("@FuncID", obj.SystemFunction)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_UserRoleFunction", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public ActionResult Create(UserRoleParameter parameters)
{
var viewModel = MapFromClientParameters(parameters);
var shareViewModel = viewModel.SharedViewModel as DashboardUserRoleShareViewModel;
if (shareViewModel != null)
{
var listRoleFunctionUpdate = shareViewModel.CheckAll ? GetAllRoleFunction() : ProcessMappingFromUserRoleGrid(shareViewModel.UserRoleFunctionData);
var listRoleFunctionOld = new List <UserRoleFunction>();
// Check user have edit some value in list role old => delete role old and add role new
foreach (var oldItem in listRoleFunctionOld)
{
if (listRoleFunctionUpdate.Any(o => o.DocumentTypeId == oldItem.DocumentTypeId))
{
oldItem.IsDeleted = true;
}
}
//after check user removed, remove item of the list new with conditions has property IsDelete equal true;
//Copy listRoleFunctionUpdate
var listRoleFunctionUpdateRecheck = listRoleFunctionUpdate.ToList();
foreach (var item in listRoleFunctionUpdateRecheck.Where(item => item.IsDeleted))
{
listRoleFunctionUpdate.Remove(item);
}
var objListFunctionForEntity = new List <UserRoleFunction>();
// Add listUpdate
objListFunctionForEntity.AddRange(listRoleFunctionUpdate);
// Add list data in old
foreach (var itemOld in listRoleFunctionOld.Where(o => !o.IsDeleted))
{
var objAdd = new UserRoleFunction
{
DocumentTypeId = itemOld.DocumentTypeId,
SecurityOperationId = itemOld.SecurityOperationId
};
objListFunctionForEntity.Add(objAdd);
}
var entity = shareViewModel.MapTo <UserRole>();
entity.UserRoleFunctions = objListFunctionForEntity;
var savedEntity = MasterFileService.Add(entity);
MenuExtractData.Instance.RefershListData();
return(Json(new { savedEntity.Id }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Id = 0 }, JsonRequestBehavior.AllowGet));
}
public int Update(UserRoleFunction obj, UserRoleFunction OriginalUserRoleFunction)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@UserRoleID", obj.UserRole),
new SqlParameter("@FuncID", obj.SystemFunction),
new SqlParameter("@Original_UserRoleID", obj.UserRole),
new SqlParameter("@Original_FuncID", obj.UserRole)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_UserRoleFunction", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private List <UserRoleFunction> GetAllRoleFunction()
{
var objResult = new List <UserRoleFunction>();
var objListDocumentType = _userRoleService.GetAllDocumentTypeId();
foreach (var id in objListDocumentType)
{
var objViewAdd = new UserRoleFunction
{
DocumentTypeId = id,
SecurityOperationId = (int)OperationAction.View
};
objResult.Add(objViewAdd);
var objInsertAdd = new UserRoleFunction
{
DocumentTypeId = id,
SecurityOperationId = (int)OperationAction.Add
};
objResult.Add(objInsertAdd);
var objUpdateAdd = new UserRoleFunction
{
DocumentTypeId = id,
SecurityOperationId = (int)OperationAction.Update
};
objResult.Add(objUpdateAdd);
var objDeleteAdd = new UserRoleFunction
{
DocumentTypeId = id,
SecurityOperationId = (int)OperationAction.Delete
};
objResult.Add(objDeleteAdd);
var objProcessAdd = new UserRoleFunction
{
DocumentTypeId = id,
SecurityOperationId = (int)OperationAction.Process
};
objResult.Add(objProcessAdd);
}
return(objResult);
}
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);
}
}