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