/// <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();
}
