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;
}
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 Button3_Click(object sender, EventArgs e)
{
string otpl = "";
otpl = (Session["otp"]).ToString();
int bid = Int32.Parse(Session["bookingid"].ToString());
if (otp.Text == otpl)
{
//Response.Write("otp matched");
payment p = new payment();
p.amountpaid = Int32.Parse(Label6.Text);
p.bookingid = Int32.Parse(Session["bookingid"].ToString());
//p.bookingid = 0;
p.paymentmode = DropDownList1.SelectedItem.Text;
p.nameoncard = cardname.Text;
p.cardno = (cardno.Text);
p.phone = phoneno.Text;
p.date = DateTime.Now;
db.payments.Add(p);
db.SaveChanges();
Label7.Text = "payment done succesfully";
booking bb = db.bookings.Where(x => x.bookingid == bid).FirstOrDefault <booking>();
Session["amount"] = Int32.Parse(Label6.Text);
Session["address"] = bb.address.ToString();
Response.Redirect("viewpayslip.aspx");
}
else
{
Label7.Text = "otp doesn't matched";
//Response.Write("error");
}
}
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 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 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 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);
}