Esempio n. 1
0
        /// <summary>
        /// 学员登录
        /// </summary>
        private void traineeLogin()
        {
            if (traineeJobNumberTextBox.Text.Trim().Length > 0 && traineePwdTextBox.Text.Trim().Length > 0)
            {
                string jobNumber = traineeJobNumberTextBox.Text.Trim();
                string pwd       = Tool.getMd5Str(traineePwdTextBox.Text.Trim());

                string        conStr = "server=localhost;database=training;integrated security=SSPI";
                SqlConnection con    = new SqlConnection(conStr);
                con.Open();
                string         sql     = "select * from trainees where jobNumber='" + jobNumber + "' and pwd='" + pwd + "'";
                SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                DataSet        ds      = new DataSet();
                adapter.Fill(ds, "trainees");
                int rows = ds.Tables["trainees"].Rows.Count;

                if (rows > 0)
                {
                    Trainee     trainee   = new Trainee(ds);
                    TraineeForm traineeFm = new TraineeForm(trainee);
                    traineeFm.Show();
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("员工编号或密码错误");
                }
            }
            else
            {
                MessageBox.Show("请正确输入员工编号和密码");
            }
        }
        public void UpdateTrainee(TraineeForm t)
        {
            if (t.txtTraineeName.Text == "")
            {
                MessageBox.Show("Please,Enter Name");
            }
            else if (!IsAllLetters(t.txtTraineeName.Text))
            {
                MessageBox.Show("Please, Enter Letters Only");
            }
            else
            {
                string gen;
                if (t.rbtnTraineeFemale.IsChecked == true)
                {
                    gen = "Female";
                }
                else
                {
                    gen = "Male";
                }

                int Id = int.Parse(t.txtTraineeID.Text.ToString());
                var tr = (from tre in context.Trainee
                          where tre.ID == Id
                          select tre).FirstOrDefault();
                tr.Name           = t.txtTraineeName.Text;
                tr.Qualification  = t.txtTraineeQualification.Text;
                tr.Gender         = gen;
                tr.MilitaryStatus = t.txtTraineeMilitaryStatus.Text;
                context.SaveChanges();
                MessageBox.Show("Sucsesfuly updated");
            }
        }
        public ActionResult Add(TraineeForm form)
        {
            if (ModelState.IsValid)
            {
                using (UserContext db = new UserContext())
                {
                    TraineeForm currentForm = new TraineeForm()
                    {
                        Name                = form.Name,
                        Surname             = form.Surname,
                        MiddleName          = form.MiddleName,
                        NameOfTheUniversity = form.NameOfTheUniversity,
                        UniversityCourse    = form.UniversityCourse,
                        Faculty             = form.Faculty,
                        Phone               = form.Phone,
                        Email               = form.Email,
                        Info                = form.Info,
                    };

                    currentForm.CreateDate         = DateTime.Now;
                    currentForm.ChangeDate         = DateTime.Now;
                    currentForm.FormCreater        = User.Identity.Name;
                    currentForm.AuthorOfLastChange = User.Identity.Name;

                    User user = db.Users.FirstOrDefault(u => u.Email == User.Identity.Name);

                    db.TraineeForms.Add(currentForm);
                    user.TraineeForms.Add(currentForm);

                    db.SaveChanges();
                    return(RedirectToAction("Home", "Form"));
                }
            }
            return(View(form));
        }
        public void AddTrainee(TraineeForm t, int LabID)
        {
            if (t.txtTraineeName.Text == "")
            {
                MessageBox.Show("Please,Enter Name");
            }
            else
            {
                string gen;
                if (t.rbtnTraineeFemale.IsChecked == true)
                {
                    gen = "Female";
                }
                else
                {
                    gen = "Male";
                }
                Trainee trainee = new Trainee()
                {
                    Name           = t.txtTraineeName.Text,
                    Qualification  = t.txtTraineeQualification.Text,
                    MilitaryStatus = t.txtTraineeMilitaryStatus.Text,
                    Gender         = gen,
                    LabID          = LabID
                };

                context.Trainee.Add(trainee);
                context.SaveChanges();
                MessageBox.Show("Trainee inserted");
            }
        }
 public void FillTraineeList(TraineeForm tr)
 {
     // TraineeList t = new TraineeList();
     // t.lstTrainee.DisplayMemberPath = "Name";
     // t.lstTrainee.SelectedValuePath = "ID";
     //t.lstTrainee.ItemsSource = context.Trainee.ToList();
 }
 public ActionResult Edit(TraineeForm form)
 {
     using (UserContext db = new UserContext())
     {
         db.Entry(form).State    = EntityState.Modified;
         form.AuthorOfLastChange = User.Identity.Name;
         form.ChangeDate         = DateTime.Now;
         db.SaveChanges();
         return(RedirectToAction("Home", "Form"));
     }
 }
 public ActionResult Delete(int?id)
 {
     if (id == null)
     {
         return(HttpNotFound());
     }
     using (UserContext db = new UserContext())
     {
         TraineeForm form = db.TraineeForms.Find(id);
         if (form == null)
         {
             return(HttpNotFound());
         }
         return(View(form));
     }
 }
 public ActionResult DeleteConfirmed(int?id)
 {
     if (id == null)
     {
         return(HttpNotFound());
     }
     using (UserContext db = new UserContext())
     {
         TraineeForm form = db.TraineeForms.Find(id);
         if (form == null)
         {
             return(HttpNotFound());
         }
         db.TraineeForms.Remove(form);
         db.SaveChanges();
         return(RedirectToAction("Home", "Form"));
     }
 }