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!"; } }