private async void ServiceTimer_Tick(object sender, System.Timers.ElapsedEventArgs e)
{
timer.Stop();
//1. Get new records from Roach
//2. Iterate through the records and create id's and passwords
//3. Send email to user with information
// Generate a random number
Random random = new Random();
// Use other methods
RandomNumberGenerator generator = new RandomNumberGenerator();
FairfieldAllergeryRepository fairfieldAllergeryRepository = new FairfieldAllergeryRepository();
List <AllergyPatient> allergyPatient = new List <AllergyPatient>();
ConfigurationValues.FairfieldAllergyConnection = System.Configuration.ConfigurationManager.AppSettings["fairfieldDatabaseConnection"];
ConfigurationValues.RegisterUrl = System.Configuration.ConfigurationManager.AppSettings["registerUrl"];
OperationResult getCurrentUserId = fairfieldAllergeryRepository.GetCurrentId();
int currentId = getCurrentUserId.CurrentId;
allergyPatient = fairfieldAllergeryRepository.GetListOfNewUsers(currentId.ToString());
for (int i = 0; i < allergyPatient.Count; i++)
{
//i = 3695;
//Console.WriteLine("Begin record: " + i.ToString() + " of " + allergyPatient.Count.ToString());
try
{
Console.WriteLine(DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " Processing record " + i.ToString() + " of " + allergyPatient.Count.ToString());
if (allergyPatient[i].first_name.Length > 0 && allergyPatient[i].last_name.Length > 0)
{
if (allergyPatient[i].first_name.Length == 1)
{
allergyPatient[i].first_name = "None";
}
if (allergyPatient[i].last_name.Length == 1)
{
allergyPatient[i].last_name = "None";
}
string userID = generator.RandomString(10, false);
string password = generator.RandomPassword();
fairfieldAllergeryRepository.CreateNewUser(allergyPatient[i], userID, password);
string sex = string.Empty;
if (allergyPatient[i].gender == 1)
{
sex = "M";
}
else if (allergyPatient[i].gender == 2)
{
sex = "F";
}
RegisterViewModel registerViewModel = new RegisterViewModel();
registerViewModel.Email = "None";
registerViewModel.FirstName = allergyPatient[i].first_name;
registerViewModel.LastName = allergyPatient[i].last_name;
if (string.IsNullOrEmpty(allergyPatient[i].home_phone))
{
registerViewModel.HomePhone = "0000000000";
}
else
{
registerViewModel.HomePhone = allergyPatient[i].home_phone;
}
if (sex.Length < 1)
{
registerViewModel.Sex = "U";
}
else
{
registerViewModel.Sex = sex;
}
if (string.IsNullOrEmpty(allergyPatient[i].birthday.ToShortDateString()))
{
registerViewModel.DateOfBirth = " ";
}
else
{
registerViewModel.DateOfBirth = allergyPatient[i].birthday.ToShortDateString();
}
//registerViewModel.DateOfBirth = allergyPatient[i].birthday.ToShortDateString();
registerViewModel.UserName = userID;
registerViewModel.Password = password;
registerViewModel.ConfirmPassword = password;
var json = JsonConvert.SerializeObject(registerViewModel);
var data = new StringContent(json, Encoding.UTF8, "application/json");
var url = ConfigurationValues.RegisterUrl;
using var client = new HttpClient();
var response = await client.PostAsync(url, data);
string jsonResult = response.Content.ReadAsStringAsync().Result;
var result = JsonConvert.DeserializeObject <Status>(jsonResult);
Console.WriteLine(result);
currentId = allergyPatient[i].pkid;
if (result.status == "Failure")
{
string s2 = string.Empty;
}
fairfieldAllergeryRepository.UpdateWebIdTableWithGuidFromAspNetUsersTable(userID);
}
Console.WriteLine("Done with record: " + i.ToString() + " of " + allergyPatient.Count.ToString());
}
catch (Exception er)
{
Console.WriteLine(er.ToString());
}
//Need to get GUID in AspNetUsers table and put it into WEBID
}
if (allergyPatient.Count > 0)
{
fairfieldAllergeryRepository.UpdateUserId(currentId++);
}
else
{
Console.WriteLine("No records to process");
}
fairfieldAllergeryRepository.UpdateUsersWithDataFromRoach();
//SQL Access Info
//ID: walden
//PW: Db#rd!927!Mz
//DB Name: RoschIT
//172.16.1.13
//Thread.Sleep(3600000);
timer.Start();
}
