public CarPassModel GetTheLastCarPassed(string entranceID, int value) { CarPassModel car = new CarPassModel(); try { PersistencyManager db = m_Persistency_Manager; Guid entranceGuid = new Guid(entranceID.ToString()); ENTRANCE testEntrance = db.ENTRANCE.Where(br => br.entranceID == entranceGuid).FirstOrDefault(); if (testEntrance != null) { if (db != null) { Guid branchGuid = new Guid(testEntrance.branchID.ToString()); car = getCar(db, branchGuid, value); } } else { return(null); } } catch (Exception) { car = null; } return(car); }
[HttpPost] //http://localhost:1182/api/car?branchName=Cankaya... public bool Post(String entranceID, [FromBody] CarPassModel model) { try { PersistencyManager db = m_Persistency_Manager; Guid entranceGuid = new Guid(entranceID.ToString()); ENTRANCE testEntrance = db.ENTRANCE.Where(br => br.entranceName == model.entranceName && br.entranceID == entranceGuid).FirstOrDefault(); if (testEntrance != null && testEntrance.entranceName == model.entranceName) { var list = db.CARPASS.Where(br => br.entranceID == entranceGuid); foreach (var item in list.ToList()) { CARPASS delete = db.CARPASS.Where(br => br.entranceID == item.entranceID).FirstOrDefault(); db.CARPASS.DeleteObject(delete); db.SaveChanges(); } CARPASS carPass = new CARPASS(); carPass.carPassID = Guid.NewGuid(); carPass.entranceID = testEntrance.entranceID; carPass.plateNo = model.plateNo; carPass.state = model.state; carPass.image = model.image; carPass.time = model.time; carPass.dbCreationTime = DateTime.Now; db.CARPASS.AddObject(carPass); db.SaveChanges(); PushNotification(testEntrance.BRANCH.branchName, model.entranceName, "Yeni Araç Geçişi!", carPass.carPassID); } else { return(false); } } catch (Exception exc) { return(false); } return(true); }
public List <CarPassModel> getCars(PersistencyManager db, Guid branchGuid) { List <CarPassModel> carList = new List <CarPassModel>(); try { var tempList = (from cp in db.CARPASS where cp.branchID == branchGuid select new { carPassID = cp.carPassID, branchID = cp.branchID, plateNo = cp.plateNo, state = cp.state, image = cp.image }).ToList(); foreach (var item in tempList) { CarPassModel carModel = new CarPassModel(); carModel.carPassID = item.carPassID; carModel.branchID = item.branchID.ToString(); carModel.plateNo = item.plateNo; carModel.state = item.state; carModel.image = item.image; carList.Add(carModel); } } catch (Exception exc) { Console.WriteLine(exc.StackTrace); } return(carList); }
public CarPassModel getCar(PersistencyManager db, Guid branchGuid, int value) { CarPassModel carModel = new CarPassModel(); try { if (value == 1) { var tempList = (from cp in db.CARPASS where cp.ENTRANCE.branchID == branchGuid orderby cp.dbCreationTime descending select new { carPassID = cp.carPassID, entranceID = cp.entranceID, plateNo = cp.plateNo, state = cp.state, image = cp.image, time = cp.time, entranceName = cp.ENTRANCE.entranceName }).ToList(); carModel.carPassID = tempList[0].carPassID; carModel.entranceID = tempList[0].entranceID.ToString(); carModel.plateNo = tempList[0].plateNo; carModel.state = tempList[0].state; carModel.image = tempList[0].image; carModel.time = tempList[0].time; carModel.entranceName = tempList[0].entranceName; } else { var tempList = (from cp in db.CARPASS where cp.ENTRANCE.branchID == branchGuid orderby cp.dbCreationTime ascending select new { carPassID = cp.carPassID, entranceID = cp.entranceID, plateNo = cp.plateNo, state = cp.state, image = cp.image, time = cp.time, entranceName = cp.ENTRANCE.entranceName }).ToList(); carModel.carPassID = tempList[0].carPassID; carModel.entranceID = tempList[0].entranceID.ToString(); carModel.plateNo = tempList[0].plateNo; carModel.state = tempList[0].state; carModel.image = tempList[0].image; carModel.time = tempList[0].time; carModel.entranceName = tempList[0].entranceName; } } catch (Exception exc) { Console.WriteLine(exc.StackTrace); } return(carModel); }