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 async Task <UserInfo> FindByLoginKeyAsync(string keyWord)
{
DynamicParameters param = new DynamicParameters();
string sql = @"select * from userinfo
where PhoneNumber=@keyWord or Email=@KeyWord";
param.Add("@keyWord", keyWord);
param.Add("@KeyWord", keyWord);
using (ReadConnection)
{
var result = await ReadConnection.QueryFirstOrDefaultAsync <UserInfo>(sql, param);
return(result);
}
}