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