public IHttpActionResult PostBookinginfo(bookinglist obj)
{
// List<USERTRIP> list = new List<USERTRIP>();
CHALOEntities db = new CHALOEntities();
List<NOOFSEAT> NOOFSEATS = new List<NOOFSEAT>();
List<WALLET> objwallet = new List<WALLET>();
string usertrip = "";
// List<LOCATION> users = new List<LOCATION>();
try
{
NOOFSEATS = db.Database.SqlQuery<NOOFSEAT>("EXEC noofseatsavailability @TRIP_ID='" + obj.trip_id + "'").ToList();
if (NOOFSEATS.Count > 0)
{
if (obj.paymenttype == "1")
{
objwallet = db.Database.SqlQuery<WALLET>("EXEC CHECKWALLETAMOUNT @USER_ID='" + obj.userid + "'").ToList();
if (objwallet[0].WALLET_AVAILABLEMONEY >= obj.totalamount)
{
usertrip=bookride(obj,objwallet[0].WALLET_ID);
try
{
string mobilenumber =usertrip.Split('$')[1];
List<CH_USER> users = db.Database.SqlQuery<CH_USER>("select * from ch_user where user_id='" + obj.userid + "' and user_status=1").ToList();
bool statusnew = common.sendmessage("Thank you for choosing CHALO. Your booking has been confirmed. Vehicle number:"+ obj.vehicle_number +", Driver name:"+ obj.driver_name +" ("+ mobilenumber +"). Please reach Pickup point("+ obj.fromlocationname +") 5 minutes before. Your pick up time is "+ obj.fromactualreachtime +". For any assistance call us at 9900036467 or [email protected]",users[0].USER_MOBILE);
}
catch(Exception ex)
{
}
//StreamReader reader = new StreamReader(Path.Combine(System.Web.HttpContext.Current.Server.MapPath(@"~/Emails/registeremail.html")));
//string readFile = reader.ReadToEnd();
//string myString = "";
//myString = readFile;
//myString = myString.Replace("$$NAME$$", objuser.USER_FIRSTNAME);
//myString = myString.Replace("$$CODE$$", objusercoupon.COUPON_NAME);
//bool statusemail = common.sendemail(myString, "Welcome to CHALO", "*****@*****.**", objuser.USER_EMAILID);
//return Ok(result);
return Json(new { Success = usertrip });
}
else
{
return Json(new { nowallet = "you have " + objwallet[0].WALLET_AVAILABLEMONEY + " RS in your wallet which is not sufficient to book your cab" });
}
}
else if(obj.paymenttype=="2")
{
usertrip = bookride(obj,0);
try
{
string mobilenumber = usertrip.Split('$')[1];
List<CH_USER> users = db.Database.SqlQuery<CH_USER>("select * from ch_user where user_id='" + obj.userid + "' and user_status=1").ToList();
bool statusnew = common.sendmessage("Thank you for choosing CHALO. Your booking has been confirmed. Vehicle number:" + obj.vehicle_number + ", Driver name:" + obj.driver_name + " (" + mobilenumber + "). Please reach Pickup point(" + obj.fromlocationname + ") 5 minutes before. Your pick up time is " + obj.fromactualreachtime + ". For any assistance call us at 9900036467 or [email protected]", users[0].USER_MOBILE);
}
catch (Exception ex)
{
}
return Json(new { Success = usertrip });
}
else
{
return Json(new { errorthing = "error" });
}
}
else
{
return Json(new { noseats = "seatsover" });
}
// users = db.LOCATIONS.ToList();
}
catch (Exception ex)
{
return Json(new { errorthing = "error" });
}
}
internal string bookride(bookinglist obj,int walletid)
{
CHALOEntities db = new CHALOEntities();
List<bookeddetails> USERTRIPs = new List<bookeddetails>();
string result = "";
// List<USERTRIP> USERTRIPs = new List<USERTRIP>();
try
{
string proc = "EXEC USP_BOOKCAB @USER_ID='" + obj.userid + "' ,@USERTRIP_TRIPID='" + obj.trip_id + "',@USERTRIP_PICKUPLOC='" + obj.fromllid + "',@USERTRIP_DROPLOC='" + obj.tollid + "',@USERTRIP_VIA='" + obj.VIA + "',@USERTRIP_ESTIMATEDDURATION='" + obj.duration + "',@USERTRIP_ACTUALDURATION='" + obj.duration + "' ,@USERTRIP_DISTANCE='" + obj.DISTANCE + "',@USERTRIP_ACTUALAMOUNT='" + obj.COST + "',@USERTRIP_DISCOUNT='" + obj.discount + "',@USERTRIP_TOTALAMOUNT='" + obj.totalamount + "',@USERTRIP_STATUS=1,@USERTRIP_APPLIEDCOUPON='" + obj.appliedcoupon + "',@TRANS_STATUS=1 ,@PAYMENTTYPE_ID='" + obj.paymenttype + "' ,@APPLIEDCOUPONNAME ='" + obj.APPLIEDCOUPONNAME + "',@ISONETIME='" + obj.ISONETIME + "',@OPERATION ='BOOKCAB',@usertrip_pickupavergetime='" + obj.fromaveragereachtimenormal + "',@usertrip_pickupactualtime='" + obj.fromactualreachtimenormal + "',@usertrip_dropaveragetime='" + obj.toactualreachtimenormal + "',@usertrip_dropactualtime='" + obj.toactualreachtimenormal + "'";
USERTRIPs = db.Database.SqlQuery<bookeddetails>("EXEC USP_BOOKCAB @USER_ID='" + obj.userid + "' ,@USERTRIP_TRIPID='" + obj.trip_id + "',@USERTRIP_PICKUPLOC='" + obj.fromllid + "',@USERTRIP_DROPLOC='" + obj.tollid + "',@USERTRIP_VIA='" + obj.VIA + "',@USERTRIP_ESTIMATEDDURATION='" + obj.duration + "',@USERTRIP_ACTUALDURATION='" + obj.duration + "' ,@USERTRIP_DISTANCE='" + obj.DISTANCE + "',@USERTRIP_ACTUALAMOUNT='" + obj.COST + "',@USERTRIP_DISCOUNT='" + obj.discount + "',@USERTRIP_TOTALAMOUNT='" + obj.totalamount + "',@USERTRIP_STATUS=1,@USERTRIP_APPLIEDCOUPON='" + obj.appliedcoupon + "',@TRANS_STATUS=1 ,@PAYMENTTYPE_ID='" + obj.paymenttype + "' ,@APPLIEDCOUPONNAME ='" + obj.APPLIEDCOUPONNAME + "',@ISONETIME='" + obj.ISONETIME + "',@OPERATION ='BOOKCAB',@usertrip_pickupavergetime='"+ obj.fromaveragereachtimenormal + "',@usertrip_pickupactualtime='"+ obj.fromactualreachtimenormal + "',@usertrip_dropaveragetime='"+ obj.toactualreachtimenormal + "',@usertrip_dropactualtime='"+ obj.toactualreachtimenormal +"',@WALLET_ID="+ walletid +"").ToList();
if(USERTRIPs.Count>0)
{
result = USERTRIPs[0].SUCCESS;
}
}
catch (Exception ex)
{
}
return result;
}
