protected void Page_Load(object sender, EventArgs e)
{
if (Session["role"].ToString() != "Admin")
{
string s = "Access denied";
Response.Redirect("login.aspx" + s);
}
carrentalEntities db = new carrentalEntities();
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT b.cid,b.rating,b.fid,b.carno FROM feedback AS b", con);
// cmd.Parameters.AddWithValue("@dnow", DateTime.Now);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
GridView1.DataSource = dt;
GridView1.DataBind();
Label1.Visible = false;
TextBox1.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["role"].ToString() != "DeliveryPerson")
{
string s = "Access denied";
Response.Redirect("login.aspx" + s);
}
carrentalEntities db = new carrentalEntities();
string mail = Session["loginid"].ToString();
chauffer cc = db.chauffers.Where(x => x.email == mail).FirstOrDefault <chauffer>();
int driverid = cc.did;
booking bb = db.bookings.Where(x => x.did == driverid).FirstOrDefault <booking>();
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT b.bookingid,b.cid,b.startdate,b.enddate FROM booking AS b where (b.startdate>=@dnow) AND b.did=" + driverid + "", con);
cmd.Parameters.AddWithValue("@dnow", DateTime.Now);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["role"].ToString() != "Customer")
{
string msg = "Access denied";
Response.Redirect("login.aspx?" + msg);
}
carrentalEntities db = new carrentalEntities();
string mail = Session["loginid"].ToString();
customer cc = db.customers.Where(x => x.email == mail).FirstOrDefault <customer>();
int customerid = cc.cid;
booking bb = db.bookings.Where(x => x.cid == customerid).FirstOrDefault <booking>();
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
con.Open();
SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT b.bookingid,b.carno,b.startdate,b.enddate,b.rentalamount,b.did FROM booking AS b where b.cid=" + customerid + "", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
GridView1.DataSource = dt;
GridView1.DataBind();
address.Visible = false;
addr.Visible = false;
}
private void sendmail(string subject)
{
string sender = (string)Application["sender_email"];
string server = (string)Application["sender_server"];
int owid3 = Int32.Parse(ownid.Text);
carrentalEntities db = new carrentalEntities();
owner oo = db.owners.Where(x => x.oid == owid3).FirstOrDefault <owner>();
string emailid = oo.email;
//Response.Write(emailid);
MailMessage mail = new MailMessage();
mail.From = new MailAddress(sender);
mail.To.Add(new MailAddress(emailid));
mail.Subject = subject;
mail.Body = "Your Car Request has been accepted.Your Carno:" + carno.Text.ToString();
mail.Body += "Offered rentprice:" + rentprice.Text.ToString();
SmtpClient smtp = new SmtpClient(server, 587);
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Credentials = new System.Net.NetworkCredential(sender, "Qtnsqc16");
smtp.Send(mail);
}
protected void Button2_Click(object sender, EventArgs e)
{
Label2.Visible = false;
Label3.Visible = false;
Label4.Visible = false;
Label5.Visible = false;
Label6.Visible = false;
Label7.Visible = false;
Label8.Visible = false;
Label9.Visible = false;
Label10.Visible = false;
int bookingid = Int32.Parse(bid.Text.ToString());
carrentalEntities db = new carrentalEntities();
DateTime dt = Convert.ToDateTime(Label7.Text);
DateTime ct = DateTime.Now;
TimeSpan t = dt.Subtract(ct);
double hr = t.TotalHours;
if (hr > 24)
{
booking b = db.bookings.Where(x => x.bookingid == bookingid).FirstOrDefault <booking>();
var q2 = (from p in db.bookings where p.bookingid == bookingid select p).ToList();
if (q2.Any())
{
foreach (var i in q2.Where(w => w.bookingid == bookingid))
{
i.status = "cancelled";
}
}
string cno = Label6.Text;
DateTime dt1 = Convert.ToDateTime(Label7.Text);
DateTime dt2 = Convert.ToDateTime(Label8.Text);
var s = (from y in db.carstatus
where y.carno == cno && y.startdate == dt1 && y.enddate == dt2
select y).FirstOrDefault();
db.carstatus.Remove(s);
db.SaveChanges();
Response.Redirect("customerprofile.aspx");
Label10.Visible = true;
}
else
{
Label10.Visible = true;
Label10.Text = "Sorry you can't cancel the booking!!!";
string m = "Sorry you can't cancel the booking!!!";
Response.Redirect("timecheck.aspx?" + m);
}
/*string cno = Label6.Text;
* DateTime sd = Convert.ToDateTime(Label7.Text);
* DateTime ed = Convert.ToDateTime(Label8.Text);
* carstatu c = db.carstatus.Where(s => s.carno == cno && s.startdate == sd && s.enddate == ed).FirstOrDefault<carstatu>();
* db.carstatus.Remove(c);
*/
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
carrentalEntities db = new carrentalEntities();
int bookid = Int32.Parse(row.Cells[1].Text);
booking bb = db.bookings.Where(x => x.bookingid == bookid).FirstOrDefault <booking>();
address.Text = bb.address;
address.Visible = true;
addr.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
var db = new carrentalEntities();
IQueryable <Cardetail> query;
query = from i in db.Cardetails
select i;
ListView1.DataSource = query.ToList();
ListView1.DataBind();
}
protected void get_Click(object sender, EventArgs e)
{
string sendr = (string)Application["sender_email"];
string server = (string)Application["sender_server"];
string role = DropDownList1.SelectedItem.Text;
string s = Email.Text.Trim().ToString();
carrentalEntities c = new carrentalEntities();
var k = (from u in c.Logins where u.LoginId == s && u.Role == role select u);
var user = (from u in c.Logins where u.LoginId == s && u.Role == role select u).FirstOrDefault();
foreach (var i in k)
{
pwd = i.Password.ToString();
//unm = i.Username.ToString();
}
if (user == null)
{
//Response.Write("hello");
msg.Text = "User not exist";
msg.Visible = true;
}
else
{
try
{
MailMessage mail = new MailMessage();
mail.From = new MailAddress(sendr);
mail.To.Add(new MailAddress(Email.Text.ToString()));
mail.Subject = "your Login credentials";
mail.Body = "Your LoginId is your email" + " " + "Your Password is:" + pwd;
SmtpClient smtp = new SmtpClient(server, 587);
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Credentials = new System.Net.NetworkCredential(sendr, "Qtnsqc16");
smtp.Send(mail);
Response.Redirect("~/login.aspx?msg=mail+sent");
Response.Write(mail.Body);
}
catch (Exception err)
{
//Response.Write(err);
msg.Text = "Mail not sent try again";
msg.Visible = true;
}
}
}
protected void submit_Click(object sender, EventArgs e)
{
carrentalEntities db = new carrentalEntities();
feedback f = new feedback();
f.carno = cno.Text.ToString();
f.cid = Int32.Parse(cid.Text);
f.rating = DropDownList1.SelectedItem.Text;
f.description = review.Text;
db.feedbacks.Add(f);
db.SaveChanges();
Response.Redirect("customerprofile.aspx");
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
Label1.Visible = true;
TextBox1.Visible = true;
GridViewRow row = GridView1.SelectedRow;
carrentalEntities db = new carrentalEntities();
feedback f = new feedback();
int feedbackid = Int32.Parse(row.Cells[3].Text);
feedback cc = db.feedbacks.Where(x => x.fid == feedbackid).FirstOrDefault <feedback>();
TextBox1.Text = cc.description;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Role"].ToString() != "Admin")
{
string msg = "Access denied";
Response.Redirect("login.aspx" + msg);
}
carrentalEntities db = new carrentalEntities();
string mail = Session["loginid"].ToString();
admin aa = db.admins.Where(x => x.email == mail).FirstOrDefault <admin>();
username_text.Text = aa.firstname;
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
carrentalEntities db = new carrentalEntities();
int customerid = Int32.Parse(row.Cells[2].Text);
customer cc = db.customers.Where(x => x.cid == customerid).FirstOrDefault <customer>();
name.Text = cc.firstname;
email.Text = cc.email;
phone.Text = cc.mobileno;
booking bb = db.bookings.Where(x => x.cid == customerid).FirstOrDefault <booking>();
address.Text = bb.address;
}
protected void Page_Load(object sender, EventArgs e)
{
carrentalEntities db = new carrentalEntities();
var cars = (from u in db.Cardetails
let vehicleid = from x in db.vehicles
select x.vehicleid
select u);
ListBox l1 = new ListBox();
foreach (var i in cars)
{
l1.Items.Add(i.carno);
Response.Write(i.carno + "\n");
}
PlaceHolder1.Controls.Add(l1);
}
private void sendmail(string subject)
{
string sender = (string)Application["sender_email"];
string server = (string)Application["sender_server"];
carrentalEntities db = new carrentalEntities();
MailMessage mail = new MailMessage();
mail.From = new MailAddress(sender);
mail.To.Add(new MailAddress(email.Text));
mail.Subject = subject;
mail.Body = "Your loginid is your email and your password is:" + pwd.Text;
SmtpClient smtp = new SmtpClient(server, 587);
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Credentials = new System.Net.NetworkCredential(sender, "Qtnsqc16");
smtp.Send(mail);
}
protected void add_Click(object sender, EventArgs e)
{
carrentalEntities db = new carrentalEntities();
chauffer c = new chauffer();
Login l = new Login();
pass = GetStr();
Session["pwd"] = pass.ToString();
c.firstname = firstname.Text;
c.lastname = lastname.Text;
c.licenseno = licenceno.Text;
c.address = address.Text;
c.salary = Int32.Parse(salry.Text);
c.email = email.Text;
c.phone = mobileno.Text;
string r = "DeliveryPerson";
l.Role = r;
l.LoginId = email.Text;
l.Password = pass;
db.Logins.Add(l);
db.chauffers.Add(c);
//db.SaveChanges();
try
{
int n = db.SaveChanges();
sendmail("Successfully registered");
msg.Text = "Successfully registered";
msg.ForeColor = System.Drawing.Color.Green;
}
catch (Exception err)
{
//msg.Text = "Some Error Occured";
// msg.ForeColor = System.Drawing.Color.Red;
Response.Write(err);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["role"].ToString() != "Customer")
{
string msg = "Access denied";
Response.Redirect("login.aspx?" + msg);
}
string s = Session["loginid"].ToString();
carrentalEntities db = new carrentalEntities();
var c = from x in db.customers where x.email == s select x;
foreach (var x in c)
{
cid.Text = x.cid.ToString();
}
int i = Int32.Parse(cid.Text);
var d = from x in db.bookings where x.cid == i select x;
foreach (var x in d)
{
cno.Text = x.carno.ToString();
}
}
protected void button1_Click(object sender, EventArgs e)
{
carrentalEntities db = new carrentalEntities();
offer o = new offer();
o.promocode = promo.Text;
o.description = desc.Text;
o.isonetime = Int32.Parse(ison.SelectedItem.Value);
o.ofbased = ofbase.SelectedItem.Text;
if (ofbase.SelectedItem.Text == "Percentage")
{
o.discountpercent = Int32.Parse(per.Text);
o.discountamount = 0;
}
else if (ofbase.SelectedItem.Text == "Amount")
{
o.discountamount = Int32.Parse(amt.Text);
o.discountpercent = 0;
}
db.offers.Add(o);
db.SaveChanges();
msg.Text = "offer added successfuly";
}
protected void get_Click(object sender, EventArgs e)
{
carrentalEntities db = new carrentalEntities();
Login l = new Login();
string pwd1 = pwd.Text;
string pwd2 = cpwd.Text;
string role = Session["role"].ToString();
string loginid = Session["loginid"].ToString();
var user = (from u in db.Logins where u.LoginId == loginid && u.Role == role select u).FirstOrDefault();
if (pwd1 != pwd2)
{
// Response.Redirect("~/changepassword.aspx?msg=password+not+matched");
msg.Text = "Password not matched";
msg.ForeColor = System.Drawing.Color.Red;
}
else
{
user.Password = cpwd.Text;
db.SaveChanges();
msg.Text = "Password changed successfully";
msg.ForeColor = System.Drawing.Color.Green;
}
}
protected void add_Click(object sender, EventArgs e)
{
carrentalEntities db = new carrentalEntities();
string role = DropDownList1.SelectedItem.Text;
customer c = new customer();
string fname = firstname.Text;
string lname = lastname.Text;
string mno = (mobileno.Text);
string mail = email.Text;
string license = licenceno.Text;
string add = address.Text;
if (DropDownList1.SelectedItem.Text == "Customer")
{
//Login l = new Login();
var already = from x in db.Logins
where x.LoginId == email.Text && x.Role == role
select x;
int count = 0;
foreach (var a in already)
{
count++;
}
if (count > 0)
{
msg.Text = "You Have Already Registered, Please Login!!";
msg.ForeColor = System.Drawing.Color.Red;
return;
}
else
{
Login l = new Login();
l.Role = DropDownList1.SelectedItem.Text.ToString();
l.LoginId = email.Text.ToString();
l.Password = pwd.Text;
c.email = email.Text;
c.firstname = fname;
c.lastname = lname;
c.licenceno = license;
c.address = add;
c.mobileno = mno;
db.customers.Add(c);
db.Logins.Add(l);
try
{
int n = db.SaveChanges();
sendmail("Successfully registered");
msg.Text = "Successfully registered";
msg.ForeColor = System.Drawing.Color.Green;
}
catch (Exception err)
{
msg.Text = "Some Error Occured";
msg.ForeColor = System.Drawing.Color.Red;
}
}
}
else if (DropDownList1.SelectedItem.Text == "Owner")
{
var already = from x in db.Logins
where x.LoginId == email.Text && x.Role == role
select x;
int count = 0;
foreach (var a in already)
{
count++;
}
if (count > 0)
{
msg.Text = "You Have Already Registered, Please Login!!";
msg.ForeColor = System.Drawing.Color.Red;
}
else
{
Login p = new Login();
owner o = new owner();
p.Role = DropDownList1.SelectedItem.Text.ToString();
p.LoginId = email.Text.ToString();
p.Password = pwd.Text;
o.email = email.Text;
o.firstname = fname;
o.lastname = lname;
o.address = add;
o.phone = mno;
db.owners.Add(o);
db.Logins.Add(p);
}
try
{
int k = db.SaveChanges();
sendmail("Successfully registered");
msg.Text = "Successfully registered";
msg.ForeColor = System.Drawing.Color.Green;
}
catch (Exception err)
{
msg.Text = "Some Error Occured";
msg.ForeColor = System.Drawing.Color.Red;
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
carrentalEntities db = new carrentalEntities();
int id = Int32.Parse(bookingid.Text);
DateTime actenddate = DateTime.Now;
// Session["pay"] = t.ToString();
carno = Label3.Text;
booking b = new booking();
TimeSpan ts = actenddate.Subtract(enddate);
double hr = ts.TotalHours;
var vid = from p in db.cardatas where p.carno == carno select p;
int vehicle = 0;
if (vid.Any())
{
foreach (var y in vid)
{
vehicle = y.vehicleid;
}
}
var rent = from z in db.vehicles where z.vehicleid == vehicle select z;
int renthr = 0;
if (rent.Any())
{
foreach (var y in rent)
{
renthr = y.priceperday;
}
}
// total = renthr * hr * 1.05;
// int t = (int)total;
var q2 = (from p in db.bookings where p.bookingid == id select p).ToList();
if (q2.Any())
{
foreach (var i in q2.Where(w => w.bookingid == id))
{
i.status = "returned";
i.actualenddate = actenddate;
i.penaltyamount = Int32.Parse(Label7.Text);
}
}
string cno = Label3.Text.ToString();
DateTime dt1 = Convert.ToDateTime(Label4.Text.ToString());
DateTime dt2 = Convert.ToDateTime(Label5.Text.ToString());
var x = (from y in db.carstatus where y.carno == cno && y.startdate == dt1 && y.enddate == dt2
select y).FirstOrDefault();
db.carstatus.Remove(x);
db.SaveChanges();
string msg = "car returned successfully!!";
Response.Redirect("chaufferprofile.aspx?" + msg);
}
protected void Button1_Click(object sender, EventArgs e)
{
Label2.Visible = true;
Label3.Visible = true;
Label4.Visible = true;
Label5.Visible = true;
Label6.Visible = true;
Label7.Visible = true;
Label8.Visible = true;
Label9.Visible = true;
Label10.Visible = false;
string s = Session["loginid"].ToString();
carrentalEntities db = new carrentalEntities();
customer cc = db.customers.Where(x => x.email == s).FirstOrDefault <customer>();
int ci = cc.cid;
int cid1 = 0, cid2 = 1;
int bi = Int32.Parse(bid.Text.ToString());
// var q = from x in db.bookings where x.cid == ci select x;
var p = from n in db.bookings where n.bookingid == bi select n;
/* if(q.Any())
* {
* foreach(var y in q)
* {
* cid1 = y.cid;
* }
* }*/
if (p.Any())
{
foreach (var z in p)
{
cid2 = z.cid;
}
}
if (ci == cid2)
{
if (p.Any())
{
foreach (var y in p)
{
Label6.Text = y.carno.ToString();
Label7.Text = y.startdate.ToString();
Label8.Text = y.enddate.ToString();
Label9.Text = y.rentalamount.ToString();
}
}
}
else
{
Label2.Visible = false;
Label3.Visible = false;
Label4.Visible = false;
Label5.Visible = false;
Label6.Visible = false;
Label7.Visible = false;
Label8.Visible = false;
Label9.Visible = false;
Label10.Visible = true;
Label10.Text = "Invalid booking id";
}
}
protected void book_Click(object sender, EventArgs e)
{
carrentalEntities db = new carrentalEntities();
booking b = new booking();
cardata cd = new cardata();
string mail = Session["loginid"].ToString();
int custid;
var q = from i in db.customers where i.email == mail select i;
if (q.Any())
{
foreach (var i in q)
{
b.cid = i.cid;
}
}
DateTime d1 = Convert.ToDateTime(Session["startdate"].ToString());
DateTime d2 = Convert.ToDateTime(Session["enddate"].ToString());
// var a = ((from x in db.carstatus where ((d1 >= x.startdate) && (d1 <= x.enddate)) || ((d2 >= x.startdate) && (d2 <= x.enddate)) select x.did));
//var ab = (from y in db.chauffers select y.did).ToList();
//var ans = ab.Except(a);
//Response.Write(ans);
string check = "SELECT did FROM chauffer WHERE did NOT IN(SELECT did FROM carstatus AS cs WHERE ((@d1 >= cs.startdate) AND (@d1 <= cs.enddate)) OR ((@d2 >= cs.startdate) AND (@d2 <= cs.enddate)) )";
cmd.Parameters.AddWithValue("@d1", Convert.ToDateTime(Session["startdate"].ToString()));
cmd.Parameters.AddWithValue("@d2", Convert.ToDateTime(Session["enddate"].ToString()));
myconn.Open();
cmd.CommandText = check;
SqlDataReader rdr = cmd.ExecuteReader();
int driverid = 0;
while (rdr.Read())
{
driverid = Int32.Parse(rdr["did"].ToString());
break;
}
//Response.Write(driverid);
b.startdate = Convert.ToDateTime(one + " " + two);
b.enddate = Convert.ToDateTime(three + " " + four);
b.rentalamount = Int32.Parse(ppay.Text.ToString());
//b.type = "Rent";
b.carno = Session["carno"].ToString();
b.did = driverid;
b.month = mo;
b.year = yr;
b.address = address.Text;
db.bookings.Add(b);
string no = Session["carno"].ToString();
/* var q2 = (from p in db.cardatas where p.carno == no select p).ToList();
* if(q2.Any())
* {
* foreach(var i in q2.Where(w=>w.carno==no))
* {
* //i.status = "booked";
*
* }
* }*/
carstatu cr = new carstatu();
cr.carno = Session["carno"].ToString();
cr.startdate = Convert.ToDateTime(one + " " + two);
cr.enddate = Convert.ToDateTime(three + " " + four);
cr.status = "booked";
cr.did = driverid;
db.carstatus.Add(cr);
db.SaveChanges();
double tot = Double.Parse(ppay.Text);
Session["pay"] = (int)tot;
int id = (from record in db.bookings orderby record.bookingid descending select record.bookingid).First();
//for generating payslip
Session["bookingid"] = id.ToString();
booking bb = db.bookings.Where(x => x.bookingid == id).FirstOrDefault <booking>();
Session["st_date"] = bb.startdate.ToString();
Session["ed_date"] = bb.enddate.ToString();
Session["carno"] = bb.carno.ToString();
cardata cx = db.cardatas.Where(y => y.carno == bb.carno.ToString()).FirstOrDefault <cardata>();
int ve_id = cx.vehicleid;
vehicle vv = db.vehicles.Where(yy => yy.vehicleid == ve_id).FirstOrDefault <vehicle>();
Session["model"] = vv.model.ToString();
Session["brand"] = vv.brand.ToString();
Session["color"] = vv.color.ToString();
Session["capacity"] = vv.capacity.ToString();
Session["mileage"] = vv.mileage.ToString();
Session["address"] = bb.address.ToString();
Response.Redirect("applyoffer.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
Label8.Visible = true;
Label9.Visible = true;
Label10.Visible = true;
Label11.Visible = true;
string loginid = Session["loginid"].ToString();
carrentalEntities db = new carrentalEntities();
chauffer cc = db.chauffers.Where(x => x.email == loginid).FirstOrDefault <chauffer>();
int cid = cc.did;
int id = Int32.Parse(bookingid.Text);
var getdata = from x in db.bookings where x.bookingid == id && x.did == cid select x;
if (getdata.Any())
{
var a = getdata.First();
carno = a.carno;
startdate = a.startdate;
enddate = a.enddate;
int pay = a.rentalamount;
Label3.Text = carno;
Label4.Text = startdate.ToString();
Label5.Text = enddate.ToString();
Label6.Text = pay.ToString();
DateTime actenddate = DateTime.Now;
TimeSpan ts = actenddate.Subtract(enddate);
double hr = ts.TotalHours;
var vid = from p in db.cardatas where p.carno == carno select p;
int vehicle = 0;
if (vid.Any())
{
foreach (var y in vid)
{
vehicle = y.vehicleid;
}
}
var rent = from z in db.vehicles where z.vehicleid == vehicle select z;
int renthr = 0;
if (rent.Any())
{
foreach (var y in rent)
{
renthr = y.priceperday;
}
}
total = renthr * hr * 1.05;
int t = (int)total;
if (t >= 0)
{
Label7.Text = t.ToString();
}
else
{
Label7.Visible = false;
}
}
else
{
Response.Write("Enter valid booking id");
}
}
protected void login_Click(object sender, EventArgs e)
{
string loginid = uname.Text;
string password = pwd.Text;
string role = DropDownList1.SelectedItem.Text;
if (uname.Text == "" || pwd.Text == "")
{
msg.Text = "All details are mandatory.";
msg.ForeColor = System.Drawing.Color.Red;
return;
}
else
{
ExampleCaptcha.UserInputID = CaptchaCodeTextBox.ClientID;
if (IsPostBack)
{
bool isHuman = ExampleCaptcha.Validate(CaptchaCodeTextBox.Text);
CaptchaCodeTextBox.Text = null;
if (!isHuman)
{
msg.Text = "Incorrect Captcha.";
msg.ForeColor = System.Drawing.Color.Red;
}
else
{
try
{
carrentalEntities db = new carrentalEntities();
if (!idflag)
{
var q = from i in db.Logins where i.LoginId == loginid && i.Role == role && i.Password == password select i;
if (q.Any())
{
foreach (var i in q)
{
Session["role"] = i.Role;
Session["loginid"] = i.LoginId;
}
if (Session["role"].ToString() == "Admin")
{
Response.Redirect("Admin.aspx");
}
else if (Session["role"].ToString() == "Customer")
{
Response.Redirect("timecheck.aspx");
}
else if (Session["role"].ToString() == "Owner")
{
Response.Redirect("ownerprofile.aspx");
}
else if (Session["role"].ToString() == "DeliveryPerson")
{
Response.Redirect("chaufferprofile.aspx");
}
}
else
{
msg.Text = "Incorrect Credentials. Please try again.";
msg.ForeColor = System.Drawing.Color.Red;
}
}
}
catch (Exception ex)
{
msg.Text = "Exception";
msg.ForeColor = System.Drawing.Color.Red;
}
}
}
}
}