Esempio n. 1
0
        public void postWork(Models.WorkListModel value)
        {
            var db = new MyDBModels.DB();

            MyDBModels.WorkList workList = new MyDBModels.WorkList();
            workList.DriverId             = value.DriverId;
            workList.BusId                = value.BusId;
            workList.SecondNameDispatcher = value.SecondNameDispatcher;
            workList.DateAction           = value.DateAction;
            db.workList.Add(workList);


            MyDBModels.Bus busModel = db.bus.Where(b => b.BusId == value.BusId).FirstOrDefault();
            string         title    = "Bus: " + busModel.BusNumber.ToString() + "/" + busModel.Model;
            string         info     = "Date: " + value.DateAction + "\nDispatcher: " + value.SecondNameDispatcher;

            string number = EncryptClass.DESEncrypt(db.driver.Where(b => b.DriverId == value.DriverId).FirstOrDefault().DriverNumber.ToString());

            MyDBModels.Account accountModel = db.account.Where(b => b.NumberWorker == number).FirstOrDefault();
            string             token        = accountModel.Token;

            sendRequestToFirebase("\"" + title + "\"", "\"" + info + "\"", "\"" + token + "\"");

            db.SaveChanges();
        }
Esempio n. 2
0
        public MyDBModels.Bus getDataById(int id)
        {
            var db = new MyDBModels.DB();

            MyDBModels.Bus busModel = db.bus.Where(b => b.BusId == id).FirstOrDefault();
            return(busModel);
        }
        // DELETE api/values/
        public void Delete(int id)
        {
            var db = new MyDBModels.DB();

            MyDBModels.Bus bus = db.bus.Where(b => b.BusId == id).FirstOrDefault();
            if (bus != null)
            {
                db.bus.Remove(bus);
                db.SaveChanges();
            }
        }
        // POST api/values
        public void Post(Models.BusModel newbus)
        {
            var db = new MyDBModels.DB();

            MyDBModels.Bus bus = new MyDBModels.Bus();
            bus.BusCondition = newbus.Condition;
            bus.BusNumber    = newbus.BusNomber;
            bus.Model        = newbus.Model;
            db.bus.Add(bus);
            db.SaveChanges();
        }
Esempio n. 5
0
 public MyDBModels.Bus logicMethodForGetData(int id)
 {
     MyDBModels.Bus data = dataAccess.getDataById(id);
     return(data);
 }