public void ValidateUniqueEmailCheckInDatabase()
{
SignUpController signUp = new SignUpController();
RequestMessage request = new RequestMessage();
request.Email = "*****@*****.**";
request.FirstName = "simple";
request.LastName = "simple";
request.Phone = "12345678901";
request.Sandbox_Key = "123";
Enrollees enrollee = new Enrollees();
if (enrollee.get_enrollees($" where email = '{request.Email}'").Count == 0)
{
Enrollees_Table enrolleesData = new Enrollees_Table();
// please either try to check this email for every test or delete it's record from the database
enrolleesData.Email = "*****@*****.**";
enrolleesData.First_name = "simple";
enrolleesData.Last_name = "simple";
enrolleesData.Phone = "12345678901";
enrollee.add_enrollees(enrolleesData);
}
ResponsMessage response = signUp.NewPlanSubscription(request);
Assert.Equal("true", (response.Response == "Failed" && response.Message == "Enrollee data already exists" ? "true":"false"));
}
public string add_enrollees(Enrollees_Table new_enrollees, bool returnID = false)
{
string result = "";
if (returnID)
{
result = "0";
}
try
{
string query = "INSERT INTO enrollees( email,first_name,last_name,phone ) " +
"VALUES ( @email,@first_name,@last_name,@phone ) ";
MySqlCommand cmd = new MySqlCommand(query);
cmd.Parameters.Add("@email", MySqlDbType.VarChar).Value = new_enrollees.Email;
cmd.Parameters.Add("@first_name", MySqlDbType.VarChar).Value = new_enrollees.First_name;
cmd.Parameters.Add("@last_name", MySqlDbType.VarChar).Value = new_enrollees.Last_name;
cmd.Parameters.Add("@phone", MySqlDbType.VarChar).Value = new_enrollees.Phone;
var x = HealthPlanSignUps.insertUpdateDeleteData(cmd);
if (returnID)
{
result = x.ToString().Trim();
}
}
catch (Exception dd)
{
result = dd.Message;
}
return(result);
}
public ResponsMessage NewPlanSubscription([FromBody] RequestMessage request)
{
ResponsMessage message = new ResponsMessage();
if (request.Email.Trim().Length < 5 || request.Email.Trim().Length > 50)
{
message.Response = "Failed";
message.Message = "Invalid email address";
return(message);
}
if (request.FirstName.Trim().Length < 1 || request.FirstName.Trim().Length > 20)
{
message.Response = "Failed";
message.Message = "Invalid first name";
return(message);
}
if (request.LastName.Trim().Length < 1 || request.LastName.Trim().Length > 20)
{
message.Response = "Failed";
message.Message = "Invalid last name";
return(message);
}
if (request.Phone.Trim().Length != 11)
{
message.Response = "Failed";
message.Message = "Invalid phone number";
return(message);
}
if (request.Sandbox_Key.Trim().Length < 1)
{
message.Response = "Failed";
message.Message = "Invalid sandbox key";
return(message);
}
Enrollees enrollee = new Enrollees();
if (enrollee.get_enrollees($" where email = '{request.Email}'").Count == 1)
{
message.Response = "Failed";
message.Message = "Enrollee data already exists";
return(message);
}
//the paramters receveied are not being used because the sandbox expects hard code data
string Referral_code = "1122345";
Enrollee[] enrollees = new Enrollee[2];
enrollees[0] = new Enrollee();
enrollees[1] = new Enrollee();
enrollees[0].payment_frequency = "monthly";
enrollees[0].first_name = "John";
enrollees[0].last_name = "Doe";
enrollees[0].email_address = "*****@*****.**";
enrollees[0].phone_number = "08132646940";
enrollees[0].plan_id = 22;
enrollees[0].can_complete_profile = true;
enrollees[0].dependants = new Dependant[2];
enrollees[0].dependants[0] = new Dependant();
enrollees[0].dependants[1] = new Dependant();
enrollees[0].dependants[0].first_name = "Janet";
enrollees[0].dependants[0].last_name = "Dependant";
enrollees[0].dependants[0].email_address = "*****@*****.**";
enrollees[0].dependants[0].phone_number = "08132646940";
enrollees[0].dependants[0].plan_id = 22;
enrollees[0].dependants[1].first_name = "Fred";
enrollees[0].dependants[1].last_name = "Dependant";
enrollees[0].dependants[1].email_address = "*****@*****.**";
enrollees[0].dependants[1].phone_number = "08132646940";
enrollees[0].dependants[1].plan_id = 24;
enrollees[1].payment_frequency = "q";
enrollees[1].first_name = "Ben";
enrollees[1].last_name = "Stiller";
enrollees[1].email_address = "*****@*****.**";
enrollees[1].phone_number = "08132646940";
enrollees[1].plan_id = 24;
enrollees[1].can_complete_profile = false;
var enrollement = new { Referral_code = Referral_code, enrollees = enrollees };
var json = JsonConvert.SerializeObject(enrollement, Formatting.Indented);
var request22 = (HttpWebRequest)WebRequest.Create("https://sandboxapi.fsi.ng/relianceHMO/retail/signup");
var postData = json.Replace("null", "[]");
var data1 = Encoding.ASCII.GetBytes(postData);
request22.Method = "POST";
request22.Headers.Add("Sandbox-Key", request.Sandbox_Key);
request22.ContentType = "application/json";
request22.ContentLength = data1.Length;
var responseString = "";
var result = "";
using (var streamProcess = request22.GetRequestStream())
{
streamProcess.Write(data1, 0, data1.Length);
}
try
{
var newHttpResponse = (HttpWebResponse)request22.GetResponse();
responseString = new StreamReader(newHttpResponse.GetResponseStream()).ReadToEnd();
dynamic passString = JsonConvert.DeserializeObject <dynamic>(responseString);
result = (string)passString.access_token;
}
catch (Exception d)
{
}
if (responseString.IndexOf("\"message\":\"OK\"") > -1)
{
Enrollees_Table enrolleesData = new Enrollees_Table();
enrolleesData.Email = request.Email;
enrolleesData.First_name = request.FirstName;
enrolleesData.Last_name = request.LastName;
enrolleesData.Phone = request.Phone;
enrollee.add_enrollees(enrolleesData);
}
else
{
message.Response = "Failed";
message.Message = "Enrollment failed";
return(message);
}
message.Response = "Successful";
message.Message = "Enrollee data captured successfully";
return(message);
}
