public string PutAllocationSlot(string barcodeNo, bool flag)// { using (SmartParkingEntities context = new SmartParkingEntities()) { try { ParkingSlotMaster recordRow = (from slot in context.ParkingSlotMasters where slot.BarcodeNo == barcodeNo select slot).SingleOrDefault(); recordRow.BarcodeNo = barcodeNo; recordRow.IsOccupied = flag; context.SaveChanges(); return recordRow.SlotName; } catch (Exception e) { Console.Write(e); return null; } } }
public List<UserProfileModel> GetUserProfileList() { List<UserProfileModel> result = new List<UserProfileModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { var qry = context.UserProfiles.ToList(); if (qry.Count() > 0) { result = qry.Select(u => new UserProfileModel() { ActiveVehicleNumber = u.ActiveVehicleNumber, Address1 = u.Address1, Address2 = u.Address2, City = u.City, EmailID = u.EmailID, FirstName = u.FirstName, IsActive = u.IsActive, LastName = u.LastName, MobileNumber = u.MobileNumber, Pincode = u.Pincode, State = u.State, UserID = u.UserID }).ToList(); } } return result; }
public bool PostParking(ParkingMaster prk) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { ParkingMaster parking = new ParkingMaster() { ParkingName = prk.ParkingName, ParkingTemplateName = prk.ParkingTemplateName, ParkingAddress = prk.ParkingAddress, NumberOfSlots = prk.NumberOfSlots, IsActive = prk.IsActive, Min_Latitude=prk.Min_Latitude, Max_Latitude=prk.Max_Latitude, Min_Longitude=prk.Min_Longitude, Max_Longitude = prk.Max_Longitude }; context.ParkingMasters.Add(parking); context.SaveChanges(); result = true; } return result; }
public List<SelectedListModel> GetParkings() { List<SelectedListModel> result = new List<SelectedListModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { result = context.ParkingMasters.Where(s => s.IsActive == true).Select(s => new SelectedListModel { ListText = s.ParkingName, ListValue = s.ParkingID }).ToList(); if (result.Count() > 0) return result; } return result; }
public int PostUserProfile(UserProfile entity) { using (_DBContext = new SmartParkingEntities()) { UserProfile thisEntity = _DBContext.UserProfiles.Find(entity.UserID); if (thisEntity == null) CreateUserProfile(entity); else thisEntity = entity; _DBContext.SaveChanges(); } return entity.UserID; }
public UserProfileModel GetUserProfile(int inputId) { UserProfileModel result = new UserProfileModel(); using (SmartParkingEntities context = new SmartParkingEntities()) { var usr = context.UserProfiles.Where(u => u.UserID == inputId).SingleOrDefault(); if (usr != null) { result = ConvertDBToModelObject(usr); } } return result; }
public ParkingModel GetParkingMaster(int inputId) { ParkingModel result = new ParkingModel(); using (SmartParkingEntities context = new SmartParkingEntities()) { var prk = context.ParkingMasters.Where(u => u.ParkingID == inputId).SingleOrDefault(); if (prk != null) { result = ConvertDBToModelObject(prk); } } return result; }
public List<WalletTranModel> GetWalletTrans(int userID) { List<WalletTranModel> result = new List<WalletTranModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { result= context.WalletTrans.Where(e => e.UserID == userID).Select(e=> new WalletTranModel{ Amount=e.Amount, CRDR = e.CRDR, TransDt = e.TransDt }).ToList(); } return result; }
public SlotModel GetSlotByNumber(string inputId) { SlotModel result = new SlotModel(); using (SmartParkingEntities context = new SmartParkingEntities()) { var qry = context.SlotMasters.Where(s => s.SlotNumber == inputId).SingleOrDefault(); if (qry != null) { result = ConvertDBToModelObject(qry); } } return result; }
public bool PostWalletTrans(WalletTran entity) { using (SmartParkingEntities DBContext = new SmartParkingEntities()) { //UserProfile usr = DBContext.UserProfiles.Find(entity.UserID); //usr.WalletAmount = DBContext.WalletTrans.Where(e => e.UserID == entity.UserID && e.CRDR == "CR").Sum(e => e.Amount) - // DBContext.WalletTrans.Where(e => e.UserID == entity.UserID && e.CRDR == "DR").Sum(e => e.Amount); //usr.WalletAmount += entity.CRDR == "CR" ? entity.Amount : -entity.Amount; entity.TransDt = DateTime.Now; DBContext.WalletTrans.Add(entity); DBContext.SaveChanges(); return true; } }
// GET api/values //public List<ParkingSlotMaster> Get() //{ // using (Smart_ParkingEntities1 context = new Smart_ParkingEntities1()) // { // List<ParkingSlotMaster> list = (from ParkingSlot in context.ParkingSlotMasters // where ParkingSlot.IsActive==true // select ParkingSlot).ToList(); // return list; // } //} // GET api/values/5 public ParkingSlotMaster Get(int inputId) { try { using (SmartParkingEntities context = new SmartParkingEntities()) { ParkingSlotMaster list = (from ParkingSlots in context.ParkingSlotMasters where ParkingSlots.ID == inputId select ParkingSlots).SingleOrDefault(); return list; } } catch (Exception e) { Console.WriteLine(e); return new ParkingSlotMaster(); } }
public bool PostTransactionLog(ParkingSlotTransaction log) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { ParkingSlotTransaction transaction = new ParkingSlotTransaction() { SlotID = log.SlotID, UserID = log.UserID, ParkingInTime = DateTime.Now, VehicleNumber = log.VehicleNumber }; context.ParkingSlotTransactions.Add(transaction); context.SaveChanges(); result = true; } return result; }
public List<SlotModel> GetSlots(int id) { List<SlotModel> result = new List<SlotModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { var qry = context.SlotMasters.Where(s => s.ParkingID == id).ToList(); if (qry.Count() > 0) { result = qry.Select(s => new SlotModel() { IsAcquired = s.IsAcquired, IsActive = s.IsActive, ParkingID = s.ParkingID, SlotID = s.SlotID, SlotNumber = s.SlotNumber }).ToList(); } } return result; }
public List<ParkingModel> GetParkingMasterList() { List<ParkingModel> result = new List<ParkingModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { var qry = context.ParkingMasters.ToList(); if (qry.Count() > 0) { result = qry.Select(p => new ParkingModel() { IsActive = p.IsActive, NumberOfSlots = p.NumberOfSlots, ParkingAddress = p.ParkingAddress, ParkingID = p.ParkingID, ParkingName = p.ParkingName, ParkingTemplateName = p.ParkingTemplateName }).ToList(); } return result; } }
//vijay public List<string> GetOnlyOccupied() { using (SmartParkingEntities context = new SmartParkingEntities()) { try { var qry = (from listSlots in context.ParkingSlotMasters where listSlots.IsOccupied == true select listSlots.SlotName); return qry.ToList(); } catch (Exception e) { Console.Write(e); return new List<string>(); } } }
public List<SlotTransactionModel> GetSlotTransactionAsUser(int userId) { List<SlotTransactionModel> result = new List<SlotTransactionModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { result = (from pt in context.ParkingSlotTransactions join s in context.SlotMasters on pt.SlotID equals s.SlotID join p in context.ParkingMasters on s.ParkingID equals p.ParkingID join u in context.UserProfiles on pt.UserID equals u.UserID where pt.UserID == userId select new SlotTransactionModel { TransactionID = pt.TransactionID, SlotID = s.SlotID, UserID = u.UserID, UserName = u.FirstName + "" + u.LastName, SlotName = s.SlotNumber, ParkingInTime = pt.ParkingInTime, ParkingName = p.ParkingName, ParkingOutTime = pt.ParkingOutTime }).ToList(); } return result; }
public bool PostUpdateUserProfile(UserProfileModel usr) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { UserProfile usrProfile = context.UserProfiles.Where(u => u.UserID == usr.UserID).SingleOrDefault(); usrProfile.FirstName = usr.FirstName; usrProfile.LastName = usr.LastName; usrProfile.EmailID = usr.EmailID; usrProfile.MobileNumber = usr.MobileNumber; usrProfile.Address1 = usr.Address1; usrProfile.Address2 = usr.Address2; usrProfile.City = usr.City; usrProfile.State = usr.State; usrProfile.Pincode = usr.Pincode; usrProfile.ActiveVehicleNumber = usr.ActiveVehicleNumber; usrProfile.IsActive = usr.IsActive; context.SaveChanges(); result = true; } return result; }
public int PostUserProfile(UserProfileModel usr) { int result = 0; using (SmartParkingEntities context = new SmartParkingEntities()) { UserProfile usrProfile = new UserProfile() { FirstName = usr.FirstName, LastName = usr.LastName, EmailID = usr.EmailID, MobileNumber = usr.MobileNumber, Address1 = usr.Address1, Address2 = usr.Address2, City = usr.City, State = usr.State, Pincode = usr.Pincode, ActiveVehicleNumber = usr.ActiveVehicleNumber, IsActive = usr.IsActive }; context.UserProfiles.Add(usrProfile); context.SaveChanges(); result = usrProfile.UserID; } return result; }
public int GetLastParkingSlot(int inputId) { int result = 0; using (SmartParkingEntities context = new SmartParkingEntities()) { ParkingSlotTransaction trasaction = context.ParkingSlotTransactions.OrderByDescending(t => t.ParkingInTime).Where(t => t.UserID == inputId).FirstOrDefault(); if (trasaction != null) { var slot = context.SlotMasters.Where(s => s.SlotID == trasaction.SlotID).SingleOrDefault(); result = slot.ParkingID; } } return result; }
public bool PostUpdateParkingSlotTransaction(string slotNumber, int userId, int parkingId) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { var getSolt = context.SlotMasters.Where(s => s.SlotNumber == slotNumber && s.ParkingID == parkingId).SingleOrDefault(); if (getSolt != null) { ParkingSlotTransaction transaction = context.ParkingSlotTransactions.Where(t => t.SlotID == getSolt.SlotID && t.UserID == userId).SingleOrDefault(); transaction.ParkingOutTime = DateTime.Now; context.SaveChanges(); result = true; } } return result; }
// DELETE api/values/5 public bool Delete(int ID) { try { using (SmartParkingEntities context = new SmartParkingEntities()) { //ParkingSlotMaster OneSlot = (from slot in context.ParkingSlotMasters // where slot.ID == ID // select slot).FirstOrDefault(); //context.ParkingSlotMasters.Attach(OneSlot); //context.ParkingSlotMasters.Remove(OneSlot); //context.SaveChanges(); //return true; ParkingSlotMaster OneSlot = new ParkingSlotMaster { ID = ID }; context.Entry(OneSlot).State = System.Data.EntityState.Deleted; context.SaveChanges(); return true; } } catch (Exception e) { Console.WriteLine(e); return false; } //delete }
public bool PostUpdateParking(ParkingMaster prk) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { ParkingMaster parking = context.ParkingMasters.Where(u => u.ParkingID == prk.ParkingID).SingleOrDefault(); parking.IsActive = prk.IsActive; parking.NumberOfSlots = prk.NumberOfSlots; parking.ParkingAddress = prk.ParkingAddress; parking.ParkingName = prk.ParkingName; parking.ParkingTemplateName = prk.ParkingTemplateName; parking.IsActive = prk.IsActive; parking.Max_Latitude = prk.Max_Latitude; parking.Min_Latitude = prk.Min_Latitude; parking.Max_Longitude = prk.Max_Longitude; parking.Min_Longitude = prk.Min_Longitude; context.SaveChanges(); result = true; } return result; }
public List<ParkingModel> SearchParkingMaster(ParkingSearchModel model) { List<ParkingModel> result = new List<ParkingModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { var qry = context.ParkingMasters.Where(s => s.IsActive == true).ToList(); if (model != null) { if (model.ParkingName != null) qry = qry.Where(p => p.ParkingName.Contains(model.ParkingName)).ToList(); if (model.ParkingAddress != null) qry = qry.Where(p => p.ParkingAddress.Contains(model.ParkingAddress)).ToList(); } if (qry.Count() > 0) { result = qry.Select(p => new ParkingModel() { IsActive = p.IsActive, NumberOfSlots = p.NumberOfSlots, ParkingAddress = p.ParkingAddress, ParkingID = p.ParkingID, ParkingName = p.ParkingName, ParkingTemplateName = p.ParkingTemplateName }).ToList(); } return result; } }
public string PostParkUnPark(int userId, int parkingId, string slotNo, int SlotStatus) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { SlotMaster slot = context.SlotMasters.Where(s => s.ParkingID == parkingId && s.SlotNumber == slotNo).SingleOrDefault(); if (SlotStatus == 2 || SlotStatus == 3) slot.CurrentUserID = userId; else slot.CurrentUserID = -1; if (slot.SlotStatus == 3 || SlotStatus == 3) { if (SlotStatus == 3 && slot.SlotStatus == 1) context.WalletTrans.Add(new WalletTran { UserID = userId, TransDt = DateTime.Now, CRDR = "DR", Amount = 20 }); if (SlotStatus == 1 && slot.SlotStatus == 3) context.WalletTrans.Add(new WalletTran { UserID = userId, TransDt = DateTime.Now, CRDR = "CR", Amount = 20 }); } slot.SlotStatus = SlotStatus; if (SlotStatus == 2 || SlotStatus == 3) { ParkingSlotTransaction transaction = new ParkingSlotTransaction() { SlotID = slot.SlotID, UserID = userId, ParkingInTime = DateTime.Now, VehicleNumber = null }; context.ParkingSlotTransactions.Add(transaction); } else { var getSolt = context.SlotMasters.Where(s => s.SlotNumber == slotNo && s.ParkingID == parkingId).SingleOrDefault(); if (getSolt != null) { ParkingSlotTransaction transaction = context.ParkingSlotTransactions.OrderByDescending(t => t.ParkingInTime).Where(t => t.SlotID == getSolt.SlotID && t.UserID == userId).FirstOrDefault(); transaction.ParkingOutTime = DateTime.Now; } } context.SaveChanges(); result = true; } //return result; return userId.ToString() + " " + parkingId.ToString() + " " + slotNo + " " + SlotStatus.ToString(); }
public string PostParkUnPark(int userId, int parkingId, string slotNo, bool isAcquired) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { SlotMaster slot = context.SlotMasters.Where(s => s.ParkingID == parkingId && s.SlotNumber == slotNo).SingleOrDefault(); slot.IsAcquired = isAcquired; if (isAcquired) { ParkingSlotTransaction transaction = new ParkingSlotTransaction() { SlotID = slot.SlotID, UserID = userId, ParkingInTime = DateTime.Now, VehicleNumber = null }; context.ParkingSlotTransactions.Add(transaction); } else { var getSolt = context.SlotMasters.Where(s => s.SlotNumber == slotNo && s.ParkingID == parkingId).SingleOrDefault(); if (getSolt != null) { ParkingSlotTransaction transaction = context.ParkingSlotTransactions.OrderByDescending(t => t.ParkingInTime).Where(t => t.SlotID == getSolt.SlotID && t.UserID == userId).FirstOrDefault(); transaction.ParkingOutTime = DateTime.Now; } } context.SaveChanges(); result = true; } //return result; return userId.ToString() + " " + parkingId.ToString() + " " + slotNo + " " + isAcquired.ToString(); }
public bool PostSlotMaster(SlotModel slot) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { SlotMaster parlSlot = new SlotMaster() { ParkingID = slot.ParkingID, SlotNumber = slot.SlotNumber, IsAcquired = slot.IsAcquired, IsActive = slot.IsActive }; context.SlotMasters.Add(parlSlot); context.SaveChanges(); result = true; } return result; }
public List<SelectedListModel> GetSearchParkingMaster(decimal Latitude, decimal Longitude) { List<SelectedListModel> result = new List<SelectedListModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { var qry = context.ParkingMasters.Where(s => s.IsActive == true).ToList(); qry = qry.Where(p => p.Min_Latitude <= Latitude && p.Max_Latitude >= Latitude && p.Min_Longitude <= Longitude && p.Max_Longitude >= Longitude).ToList(); //if (model != null) //{ // if (model.Longitute.HasValue && model.Latitude.HasValue) // qry = qry.Where(p => p.Min_Latitude <= model.Latitude.Value && p.Max_Latitude >= model.Latitude.Value && p.Min_Longitude <= model.Longitute.Value && p.Max_Longitude >= model.Longitute.Value).ToList(); // if (model.ParkingName != null) // qry = qry.Where(p => p.ParkingName.Contains(model.ParkingName)).ToList(); // if (model.ParkingAddress != null) // qry = qry.Where(p => p.ParkingAddress.Contains(model.ParkingAddress)).ToList(); //} if (qry.Count() > 0) { result = qry.Select(p => new SelectedListModel() { ListText = p.ParkingName, ListValue = p.ParkingID }).ToList(); } return result; } }
public bool PostUpdateSlotMaster(SlotModel slot) { bool result = false; using (SmartParkingEntities context = new SmartParkingEntities()) { SlotMaster updateSlot = context.SlotMasters.Where(s => s.ParkingID == slot.ParkingID && s.SlotID==slot.SlotID).SingleOrDefault(); updateSlot.SlotNumber = slot.SlotNumber; updateSlot.IsActive = slot.IsActive; updateSlot.IsAcquired = slot.IsAcquired; context.SaveChanges(); result = true; } return result; }
public int GetWalletAmount(int userID) { using (SmartParkingEntities DBContext = new SmartParkingEntities()) { UserProfile usr = DBContext.UserProfiles.Find(userID); usr.WalletAmount = DBContext.WalletTrans.Where(e => e.UserID == userID && e.CRDR == "CR").Sum(e => e.Amount).GetValueOrDefault(0) - DBContext.WalletTrans.Where(e => e.UserID == userID && e.CRDR == "DR").Sum(e => e.Amount).GetValueOrDefault(0); return usr.WalletAmount.GetValueOrDefault(0); } }
public List<UserProfileModel> SearchUserProfile(UserSearchModel model) { List<UserProfileModel> result = new List<UserProfileModel>(); using (SmartParkingEntities context = new SmartParkingEntities()) { var qry = context.UserProfiles.Where(s => s.IsActive == true).ToList(); if (model != null) { if (model.UserName != null) qry = qry.Where(u => u.FirstName.Contains(model.UserName)).ToList(); if (model.City != null) qry = qry.Where(u => u.City.Contains(model.City)).ToList(); if (model.Email != null) qry = qry.Where(u => u.EmailID.Contains(model.Email)).ToList(); } if (qry.Count() > 0) { result = qry.Select(u => new UserProfileModel() { ActiveVehicleNumber = u.ActiveVehicleNumber, Address1 = u.Address1, Address2 = u.Address2, City = u.City, EmailID = u.EmailID, FirstName = u.FirstName, IsActive = u.IsActive, LastName = u.LastName, MobileNumber = u.MobileNumber, Pincode = u.Pincode, State = u.State, UserID = u.UserID }).ToList(); } } return result; }