public async Task ImportExcel(Queue <DriverVM> listModel) { try { if (listModel != null && listModel.Count > 0) { //Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); //MySqlConnection con = new MySqlConnection("server=192.168.1.208;userid=root;pwd=lyh888150;database=ccp(latest);sslmode=none;"); foreach (var item in listModel) { string sql = $"select * from aspnetusers where PhoneNumber={item.PhoneNumber}"; var user = new Aspnetusers(); using (ReadConnection) { user = await ReadConnection.QueryFirstOrDefaultAsync <Aspnetusers>(sql); } if (user != null) { if (user.UserCategory != UserCategory.JFEmployees) { user.UserCategory = UserCategory.JFEmployees; using (WriteConnection) { await WriteConnection.UpdateAsync(user); } } } else { var newuser = new Aspnetusers() { PhoneNumber = item.PhoneNumber, UserName = item.PhoneNumber, CertificatePhotoCertificationState = CertificationStatus.Uncommitted, DrivingLicenseKeyCertificationState = CertificationStatus.Uncommitted, IdentityCardCertificationState = CertificationStatus.Uncommitted, LockoutEnabled = true, RealNameStatus = CertificationStatus.Uncommitted, CertificationStatus = CertificationStatus.Uncommitted, TrailerLicenseCertificationStatus = CertificationStatus.Uncommitted, VehiclePhotoCertificationStatus = CertificationStatus.Uncommitted, RoleType = ApplicationRoleType.Driver, RoadTransportStatus = CertificationStatus.Uncommitted, Date = DateTime.Now, UserCategory = UserCategory.JFEmployees }; using (WriteConnection) { await WriteConnection.InsertAsync(newuser);; } } } } } catch (Exception ex) { throw ex; } }
public override async Task <TEntity> InsertAsync(TEntity entity) { using (WriteConnection) { await WriteConnection.InsertAsync(entity); return(entity); } }
public override async Task <TPrimaryKey> InsertAndGetIdAsync(TEntity entity) { using (WriteConnection) { await WriteConnection.InsertAsync(entity); return(entity.Id); } }
public async Task <ReturnValue> CreateAsync(UserInfo user) { using (WriteConnection) { var result = await WriteConnection.InsertAsync(user); if (result >= 0) { return(await Task.FromResult(new ReturnValue { IsSuccess = true })); } else { throw new Exception(ExceptionCode.EC103); } } }