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> UpdateAsync(TEntity entity) { using (WriteConnection) { var count = await WriteConnection.UpdateAsync(entity); if (count > 0) { return(entity); } else { return(null); } } }