private void BtnAddStudent_Click(object sender, EventArgs e)
{
var selectedcourse = listBox1.CheckedItems;
var properties = selectedcourse.GetType().GetProperties();
AddEditStudentDto model = new AddEditStudentDto();
model.Courses = new List <int>();
foreach (var item in listBox1.CheckedItems)
{
model.Courses.Add(Convert.ToInt32(item.GetType().GetProperty("CourseId").GetValue(item, null)));
}
model.ImageUrl = txtImageUrl.Text;
model.Name = TxtName.Text;
model.FName = TxtFName.Text;
model.Email = TxtEmail.Text;
model.Phone = TxtStudentPhone.Text;
model.Password = TxtPassword.Text;
model.ConfirmPassword = TxtConfirmPassword.Text;
model.Dob = DtpStudetDob.Text.ToString();
model.UserId = USER_ID;
_StudentRepo.AddStudent(model);
RefreshStudentTable();
MessageBox.Show("Student Added Successfully");
RefreshStudentForm();
}
public bool AddStudentByProcedure(AddEditStudentDto s)
{
try
{
var id = Convert.ToInt32(context.AddStudent(s.Name, s.FName, s.Phone, s.Email, s.Dob, s.Password, s.ConfirmPassword));
context.AddCourses(id, s.Courses);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool UpdateStudent(AddEditStudentDto stdPost)
{
try
{
//update first Student
Student s = new Student();
s.Id = stdPost.Id;
s.Name = stdPost.Name;
s.FName = stdPost.FName;
s.Dob = stdPost.Dob;
s.Email = stdPost.Email;
s.Phone = stdPost.Phone;
s.UserId = stdPost.UserId;
s.Password = stdPost.Password;
s.ImageUrl = stdPost.ImageUrl;
s.ThumbUrl = stdPost.ThumbUrl;
s.ConfirmPassword = stdPost.ConfirmPassword;
//now First Find Courses And delete previous courses for Student
var stdPreCourses = context.StudentCourses.Where(x => x.StudentId == stdPost.Id).ToList();
if (stdPreCourses != null)
{
context.StudentCourses.RemoveRange(stdPreCourses);
context.SaveChanges();
}
//Now Add Newly Added Courses
List <StudentCourse> courseList = new List <StudentCourse>();
if (stdPost.Courses != null)
{
foreach (var Course in stdPost.Courses)
{
StudentCourse course_Obj = new StudentCourse();
course_Obj.StudentId = stdPost.Id;
course_Obj.CourseId = Convert.ToInt32(Course);
courseList.Add(course_Obj);
}
context.StudentCourses.AddRange(courseList);
context.Entry(s).State = EntityState.Modified;
context.SaveChanges();
}
//Adding updated Courses
}
catch (Exception e)
{
return(false);
}
return(true);
}
public void GivenWillAddNewStudentDetailsCallToAddStudent(string name)
{
var obj = new
{
username = "******",
password = "******",
grant_type = "password"
};
var request = new HttpRequestWrapper()
.SetMethod(Method.POST)
.SetResourse("/Login")
.AddJsonContent(obj);
_restResponse = new RestResponse();
_restResponse = request.Execute();
_statusCode = _restResponse.StatusCode;
_userResponseDto = JsonConvert.DeserializeObject <LoginUserDto>(_restResponse.Content);
_Token = _userResponseDto.access_token;
Assert.AreEqual(_userResponseDto.token_type, "bearer");
Dictionary <string, string> header = new Dictionary <string, string>();
header.Add("Authorization", "bearer " + _Token);
AddEditStudentDto student = new AddEditStudentDto();
student.Name = name;
student.FName = "testfather";
student.Email = "*****@*****.**";
student.Dob = "11/11/1995";
List <int> courses = new List <int>();
courses.Add(1);
courses.Add(2);
courses.Add(3);
student.Courses = courses;
var Request = new HttpRequestWrapper()
.SetMethod(Method.POST)
.AddHeaders(header)
.SetResourse("/api/Student")
.AddJsonContent(student);
_restResponse = new RestResponse();
_restResponse = Request.Execute();
_statusCode = _restResponse.StatusCode;
_studentDtoResp = JsonConvert.DeserializeObject <StudentDtoResponse>(_restResponse.Content);
Assert.AreEqual(_studentDtoResp.result, true);
}
public void GivenTheIdOfStudentToDeleteIs(int Id)
{
Dictionary <string, string> header = new Dictionary <string, string>();
header.Add("Authorization", "bearer " + _Token);
_id = Id;
var Request = new HttpRequestWrapper()
.SetMethod(Method.GET)
.AddHeaders(header)
.SetResourse("/api/Student/?id=" + _id);
_restResponse = new RestResponse();
_restResponse = Request.Execute();
model = JsonConvert.DeserializeObject <AddEditStudentDto>(_restResponse.Content);
Assert.AreEqual(HttpStatusCode.OK, _restResponse.StatusCode);
Assert.AreNotEqual(model, null, "This Record Does Not exist in Database Change Id Please And Try Again This Test");
}
private void BtnEditStudent_Click(object sender, EventArgs e)
{
AddEditStudentDto model = new AddEditStudentDto();
model.Courses = new List <int>();
foreach (var item in listBox1.CheckedItems)
{
model.Courses.Add(Convert.ToInt32(item.GetType().GetProperty("CourseId").GetValue(item, null)));
}
model.Id = StudentId;
model.Name = TxtName.Text;
model.FName = TxtFName.Text;
model.Email = TxtEmail.Text;
model.Phone = TxtStudentPhone.Text;
model.Password = TxtPassword.Text;
model.ConfirmPassword = TxtConfirmPassword.Text;
model.Dob = DtpStudetDob.Text.ToString();
model.UserId = USER_ID;
model.ImageUrl = txtImageUrl.Text;
_StudentRepo.UpdateStudent(model);
RefreshStudentGridView();
this.Close();
}
public bool AddStudent(AddEditStudentDto studentDto)
{
try
{
StudentCourse stdCourse = new StudentCourse();
Student s = new Student();
s.Name = studentDto.Name;
s.FName = studentDto.FName;
s.Dob = studentDto.Dob;
s.Email = studentDto.Email;
s.Phone = studentDto.Phone;
s.Password = studentDto.Password;
s.ImageUrl = studentDto.ImageUrl;
s.ThumbUrl = studentDto.ThumbUrl;
s.ConfirmPassword = studentDto.ConfirmPassword;
s.UserId = studentDto.UserId;
context.Students.Add(s);
List <StudentCourse> courseList = new List <StudentCourse>();
if (studentDto.Courses != null)
{
foreach (var Course in studentDto.Courses)
{
StudentCourse course_Obj = new StudentCourse();
course_Obj.StudentId = s.Id;
course_Obj.CourseId = Convert.ToInt32(Course);
courseList.Add(course_Obj);
}
context.StudentCourses.AddRange(courseList);
}
context.SaveChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public IHttpActionResult Put([FromBody] AddEditStudentDto Model)
{
Model.UserId = USER_ID;
return(Ok(_repo.UpdateStudent(Model)));
}