public IHttpActionResult PutUser_Trips(int id, User_Trips user_Trips)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != user_Trips.srno)
{
return(BadRequest());
}
db.Entry(user_Trips).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!User_TripsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostUser_Trip_Payment(User_Trip_Payment user_Trip_Payment)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.User_Trip_Payment.Add(user_Trip_Payment);
try
{
db.SaveChanges();
User_Trips ut = db.User_Trips.Where(t => t.userid == user_Trip_Payment.tripId).FirstOrDefault();
string smsto = ut.DriverMobileNo + "," + ut.DriverOwnerMobNo;
User us = db.Users.Where(u => u.srno == Convert.ToInt32(user_Trip_Payment.userno)).FirstOrDefault();
string smsmsg;
smsmsg = "Dear Customer, Rs. " + user_Trip_Payment.TripPaymentAmount + " Paid via " + user_Trip_Payment.TripPaymentMode + "for Trip Id -" + user_Trip_Payment.tripId;
ns.sendsms("smsfrom", smsto, smsmsg);
ns.sendemail(us.userEmail, "", "TollPay.IN Trip Booked", smsmsg);
}
catch (DbUpdateException)
{
if (User_Trip_PaymentExists(user_Trip_Payment.srno))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = user_Trip_Payment.srno }, user_Trip_Payment));
}
public IHttpActionResult DeleteUser_Trips(int id)
{
User_Trips user_Trips = db.User_Trips.Find(id);
if (user_Trips == null)
{
return(NotFound());
}
db.User_Trips.Remove(user_Trips);
db.SaveChanges();
return(Ok(user_Trips));
}
public IHttpActionResult PostUser_Trips(User_Trips user_Trips)
{
//bool cb = true; //sagar code
bool cb = false; //sachin code
if (cb)
{
//User_Trips user_Trips = new User_Trips();
//user_Trips.tripStartLocation = source;
//user_Trips.tripEndLocation = destination;
//user_Trips.tripDate =Convert.ToDateTime(startdate);
bool flag = false;
IQueryable <User_Trips> result = db.User_Trips.Where(l => l.userid == user_Trips.userid);
User_Trips[] utrips = result.ToArray();
foreach (var item in utrips)
{
if (user_Trips.tripStartLocation == item.tripStartLocation && user_Trips.tripEndLocation == item.tripEndLocation)
{
flag = true;
item.tripDate = user_Trips.tripDate;
item.tripEndDate = user_Trips.tripEndDate;
item.CreatedDate = System.DateTime.Now;
db.SaveChanges();
}
}
if (flag == false)
{
user_Trips.CreatedDate = DateTime.Now;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.User_Trips.Add(user_Trips);
db.SaveChanges();
}
}
else
{
int? uid = user_Trips.userid;
string src = user_Trips.tripStartLocation;
string dest = user_Trips.tripEndLocation;
decimal? tripamt = user_Trips.totalCost;
string tt = "single";
string vehicleno = user_Trips.userVechicleNumber;
string vehicleType = db.User_Vehicle.Where(p => p.uservehicleRegNo == vehicleno).FirstOrDefault().uservehicleType;
string pm = "wallet";
string POSDetails = "wallet";
DateTime?stdate = user_Trips.tripDate;
DateTime?enddate = user_Trips.tripEndDate;
string resulttolllist = db.RouteTollsQueries.Where(r => r.src.Contains(src) && r.dest.Contains(dest)).FirstOrDefault().routetolls;
// db.CreateTrip(#ut.userid, #ut.tripStartLocation, #ut.tripEndLocation, #resulttolllist, #TripTotalAmount, #pm,
//#TxtPOSDetails.Text, #TxtPOSDetails.Text, #TxtPOSDetails.Text, ut.userVechicleNumber, vt, tt, ut.tripDate, ut.tripEndDate);
int rid = db.CreateTrip(uid, src, dest, resulttolllist, tripamt, pm, POSDetails, POSDetails, POSDetails, vehicleno, vehicleType, tt, stdate, enddate, user_Trips.DriverMobileNo, user_Trips.DriverOwnerMobNo);
string smsmsg;
smsmsg = "Dear Customer, Rs. " + tripamt + " Paid via " + POSDetails + "for Trip Src-" + src + "Dest- " + dest;
ns.sendsms("smsfrom", user_Trips.DriverMobileNo, smsmsg);
string userEmail = db.Users.Where(o => o.srno == uid).FirstOrDefault().userEmail;
ns.sendemail(userEmail, "", "TollPay.IN Trip Booked", smsmsg);
}
return(CreatedAtRoute("DefaultApi", new { id = user_Trips.srno }, user_Trips));
}
public Tollcal GetTollPlaza(string source, string destination, string vehicletype, string journey)
{
bool flag = false;
Tollcal response = new Tollcal();
if (flag)
{
#region Sagar Code
WebClient wb = new WebClient();
string strurl = "http://tis.nhai.gov.in/UploadHandler.ashx?Up=3&Source=" + source + "&Destination=" + destination;
string result = wb.DownloadString(strurl);
//18.3313849,73.8525197$17.810312,73.971381$$113 km!2 hours 13 mins
List <string> tollplazza = result.Split('$').ToList();
DP_TPEntities db = new DP_TPEntities();
List <TollPlaza> lsttollinrounte = new List <TollPlaza>();
User_Trips ut = new User_Trips();
ut.tripStartLocation = source;
ut.tripEndLocation = destination;
Random random = new Random();
int numb = random.Next(1, 31) % 31;
if (numb != 0)
{
ut.tripDate = new DateTime(2019, 8, numb);
ut.tripStatus = "a";
ut.userid = 1;
}
foreach (var item in tollplazza)
{
if (item.Contains(','))
{
List <string> latlng = item.Split(',').ToList();
double dlat = Convert.ToDouble(latlng[0]);
lsttollinrounte.Add(db.TollPlazas.Where(l => l.lat == dlat).FirstOrDefault());
}
}
dynamic orderTotals = 0.0;
//let orderTotals;
//var orderTotals;
List <TollPlazaRateByVehicleTypes> LstTPRBV = new List <TollPlazaRateByVehicleTypes>();
switch (vehicletype)
{
case "Bus":
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => item.rates_bus_multi)).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_bus_multi
}).ToList();
break;
case "car":
if (journey == "multi")
{
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => item.rates_car_multi)).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_car_multi
}).ToList();
}
else
{
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => Convert.ToDecimal(item.rates_car_single))).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_car_single
}).ToList();
}
break;
case "sixaxle":
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => item.rates_four_six_axle_multi)).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_four_six_axle_multi
}).ToList();
break;
case "hcm":
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => item.rates_hcm_multi)).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_hcm_multi
}).ToList();
break;
case "lcv":
if (journey == "multi")
{
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => item.rates_lcv_multi)).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_lcv_multi
}).ToList();
}
else
{
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => Convert.ToDecimal(item.rates_lcv_single))).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_lcv_single
}).ToList();
}
break;
case "multaxle":
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => item.rates_multiaxle_multi)).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_multiaxle_multi
}).ToList();
break;
case "sevenaxle":
orderTotals = lsttollinrounte.GroupBy(i => 1).Select(g => g.Sum(item => item.rates_seven_plus_axle_multi)).FirstOrDefault();
LstTPRBV = lsttollinrounte.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, lat = x.lat, lon = x.lon, Rate = x.rates_seven_plus_axle_multi
}).ToList();
break;
default:
Console.WriteLine("Default case");
break;
}
// Tollcal response = new Tollcal();
response.tollplaza = LstTPRBV;
response.totalcost = (double)orderTotals;
return(response);
#endregion
}
else
{
string src = source;
string dest = destination;
string vt = vehicletype;
string tt = journey;
//TollPlazaServiceSoapClient proxy = new TollPlazaServiceSoapClient();
//List<string> names= proxy.AutoCompleteLocation("pu").ToList();
WebClient wb = new WebClient();
string result = string.Empty;
try
{
result = db.RouteTollsQueries.Where(r => r.src.Contains(src) && r.dest.Contains(dest)).FirstOrDefault().routetolls;
}
catch (Exception ex)
{
if (result == string.Empty)
{
string strurl = "http://tis.nhai.gov.in/UploadHandler.ashx?Up=3&Source=" + src + "&Destination=" + dest;
result = wb.DownloadString(strurl);
db.RouteTollsQueries.Add(new RouteTollsQuery()
{
src = src, dest = dest, routeactive = "a", routetolls = result
});
db.SaveChanges();
}
}
List <getTripPrices_Result> lsttollplazz = db.getTripPrices(result).ToList();
List <TollPlazaRateByVehicleTypes> LstTPRBV = new List <TollPlazaRateByVehicleTypes>();
switch (vt)
{
case "Bus":
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_bus_multi
}).ToList();
break;
case "Car":
if (journey == "multi")
{
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_car_multi
}).ToList();
}
else
{
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_car_single
}).ToList();
}
break;
case "Sixaxle":
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_four_six_axle_multi
}).ToList();
break;
case "HCM":
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_hcm_multi
}).ToList();
break;
case "LCV":
if (journey == "multi")
{
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_lcv_multi
}).ToList();
}
else
{
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_lcv_single
}).ToList();
}
break;
case "Multaxle":
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_multiaxle_multi
}).ToList();
break;
case "Sevenaxle":
LstTPRBV = lsttollplazz.Select(x => new TollPlazaRateByVehicleTypes()
{
id = x.id, name = x.name, lat = x.lat, lon = x.lon, Rate = x.rates_seven_plus_axle_multi
}).ToList();
break;
default:
// Console.WriteLine("Default case");
break;
}
List <TollRateCard> orderTotals = lsttollplazz
.GroupBy(i => 1)
.Select(g => new TollRateCard
{
cnt = g.Count(),
rates_car_single = g.Sum(item => item.rates_car_single),
rates_car_multi = g.Sum(item => item.rates_car_multi),
rates_car_monthly = g.Sum(item => item.rates_car_monthly),
rates_bus_multi = g.Sum(item => item.rates_bus_multi),
rates_bus_monthly = g.Sum(item => item.rates_bus_monthly),
rates_four_six_axle_single = g.Sum(item => item.rates_four_six_axle_single),
rates_four_six_axle_multi = g.Sum(item => item.rates_four_six_axle_multi),
rates_four_six_axle_monthly = g.Sum(item => item.rates_four_six_axle_monthly),
rates_seven_plus_axle_single = g.Sum(item => item.rates_seven_plus_axle_single),
rates_seven_plus_axle_multi = g.Sum(item => item.rates_seven_plus_axle_multi),
rates_seven_plus_axle_monthly = g.Sum(item => item.rates_seven_plus_axle_monthly),
rates_hcm_single = g.Sum(item => item.rates_hcm_single),
rates_hcm_multi = g.Sum(item => item.rates_hcm_multi),
rates_hcm_monthly = g.Sum(item => item.rates_hcm_monthly),
rates_lcv_single = g.Sum(item => item.rates_lcv_single),
rates_lcv_multi = g.Sum(item => item.rates_lcv_multi),
rates_lcv_monthly = g.Sum(item => item.rates_lcv_monthly),
rates_multiaxle_single = g.Sum(item => item.rates_multiaxle_single),
rates_multiaxle_multi = g.Sum(item => item.rates_multiaxle_multi),
rates_multiaxle_monthly = g.Sum(item => item.rates_multiaxle_monthly)
}).ToList();
double?tollamt = 0;
switch (vt)
{
case "Car":
if (tt.ToLower() == "single")
{
tollamt = orderTotals[0].rates_car_single;
}
else if (tt.ToLower() == "multi")
{
tollamt = orderTotals[0].rates_car_multi;
}
else
{
tollamt = orderTotals[0].rates_car_monthly;
}
break;
case "LCV":
if (tt.ToLower() == "single")
{
tollamt = orderTotals[0].rates_lcv_single;
}
else if (tt.ToLower() == "multi")
{
tollamt = orderTotals[0].rates_lcv_multi;
}
else
{
tollamt = orderTotals[0].rates_lcv_monthly;
}
break;
case "Bus":
if (tt.ToLower() == "single")
{ //tollamt = orderTotals[0].rates_bus_single;
}
else if (tt.ToLower() == "multi")
{
tollamt = orderTotals[0].rates_bus_multi;
}
else
{
tollamt = orderTotals[0].rates_bus_monthly;
}
break;
case "Multiaxle":
if (tt.ToLower() == "single")
{
tollamt = orderTotals[0].rates_multiaxle_single;
}
else if (tt.ToLower() == "multi")
{
tollamt = orderTotals[0].rates_multiaxle_multi;
}
else
{
tollamt = orderTotals[0].rates_multiaxle_monthly;
}
break;
case "HCM":
if (tt.ToLower() == "single")
{
tollamt = orderTotals[0].rates_hcm_single;
}
else if (tt.ToLower() == "multi")
{
tollamt = orderTotals[0].rates_hcm_multi;
}
else
{
tollamt = orderTotals[0].rates_hcm_monthly;
}
break;
case "Four_six_axle":
if (tt.ToLower() == "single")
{
tollamt = orderTotals[0].rates_four_six_axle_single;
}
else if (tt.ToLower() == "multi")
{
tollamt = orderTotals[0].rates_four_six_axle_multi;
}
else
{
tollamt = orderTotals[0].rates_four_six_axle_monthly;
}
break;
case "Seven_plus_axle":
if (tt.ToLower() == "single")
{
tollamt = orderTotals[0].rates_seven_plus_axle_single;
}
else if (tt.ToLower() == "multi")
{
tollamt = orderTotals[0].rates_seven_plus_axle_multi;
}
else
{
tollamt = orderTotals[0].rates_seven_plus_axle_monthly;
}
break;
default: break;
}
List <TollPlaza> lsttp = new List <TollPlaza>();
foreach (var item in lsttollplazz)
{
TollPlaza tp = new TollPlaza();
tp.id = item.id;
tp.name = item.name;
tp.lat = item.lat;
tp.lon = item.lon;
lsttp.Add(tp);
//response.tollplaza.Add(tp);
#region mapcode
//public string name { get; set; }
//public Nullable<double> lat { get; set; }
//public Nullable<double> lon { get; set; }
//public Nullable<System.DateTime> fee_effective_date { get; set; }
//public Nullable<double> rates_car_single { get; set; }
//public Nullable<double> rates_car_multi { get; set; }
//public Nullable<double> rates_car_monthly { get; set; }
//public Nullable<double> rates_lcv_single { get; set; }
//public Nullable<double> rates_lcv_multi { get; set; }
//public Nullable<double> rates_lcv_monthly { get; set; }
//public Nullable<double> rates_bus_multi { get; set; }
//public Nullable<double> rates_bus_monthly { get; set; }
//public Nullable<double> rates_multiaxle_single { get; set; }
//public Nullable<double> rates_multiaxle_multi { get; set; }
//public Nullable<double> rates_multiaxle_monthly { get; set; }
//public Nullable<double> rates_hcm_single { get; set; }
//public Nullable<double> rates_hcm_multi { get; set; }
//public Nullable<double> rates_hcm_monthly { get; set; }
//public Nullable<double> rates_four_six_axle_single { get; set; }
//public Nullable<double> rates_four_six_axle_multi { get; set; }
//public Nullable<double> rates_four_six_axle_monthly { get; set; }
//public Nullable<double> rates_seven_plus_axle_single { get; set; }
//public Nullable<double> rates_seven_plus_axle_multi { get; set; }
//public Nullable<double> rates_seven_plus_axle_monthly { get; set; }
#endregion
}
response.tollplaza = LstTPRBV;
response.totalcost = (double)tollamt;
return(response);
}
}
