예제 #1
0
        public IHttpActionResult Put(int id, UserDetail changepassword)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            //if (id != changepassword.UID)
            //{
            //    return BadRequest();
            //}

            //db.Entry(changepassword).State = EntityState.Modified;
            using (var a = new BusReservationEntities())
            {
                var user = a.UserDetails.Where(m => m.UID == id).FirstOrDefault <UserDetail>();
                if (user != null)
                {
                    if (changepassword.Password != null)
                    {
                        user.Password = changepassword.Password;
                    }
                    a.SaveChanges();
                }
                else
                {
                    return(NotFound());
                }
            }
            return(Ok("updated password"));
        }
        private void addbtn_Click(object sender, EventArgs e)
        {
            BusReservationEntities db = new BusReservationEntities();
            Customer customers        = new Customer
            {
                Name        = nametxt.Text,
                FatherName  = fnametxt.Text,
                DateOfBirth = birthdate.Value,
                Email       = emailtext.Text,
                PhoneNo     = phonetxt.Text,
                Address     = addresstext.Text
            };


            if (passText.Text == passConfText.Text)
            {
                db.Customers.Add(customers);
                db.SaveChanges();
                db.Logins.Add(new Login
                {
                    custId   = customers.Id,
                    username = nametxt.Text,
                    password = passText.Text
                });
                db.SaveChanges();
                MessageBox.Show("Customer is added");
                this.Hide();
            }
            else
            {
                MessageBox.Show("Password is not match with Confrim password");
            }
        }
        private void LoginBtn_Click(object sender, EventArgs e)
        {
            BusReservationEntities db = new BusReservationEntities();

            if (usertext.Text != string.Empty && passtext.Text != string.Empty)
            {
                var user = db.AdminLogins.Where(a => a.username.Equals(usertext.Text)).FirstOrDefault();
                //var custUser = db.Customer_login.Where(a => a.Username.Equals(usertext.Text)).SingleOrDefault();
                if (user != null)
                {
                    if (user.password.Equals(passtext.Text))
                    {
                        new AdminMenu().Show();
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("Wrong password");
                    }
                }
                else
                {
                    MessageBox.Show("Wrong username");
                }
            }
            else
            {
                MessageBox.Show("Please fill all form");
            }
        }
        private void updatebtn_Click(object sender, EventArgs e)
        {
            db = new BusReservationEntities();
            Customer customers = db.Customers.Where(a => a.Id == id).FirstOrDefault();

            customers.Name        = nametxt.Text;
            customers.FatherName  = fnametxt.Text;
            customers.Email       = emailtext.Text;
            customers.DateOfBirth = birthdate.Value;
            customers.PhoneNo     = phonetxt.Text;
            customers.Address     = addresstext.Text;
            db.SaveChanges();
            MessageBox.Show("Record Updated");
        }
 public CustomerDetail(int?Id)
 {
     InitializeComponent();
     if (Id != null)
     {
         addbtn.Visible = false;
         db             = new BusReservationEntities();
         Customer customers = db.Customers.Where(a => a.Id == Id).FirstOrDefault();
         id               = customers.Id;
         nametxt.Text     = customers.Name;
         fnametxt.Text    = customers.FatherName;
         emailtext.Text   = customers.Email;
         birthdate.Value  = (DateTime)customers.DateOfBirth;
         phonetxt.Text    = customers.PhoneNo;
         addresstext.Text = customers.Address;
     }
     else
     {
         updatebtn.Visible = false;
     }
 }
 public IHttpActionResult Put(int id, Ticket valuechange)
 {
     if (!ModelState.IsValid)
     {
         return(BadRequest("Not a valid model"));
     }
     using (var ue = new BusReservationEntities())
     {
         var existingdetails = ue.Tickets.Where(p => p.BookingUserID == id).FirstOrDefault <Ticket>();
         if (existingdetails != null)
         {
             existingdetails.TicketBookingStatus = 0;
             ue.SaveChanges();
         }
         else
         {
             return(NotFound());
         }
     }
     return(Ok());
 }
 public IHttpActionResult PutUser(int id, EditUser valuechange)
 {
     if (!ModelState.IsValid)
     {
         return(BadRequest("Not a valid model"));
     }
     using (var ue = new BusReservationEntities())
     {
         var existingdetails = ue.UserDetails.Where(p => p.UID == id).FirstOrDefault <UserDetail>();
         if (existingdetails != null)
         {
             if (valuechange.PhoneNumber != null)
             {
                 existingdetails.PhoneNumber = valuechange.PhoneNumber;
             }
             if (valuechange.Address != null)
             {
                 existingdetails.Address = valuechange.Address;
             }
             if (valuechange.EmailId != null)
             {
                 existingdetails.GuestUserDetail.EmailId = valuechange.EmailId;
             }
             if (valuechange.Password != null)
             {
                 existingdetails.Password = valuechange.Password;
             }
             if (valuechange.Address == null)
             {
                 existingdetails.Address = existingdetails.Address;
             }
             ue.SaveChanges();
         }
         else
         {
             return(NotFound());
         }
     }
     return(Ok());
 }
예제 #8
0
        public CustomerTicketReservation(Login user, BusInfo busUser)
        {
            this.user          = user;
            this.busUser       = busUser;
            this.selectedSeats = SelectSeat.selectedSeats;

            db = new BusReservationEntities();

            InitializeComponent();
            usernameLb.Text = user.username.ToUpper();
            try{
                busId.Text = this.busUser.BusNo.ToString();
            }catch (Exception)
            {
            }

            var item = db.Customers.Where(a => a.Id == this.user.custId).FirstOrDefault();

            CustomerId.Text = item.Id.ToString();
            try
            {
                customerNameTxt.Text = item.Name;
                fatherNameTxt.Text   = item.FatherName;
                dateTimePicker1.Text = item.DateOfBirth.ToString();
                emailTxt.Text        = item.Email;
                phoneNumTxt.Text     = item.PhoneNo;
                addressTxt.Text      = item.Address;
            }
            catch (Exception e)
            {
                MessageBox.Show(e.GetBaseException().ToString());
            }

            selectSeatLb.Text = SelectSeat.seats;

            BindSource();
            BindDestination();
        }
예제 #9
0
        private void LoginBtn_Click(object sender, EventArgs e)
        {
            BusReservationEntities db = new BusReservationEntities();

            if (usertext.Text != "User Name" && passtext.Text != "Password")
            {
                var user = db.Logins.Where(a => a.username.Equals(usertext.Text)).FirstOrDefault();
                //var custUser = db.Customer_login.Where(a => a.Username.Equals(usertext.Text)).SingleOrDefault();
                if (user != null)
                {
                    if (user.password.Equals(passtext.Text))
                    {
                        //MessageBox.Show("you are login");
                        if (remmechk.Checked)
                        {
                            Properties.Settings.Default.UserName = usertext.Text;
                            Properties.Settings.Default.Password = passtext.Text;
                            Properties.Settings.Default.Save();
                        }

                        new CustomerMenu(user).Show();
                        this.Hide();
                    }
                    else
                    {
                        MessageBox.Show("Wrong password");
                    }
                }
                else
                {
                    MessageBox.Show("Wrong username");
                }
            }
            else
            {
                MessageBox.Show("Please fill all form");
            }
        }
예제 #10
0
 public DBAccess()
 {
     db = new BusReservationEntities();
 }