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" })); }