/// <summary> /// Converts a <see cref="BusinessEntities.Student"/> class to a <see cref="Model.Student"/> /// class. The BusinessEntities.Student class is referenced by this Business Logic Layer /// while the Model.Student class is referenced by the Data Access Layer. /// </summary> /// <param name="businessStudent">The instance of the BusinessEntities.Student class.</param> /// <returns>A corresponding instance of the Model.Student class.</returns> public Model.Student ToModel(BusinessEntities.Student businessStudent) { Model.Student modelStudent = new Model.Student(); modelStudent.Id = businessStudent.Id; modelStudent.Firstname = businessStudent.Firstname; modelStudent.Surname = businessStudent.Surname; modelStudent.DOB = DateTime.Parse(businessStudent.DOB); modelStudent.Course = businessStudent.Course; modelStudent.YearOfStudy = (Model.YearOfStudyEnum)businessStudent.YearOfStudy; modelStudent.Address = new Model.Address(); modelStudent.Address.Address1 = businessStudent.Address.Address1; modelStudent.Address.Town = businessStudent.Address.Town; modelStudent.Address.County = businessStudent.Address.County; modelStudent.Address.PostCode = businessStudent.Address.PostCode; modelStudent.Contact = new Model.ContactDetail(); modelStudent.Contact.HomePhone = businessStudent.Contact.HomePhone; modelStudent.Contact.MobilePhone = businessStudent.Contact.MobilePhone; modelStudent.Contact.HomeEmail = businessStudent.Contact.HomeEmail; modelStudent.Contact.StudentEmail = businessStudent.Contact.StudentEmail; return modelStudent; }
protected void Page_Load(object sender, EventArgs e) { BLL.Student studentbll = new BLL.Student(); string username=Request.QueryString["Username"]; Model.Student student = new Model.Student(); student = studentbll.GetModel(username); this.preferedprogram.Text = student.FirstProject.ToString(); this.altprogram.Text = student.SecondProject.ToString(); this.graduated.Text = student.GraduateSchool; this.major.Text = student.Major; this.gradyear.Text = student.GraduateTime.ToString(); this.startyear.Text = student.EntranceTime.ToString(); this.englishskill.Text = student.EnglishLevel; this.gpa.Text = student.UndergraduateGPA.ToString(); this.rewardspunisment.Text = student.RewardsAndPunish; this.name.Text = student.Realname; this.gender.Text = student.Sex; this.idno.Text = student.IDCardNumber; // this.politic.Text政治面貌 this.nationality.Text = student.Ethnic; this.city.Text = student.DomicileAddress; this.address.Text = student.Address; this.zipcode.Text = student.Postalcode.ToString(); this.phone.Text = student.PhoneNumber.ToString(); this.email.Text = student.Email; this.famaddress.Text = student.FamilyAddress; //this.famzipcode.Text //this.parid.Valu //this.parrelation //this.parwork //this.parphone }
// ctor with fake data public Student() { // Create command instance - use RealyCommand to call AddContact method _addStudent = new RelayCommand(AddStudentCommand){IsEnabled = true}; _studentList = new List<Model.Student>(); _studentList.Add(new Model.Student(){FirstName = "Liv", LastName = "Vang", ExamGroup = "None"}); _studentList.Add(new Model.Student(){FirstName = "Mikkel", LastName = "vang", ExamGroup = "Lazy"}); _studentList.Add(new Model.Student() { FirstName = "Ebbe", LastName = "Vang", ExamGroup = "Winners" }); _studentList.Sort(); _currentStudent = _studentList[0]; }
protected void submit_Click(object sender, EventArgs e) { StudentAuth = (db.Students.Where(u => u.InvoiceNumber == invoiceNum.Text && u.Password == pin.Text).Count() > 0) ? db.Students.FirstOrDefault(u => u.InvoiceNumber == invoiceNum.Text && u.Password == pin.Text) : null; if (StudentAuth==null) { errorDisplay.Text = "Username or Password is incorrect"; } else { string parameter ="grab="+StudentAuth.StudentKey; Response.Redirect("Profile.aspx?"+parameter); } }
public Studenti() { list = new ObservableCollection<Model.Student>(); list.Add(new Model.Student() { Jmeno = "Jarda", Prijmeni = "Navratil", Cislo = 123 }); list.Add(new Model.Student() { Jmeno = "Marek", Prijmeni = "Novy", Cislo = 147 }); Selected = list[0]; Pridat = new RelayCommand( (o) => { var student = new Model.Student() { Jmeno = "Jmeno", Prijmeni = "Prijmeni" }; list.Add(student); Selected = student; }, (o) => list.Count < 5); }
/// <summary> /// 根据名字取得用户信息 /// </summary> /// <param name="name">要check的用户名</param> /// <returns></returns> public Model.Student GetName(string name) { DataTable dt = SqlHelper.ExecuteDataTable("select * from Student where Name=@name", new SqlParameter("@name", name)); //int i = dt.Rows.Count; //DataTable中的行数,若1行都没有,说明返回的DataTable是一个null //即:DataRow中没有数据(但DataTable仍是一张表) Model.Student model = null; if (dt.Rows.Count > 0) //DataTable不为null时(有用户名时) { DataRow dr = dt.Rows[0]; model = new Model.Student(); model.Name = dr[1].ToString(); model.Password = dr[2].ToString(); } return model; }
protected void submit_Click(object sender, EventArgs e) { /* db = new Education365Context(); string[] lines = File.ReadAllLines(Server.MapPath("files/session.csv")); for (int i = 0; i < lines.Length; i++) { string[] members = lines[i].Split(','); Models.Session session = new Models.Session(); session.SessionId = int.Parse(members[0]); session.Name = members[1]; session.Current = (members[2] == "1"); db.Sessions.Add(session); } //db.SaveChanges(); Response.Write("Complete!");*/ string FileName = System.IO.Path.GetFileName(uploadCSV.PostedFile.FileName); uploadCSV.PostedFile.SaveAs(Server.MapPath("~/SchoolFile/" + FileName)); string csvPath =uploadCSV.PostedFile.FileName; //response.Write(csvPath.ToString()); string[] readCsv = System.IO.File.ReadAllLines(Server.MapPath("~/SchoolFile/" + FileName)); for (int i = 0; i < readCsv.Length; i++) { string[] members = readCsv[i].ToString().Split(','); Model.Student student = new Model.Student(); student.Surname = members[0]; student.Firstname = members[1]; student.Middlename = members[2]; student.Major = members[3]; student.Minor = members[4]; student.Level = double.Parse(members[5].ToString()); student.FacultyName = members[6].ToString(); student.InvoiceNumber = Guid.NewGuid().ToString().Substring(0, new Guid().ToString().IndexOf("-")); student.StudentKey = System.Guid.NewGuid().ToString(); db.Students.Add(student); db.SaveChanges(); } //Response.Write("Data Inserted"); }
protected void submit_Click(object sender, EventArgs e) { try { var InsertResult = new Model.Student { // DateEntered=DateTime.Now, StudentKey = System.Guid.NewGuid().ToString(), Firstname = firstname.Text.ToUpper(), Surname = surname.Text.ToUpper(), Middlename = othername.Text.ToUpper(), Nationality = country.SelectedItem.Text.ToUpper(), SOR = sor.SelectedItem.Text.ToUpper(), LGA = lga.Text.ToUpper(), Email = email.Text, PhoneNumber = phoneNumber.Text, Gender = sex.Text.ToUpper(), FacultyName = school.SelectedItem.Text, Major = major.SelectedItem.Value, Minor = minor.SelectedItem.Value, Level = 100, InvoiceNumber = Guid.NewGuid().ToString().Substring(0, new Guid().ToString().IndexOf("-")), }; db.Students.Add(InsertResult); db.SaveChanges(); string parameters = "grab="+ StudentKey; //string parameters = "surname=" + surname.Text + "&firstname=" + firstname.Text + "&othernames=" + othername.Text + "&SOR=" + sor.SelectedItem.Text + "&LGA=" + lga.Text + "&Nationality=" + country.SelectedItem.Text + "&EmailAdress=" + email.Text + "&PhoneNumber=" + phoneNumber.Text + "&InvoiceNo=" + InvoiceNumber + "&DateEntered=" + DateTime.Now.Year + "&Major=" + major.SelectedItem.Value + "&Minor=" + minor.SelectedItem.Value + "&Gender=" + sex.Text; Response.Redirect("../../Students/Register.aspx?"+ parameters); firstname.Text = ""; surname.Text = ""; othername.Text = ""; lga.Text = ""; email.Text = ""; } catch (Exception ex) { Response.Write(ex.Message); } }
/// <summary> /// DAL_AddStudent()方法,向数据库插入一条信息 /// </summary> /// <param name="name">要新增的姓名</param> /// <param name="pwd">要新增的密码</param> /// <param name="age">要新增的年龄</param> /// <param name="gender">要新增的性别</param> /// <param name="address">要新增的地址</param> /// <returns>新增的ID</returns> public Model.Student AddStudent(string name, string pwd, int age, string gender, string address) { SqlParameter par1 = new SqlParameter(); par1.ParameterName = "@name"; par1.SqlDbType = SqlDbType.NVarChar; par1.Value = name; SqlParameter par2 = new SqlParameter("@pwd", SqlDbType.NVarChar) { Value = pwd }; SqlParameter par3 = new SqlParameter(); par3.ParameterName = "@age"; par3.SqlDbType = SqlDbType.Int; par3.Value = age; SqlParameter par4 = new SqlParameter("@gender", SqlDbType.NVarChar) { Value = gender }; SqlParameter par5 = new SqlParameter("@address", SqlDbType.NVarChar) { Value = address }; try { object obj = SqlHelper.ExecuteScalar("insert into Student(Name,Password,Age,Gender,Address) output inserted.ID values(@name,@pwd,@age,@gender,@address)", par1, par2, par3, par4, par5); Model.Student model = null; if (Convert.ToInt32(obj) > 0) //若有返回值,就实例化实体类 { //实例化实体类 model = new Model.Student(); //把得到的ID值存到实体类中的ID属性 model.ID = Convert.ToInt32(obj); return model; } return model; } catch (SqlException) { throw; } }
public bool Insert(Model.Student st) { return(Stu.Insert(st)); }
public IActionResult AddStudent(Model.Student student) { _studentData.AddStudent(student); return(Created(HttpContext.Request.Scheme + "://" + HttpContext.Request.Host + HttpContext.Request.Path + "/" + student.Id, student));; }
public void SaveStudent(Model.Student student) { // impl here to save a student informatin to a // persistent storage }
private void btnImport_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (XtraMessageBox.Show("导入数据需要几分钟时间,原有数据将被清空。\n是否确认?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } // 清空原有记录 repoNewStudent.Clear(); int cnt = 0; DataTable dt = Utils.ExcelHelper.ExcelToDataTableFormPath(this.txtFileName.EditValue.ToString(), true, 1); //学生数据须为第一张sheet foreach (DataRow dr in dt.Rows) { Model.Student s = new Model.Student(); s.zkzh = dr["准考证号"] == null ? "" : dr["准考证号"].ToString(); s.xm = dr["姓名"] == null ? "" : dr["姓名"].ToString(); s.bmdz = dr["报名地州"] == null ? "" : dr["报名地州"].ToString(); s.bmxs = dr["报名县市"] == null ? "" : dr["报名县市"].ToString(); s.bmxx = dr["报名学校"] == null ? "" : dr["报名学校"].ToString(); s.bmhkdz = dr["报名户口地州"] == null ? "" : dr["报名户口地州"].ToString(); s.sjsydz = dr["实际生源地州"] == null ? "" : dr["实际生源地州"].ToString(); s.ywcj = dr["语文成绩"] == null ? 0 : float.Parse(dr["语文成绩"].ToString()); s.wlhxcj = dr["物理、化学成绩"] == null ? 0 : float.Parse(dr["物理、化学成绩"].ToString()); s.sxcj = dr["数学成绩"] == null ? 0 : float.Parse(dr["数学成绩"].ToString()); s.ddyfzlscj = dr["道德与法治、历史成绩"] == null ? 0 : float.Parse(dr["道德与法治、历史成绩"].ToString()); s.wycj = dr["外语成绩"] == null ? 0 : float.Parse(dr["外语成绩"].ToString()); s.zcj = dr["总成绩(不加体育)"] == null ? 0 : float.Parse(dr["总成绩(不加体育)"].ToString()); s.tycj = dr["体育是否合格"] == null ? "" : dr["体育是否合格"].ToString(); s.sfzh = dr["身份证号"] == null ? "" : dr["身份证号"].ToString(); s.xjh = dr["学籍号"] == null ? "" : dr["学籍号"].ToString(); s.sy = dr["生源"] == null ? "" : dr["生源"].ToString(); s.zb = dr["族别"] == null ? "" : dr["族别"].ToString(); s.xb = dr["性别"] == null ? "" : dr["性别"].ToString(); s.csrq = dr["出生日期"] == null ? DateTime.Today : DateTime.Parse(dr["出生日期"].ToString()); s.bj = dr["班级"] == null ? "" : dr["班级"].ToString(); s.kstz = dr["考生特征"] == null ? "" : dr["考生特征"].ToString(); s.zzmm = dr["政治面貌"] == null ? "" : dr["政治面貌"].ToString(); s.hkxz = dr["户口性质"] == null ? "" : dr["户口性质"].ToString(); s.txdz = dr["通讯地址"] == null ? "" : dr["通讯地址"].ToString(); s.lxdh = dr["联系电话"] == null ? "" : dr["联系电话"].ToString(); s.yzbm = dr["邮政编码"] == null ? "" : dr["邮政编码"].ToString(); s.fqxm = dr["父亲姓名"] == null ? "" : dr["父亲姓名"].ToString(); s.fqsfzh = dr["父亲身份证号"] == null ? "" : dr["父亲身份证号"].ToString(); s.fqzb = dr["父亲族别"] == null ? "" : dr["父亲族别"].ToString(); s.fqhkxz = dr["父亲户口性质"] == null ? "" : dr["父亲户口性质"].ToString(); s.fqlxdh = dr["父亲联系电话"] == null ? "" : dr["父亲联系电话"].ToString(); s.fqgzdw = dr["父亲工作单位"] == null ? "" : dr["父亲工作单位"].ToString(); s.mqxm = dr["母亲姓名"] == null ? "" : dr["母亲姓名"].ToString(); s.mqsfzh = dr["母亲身份证号"] == null ? "" : dr["母亲身份证号"].ToString(); s.mqzb = dr["母亲族别"] == null ? "" : dr["母亲族别"].ToString(); s.mqhkxz = dr["母亲户口性质"] == null ? "" : dr["母亲户口性质"].ToString(); s.mqlxdh = dr["母亲联系电话"] == null ? "" : dr["母亲联系电话"].ToString(); s.mqgzdw = dr["母亲工作单位"] == null ? "" : dr["母亲工作单位"].ToString(); s.lqss = dr["录取省市"] == null ? "" : dr["录取省市"].ToString(); s.lqxx = dr["录取学校"] == null ? "" : dr["录取学校"].ToString(); try { repoNewStudent.Add(s); cnt++; } catch (Exception ex) { XtraMessageBox.Show("数据导入错误。\n第" + (cnt + 1).ToString() + "行。\n" + ex.Message + "\n请查看出错数据并尝试重新导入。"); return; } } XtraMessageBox.Show("导入完成。共导入" + cnt + "条记录。"); this.BindStudent(); }
public void RemoveStudent(Model.Student stud) { }
/// <summary> ///编辑学生信息 /// </summary> /// <returns>成功返回真</returns> public static bool EditStudent(Model.Student ms) { return(dal.EditStudent(ms)); }
public void DeleteStudent(Model.Student stud) { }
public void Delete(long id) { Model.Student entity = Find(id); Delete(entity); }
public void DeleteStudent(Model.Student stud) { StudentList.Single(w => w.Id == stud.Id).IsRemoved = true; }
public void Delete(Model.Student entity) { StudentDaoStorage.Students.Remove(entity); StudentDaoStorage.Dictionary.Remove(entity.Id); }
public DataTable Search(Model.SC sc, Model.Student stu, string condition) { return(course.Search(sc, stu, condition)); }
/// <summary> /// 把DataTable中的数据,存入Model实体类对象中 /// </summary> /// <param name="dr">DataTable中的行集合</param> /// <returns>已存好数据的实体类对象</returns> private Model.Student GetModel(DataRow dr) { //实例化实体类model Model.Student model = new Model.Student(); model.ID = Convert.ToInt32(dr[0]); model.Name = dr[1].ToString(); model.Password = dr[2].ToString(); if (!(dr[3] is DBNull)) //字段Age可以为null { model.Age = Convert.ToInt32(dr[3]); } if (!(dr[4] is DBNull)) { model.Gender = dr[4].ToString(); } if (!(dr[5] is DBNull)) { model.Address = dr[5].ToString(); } return model; }
public bool SearchSname(Model.Student st) { return(Stu.SearchSname(st)); }
public void StudentOnExpulsion(Model.Student stud) { ExpelledStudentList.Add(stud); StudentList.Remove(stud); }
public DataTable StudentInfoSearchSname(Model.Student st) { return(Stu.StudentInfoSearchSname(st)); }
public void Post(Model.Student student) { Business.Student c = new(); c.Insert(student); }
public static DataSet GetStudent(Model.Student ms) { return(dal.GetStudent(ms)); }
public void Put(Model.Student student) { Business.Student c = new(); c.Update(student); }
/// <summary> /// 添加学生 /// </summary> /// <param name="ms"></param> /// <returns></returns> public static bool addStudent(Model.Student ms) { return(dal.addStudent(ms)); }
public Model.Student Create(Model.Student student) { _studentRepository.Students.Add(student); _studentRepository.SaveChanges(); return(student); }
public void EditStudent(Model.Student stud) { }
private void InsertMatric() { string NewCurrent = (from d in db.Sessions where d.CurrentSession == true select d.SessionYear).FirstOrDefault(); string[] stringValue = NewCurrent.Split('/'); var InsertStudent = new Model.Student { Firstname = "Sample", Middlename = "Sample", Surname = "Sample", MatricNo = "NCE/" + stringValue[0].ToString() + "/0000", StudentKey = System.Guid.NewGuid().ToString(), SOR = "ABIA", }; db.Students.Add(InsertStudent); db.SaveChanges(); }