public Student Modify([FromBody] StudentInput modifiedStudent) { string cs = @"Database\sample.db3;"; string newPath = Path.GetFullPath(Path.Combine(@".\", cs)); newPath = "Data Source=" + newPath; using var con = new SQLiteConnection(newPath); con.Open(); var age = Int32.Parse(modifiedStudent.Age); using var cmd = new SQLiteCommand(con); cmd.CommandText = "UPDATE Student SET Username = @Username, FirstName = @FirstName, LastName = @LastName, Age = @Age, Career = @Career WHERE Id = @Id"; cmd.Parameters.AddWithValue("@Username", modifiedStudent.Username); cmd.Parameters.AddWithValue("@FirstName", modifiedStudent.FirstName); cmd.Parameters.AddWithValue("@LastName", modifiedStudent.LastName); cmd.Parameters.AddWithValue("@Age", age); cmd.Parameters.AddWithValue("@Career", modifiedStudent.Career); cmd.Parameters.AddWithValue("@Id", modifiedStudent.Id); cmd.Prepare(); cmd.ExecuteNonQuery(); Console.WriteLine("row inserted"); return(new Student()); }
public Student Insert([FromBody] StudentInput newStudent) { string cs = @"Database\sample.db3;"; string newPath = Path.GetFullPath(Path.Combine(@".\", cs)); newPath = "Data Source=" + newPath; using var con = new SQLiteConnection(newPath); con.Open(); var age = Int32.Parse(newStudent.Age); using var cmd = new SQLiteCommand(con); cmd.CommandText = "INSERT INTO Student(Username, FirstName, LastName, Age, Career) VALUES(@Username, @FirstName, @LastName, @Age, @Career)"; cmd.Parameters.AddWithValue("@Username", newStudent.Username); cmd.Parameters.AddWithValue("@FirstName", newStudent.FirstName); cmd.Parameters.AddWithValue("@LastName", newStudent.LastName); cmd.Parameters.AddWithValue("@Age", age); cmd.Parameters.AddWithValue("@Career", newStudent.Career); cmd.Prepare(); cmd.ExecuteNonQuery(); Console.WriteLine("row inserted"); return(new Student()); }
public Object Add(StudentInput input) { var param = new Student { Id = input.Id, Name = input.Name }; _studentService.Add(param); return(param); }
public PagedResultDto <StudentListDto> GetPagedStudents(StudentInput input) { var query = GetStudentsByCondition(input); var count = query.Count(); input.SkipCount = ((input.PIndex ?? 1) - 1) * (input.PSize ?? 10); input.MaxResultCount = input.PSize ?? 10; var list = query.PageBy(input).ToList(); return(new PagedResultDto <StudentListDto>(count, list.MapTo <List <StudentListDto> >())); }
private IQueryable <Student.Students> GetStudentsByCondition(StudentInput input) { //WhereIf 是ABP针对IQueryable<T>的扩展方法 第一个参数为条件,第二个参数为一个Predicate 当条件为true执行后面的条件过滤 var query = _studentRepository.GetAll() .WhereIf(!input.Id.IsNullOrEmpty(), o => o.Id == input.Id) .WhereIf(!input.CnName.IsNullOrEmpty(), t => t.CnName.Contains(input.CnName)) .WhereIf(input.IsActive.HasValue, o => o.IsActive == input.IsActive) .Where(o => o.IsDeleted == false); query = string.IsNullOrEmpty(input.Sorting) ? query.OrderByDescending(t => t.CreationTime) : query.OrderBy(t => input.Sorting); return(query); }
public ViewResult RsvpForm(StudentInput StudentInfo) { Repository.AddResponse(StudentInfo); return(View("Congratulations", StudentInfo)); }
public async Task Add(StudentInput input) { //验证传入参数 if (!input.EntryDate.HasValue) { throw new UserFriendlyException("传入EntryDate参数不正确!"); } //验证用户名是否存在 var user = _userRepository.FirstOrDefault(x => x.UserName == input.StudentNo); if (user != null) { throw new UserFriendlyException($"登陆账号{input.StudentNo}已存在!"); } var role = await _roleManager.GetRoleByNameAsync(StaticRoleNames.CourseSelecting.Student); if (role == null) { throw new UserFriendlyException("系统未初始化!"); } //创建学生对象 var student = new CourseSelecting.Users.Student { TenantId = AbpSession.TenantId, UserName = input.StudentNo, //用户名称 Name = input.Name, Surname = input.Name, EmailAddress = "*****@*****.**", //入学时间 EntryDate = input.EntryDate.Value, StudentNo = input.StudentNo }; #region --非必填属性赋值-- //密码属性赋值 if (!string.IsNullOrEmpty(input.Password)) { student.Password = new PasswordHasher().HashPassword(input.Password); } else { student.Password = new PasswordHasher().HashPassword(CourseSelecting.Users.Student.DefaultStudentPassword); } //性别属性赋值 if (input.Gender.HasValue) { student.Gender = input.Gender.Value; } //专业属性赋值 if (!string.IsNullOrEmpty(input.Major)) { student.Major = input.Major; } //电话属性赋值 if (!string.IsNullOrEmpty(input.Tel)) { student.Tel = input.Tel; } //年级属性赋值 if (!string.IsNullOrEmpty(input.Grade)) { student.Grade = input.Grade; } //班级属性赋值 if (!string.IsNullOrEmpty(input.Class)) { student.Class = input.Class; } //生源地属性赋值 if (!string.IsNullOrEmpty(input.OriginOfStudent)) { student.OriginOfStudent = input.OriginOfStudent; } //专业等级属性赋值 if (!string.IsNullOrEmpty(input.ProfessionLevel)) { student.ProfessionLevel = input.ProfessionLevel; } //院系属性赋值 if (!string.IsNullOrEmpty(input.Department)) { student.Department = input.Department; } #endregion student = await _studentRepository.InsertAsync(student); var userRole = new UserRole { TenantId = AbpSession.TenantId, RoleId = role.Id, UserId = student.Id }; await _userRoleRepository.InsertAsync(userRole); }
public async Task Edit(StudentInput input) { var student = _studentRepository.FirstOrDefault(x => x.Id == input.Id); if (student == null) { throw new UserFriendlyException($"登陆账号{input.StudentNo}不存在!"); } //验证用户名是否重复 var user = await _userRepository.FirstOrDefaultAsync(x => x.UserName == input.StudentNo && x.Id != student.Id); if (user != null) { throw new UserFriendlyException($"登陆账号{input.StudentNo}已存在!"); } if (!string.IsNullOrEmpty(input.StudentNo)) { student.UserName = input.StudentNo; } if (!string.IsNullOrEmpty(input.Name)) { student.Name = input.Name; } //入学时间 if (input.EntryDate.HasValue) { student.EntryDate = input.EntryDate.Value; } #region --非必填属性赋值-- //密码属性赋值 if (!string.IsNullOrEmpty(input.Password)) { student.Password = new PasswordHasher().HashPassword(input.Password); } else { student.Password = new PasswordHasher().HashPassword(CourseSelecting.Users.Student.DefaultStudentPassword); } //性别属性赋值 if (input.Gender.HasValue) { student.Gender = input.Gender.Value; } //专业属性赋值 if (!string.IsNullOrEmpty(input.Major)) { student.Major = input.Major; } //电话属性赋值 if (!string.IsNullOrEmpty(input.Tel)) { student.Tel = input.Tel; } //年级属性赋值 if (!string.IsNullOrEmpty(input.Grade)) { student.Grade = input.Grade; } //班级属性赋值 if (!string.IsNullOrEmpty(input.Class)) { student.Class = input.Class; } //生源地属性赋值 if (!string.IsNullOrEmpty(input.OriginOfStudent)) { student.OriginOfStudent = input.OriginOfStudent; } //专业等级属性赋值 if (!string.IsNullOrEmpty(input.ProfessionLevel)) { student.ProfessionLevel = input.ProfessionLevel; } //院系属性赋值 if (!string.IsNullOrEmpty(input.Department)) { student.Department = input.Department; } #endregion await _studentRepository.UpdateAsync(student); }
public Student.Students GetStudent(StudentInput input) { return(GetStudentsByCondition(input).FirstOrDefault()); //_studentRepository.Get(input.Id); }