protected void btnproceed_Click(object sender, EventArgs e)
{
clsuser objj = new clsuser();
objj = null;
String car;
String query = "select * from tblcar where CarName='" + ddlCarName.Text + "'";
try
{
DataSet ds = dbobj.getRecord(query);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
car = dr["Booked"].ToString();
if (car.Equals("NO"))
{
Session["CarNo"] = dr["CarNo"].ToString();
Session["HrlyRate"] = dr["HrlyRate"].ToString();
Session["MinHrs"] = dr["MinHrs"].ToString();
Response.Redirect("BookingCar.aspx");
}
}
lblmsg.Text = "Sorry,Car Is Not Available..Try Booking Another Car";
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
clsuser obj = new clsuser();
String s = "", s1 = "", query;
try
{
obj.Email = txtEmail.Text;
s = txtPass.Text;
s1 = "";
int l = s.Length;
for (int i = l - 1; i >= 0; i--)
{
if (i > 0)
{
s1 = s1 + (int)s[i] + "?";
}
else
{
s1 = s1 + (int)s[i];
}
}
obj.Password = s1;
query = "select * from tbluserrecord where Email='" + obj.Email + "' and Password='******'";
DataSet ds = obj.GetDetailsbyEmail(query);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 1)
{
foreach (DataRow dr in dt.Rows)
{
Session["Name"] = dr["Name"].ToString();
Session["Mobile"] = dr["Mobile"].ToString();
}
Session["Email"] = obj.Email;
Session["Password"] = obj.Password;
Response.Redirect("UserHomePage.aspx");
}
else
{
lblmsg.Text = "Invalid Email or Password";
}
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
private void populateGridview()
{
clsuser objreg = new clsuser();
try
{
DataSet ds = objreg.GetDetails();
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int rowupdate = e.RowIndex;
String emailid = (String)GridView1.Rows[rowupdate].Cells[4].Text;
clsuser objreg = new clsuser();
try
{
objreg.Delete(emailid);
GridView1.EditIndex = -1;
populateGridview();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
private void populateGridview()
{
clsuser objreg = new clsuser();
try
{
DataSet ds = objreg.GetDetails();
// set the datasourec of the Gridview to
//dataset table
GridView1.DataSource = ds.Tables[0];
//call the databind method
GridView1.DataBind();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
clsuser obj = new clsuser();
String s = txtPass.Text;
String s1 = "", query = "";
int l = s.Length;
try
{
obj.Email = txtEmail.Text;
for (int i = l - 1; i >= 0; i--)
{
if (i > 0)
{
s1 = s1 + (int)s[i] + "?";
}
else
{
s1 = s1 + (int)s[i];
}
}
obj.Password = s1;
query = "select * from tbladmin where AdminEmail='" + obj.Email + "' and AdminPassword='******'";
DataSet ds = obj.GetDetailsbyEmail(query);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 1)
{
Session["AdminEmail"] = txtEmail.Text;
Response.Redirect("HomePageAdmin.aspx");
}
else
{
lblmsg.Text = "Invalid Email ID or Password";
}
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
int rowupdate = e.RowIndex;
TextBox txtname = (TextBox)GridView1.Rows[rowupdate].Cells[1].Controls[0];
TextBox txtaddress = (TextBox)GridView1.Rows[rowupdate].Cells[2].Controls[0];
TextBox txtmobile = (TextBox)GridView1.Rows[rowupdate].Cells[3].Controls[0];
String email = (String)GridView1.Rows[rowupdate].Cells[4].Text;
// String password = (String)GridView1.Rows[rowupdate].Cells[5].Text;
String query = "update tbluserrecord set Name='" + txtname.Text + "',Address='" + txtaddress.Text + "',Mobile='" + txtmobile.Text + "' where Email='" + email + "'";
clsuser objreg = new clsuser();
objreg.Update(query, email);
//remove the edit mode
GridView1.EditIndex = -1;
populateGridview();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
