private void button1_Click(object sender, EventArgs e) { Model.Student student = new Model.Student() { StuId = this.textBox1.Text.Trim(), StuPsd = this.textBox2.Text.Trim() }; Model.Student studentLogin = studentLogic.UserLogin(student); if (studentLogin == null) { MessageBox.Show("账号或密码错误,请重新输入"); return; } else { this.DialogResult = DialogResult.OK; //MessageBox.Show("登陆成功"); this.uid = student.StuId; 学生 a = new 学生(this.uid);//新窗体弹窗,旧的隐藏 this.Hide(); a.ShowDialog(); this.Show(); } }
public Model.Student UserLogin(Model.Student student) { string sql = "select * from dbo.student where id=@id and psw=@psw"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@id", student.StuId), new SqlParameter("@psw", student.StuPsd) }; try { SqlDataReader reader = SqlDbHelper.GetDataReader(sql, paras); if (reader.Read()) { student.StuId = reader["id"].ToString(); } else { student = null; } reader.Close(); } catch (Exception ex) { throw ex; } return(student); }
/// <summary> /// 序列化保存测试 /// </summary> /// <param name="type"></param> public static void SaveTest(JsonToolType type) { var path = Environment.CurrentDirectory + "\\json.txt"; if (File.Exists(path)) { File.Delete(path); } int length = 100000; List <Student> list = new List <Model.Student>(); for (var i = 0; i < length; i++) { Student student = new Model.Student(); student.ID = i; student.Name = "Student" + i; student.Mobile = i.ToString(); student.Address = "city" + i.ToString(); list.Add(student); } var date1 = DateTime.Now; SaveJsonFile <Student>(list, path, type, 1000); var date2 = DateTime.Now; Console.WriteLine("序列化用时:{0}秒", (date2 - date1).TotalSeconds); }
public object getByStuId(string stuId) { Student stu = null; string selectSql = "SELECT * FROM t_student WHERE stuId=@stuId"; SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@stuId", stuId) }; DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas); if (ds.Tables[0].Rows.Count != 0) { stu = new Student(); stu.Id = ds.Tables[0].Rows[0][0].ToString(); stu.StuId = ds.Tables[0].Rows[0][1].ToString(); stu.Name = ds.Tables[0].Rows[0][2].ToString(); stu.Gender = ds.Tables[0].Rows[0][3].ToString(); stu.Birth = ds.Tables[0].Rows[0][4].ToString(); stu.Phone = ds.Tables[0].Rows[0][5].ToString(); stu.Address = ds.Tables[0].Rows[0][6].ToString(); stu.ClassID = ds.Tables[0].Rows[0][7].ToString(); stu.UserID = ds.Tables[0].Rows[0][8].ToString(); } return stu; }
public AddStudent(Student stu,StudentContext context) { InitializeComponent(); BindClassesComboxData(); this.stu = stu; this.context = context; }
public IHttpActionResult PutStudent(int id, Student student) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != student.StudentId) { return BadRequest(); } db.Entry(student).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!StudentExists(id)) { return NotFound(); } else { throw; } } return StatusCode(HttpStatusCode.NoContent); }
//根据学员编号获取学员信息 //public Model.Student GetStudentBLL(string id) //{ // return new DAL.StudentDAL().GetStudentDAL(" and [StudentID]='" + id + "'")[0]; //} //添加新学员 public int InsertStudentBLL(Model.Student stu) { if (!new Rule.StudentRule().TestInsert(stu.StudentID)) { return(-3); } return(new DAL.StudentDAL().InsertStudentDAL(stu)); }
public void Add(Student student) { this.OpenPage(); if (StudentsInCoursesPage.Instance.FindExistingStudentIncourseRowIndex(student) != int.MaxValue) { this.DeleteStudentInCourse(student); } this.UpdateForm(student); }
public IHttpActionResult PostStudent(Student student) { if (!ModelState.IsValid) { return BadRequest(ModelState); } db.Students.Add(student); db.SaveChanges(); return CreatedAtRoute("DefaultApi", new { id = student.StudentId }, student); }
//更新学员信息 public int UpdateStudentDAL(Model.Student stu) { string sql = "Update [Student] set [State]=0"; if (!string.IsNullOrEmpty(stu.StudentName)) { sql += ",[StudentName]='" + stu.StudentName + "'"; } if (!string.IsNullOrEmpty(stu.Age.ToString())) { sql += ",[Age]='" + stu.Age + "'"; } if (!string.IsNullOrEmpty(stu.Gender)) { sql += ",[Gender]='" + stu.Gender + "'"; } if (!string.IsNullOrEmpty(stu.dormitoryID.ToString())) { sql += ",[dormitoryID]='" + stu.dormitoryID + "'"; } if (!string.IsNullOrEmpty(stu.Place)) { sql += ",[Place]='" + stu.Place + "'"; } if (!string.IsNullOrEmpty(stu.Accommodationtime.ToString())) { sql += ",[Accommodationtime]='" + stu.Accommodationtime + "'"; } if (!string.IsNullOrEmpty(stu.leavetime.ToString())) { sql += ",[leavetime]='" + stu.leavetime + "'"; } if (!string.IsNullOrEmpty(stu.Phone)) { sql += ",[Phone]='" + stu.Phone + "'"; } if (!string.IsNullOrEmpty(stu.Explains)) { sql += ",[Explains]='" + stu.Explains + "'"; } sql += " where [StudentID]='" + stu.StudentID + "'"; return(DBHelper.ExecQuery(sql)); }
private void btnAddStudent_Click(object sender, EventArgs e) { var stu = new Student(); var student = new AddStudent(stu,context); if (student.ShowDialog() == DialogResult.OK) { context.Students.Add(stu); context.SaveChanges(); ClearStudentsData(); } }
/// <summary> /// Register user with adding one to database /// </summary> /// <param name="name">Name of new user</param> /// <param name="surname">Surname of new user</param> /// <param name="zal">Student ticket number of new user</param> /// <param name="username">Username of new user</param> /// <param name="password">Password of new user</param> /// <returns></returns> public bool registerUser(ParamsForRegister values) { Model.Person person = new Model.Person { Name = values.name, Surname = values.surname, Password = values.password, Photo = userPhoto, Username = values.username }; Model.Student student = new Model.Student { TicketNumber = long.Parse(values.ticket), ReportCard = long.Parse(values.zal), PersonID = values.username, GroupID = values.group }; if (service.LoadLogInPersonAsync(values.username) == null) { service.CreatePersonAsync(person).Wait(); service.CreateStudentAsync(student).Wait(); return(true); } else { return(false); } }
// if (Info != null) // { // for (int index = 0; index < Info.Tables.Rows.Count; index++) // { // Model.Student element = new Model.Student(); // element.Id = Convert.ToInt32(Info.Tables.Rows[0]["student_id"].ToString()); // element.Name = Info.Tables[index].Rows[0]["student_name"].ToString(); // element.Gender = Info.Tables[index].Rows[0]["student_gender"].ToString(); // element.PhoneNumber = Convert.ToInt64(Info.Tables[index].Rows[0]["student_phone"].ToString()); // element.Marks = Convert.ToInt16(Info.Tables[index].Rows[0]["student_marks"].ToString()); // element.Address = Info.Tables[index].Rows[0]["student_address"].ToString(); // result.Add(element); // } // } // return result; //} public Student GetStudentById(int Id) { var dbManager = new DBManager("connection"); var parameters = new List <IDbDataParameter>(); // parameters.Add(dbManager.CreateParameter("@Event", "SelectById", DbType.String)); parameters.Add(dbManager.CreateParameter("@Student_id", Id, DbType.Int32)); var Info = dbManager.GetDataTable("SelectById", CommandType.StoredProcedure, parameters.ToArray()); Student element = new Model.Student(); element.Id = Convert.ToInt32(Info.Rows[0]["student_id"].ToString()); element.Name = Info.Rows[0]["studentFirst_Name"].ToString(); element.Gender = Info.Rows[0]["student_Gender"].ToString(); element.PhoneNumber = Convert.ToInt64(Info.Rows[0]["studentMobile_Number"].ToString()); // element.Marks = Convert.ToInt16(Info.Rows[0]["student_marks"].ToString()); element.Address = Info.Rows[0]["student_Address"].ToString(); return(element); }
public static void Main() { string message = "Hello!"; char[] substring = Operations.Subsequence(message.ToCharArray(), 2, 3); Console.WriteLine(substring); int[] array = new int[] { -1, 3, 2, 1 }; int[] subArray = Operations.Subsequence(array, 0, 2); Console.WriteLine(string.Join(" ", subArray)); int[] fullArray = Operations.Subsequence(array, 0, 4); Console.WriteLine(string.Join(" ", fullArray)); int[] emptyArray = Operations.Subsequence(array, 0, 0); Console.WriteLine(string.Join(" ", emptyArray)); Console.WriteLine(Operations.ExtractEnding("I love C#", 2)); Console.WriteLine(Operations.ExtractEnding("Nakov", 4)); Console.WriteLine(Operations.ExtractEnding("beer", 4)); // Console.WriteLine(Operations.ExtractEnding("Hi", 100)); Console.WriteLine(Operations.CheckPrime(23)); Console.WriteLine(Operations.CheckPrime(33)); List<Exam> peterExams = new List<Exam>() { new SimpleMathExam(2), new CSharpExam(55), new CSharpExam(100), new SimpleMathExam(1), new CSharpExam(0), }; Student peter = new Student("Peter", "Petrov", peterExams); double peterAverageResult = peter.CalcAverageExamResultInPercents(); Console.WriteLine("Average results = {0:p0}", peterAverageResult); }
private void frmNewStudent_Load(object sender, EventArgs e) { LoadCombos(); if (this.did > 0) { Model.Student degObj = DAL.StudentsDAL.GetStudentByID(this.did); if (degObj != null) { lblStudentID.Text = degObj.StudentID.ToString(); txtName.Text = degObj.Name; txtNIC.Text = degObj.NIC; cmbGender.SelectedValue = degObj.Gender; txtFavSports.Text = degObj.FavSports; txtMobileNo.Text = degObj.MobileNo; txtHomeNo.Text = degObj.HomeNo; cmbDegree.SelectedValue = degObj.DegreeID; txtCurrentSemesterNo.Text = degObj.CurrentSemesterNo.ToString(); } //End of If } //end of outer if }
private void btnSave_Click(object sender, EventArgs e) { if (txtName.Text.Trim() == "") { MessageBox.Show("Name can't be empty"); return; } Model.Student degObj = new Model.Student(); degObj.StudentID = this.did; //For New, this will be zero degObj.Name = txtName.Text.Trim(); degObj.NIC = txtNIC.Text.Trim(); degObj.Gender = cmbGender.SelectedValue.ToString(); degObj.FavSports = txtFavSports.Text.Trim(); degObj.MobileNo = txtMobileNo.Text.Trim(); degObj.HomeNo = txtHomeNo.Text.Trim(); degObj.DegreeID = Convert.ToInt32(cmbDegree.SelectedValue); degObj.CurrentSemesterNo = Convert.ToInt32(txtCurrentSemesterNo.Text.Trim()); int id = DAL.StudentsDAL.SaveStudent(degObj); if (id > 0) { MessageBox.Show("Data has been saved"); lblStudentID.Text = ""; txtName.Text = ""; txtNIC.Text = ""; cmbGender.SelectedIndex = 0; txtFavSports.Text = ""; txtMobileNo.Text = ""; txtHomeNo.Text = ""; cmbDegree.SelectedIndex = 0; txtCurrentSemesterNo.Text = ""; } }
public List <Model.Student> GetInfo() { List <Model.Student> result = new List <Model.Student>(); var dbManager = new DBManager("connection"); var parameters = new List <IDbDataParameter>(); // parameters.Add(dbManager.CreateParameter("@Event", "Select", DbType.String)); var Info = dbManager.GetDataTable("Select_Student", CommandType.StoredProcedure, parameters.ToArray()); for (int index = 0; index < Info.Rows.Count; index++) { Model.Student element = new Model.Student(); element.Id = Convert.ToInt32(Info.Rows[index]["student_id"].ToString()); element.Name = Info.Rows[index]["studentFirst_Name"].ToString(); element.Gender = Info.Rows[index]["student_Gender"].ToString(); element.PhoneNumber = Convert.ToInt64(Info.Rows[index]["studentMobile_Number"].ToString()); // element.Marks = Convert.ToInt16(Info.Rows[index]["student_marks"].ToString()); element.Address = Info.Rows[index]["student_Address"].ToString(); result.Add(element); } return(result); }
public Model.Student UserLogin(Model.Student student) { return(studentDao.UserLogin(student)); }
//添加新学员 public int InsertStudentDAL(Model.Student stu) { return(DBHelper.ExecQuery("Insert into [Student] ([StudentName],[Age],[Gender],[dormitoryID],[Place],[Accommodationtime],[leavetime],[Phone],[Explains]) values('" + stu.StudentName + "','" + stu.Age + "','" + stu.Gender + "','" + stu.dormitoryID + "','" + stu.Place + "','" + stu.Accommodationtime + "','" + stu.leavetime + "','" + stu.Phone + "','" + stu.Explains + "')")); }
public void DeleteStudentInCourse(Student student) { StudentsInCoursesPage.Instance.Browser.Manager.DialogMonitor.AddDialog(new ConfirmDialog(StudentsInCoursesPage.Instance.Browser, DialogButton.OK)); StudentsInCoursesPage.Instance.Browser.Manager.DialogMonitor.Start(); var rowForDeleteIndex = StudentsInCoursesPage.Instance.FindExistingStudentIncourseRowIndex(student); var buttonToClick = StudentsInCoursesPage.Instance.GridPage.DeleteButton[rowForDeleteIndex]; buttonToClick.ScrollToVisible(); buttonToClick.Click(); }
//更新学员信息 public string UpdateStudentBLL(Model.Student stu) { return(Option(new DAL.StudentDAL().UpdateStudentDAL(stu), "更新")); }
public Student GetUnenrolledStudent() { CoursesUnenrolledStudentsPage helpPage = new CoursesUnenrolledStudentsPage(); helpPage.Navigate(); helpPage.VerifyTitle(); Thread.Sleep(1000); helpPage.Browser.RefreshDomTree(); string name = helpPage.GridPage.GridTable.Rows[0].Cells[2].InnerText; string course = helpPage.GridPage.GridTable.Rows[0].Cells[1].InnerText; Student student = new Student(name, course); return student; }
public void AssertNewUserInCourseIsCreated(Student user) { Thread.Sleep(2000); StudentsInCoursesPageAsserter.AssertStudentInCourseIsEnrolled(StudentsInCoursesPage.Instance, user); }
public void UpdateForm(Student student) { StudentsInCoursesPage.Instance.OpenStudentsInCourseForm(); StudentsInCoursesFormPage.Instance.FillData(student); StudentsInCoursesFormPage.Instance.UpdateButton.MouseClick(); }