public IHttpActionResult PostUser_Vehicle(User_Vehicle user_V)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
User_Vehicle UV = db.User_Vehicle.Where(u => u.OwnerName == user_V.OwnerName &&
u.uservehicleRegNo == user_V.uservehicleRegNo).FirstOrDefault();
if (UV != null)
{
UV.userid = user_V.userid;
UV.CreatedDate = DateTime.Now;
UV.Latitude = user_V.Latitude;
UV.Longitude = user_V.Longitude;
db.SaveChanges();
}
else
{
db.User_Vehicle.Add(user_V);
db.SaveChanges();
}
}
catch (Exception ex)
{
return(CreatedAtRoute("DefaultApi", new { uservehicleStatus = ex.Message }, user_V));
}
return(CreatedAtRoute("DefaultApi", new { id = user_V.srno }, user_V));
}
public IHttpActionResult PutUser_Vehicle(long id, User_Vehicle user_Vehicle)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != user_Vehicle.srno)
{
return(BadRequest());
}
db.Entry(user_Vehicle).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!User_VehicleExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult DeleteUser_Vehicle(long id)
{
User_Vehicle user_Vehicle = db.User_Vehicle.Find(id);
if (user_Vehicle == null)
{
return(NotFound());
}
db.User_Vehicle.Remove(user_Vehicle);
db.SaveChanges();
return(Ok(user_Vehicle));
}
public IHttpActionResult VerifyFastTagBooking(string RFID, string TollPlazaId)
{
User_Vehicle vh = db.User_Vehicle.Where(v => v.RFIDNumber == RFID).FirstOrDefault();
User vu = db.Users.Where(u => u.srno == vh.userid).FirstOrDefault();
TollPayWallet tpw = db.TollPayWallets.Where(w => w.UserID == vh.userid).FirstOrDefault();
DateTime d = DateTime.Now;
UserTollTracker utt = db.UserTollTrackers.Where(ut => ut.TollPlazzaNo == Convert.ToInt32(TollPlazaId) && ut.VehicleNumber == vh.uservehicleRegNo && ut.tripDate <= d && ut.tripEndDate <= d).FirstOrDefault();
utt.TollRemark = "Pass_" + d.ToString();
db.SaveChanges();
string smsmsg;
smsmsg = "Dear " + vu.userEmail + " , TollPay.in U Just Passed. -" + TollPlazaId + ", TollAmt : " + utt.TollCost + "We be deducted";
ns.sendsms("smsfrom", vu.mobno1, smsmsg);
ns.sendemail(vu.userEmail, "", "TollPay.IN Notifications", smsmsg);
bool res = true;
return(Ok(res));
}
public void allocateFastTag(Bank_CreateWalletAPI cw)
{
try
{
//Create User for TollPay
//Update FastTage Vehicle Mapping
//Update Distribi
string cfasttag = cw.tagseq;
ecom_RFID er = db.ecom_RFID.Where(p => p.ecom_RFIDTagSrNo == cfasttag).FirstOrDefault();
User u = new User();
u.mobno1 = cw.custmobilenumber;
u.userEmail = cw.custemailId;
u.address = "FN=" + cw.custfirstname + "|LN=" + cw.custlastname + "|DoB=" + cw.custdob + "|PINCode=" + cw.custpincode;
u.password = Convert.ToString(GenerateRandomNo());
u.status = "a";
u.username = cw.custmobilenumber.Trim();
er.ecom_CustomerVehicleNo = cw.vehregnumber;
er.ecom_CustomerFName = cw.custfirstname;
er.ecom_CustomerLName = cw.custlastname;
er.ecom_CustomerMobNo = cw.custmobilenumber.Trim();
er.ecom_OTP = u.password;
er.ecom_isAllocated = true;
er.ecom_CustomerVehicleType = cw.vehclass;
er.ecom_CustomerIdentity = "DoB=" + cw.custdob + "|PINCode=" + cw.custpincode;
er.ecom_RFIDTagSrNo = cw.tagseq;
er.ecom_RFIDStatus = "a";
er.ecom_CustomerId = createTollPayCustomer(u);
db.SaveChanges();
User_Vehicle vu = new User_Vehicle();
vu.userid = er.ecom_CustomerId;
vu.RFIDNumber = er.ecom_RFIDTagSrNo;
vu.uservehicleRegNo = er.ecom_CustomerVehicleNo;
vu.uservehicleType = er.ecom_CustomerVehicleType;
User_Vehicle uve = db.User_Vehicle.Where(i => i.uservehicleRegNo == vu.uservehicleRegNo).FirstOrDefault();
if (uve == null)
{
db.User_Vehicle.Add(vu);
db.SaveChanges();
}
else
{
uve.userid = er.ecom_CustomerId;
uve.RFIDNumber = er.ecom_RFIDTagSrNo;
uve.uservehicleRegNo = er.ecom_CustomerVehicleNo;
uve.uservehicleType = er.ecom_CustomerVehicleType;
db.SaveChanges();
}
TollPayWallet tpw = new TollPayWallet();
tpw.UserID = Convert.ToInt32(vu.userid);
tpw.WalletAmount = 0;
tpw.Status = "a";
tpw.ModifiedDate = DateTime.Now;
TollPayWallet tpwe = db.TollPayWallets.Where(i => i.UserID == tpw.UserID).FirstOrDefault();
if (tpwe == null)
{
db.TollPayWallets.Add(tpw);
db.SaveChanges();
}
else
{
tpwe.UserID = Convert.ToInt32(vu.userid);
tpwe.WalletAmount = Convert.ToDecimal(cw.depositamt);
tpwe.Status = "a";
tpwe.ModifiedDate = DateTime.Now;
db.SaveChanges();
}
}
catch (Exception ex)
{
}
}
