Пример #1
0
        public void CreateHistory(string carname)
        {
            tblCarDAO dao = new tblCarDAO();
            tblCar    car = dao.getCarByName(carname);

            if (dao.Getposition(car.carID) != null)
            {
                DataClasses1DataContext db = new DataClasses1DataContext();

                var carpark = (from table in db.tblCarParks where table.position == dao.Getposition(car.carID) select table).SingleOrDefault();
                if (carpark.timeIn == null)
                {
                    carpark.timeIn = DateTime.Now;
                }
                db.SubmitChanges();

                tblHistory his = new tblHistory();
                his.carID    = car.carID;
                his.position = dao.Getposition(car.carID);
                his.timeIn   = DateTime.Now;
                his.userID   = car.userID;
                Random rd = new Random();
                his.keyCode = rd.Next(1000, 9999).ToString();

                db.tblHistories.InsertOnSubmit(his);
                db.SubmitChanges();
                var caru = (from table in db.tblCars where table.carName == carname select table).Single();
                caru.status = "activated";
                db.SubmitChanges();

                string phone = (from table in db.tblUsers
                                where table.userID
                                == car.userID
                                select table.phoneNumber).Single();
                SMSSender sms         = new SMSSender();
                bool      checksended = sms.sendSMS(phone, his.keyCode);
                if (checksended == true)
                {
                    System.Windows.Forms.MessageBox.Show("your keycode is already sended!!!");
                }
            }
            else
            {
                System.Windows.Forms.MessageBox.Show("you have no place in plan");
            }
        }
        public void CreateHistory(string carname)
        {
            cameraCheck camc = new cameraCheck();
            tblCar      car  = camc.getCarByName(carname);

            if (camc.Getposition(car.carID) != 0)
            {
                DataClasses1DataContext db = new DataClasses1DataContext();

                tblHistory his = new tblHistory();
                his.carID    = car.carID;
                his.position = camc.Getposition(car.carID).ToString();
                his.timeIn   = DateTime.Now;
                his.userID   = car.userID;
                Random rd = new Random();
                his.keyCode = rd.Next(1000, 9999).ToString();

                db.tblHistories.InsertOnSubmit(his);
                db.SubmitChanges();

                string phone = (from table in db.tblUsers
                                where table.userID
                                == car.userID
                                select table.phoneNumber).Single();
                SMSSender sms         = new SMSSender();
                bool      checksended = sms.sendSMS(phone, his.keyCode);
                if (checksended == true)
                {
                    System.Windows.Forms.MessageBox.Show("your keycode is already sended!!!");
                }
            }
            else
            {
                System.Windows.Forms.MessageBox.Show("you have no place in plan");
            }
        }