public async Task <RespondData> ImportUser(UserImportModel model)
{
var userDataList = model.ImportData.Select(x => new UserOrgRS {
OrgId = model.OrgId,
OrgName = model.OrgName,
Code = x.Code,
DOB = x.Dob,
IdCardNumber = x.Identity,
UserFullName = x.UserFullName,
UserName = x.PhoneNumber,
UserEmail = x.UserEmail,
PhoneNumber = x.PhoneNumber
});
var invalidData = new List <string>();
foreach (var user in userDataList)
{
try
{
user.IsCreateUser = true;
user.UserName = user.PhoneNumber;
await this.AddAsync(user);
} catch (Exception ex)
{
invalidData.Add(user.PhoneNumber);
}
}
return(Success(invalidData));
}
public ResultModel insertUserList(UserImportModel model)
{
try
{
SqlParameter[] prms = new SqlParameter[]
{
new SqlParameter {
ParameterName = "userId", DbType = DbType.String, Value = model.userId, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "branchCode", DbType = DbType.String, Value = model.branchCode, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "userRoleList", DbType = DbType.String, Value = model.strUserList == null ? (object)DBNull.Value : model.strUserList, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "resultMessage", DbType = DbType.String, Direction = ParameterDirection.Output, Size = Int32.MaxValue
},
new SqlParameter {
ParameterName = "resultCode", DbType = DbType.Int32, Direction = ParameterDirection.Output, Size = Int32.MaxValue
}
};
var result = _Repository.ExecWithStoreProcedureCommand(Store_insertUserList, prms);
return(result);
}
catch (Exception ex)
{
HDBH.Log.WriteLog.Error("UserService => insertUserList", ex);
return(null);
}
}
public JsonResult ImportUserList(HttpPostedFileBase btnImportUser)
{
string fileName = "";
object ls;
try
{
var file = btnImportUser;
if (file != null)
{
string[] extFile = new string[] { "xlsx" };
fileName = string.Format("{0}\\{1}{2}", Server.MapPath("~/Content/Uploads"), DateTime.Now.ToString("yyyyMMddHHmmss"), System.IO.Path.GetExtension(file.FileName));
if (fileName.EndsWith(".xlsx", StringComparison.CurrentCultureIgnoreCase))
{
file.SaveAs(fileName);
}
Reader reader = new Reader(fileName);
IDataTransformer podata = new DataTransformer();
ls = reader.GetData <UserImportItemModel>(podata);
if (ls != null)
{
int idx = 1;
List <UserImportItemModel> lsImport = new List <UserImportItemModel>();
foreach (var itx in ls as List <UserImportItemModel> )
{
if (!string.IsNullOrEmpty(itx.userName))
{
var item = new UserImportItemModel
{
userName = itx.userName,
fullName = itx.fullName,
email = itx.email,
officerCode = itx.officerCode,
phoneNumber = itx.phoneNumber,
userBranchCode = itx.userBranchCode,
};
lsImport.Add(item);
idx++;
}
}
UserImportModel model = new UserImportModel();
model.userId = RDAuthorize.UserId;
model.branchCode = RDAuthorize.BranchCode;
if (lsImport != null && lsImport.Any())
{
model.strUserList = JsonConvert.SerializeObject(lsImport);
}
return(Json(new { Code = 0, Message = "Thành công!" }));
}
}
}
catch (Exception ex)
{
HDBH.Log.WriteLog.Error("ManagerController => ImportCommisionList", ex);
return(Json(new { Code = 1, Message = "Đã có lỗi xảy ra" }));
}
finally
{
if (!string.IsNullOrWhiteSpace(fileName))
{
System.IO.File.Delete(fileName);
}
}
return(Json(new { Code = -1, Message = "Không tìm thấy danh sách sản phẩm" }));
}
