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) { } }