protected void LinkButton4_Click(object sender, EventArgs e) { if (TextBox1.Text == TextBox5.Text) { OpenClass update = new OpenClass(); update.inserting("UPDATE System_Users SET password='******' WHERE National_ID='" + Session["User"] + "'"); update.inserting("UPDATE Agents_Reg SET password='******' WHERE National_ID='" + Session["User"] + "'"); Session.Clear(); Response.Redirect("../Agents/Log_in.aspx"); } else { Label2.Text = "The password do not match"; } }
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 insertdetails(object sender, EventArgs e) { string str = ConfigurationManager.ConnectionStrings["Fuel_systemConnectionString"].ToString(); SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand("SELECT *FROM Fuel WHERE Station_ref='" + DropDownList1.SelectedItem.Value + "' AND Fuel_ref='" + DropDownList2.SelectedItem.Value + "'", con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { response.Text = "You already submitted this record please confirm"; con.Close(); } else { con.Close(); OpenClass p = new OpenClass(); Random random = new Random(); int rand = random.Next(100000, 999999); p.inserting("INSERT INTO Fuel(Station_ref,Fuel_ref,Tank_capacity,Current_capacity,Price_itre) VALUES('" + DropDownList1.SelectedItem.Value + "','" + DropDownList2.SelectedItem.Value + "','" + TextBox4.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "')"); Session["firepopup"] = null; response.Text = "Submitted successfully!"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "final()", true); } Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "final() ", true); }
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!"; } }