protected void Button2_Click(object sender, EventArgs e) { Vehicle_Info v_inf = new Vehicle_Info(); Vehicle_Sp v_sp = new Vehicle_Sp(); Memb_Info info = new Memb_Info(); Memb_Sp sp = new Memb_Sp(); v_inf.Bus_Reg_No = txtvehicle.Text.ToLower(); if (v_sp.CompareBusRegNo(v_inf.Bus_Reg_No) != 0) { Vehicle_Info nv_inf = new Vehicle_Info(); nv_inf = v_sp.ViewVehicleThroughBusRegNo(v_inf.Bus_Reg_No); int sds = nv_inf.Own_No; Memb_Info ninfo = new Memb_Info(); ninfo = sp.ViewMember(sds); lbname.Text = ninfo.MemberName; lbage.Text = ninfo.Age.ToString(); lbadd.Text = ninfo.Address; lbemail.Text = ninfo.E_Mail; lbphno.Text = ninfo.Mobile; lbnob.Text = ninfo.Nob.ToString(); String path = Server.MapPath("~/Photos/Owners/"); Image1.ImageUrl = path + ninfo.Phot; MultiView1.SetActiveView(View2); } else { Label14.Visible = true; } }
protected void Button2_Click(object sender, EventArgs e) { lbusrex.Visible = false; int t1 = 0; Memb_Info info = new Memb_Info(); Memb_Sp sp = new Memb_Sp(); t1 = int.Parse(DropDownList1.SelectedValue.ToString()); info.Usrname = Txtusrname.Text; info.Password = Txtpw.Text; info.MemberName = ""; info.Age = 0; info.Type = t1; info.Address = ""; info.E_Mail = ""; info.Mobile = ""; info.Nob = 0; info.Phot = ""; //info.Type = t1; if (sp.Compareusername(info.Usrname) == 0) { sp.Add(info); Txtusrname.Text = ""; Response.Redirect("admin_home.aspx"); } else { lbusrex.Text = "UserName Exists!!"; lbusrex.Visible = true; } }
public Memb_Info logcheck_1(string send_usrname) { con.Open(); SqlCommand cmd = new SqlCommand("LogCheck_Authorisation", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p = new SqlParameter(); p = cmd.Parameters.Add("@username", SqlDbType.VarChar); p.Value = send_usrname; SqlDataReader read = cmd.ExecuteReader(); Memb_Info inf = new Memb_Info(); read.Read(); if (read.HasRows) { inf.Password = read["password"].ToString(); inf.Authorised = int.Parse(read["authorised"].ToString()); inf.Type = int.Parse(read["type"].ToString()); inf.MemberName = read["nam"].ToString(); } else { //since no data in dbase inf.Authorised = 1000;// reurn these values to show // invalid entry,(may be any string,int,int ) } read.Close(); con.Close(); return(inf); }
public Memb_Info ViewMember(int no) { con.Close(); con.Open(); SqlCommand cmd = new SqlCommand("ViewMember", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p = new SqlParameter(); p = cmd.Parameters.Add("@no", SqlDbType.VarChar, 50); p.Value = no; SqlDataReader read = cmd.ExecuteReader(); Memb_Info info = new Memb_Info(); if (read.Read()) { info.No = int.Parse(read["no"].ToString()); info.MemberName = read["nam"].ToString(); info.Age = int.Parse(read["age"].ToString()); info.Address = read["address"].ToString(); info.Password = read["password"].ToString(); info.E_Mail = read["e_mail"].ToString(); info.Mobile = read["mobile"].ToString(); info.Nob = int.Parse(read["nob"].ToString()); info.Phot = read["phot"].ToString(); info.Usrname = read["usrname"].ToString(); } read.Close(); con.Close(); return(info); }
protected void Button1_Click(object sender, EventArgs e) { Memb_Info inf = new Memb_Info(); Memb_Sp sp1 = new Memb_Sp(); int xx = int.Parse(GridView2.SelectedDataKey.Value.ToString()); sp1.Update1(xx); inf = sp1.ViewMember(xx); Session["username"] = inf.Usrname; Session["own_name"] = inf.MemberName; Response.Redirect("admin_vehicle_info.aspx"); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { Memb_Sp sp = new Memb_Sp(); Memb_Info info = sp.ViewMember(int.Parse(GridView1.SelectedValue.ToString())); lbname.Text = info.MemberName; lbage.Text = info.Age.ToString(); lbadd.Text = info.Address; lbemail.Text = info.E_Mail; lbphno.Text = info.Mobile; lbnob.Text = info.Nob.ToString(); String path = Server.MapPath("~/Photos/Owners/"); Image1.ImageUrl = path + info.Phot; MultiView1.SetActiveView(View2); }
public void Update(Memb_Info inf)//FOR REGISTRATION { con.Open(); SqlCommand cmd = new SqlCommand("UpdateMember", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p = new SqlParameter(); p = cmd.Parameters.Add("@no", SqlDbType.Int); p.Value = inf.No; p = cmd.Parameters.Add("@name", SqlDbType.VarChar, 50); p.Value = inf.MemberName; p = cmd.Parameters.Add("@age", SqlDbType.Int); p.Value = inf.Age; p = cmd.Parameters.Add("@password", SqlDbType.VarChar, 50); p.Value = inf.Password; p = cmd.Parameters.Add("@address", SqlDbType.VarChar); p.Value = inf.Address; p = cmd.Parameters.Add("@e_mail", SqlDbType.VarChar, 50); p.Value = inf.E_Mail; p = cmd.Parameters.Add("@mobile", SqlDbType.VarChar, 50); p.Value = inf.Mobile; p = cmd.Parameters.Add("@nob", SqlDbType.Int); p.Value = inf.Nob; p = cmd.Parameters.Add("@type", SqlDbType.Int); p.Value = inf.Type; p = cmd.Parameters.Add("@authorised", SqlDbType.Int); p.Value = inf.Authorised; p = cmd.Parameters.Add("@phot", SqlDbType.VarChar, 50); p.Value = inf.Phot; p = cmd.Parameters.Add("@usrname", SqlDbType.VarChar, 50); p.Value = inf.Usrname; cmd.ExecuteNonQuery(); con.Close(); }
public void change_pw(Memb_Info info) { con.Open(); SqlCommand cmd = new SqlCommand("UpdatePassword", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p = new SqlParameter(); p = cmd.Parameters.Add("@usrname", SqlDbType.VarChar, 50); p.Value = info.Usrname; p = cmd.Parameters.Add("@password", SqlDbType.VarChar, 50); p.Value = info.Password; cmd.ExecuteNonQuery(); con.Close(); }
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e) { //Memb_Info info = new Memb_Info(); //Memb_Sp sp = new Memb_Sp(); //sp.ViewAllMembers(); // Memb_Info info = new Memb_Info(); Memb_Sp sp = new Memb_Sp(); //sp.ViewAllData(); Memb_Info info = sp.ViewMember(int.Parse(GridView2.SelectedValue.ToString())); txtage.Text = info.Age.ToString(); txtname.Text = info.MemberName; txtaddress.Text = info.Address; txtnob.Text = info.Nob.ToString(); txtmobile.Text = info.Mobile; String path = Server.MapPath("~/Photos/Owners/"); Image1.ImageUrl = path + info.Phot; MultiView1.SetActiveView(View2); }
protected void Button1_Click(object sender, EventArgs e) { Memb_Info info = new Memb_Info(); Memb_Sp sp = new Memb_Sp(); info.Usrname = Session["username"].ToString(); info.Password = txtpw.Text; Memb_Info inf_return = new Memb_Info(); inf_return = sp.logcheck_1(info.Usrname); //checks,is there any user as per given datas // if (inf_return.Authorised == 1000) //if so retuns his authorisation status. // { // Label5.Text = "ACCESS DENIED"; // Label5.Visible = true; // } // else //{ if (inf_return.Password == info.Password) { if (txtvnewpw.Text == txtnewpw.Text) { info.Password = txtnewpw.Text; sp.change_pw(info); } else { Label5.Visible = true; } } else { Label5.Text = "INVALID PASSWORD/USER NAME"; } //} }
protected void Button1_Click(object sender, EventArgs e) { int verify = 2; // entry "2" in authorisation field represents an verified/authorised member. string dest = ""; bool flag = true; Memb_Info info = new Memb_Info(); Memb_Sp sp = new Memb_Sp(); string imagepath = ""; Boolean fileOK = false; String path = Server.MapPath("~/Photos/Owners/"); if (FileUpload1.HasFile) { String fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower(); String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" }; for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i]) { fileOK = true; } } } if (fileOK) { try { imagepath = path + FileUpload1.FileName; FileUpload1.PostedFile.SaveAs(imagepath); FileInfo f = new FileInfo(imagepath); dest = new Memb_Sp().GetMaxCode() + "." + f.Name.Split('.')[1]; info.MemberName = txtuname.Text; info.Age = int.Parse(txtage.Text); info.Password = txtpw.Text; info.Address = txtadd.Text; info.E_Mail = txtemid.Text; info.Mobile = txtmob.Text; info.Nob = int.Parse(txtnob.Text); info.Usrname = txtusrname.Text; if (sp.Compareusername(info.Usrname) != 0) { flag = false; } if (RadioButton1.Checked) { info.Authorised = verify; } if (flag == true) { f.CopyTo(path + dest); info.Phot = dest; sp.Add(info); txtusrname.Text = ""; txtuname.Text = ""; txtage.Text = ""; txtpw.Text = ""; txtvpw.Text = ""; txtadd.Text = ""; txtemid.Text = ""; txtmob.Text = ""; txtnob.Text = ""; RadioButton3.Checked = true; lbfile.Visible = false; lbusrname1.Visible = false; if (RadioButton1.Checked) { Session["username"] = info.Usrname; //for reference to vehicle details entry Session["own_name"] = info.MemberName; //-do- Response.Redirect("admin_vehicle_info.aspx"); } } else { lbusrname1.Text = "user name exists.!!"; lbusrname1.Visible = true; } f = new FileInfo(imagepath); f.Delete(); } catch (Exception ex) { lbfile.Text = "File could not be uploaded."; lbfile.Visible = true; } } else { lbfile.Text = "Cannot accept files of this type."; lbfile.Visible = true; } }
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { Memb_Info info = new Memb_Info(); Memb_Sp sp = new Memb_Sp(); info.Usrname = Login1.UserName; info.Password = Login1.Password; Memb_Info inf_return = new Memb_Info(); inf_return = sp.logcheck_1(info.Usrname); //checks,is there any user as per given datas if (inf_return.Authorised == 1000) //if so retuns his authorisation status. { lbunexpcted.Text = "ACCESS DENIED"; lbunexpcted.Visible = true; } else { if (inf_return.Password == info.Password) { if (inf_return.Authorised == 2) { Session["username"] = Login1.UserName; bool flag = true; string type_of_user = ""; switch (inf_return.Type) { case 0: { Response.Redirect("owners_home.aspx"); //string UserName = (string)(Session["usrname"]); //string Password = (string)(Session["First"]); break; } case 1: { //type_of_user = "******";//redirect Response.Redirect("admin_home.aspx"); break; } case 2: { //type_of_user = "******"; Session["username"] = Login1.UserName; //Punch_Station_Sp psp = new Punch_Station_Sp(); //Punch_Station_Info pinfo= psp.View_PunchStation(Login1.UserName); //Session["towards"] = pinfo.Towards; //Punch_Distance_Sp pdp = new Punch_Distance_Sp(); //Punch_Distence_Info pdinfo = pdp.View_PunchDistance(pinfo.Punch_Id); //Session["distance"] = pdinfo.Distance; Response.Redirect("punch_bus_station.aspx"); //redirect break; } case 3: { Session["username"] = Login1.UserName; Punch_Station_Sp psp = new Punch_Station_Sp(); Punch_Station_Info pinfo = psp.View_PunchStation(Login1.UserName); Session["towards"] = pinfo.Towards; //Punch_Distance_Sp pdp = new Punch_Distance_Sp(); //Punch_Distence_Info pdinfo = pdp.View_PunchDistance(pinfo.Punch_Id); Session["distance"] = pinfo.Distance; Response.Redirect("Punching.aspx"); //redirect break; } case 4: { //type_of_user = "******"; Response.Redirect("rto_home.aspx"); //redirect break; } default: { lbunexpcted.Text = "ACCESS DENIED"; lbunexpcted.Visible = true; flag = false; break; } } } else { lbunexpcted.Text = "Hi " + inf_return.MemberName + ",u r still unauthorised ,waite untill we conform ur membership. "; lbunexpcted.Visible = true; } } else { lbunexpcted.Text = "ACCESS DENIED"; lbunexpcted.Visible = true; } } }
protected void Button1_Click(object sender, EventArgs e) { string dest = ""; bool flag = true; Memb_Info info = new Memb_Info(); Memb_Sp sp = new Memb_Sp(); info.MemberName = txtuname.Text; info.Age = int.Parse(txtage.Text); info.Password = txtpw.Text; info.Address = txtadd.Text; info.E_Mail = txtemid.Text; info.Mobile = txtmob.Text; info.Nob = int.Parse(txtnob.Text); info.Usrname = txtusrname.Text; if (sp.Compareusername(info.Usrname) != 0) { flag = false; } string imagepath = ""; Boolean fileOK = false; String path = Server.MapPath("~/Photos/Owners/"); if (FileUpload1.HasFile) { String fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower(); String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" }; for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i]) { fileOK = true; } } } if (fileOK) { try { imagepath = path + FileUpload1.FileName; FileUpload1.PostedFile.SaveAs(imagepath); FileInfo f = new FileInfo(imagepath); dest = new Memb_Sp().GetMaxCode() + "." + f.Name.Split('.')[1]; if (flag == true) { f.CopyTo(path + dest); info.Phot = dest; sp.Add(info); txtuname.Text = ""; txtage.Text = ""; txtpw.Text = ""; txtvpw.Text = ""; txtadd.Text = ""; txtemid.Text = ""; txtmob.Text = ""; txtnob.Text = ""; txtusrname.Text = ""; int id = (sp.GetMaxCode() - 1); Memb_Info inf = new Memb_Info(); inf = sp.ViewMember(id); lbid.Text = inf.No.ToString(); lbusrname2.Text = inf.Usrname; lbhiname.Text = inf.MemberName; MultiView1.SetActiveView(View2); } else { lbusrname1.Text = "usrer name exists!!."; lbusrname1.Visible = true; } f = new FileInfo(imagepath); f.Delete(); } catch (Exception ex) { lbfile.Text = "File could not be uploaded!!."; lbfile.Visible = true; } } else { lbfile.Text = "Cannot accept files of this type!!."; lbfile.Visible = true; } }