public static List <SaveUserRequestDTO> ReadExcelForBulkUploadUser(ExcelPackage package, ExcelWorksheet worksheet)
{
var data = new List <SaveUserRequestDTO>();
var rowCount = worksheet.Dimension?.Rows;
var colCount = worksheet.Dimension?.Columns;
if (!rowCount.HasValue || !colCount.HasValue)
{
return(data);
}
//We have some rows and columns. Start Reading them.
for (int row = 2; row <= rowCount.Value; row++)
{
var user = new SaveUserRequestDTO();
user.FirstName = worksheet.Cells[row, 1].Value?.ToString();
user.MiddleName = worksheet.Cells[row, 2].Value?.ToString();
user.LastName = worksheet.Cells[row, 3].Value?.ToString();
user.Username = worksheet.Cells[row, 4].Value?.ToString();
user.EmailAddress = worksheet.Cells[row, 5].Value?.ToString();
user.Password = worksheet.Cells[row, 4].Value?.ToString();
data.Add(user);
}
return(data);
}
public IActionResult Add(SaveUserRequestDTO userDTO)
{
User user = _mapper.Map <User>(userDTO);
var res = _service.Add(user);
if (res.IsSuccess)
{
return(Ok(res.IsSuccess));
}
else
{
return(BadRequest(res.Errors));
}
}
public async Task <IActionResult> Put(SaveUserRequestDTO userDTO)
{
User user = _mapper.Map <User>(userDTO);
var res = _service.Edit(user);
if (res.IsSuccess)
{
return(Ok());
}
else
{
return(BadRequest(res.Errors));
}
}