/// <summary> /// get login Student information by stuID /// </summary> public StudentInfoModel getStudentInfoByID(string stuID) { StudentInfoModel stu = null; string comd = "select stuid,stuname,stupwd,schoolid,headpath,collegeid,professionid,stuclass,entrance,nowborrows,nowscredit from StudentInfo where stuID = @stuID"; SqlParameter[] ps = { new SqlParameter("@stuID", stuID) }; SQLHelper h = new SQLHelper(); using (SqlDataReader read = h.getDataReader(comd, ps)) { if (read.HasRows) { while (read.Read()) { stu = new StudentInfoModel(); stu.StuID = read["stuID"].ToString(); stu.StuName = read["stuName"].ToString(); stu.StuPwd = read["stuPwd"].ToString(); stu.SchoolID = read["schoolID"].ToString(); stu.CollegeID = read["collegeID"].ToString(); stu.ProfessionID = read["professionID"].ToString(); stu.StuClass = read["stuClass"].ToString(); stu.NowBorrows = Convert.ToInt32(read["nowBorrows"]); stu.NowsCredit = Convert.ToInt32(read["nowsCredit"]); stu.HeadPath = read["headPath"].ToString(); stu.Entrance = Convert.ToDateTime(read["entrance"]); } } } return(stu); }
public StudentInfoModel DepartmentId(string DepartmentId) { try { var query = "SELECT * FROM tblStudentInfo WHERE DepartmentId='" + DepartmentId + "'"; var reader = _sDB.ExecuteReader(query, _connectionString); if (reader.HasRows) { reader.Read(); var StudentInfoModel = new StudentInfoModel() { Id = Convert.ToInt32(reader["Id"]), StudentId = Convert.ToInt32(reader["StudentId"]), DepartmentId = Convert.ToInt32(reader["DepartmentId"]), CourseId = Convert.ToInt32(reader["CourseId"]), }; return(StudentInfoModel); } return(null); } catch (Exception e) { throw new Exception(e.Message); } }
public List <StudentInfoModel> GetAllStudents() { var getAllStudents = from allStudents in _context.tblStudent select allStudents; //var getAllStudents = _context.tblStudent.Where(student => student.).FirstOrDefault(); List <StudentInfoModel> studentsList = new List <StudentInfoModel>(); foreach (var singleStudent in getAllStudents) { StudentInfoModel student = new StudentInfoModel() { StudentID = singleStudent.StudentID, FirstName = singleStudent.FirstName, LastName = singleStudent.LastName, ContactNumber = singleStudent.ContactNumber, EmailAddress = singleStudent.EmailAddress }; studentsList.Add(student); } return(studentsList); //return _context.tblStudent.ToList(); }
/// <summary> /// ---- begin log in /// </summary> private void button1_Click(object sender, EventArgs e) { lblP.Visible = false; lblU.Visible = false; MainForm main = new MainForm(); if (this.rdoUser.Checked == true) { StudentInfoModel student = new StudentInfoModel(); if (checkStudent(out student)) { getLoginStudent login = new getLoginStudent(main.getLoginStudent); login(student); main.Show(); this.Hide(); } } else { AdminInfoModel admin = new AdminInfoModel(); if (checkAdmin(out admin)) { getLoginAdmin login = new getLoginAdmin(main.getLoginAdmin); login(admin); main.Show(); this.Hide(); } } }
public static List <StudentInfoModel> GetStudents() { try { IEnumerable <tblStudent> lstStudents = _unitOfWork.StudentRepository.Get(); List <StudentInfoModel> studentsList = new List <StudentInfoModel>(); foreach (var singleStudent in lstStudents) { StudentInfoModel student = new StudentInfoModel() { StudentID = singleStudent.StudentID, FirstName = singleStudent.FirstName, LastName = singleStudent.LastName, ContactNumber = singleStudent.ContactNumber, EmailAddress = singleStudent.EmailAddress }; studentsList.Add(student); } return(studentsList); } catch (Exception e) { string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName(); ErrorLogger.LogException(e, currentFile); List <StudentInfoModel> studentsList = new List <StudentInfoModel>(); return(studentsList); } }
public JsonResult UpdateStudentInfo(StudentInfoModel model) { try { var result = StudentBusiness.UpdateStudentInfo(model); if (result != null) { if (Request.Files.Count > 0) { UploadStudentResume(result.studentId); } } var response = new ApiRespnoseWrapper { status = ApiRespnoseStatus.Success, results = new ArrayList() { result } }; return(new JsonResult { Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { return(CommonBusiness.GetErrorResponse(ex.Message)); } }
public static StudentInfoModel UpdateStudentInfo(StudentInfoModel model) { using (var context = new MakeMyJobsEntities()) { StudentInfoModel studentInfo = new StudentInfoModel(); int updated = 0; var user = context.Users.FirstOrDefault(x => x.UserId == model.userId && x.IsActive == 1); var student = context.Students.FirstOrDefault(x => x.StudentId == model.studentId); if (user == null || student == null) { return(null); } else { user.Email = model.email; updated += context.SaveChanges(); student.FirstName = model.firstName; student.LastName = model.lastName; student.ContactNumber = model.contactNumber; student.DateOfBirth = model.dateOfBirth; student.CollegeName = model.collegeName; student.Address = model.address; student.State = model.state; student.Country = model.country; student.ZipCode = model.zipCode; updated += context.SaveChanges(); } return(GetUpdatedStudentInfo(user.UserId, student.StudentId)); } }
public static StudentInfoModel GetStudentInfoForEdit(int id) { using (var context = new MakeMyJobsEntities()) { if (context.Students.Any(x => x.UserId == id)) { StudentInfoModel studentInfoModel = context.Students.Join(context.Users, s => s.UserId, u => u.UserId, (s, u) => new StudentInfoModel() { studentId = s.StudentId, userId = s.UserId, firstName = s.FirstName, lastName = s.LastName, collegeName = s.CollegeName, contactNumber = s.ContactNumber, dateOfBirth = s.DateOfBirth, resume = s.Resume, dateJoined = s.DateJoined, address = s.Address, state = s.State, country = s.Country, email = u.Email, zipCode = s.ZipCode }).FirstOrDefault(x => x.userId == id); return(studentInfoModel); } else { return(null); } } }
public async Task <MessageModel <string> > PostAddStudent(StudentInfoModel studentInfo) { if (ModelState.IsValid) { var addStudent = await _studentInfoService.Add(new StudentInfo() { Name = studentInfo.Name, StudentNumber = studentInfo.StudentNumber, Sex = studentInfo.Sex, Age = studentInfo.Age, }); return(new MessageModel <string>() { msg = "添加学生信息成功", status = 200, success = true, response = addStudent.ToString() }); } else { return(new MessageModel <string>() { msg = "添加学生信息失败", success = false, }); } }
private void btnupdate_Click(object sender, EventArgs e) { StudentInfoModel stu = new StudentInfoModel(); stu = (StudentInfoModel)dgvStudent.CurrentRow.DataBoundItem; StudentInfoBLL stubll = new StudentInfoBLL(); stubll.updateStudentInfo(stu); }
public IActionResult GetStudentById([FromBody] StudentInfoModel model) { var student = _student.GetStudentById(model.Id); if (student == null) { return(BadRequest()); } return(Ok(MapStudentObject(student))); }
private IActionResult GetTestStudentById(int studentId) { var studentInfoModel = new StudentInfoModel { Id = studentId }; _studentDataMock.Setup(x => x.GetStudentById(It.IsAny <int>())) .Returns(new User()); return(_studentController.GetStudentById(studentInfoModel)); }
// GET: Student public ActionResult Index() { List <StudentInfoModel> studentInfoModels = new StudentInfoModel().GetStudentList(); if (studentInfoModels != null && studentInfoModels.Count > 0) { return(View(studentInfoModels)); } else { return(View(new List <StudentInfoModel>())); } }
public bool Save(StudentInfoModel category) { try { var query = "INSERT INTO tblStudentInfo (StudentId, DepartmentId, CourseId) VALUES('" + category.StudentId + "','" + category.DepartmentId + "','" + category.CourseId + "')"; var rowAffected = _sDB.ExecuteNonQuery(query, _connectionString); return(rowAffected > 0); } catch (Exception e) { throw new Exception(e.Message); } }
public ActionResult Create(StudentInfoModel model) { try { // TODO: Add insert logic here model.InsertStudent(model); return(RedirectToAction("Index")); } catch { return(View()); } }
void OnSubgroupPickerSelectedIndexChanged(object sender, EventArgs e) { var picker = (Picker)sender; int selectedIndex = picker.SelectedIndex; if (selectedIndex != -1) { String selectedSubgroup = (string)picker.ItemsSource[selectedIndex]; StudentInfoModel.Subgroup = selectedSubgroup; StudentInfoModel.SaveLoginInfo(); Login.IsVisible = true; } }
public ActionResult Delete(StudentInfoModel model) { try { // TODO: Add delete logic here model.DeleteStudent(model.id); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(StudentInfoModel model) { try { // TODO: Add update logic here model.UpdateStudent(model); return(RedirectToAction("Index")); } catch { return(View()); } }
public void GetStudentById_ShouldReturnABadRequestResult_WhenNoStudentIdIsGiven() { var studentInfoModel = new StudentInfoModel { Id = 1 }; _studentDataMock.Setup(x => x.GetStudentById(It.IsAny <int>())) .Returns((User)null); var result = _studentController.GetStudentById(studentInfoModel); Assert.AreEqual(result.GetType(), typeof(BadRequestResult)); }
public int SaveMst(StudentInfoModel student) { var connection = new SqlConnection(DataManager.OraConnString()); connection.Open(); // string variables = // "Sl_Id,NID,StdName,StdPhoneNo,FthName,FthPhoneNo,MthName,MthPhoneNo,DBO,Email,Nationality,Religion,MaritalStatus,LastEducation,Bord,Result,PresentAddress,ParVill,ParPO,ParPS,ParDistrict,AddDate"; string variables = "Sl_Id,NID,StdName,StdPhoneNo,FthName,FthPhoneNo,MthName,MthPhoneNo,DBO,Email,Nationality,Religion,MaritalStatus,LastEducation,Bord,Result,PresentAddress,ParVill,ParPO,ParPS,ParDistrict,AddDate"; string valus = " '" + student.SlNo + "','" + student.NID + "','" + student.Name + "','" + student.StdPhone + "','" + student.FthName + "','" + student.FthPhone + "','" + student.MthName + "','" + student.MthPhone + "',convert(datetime,nullif('" + student.DBO + "',''),103),'" + student.Email + "','" + student.Nationality + "','" + student.Religion + "','" + student.MaritalStatus + "','" + student.LastEducation + "','" + student.Bord + "','" + student.Result + "','" + student.PresentAddress + "','" + student.ParVill + "','" + student.ParPO + "','" + student.ParPS + "','" + student.ParDis + "', GETDate() "; string query = ""; if (student.StdPhoto != null) { if (student.StdPhoto.Length > 0) { variables = variables + ",StdPhoto"; valus = valus + ",@img"; } } query = "Insert Into StudetnInfoMst (" + variables + ") Values (" + valus + ")"; var command = new SqlCommand(query, connection); SqlParameter img = new SqlParameter(); img.SqlDbType = SqlDbType.VarBinary; img.ParameterName = "img"; img.Value = student.StdPhoto; command.Parameters.Add(img); if (student.StdPhoto == null) { command.Parameters.Remove(img); } else { if (student.StdPhoto.Length == 0) { command.Parameters.Remove(img); } } return(command.ExecuteNonQuery()); }
/// <summary> /// 获取登录的学生用户 /// </summary> /// <param name="stu"></param> public void getLoginStudent(StudentInfoModel stu) { lblShowID.Text = "编号:" + stu.StuID; lblShowName.Text = "用户名:" + stu.StuName; try { if (!string.IsNullOrEmpty(stu.HeadPath)) { picHead.Image = Image.FromFile(stu.HeadPath); } } catch { } id = stu.StuID; pro = "student"; }
/// <summary> /// update Student information by model /// </summary> /// <param name="stu"></param> /// <returns></returns> public int updateStudentInfo(StudentInfoModel stu) { string comd = "update StudentInfo set stuName=@stuName,stuPwd=@stuPwd,headPath=@headPath where stuID=@stuID "; SqlParameter[] ps = { new SqlParameter("@stuName", stu.StuName), new SqlParameter("@stuPwd", stu.StuPwd), new SqlParameter("@headPath", stu.HeadPath), new SqlParameter("@stuID", stu.StuID) }; SQLHelper h = new SQLHelper(); return(h.ExecuteNonQuery(comd, ps)); }
public int Save(StudentInfoModel student) { var connection = new SqlConnection(DataManager.OraConnString()); SqlTransaction transaction; try { connection.Open(); transaction = connection.BeginTransaction(); var command = new SqlCommand(); command.Connection = connection; command.Transaction = transaction; var command1 = new SqlCommand(); command1.Connection = connection; command1.Transaction = transaction; var Command2 = new SqlCommand(); Command2.Connection = connection; Command2.Transaction = transaction; command.CommandText = @"SELECT TOP(1)[ID] FROM StudetnInfoMst ORDER BY ID DESC"; int ID = Convert.ToInt32(command.ExecuteScalar()); command.CommandText = " INSERT INTO dbo.StudentInfoDtl (MstId,CourseName,TrainerName,BatchNo,ClassTime,APM,AdmissionDate,CourseFee,Waiver,DisCount,TotalAmount,PayAmount,AddmissionYear,CertificationDate) VALUES('" + ID + "','" + student.CourseName + "','" + student.TrainerName + "','" + student.BatchNo + "','" + student.ClassTime + "','" + student.APM + "', convert(datetime,nullif('" + student.AdmissionDate + "',''),103),'" + student.CourseFee + "','" + student.Waiver + "','" + student.DisCount + "','" + student.TotalAmount + "','" + student.PayAmount + "','" + student.AddmissionYear + "',convert(datetime,nullif('" + student.CertificationDate + "',''),103) ) "; command.ExecuteNonQuery(); command1.CommandText = "insert into Day_Information(StudentID,StarDay,Sunday,MonDay,TusesDay,WednessDay,ThusDay,Friday) values('" + ID + "','" + student.SatDay + "','" + student.SunDay + "','" + student.MonDay + "','" + student.TuesDay + "','" + student.WednessDay + "','" + student.ThusDay + "','" + student.FriDay + "')"; command1.ExecuteNonQuery(); Command2.CommandText = "Insert Into StdPaymentDtls (StudentId,CourseFee,Waiver,Discount,TotalAmount,PaidAmount) values('" + ID + "','" + student.CourseFee + "','" + student.Waiver + "','" + student.DisCount + "','" + student.TotalAmount + "','" + student.PayAmount + "')"; int success = Command2.ExecuteNonQuery(); transaction.Commit(); return(success); } catch (Exception ex) { throw new Exception(ex.Message); } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } }
public static StudentInfoModel GetStudentInfo(int id) { using (var context = new MakeMyJobsEntities()) { if (context.Students.Any(x => x.UserId == id)) { StudentInfoModel studentInfoModel = context.Students.Join(context.States, s => s.State, st => st.StateId, (s, st) => new { StateName = st.StateName, student = s }).Join(context.Countries, s => s.student.Country, c => c.CountryId, (s, c) => new { student = s, stateName = s.StateName, countryName = c.CountryName }).Join(context.Users, s => s.student.student.UserId, u => u.UserId, (s, u) => new StudentInfoModel() { studentId = s.student.student.StudentId, userId = s.student.student.UserId, firstName = s.student.student.FirstName, lastName = s.student.student.LastName, collegeName = s.student.student.CollegeName, contactNumber = s.student.student.ContactNumber, dateOfBirth = s.student.student.DateOfBirth, resume = s.student.student.Resume, dateJoined = s.student.student.DateJoined, address = s.student.student.Address + ", " + s.student.StateName + ", " + s.countryName, state = s.student.student.State, country = s.student.student.Country, email = u.Email, zipCode = s.student.student.ZipCode }).FirstOrDefault(x => x.userId == id); if (context.StudentDocuments.Any(x => x.StudentId == studentInfoModel.studentId && x.DocumentType == StudentDocumentTypes.Resume)) { studentInfoModel.resume = "1"; } return(studentInfoModel); } else { return(null); } } }
public IActionResult AddStudentInfo(int studentInfoId, string operationType) { var model = new StudentInfoModel(studentInfoId, operationType, _studentInfoService, _courseService, _programService); ViewBag.ProgramList = new SelectList(_programService.Where(x => x.IsDeleted == false), "Id", "Name"); ViewBag.ProjectTyepList = new SelectList(_projectTypeService.Where(x => x.IsDeleted == false), "Id", "Name"); if (operationType == Constants.OperationType.Update) { ViewBag.CourseList = new SelectList(_courseService.Where(x => x.ProgramsId == model.ProgramsId && x.IsDeleted == false), "Id", "Name"); } else { ViewBag.CourseList = new SelectList(string.Empty, "Value", "Text"); } _session.SetString("OperationType", operationType); return(PartialView("_AddStudentInfo", model)); }
public ActionResult EditInfo(StudentInfoModel model) { if (ModelState.IsValid) { // Get the currently logged in student. var student = Student; // Map the new values from the view model to the current student. Mapper.Map(model, student); // Update the student in the database. StudentRepository.Update(student); return(RedirectToAction("Dashboard")); } return(View(model)); }
/// <summary> /// 填充对象 /// </summary> /// <param name="list"></param> /// <param name="read"></param> private static void FillModel(List <StudentInfoModel> list, SqlDataReader read) { StudentInfoModel stu = new StudentInfoModel(); stu.StuID = read["stuID"].ToString(); stu.StuName = read["stuName"].ToString(); stu.StuPwd = read["stuPwd"].ToString(); stu.SchoolID = read["schoolName"].ToString(); stu.CollegeID = read["collegeName"].ToString(); stu.ProfessionID = read["professionName"].ToString(); stu.StuClass = read["stuClass"].ToString(); stu.NowBorrows = Convert.ToInt32(read["nowBorrows"]); stu.NowsCredit = Convert.ToInt32(read["nowsCredit"]); stu.HeadPath = read["headPath"].ToString(); stu.Entrance = Convert.ToDateTime(read["entrance"]); list.Add(stu); }
public int UpdateMst(StudentInfoModel student, string MstId) { var connection = new SqlConnection(DataManager.OraConnString()); connection.Open(); string variables = "Update StudetnInfoMst set NID ='" + student.NID + "',StdName ='" + student.Name + "',StdPhoneNo ='" + student.StdPhone + "',FthName ='" + student.FthName + "',FthPhoneNo ='" + student.FthPhone + "',MthName ='" + student.MthName + "',MthPhoneNo ='" + student.MthPhone + "',DBO = convert(datetime,nullif('" + student.DBO + "',''),103),Email ='" + student.Email + "',Nationality ='" + student.Nationality + "',Religion ='" + student.Religion + "',MaritalStatus ='" + student.MaritalStatus + "',LastEducation ='" + student.LastEducation + "',Bord='" + student.Bord + "',Result='" + student.Result + "',PresentAddress ='" + student.PresentAddress + "',ParVill ='" + student.ParVill + "',ParPO ='" + student.ParPO + "',ParPS ='" + student.ParPS + "',ParDistrict ='" + student.ParDis + "',UpdateDate=GETDATE()"; string query = ""; if (student.StdPhoto != null) { if (student.StdPhoto.Length > 0) { variables = variables + ",StdPhoto = @img"; } } string WHERE = "Where Id='" + MstId + "'"; query = "" + variables + " " + WHERE + ""; var command = new SqlCommand(query, connection); SqlParameter img = new SqlParameter(); img.SqlDbType = SqlDbType.VarBinary; img.ParameterName = "img"; img.Value = student.StdPhoto; command.Parameters.Add(img); if (student.StdPhoto == null) { command.Parameters.Remove(img); } else { if (student.StdPhoto.Length == 0) { command.Parameters.Remove(img); } } return(command.ExecuteNonQuery()); }
public void ParseStudentNameCSV(string filepath) { //Reads the contents of the CSV files as individual lines string[] lines = System.IO.File.ReadAllLines(filepath); //Split each row into column data bool isFirst = true; foreach (var line in lines) { //creates a new Student if (isFirst)//handles a header for the file so it is not added to the data { isFirst = false; continue; } StudentInfoModel st = new StudentInfoModel(line); //adds our newly created student to our Students List Students.Add(st); } }
// To Insert Student Info in Student Table public int InsertStudentInfo(StudentInfoModel model, string UserName) { using (var context = new JustHallAtumationEntities()) { var user = context.Users.Where(x => x.UserName == UserName).FirstOrDefault(); Student student = new Student() { StudentName = model.StudentName, FatherName = model.FatherName, MobileNumber = model.MobileNumber, MotherName = model.MotherName, RoomId = model.RoomId, PaymentId = model.PaymentId, UserId = user.UserId }; context.Students.Add(student); context.SaveChanges(); return(student.StudentId); } }