public ActionResult Upload(HttpPostedFileBase upload, BulkUpload model)
{
string info = "";
try {
// Check if the user has entered application ids
if (model.Applications.Trim().Length > 0)
{
string[] appications = model.Applications.Split(';');
string[] securityRoles = model.SecurityRoles.Split(';');
string[] permissionGroups = model.PermissionGroups.Split(';');
var file = new System.IO.StreamReader(upload.InputStream);
while (file.Peek() >= 0)
{
string line = file.ReadLine();
string[] fields = line.Split(',');
var bulkUser = new BulkUser();
bulkUser.Title = fields[0];
bulkUser.GivenName = fields[1];
bulkUser.MiddleName = fields[2];
bulkUser.Surname = fields[3];
bulkUser.Email = fields[4];
bulkUser.Password = fields[5];
// call to creat user
// call
}
}
else
{
// No Application entered
info = "No Application Ids entered.";
}
}
catch (Exception exp)
{
info = exp.Message;
}
return(View());
}
public void UpdateTable(BulkUser bulkUser, string status)
{
try
{
if (_cc != null)
{
bulkUser.Status = status;
bulkUser.ModifiedDate = DateTime.UtcNow;
_cc.Update(bulkUser);
_cc.SaveChanges();
}
}
catch (Exception ex)
{
_logger.LogError($"DbHelper-UpdateTable:Exception occured while updating the bulk user id {bulkUser.Id}");
_logger.LogError(ex);
}
}
private bool IsBulkUserValid(BulkUser bulkUser, string action)
{
var retVal = true;
try
{
if (bulkUser == null || string.IsNullOrEmpty(action))
{
return(false);
}
switch (action)
{
case CareStreamConst.Bulk_User_Create:
case CareStreamConst.Bulk_User_Update:
#region Create || Update
if (bulkUser.FileId == 0)
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.Action))
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.UserPrincipalName))
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.DisplayName))
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.InitialPassword))
{
return(false);
}
#endregion
break;
case CareStreamConst.Bulk_User_Invite:
#region Invite
if (bulkUser.FileId == 0)
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.Action))
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.InviteeEmail))
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.InviteRedirectURL))
{
return(false);
}
#endregion
break;
case CareStreamConst.Bulk_User_Delete:
#region Create || Update
if (bulkUser.FileId == 0)
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.Action))
{
return(false);
}
if (string.IsNullOrEmpty(bulkUser.UserPrincipalName))
{
return(false);
}
#endregion
break;
}
}
catch (Exception ex)
{
retVal = false;
_logger.LogError("BulkUploadController-IsBulkUserValid: Exception occurred...");
_logger.LogError(ex);
}
return(retVal);
}
private List <BulkUser> ProcessCSVAndCreateDbObject(CsvReader csvReader, string actionFor)
{
List <BulkUser> bulkUsers = new List <BulkUser>();
try
{
if (csvReader != null)
{
switch (actionFor)
{
case CareStreamConst.Bulk_User_Create:
case CareStreamConst.Bulk_User_Update:
#region Create || Update User
while (csvReader.Read())
{
BulkUser bulkUser = new BulkUser
{
Action = actionFor,
Status = CareStreamConst.Bulk_User_Loaded_Status,
CreatedDate = DateTime.UtcNow,
ModifiedDate = DateTime.UtcNow
};
foreach (string header in csvReader.Context.HeaderRecord)
{
try
{
switch (header.ToLower())
{
case CareStreamConst.BU_DisplayName:
bulkUser.DisplayName = csvReader.GetField(header);
break;
case CareStreamConst.BU_UserPrincipalName:
bulkUser.UserPrincipalName = csvReader.GetField(header);
break;
case CareStreamConst.BU_InitialPassword:
bulkUser.InitialPassword = csvReader.GetField(header);
break;
case CareStreamConst.BU_BlockSignIn:
var blockSignStr = csvReader.GetField(header);
if (string.IsNullOrEmpty(blockSignStr))
{
bulkUser.BlockSignIn = false;
}
else if (blockSignStr.ToLower() == "yes")
{
bulkUser.BlockSignIn = true;
}
else
{
bulkUser.BlockSignIn = false;
}
break;
case CareStreamConst.BU_FirstName:
bulkUser.FirstName = csvReader.GetField(header);
break;
case CareStreamConst.BU_LastName:
bulkUser.LastName = csvReader.GetField(header);
break;
case CareStreamConst.BU_JobTitle:
bulkUser.JobTitle = csvReader.GetField(header);
break;
case CareStreamConst.BU_Department:
bulkUser.Department = csvReader.GetField(header);
break;
case CareStreamConst.BU_Usagelocation:
bulkUser.Usagelocation = csvReader.GetField(header);
break;
case CareStreamConst.BU_StreetAddress:
bulkUser.StreetAddress = csvReader.GetField(header);
break;
case CareStreamConst.BU_State:
bulkUser.State = csvReader.GetField(header);
break;
case CareStreamConst.BU_Country:
bulkUser.Country = csvReader.GetField(header);
break;
case CareStreamConst.BU_Office:
bulkUser.Office = csvReader.GetField(header);
break;
case CareStreamConst.BU_City:
bulkUser.City = csvReader.GetField(header);
break;
case CareStreamConst.BU_ZIP:
bulkUser.ZIP = csvReader.GetField(header);
break;
case CareStreamConst.BU_OfficePhone:
bulkUser.OfficePhone = csvReader.GetField(header);
break;
case CareStreamConst.BU_MobilePhone:
bulkUser.MobilePhone = csvReader.GetField(header);
break;
}
}
catch (Exception ex)
{
_logger.LogError($"BulkUploadController-ProcessCSVAndCreateDbObject: Create || Update user error reading values for header- {header}");
_logger.LogError(ex);
}
}
bulkUsers.Add(bulkUser);
}
#endregion
break;
case CareStreamConst.Bulk_User_Invite:
#region Invite User
while (csvReader.Read())
{
BulkUser bulkUser = new BulkUser
{
Action = actionFor,
Status = CareStreamConst.Bulk_User_Loaded_Status,
CreatedDate = DateTime.UtcNow,
ModifiedDate = DateTime.UtcNow
};
foreach (string header in csvReader.Context.HeaderRecord)
{
try
{
switch (header.ToLower())
{
case CareStreamConst.BU_InviteeEmail:
bulkUser.InviteeEmail = csvReader.GetField(header);
break;
case CareStreamConst.BU_InviteRedirectURL:
bulkUser.InviteRedirectURL = csvReader.GetField(header);
break;
case CareStreamConst.BU_CustomizedMessageBody:
bulkUser.CustomizedMessageBody = csvReader.GetField(header);
break;
case CareStreamConst.BU_SendEmail:
var blockSignStr = csvReader.GetField(header);
if (string.IsNullOrEmpty(blockSignStr))
{
bulkUser.SendEmail = false;
}
else if (blockSignStr.ToLower() == "true")
{
bulkUser.SendEmail = true;
}
else
{
bulkUser.SendEmail = false;
}
break;
}
}
catch (Exception ex)
{
_logger.LogError($"BulkUploadController-ProcessCSVAndCreateDbObject: Invite user error reading values for header- {header}");
_logger.LogError(ex);
}
}
bulkUsers.Add(bulkUser);
}
#endregion
break;
case CareStreamConst.Bulk_User_Delete:
#region Delete User
while (csvReader.Read())
{
BulkUser bulkUser = new BulkUser
{
Action = actionFor,
Status = CareStreamConst.Bulk_User_Loaded_Status,
CreatedDate = DateTime.UtcNow,
ModifiedDate = DateTime.UtcNow
};
foreach (string header in csvReader.Context.HeaderRecord)
{
try
{
switch (header.ToLower())
{
case CareStreamConst.BU_UserPrincipalName:
bulkUser.UserPrincipalName = csvReader.GetField(header);
break;
}
}
catch (Exception ex)
{
_logger.LogError($"BulkUploadController-ProcessCSVAndCreateDbObject: Delete user error reading values for header- {header}");
_logger.LogError(ex);
}
}
bulkUsers.Add(bulkUser);
}
#endregion
break;
}
}
}
catch (Exception ex)
{
_logger.LogError("BulkUploadController-ProcessCSVAndCreateDbObject: Exception occurred...");
_logger.LogError(ex);
}
return(bulkUsers);
}
