protected void LinkButton2_Click(object sender, EventArgs e)
{
Auth p = new Auth();
auth.login("Select *from Agents_Reg where National_ID='" + TextBox1.Text + "' or Username='******'");
if (auth.log)
{
Label2.Text = "Error! The user with above ID or Username already exist!.";
}
else
{
OpenClass.inserting("Insert into Agents_Reg(Station_ref,National_ID,Full_names,Username,Password,Location,Phone,Role) VALUES('" + DropDownList1.SelectedItem.Value + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox7.Text + "','2')");
TextBox4.Text = "12345678";
Label2.Text = "Submitted successfully!";
//SEND MESSAGE
string message1 = "Hae " + TextBox2.Text + " ,Your have been registered as an fuel sales agent at " + TextBox5.Text + " fuel Station.\n";
message1 += "Your username is:YOUR NATIONAL ID";
message1 += " and your password is: " + TextBox4.Text;
message1 += ".\nPlease use above credentials to log in every evening at 5:00pm and submit meter readings to the manager.You will be directed to set new strong password.\n Call 0712035642 for assistance.";
OpenClass send = new OpenClass();
string Phone = TextBox7.Text;
p.SendMessage(p.Add254(Phone), message1);
OpenClass.ClearInputs(Page.Controls);
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
OpenClass OpenClass = new OpenClass();
OpenClass.AddToSession("ID", TextBox2.Text);
OpenClass.AddToSession("Reff", TextBox1.Text);
if (OpenClass.CheckIfReffExist(TextBox1.Text))
{
OpenClass.inserting("Insert into Station_registration(Station_ref,National_ID,Station_name,Location) VALUES('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox5.Text + "')");
OpenClass.ClearInputs(Page.Controls);
Response.Redirect("../Agents/Station_reg.aspx");
Label3.Text = "Data inserted successfully!";
}
else
{
OpenClass.inserting("Insert into Station_registration(Station_ref,National_ID,Station_name,Location) VALUES('" + Session["Reff"] + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox5.Text + "')");
OpenClass.ClearInputs(Page.Controls);
Label3.Text = "Data inserted successfully!";
}
}
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!";
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Administrations Admin = new Administrations();
Admin.Login("SELECT *FROM System_Users WHere National_ID=@Username and Password=@Password", TextBox5.Text, TextBox1.Text);
if (Admin.test)
{
if (TextBox1.Text == "12345678")
{
Session.Add("User", TextBox5.Text);
Response.Redirect("../Agents/Set_new_password.aspx");
}
else if (TextBox1.Text == "12345")
{
Response.Redirect("../Agents/Agents_Dashboard.aspx");
}
else
{
Response.Redirect("../Agents/Petrol_station_selection.aspx");
}
}
else
{
Admin.LoginaAgents("SELECT *FROM Agents_Reg WHere National_ID=@Username and Password=@Password", TextBox5.Text, TextBox1.Text);
if (Admin.test)
{
if (TextBox1.Text == "12345678")
{
Session.Add("User", TextBox5.Text);
Response.Redirect("../Agents/Set_new_password.aspx");
}
else if (TextBox1.Text == "12345")
{
Response.Redirect("../Agents/Agents_Dashboard.aspx");
}
else
{
Response.Redirect("../Agents/Agents_Dashboard.aspx");
}
}
else
{
OpenClass Clear = new OpenClass();
Clear.ClearInputs(Page.Controls);
Label4.Text = "Invalid credentials";
}
}
}
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
{
}
}
