void send()
{
OpenClass p = new OpenClass();
p.testifavailable("SELECT *FROM System_Users where National_ID='" + TextBox5.Text + "'");
if (p.res)
{
var random = new Random();
int randomnumber = random.Next(9999);
string message = "Fuela password verification code:" + randomnumber;
Session.Add("Random", randomnumber);
p.SendMessage(Session["TwilioPhone"].ToString(), p.phone, Session["TwilioSid"].ToString(), Session["Auth"].ToString(), message);
verify = true;
p.seting();
sent();
Session.Add("User", TextBox5.Text);
p.ClearInputs(Page.Controls);
}
else if (!p.res)
{
p.testifavailable("SELECT *FROM Agents_Reg WHERE National_ID='" + TextBox5.Text + "'");
if (p.res)
{
var random = new Random();
int randomnumber = random.Next(9999);
string message = "Fuela password verification code:" + randomnumber;
Session.Add("Random", randomnumber);
p.SendMessage(Session["TwilioPhone"].ToString(), p.phone, Session["TwilioSid"].ToString(), Session["Auth"].ToString(), message);
sent();
Session.Add("User", TextBox5.Text);
p.seting();
}
else
{
Session.Add("check", "2");
Label2.Text = "ID not found!! Please check and try again!";
}
}
else
{
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
//Session.Add("M_ID", TextBox1.Text);
//Session.Add("M_Fname", TextBox1.Text);
//Session.Add("M_Fname", TextBox1.Text);
//Session.Add("M_ID", TextBox1.Text);
//Session.Add("M_Fname", TextBox1.Text);
//Session.Add("M_Fname", TextBox1.Text);
//Session.Add("M_Fname", TextBox1.Text);
//Session.Add("M_Fname", TextBox1.Text);
auth.login("Select *from System_Users where National_ID='" + TextBox1.Text + "' or Username='******'");
OpenClass p = new OpenClass();
if (auth.log)
{
Label2.Text = "Error! A User with this ID or Username exist!";
}
else
{
Session.Add("M_ID", TextBox1.Text);
p.inserting("Insert into System_Users(National_ID,Full_names,Username,Password,Location,Phone,Role) VALUES('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + p.Add254(TextBox7.Text) + "','1')");
//LETS GET TWILIO CREDENTIALS
string str = ConfigurationManager.ConnectionStrings["Fuel_systemConnectionString"].ToString();
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("select *from Twilio_config", con);
con.Open();
SqlDataReader myDataReadert = cmd.ExecuteReader();
if (myDataReadert.Read())
{
string message1 = "You have been registered with Fuela as Fuel station manager. \n";
string message2 = "Your Username is:YOUR NATIONAL ID";
string message3 = "Password is:";
string message4 = "Please use the credentials above to log in.Call:0712035642 for queries.";
OpenClass send = new OpenClass();
send.SendMessage(myDataReadert["Twilio_phone"].ToString(), p.Add254(TextBox7.Text), myDataReadert["Twilio_SID"].ToString(), myDataReadert["Twilio_Auth"].ToString(), "Hae " + TextBox2.Text + message1 + "," + message2 + "','" + message3 + TextBox4.Text + "." + message4);
con.Close();
}
else
{
con.Close();
}
Response.Redirect("../Agents/Station_reg.aspx");
p.ClearInputs(Page.Controls);
Label2.Text = "Records submitted successfully!";
}
}