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 List <Enrollees_Table> get_enrollees(string sql)
{
var actual = new List <Enrollees_Table>();
DataTable dt = HealthPlanSignUps.fetchData("select id , email , first_name , last_name , phone from enrollees" + sql);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
actual = (from rw in dt.AsEnumerable()
select new Enrollees_Table()
{
Id = Convert.ToInt64(rw["id"]),
Email = rw["email"].ToString(),
First_name = rw["first_name"].ToString(),
Last_name = rw["last_name"].ToString(),
Phone = rw["phone"].ToString()
}).ToList();
}
}
return(actual);
}
