public IActionResult DeleteStudent(DeleteStudent delete)
{
//Search for Student index number to make sure that Student exist
string studentIndex = context.Student.Where(s => s.IndexNumber == delete.IndexNumber).Select(s1 => s1.IndexNumber).FirstOrDefault();
//Get IdEnrollment that assign to this Student
int studentIdEnroll = context.Student.Where(s => s.IndexNumber == delete.IndexNumber).Select(s1 => s1.IdEnrollment).FirstOrDefault();
if (studentIndex == null)
{
return(NotFound("Student does not Exist!"));
}
else
{
//remove student from Db
context.Student.Remove(context.Student.Where(s => s.IndexNumber == studentIndex).First());
}
//count how many Stundents are assigned to this idEnrollment
int countSameIdEnroll = context.Student.Where(s => s.IdEnrollment == studentIdEnroll).Count();
if (countSameIdEnroll == 1)
{
//remove Enrollment
context.Enrollment.Remove(context.Enrollment.Where(e => e.IdEnrollment == studentIdEnroll).First());
}
context.SaveChanges();
return(Ok("Student has been deleted from Database!"));
}
public DeleteStudent DeleteStudent(DeleteStudent obj)
{
var returnModel = new DeleteStudent();
var Student = _studentsRepo.Get(obj.StudentId);
var studentsList = _studentsRepo.GetAll().ToList();
var StudentPromotionsList = _StudentPromotionsRepo.GetAll().ToList();
var query = (from p in StudentPromotionsList
where p.StudentId == obj.StudentId
select p);
foreach (var item in query)
{
var StudentPromotion = _StudentPromotionsRepo.Get(item.Id);
if (StudentPromotion != null)
{
_StudentPromotionsRepo.Delete(StudentPromotion);
returnModel.Message = "Delete Successful.";
}
}
if (Student != null)
{
_studentsRepo.Delete(Student);
if (Student.IP300X200 != null)
{
string DelImgofIP300X200 = Path.Combine(obj.WebRootPath, Student.IP300X200);
_commonServ.DelFileFromLocation(DelImgofIP300X200);
}
returnModel.Message = "Delete Successful.";
}
return(returnModel);
}
protected void btnDeleteStudent_Click(object sender, EventArgs e)
{
DeleteStudent ds = new DeleteStudent();
DeleteEmployer de = new DeleteEmployer();
DeleteStudentSkill dss = new DeleteStudentSkill();
DeleteStudentQual dsq = new DeleteStudentQual();
if (Label1.Text == "Students")
{
btnDeleteStudent.Text = "Delete Student";
int studentNo = int.Parse(txtStudentNoDelete.Text);
ds.studentNumber = int.Parse(txtStudentNoDelete.Text);
dss.studentNumber = int.Parse(txtStudentNoDelete.Text);
dsq.studentNumber = int.Parse(txtStudentNoDelete.Text);
handler.BLL_DeleteStudentSkill(dss);
handler.BLL_DeleteStudentQual(dsq);
handler.BLL_DeleteStudent(ds);
dgvStudents.DataSource = handler.BLL_GetAllStudents();
dgvStudents.DataBind();
txtStudentNoDelete.Text = "";
}
else if (Label1.Text == "Employers")
{
btnDeleteStudent.Text = "Delete Employer";
//int employerID = int.Parse(txtStudentNoDelete.Text);
de.employerName = txtStudentNoDelete.Text;
handler.BLL_DeleteEmployer(de);
dgvStudents.DataSource = handler.BLL_GetAllEmployers();
dgvStudents.DataBind();
txtStudentNoDelete.Text = "";
}
}
public void DeleteStudentTest()
{
try
{
DeleteStudent form_null = new DeleteStudent(null);
DeleteStudent form_list = new DeleteStudent(new List <Student>());
} catch
{
Assert.Fail();
}
}
public IActionResult DeleteStudent(DeleteStudent delete)
{
if (context.Student.Any(s => s.IndexNumber == delete.IndexNumber))
{
context.Student.Remove(context.Student.Where(s => s.IndexNumber == delete.IndexNumber).FirstOrDefault());
}
else
{
return(BadRequest("Student with such index number doesn't exists"));
}
context.SaveChanges();
return(Ok("Student was deleted successfully"));
}
public int DeleteStudent(DeleteStudent model)
{
int rowAffected = 0;
try
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", model.Id);
rowAffected = SqlMapper.Execute(con, "sp_DeleteStudent", param: parameters, commandType: CommandType.StoredProcedure);
return(rowAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> DeleteStudent(long StudentId)
{
try
{
var model = new DeleteStudent()
{
WebRootPath = _he.WebRootPath,
StudentId = StudentId
};
await Task.Run(() => _studentsServ.DeleteStudent(model));
}
catch (Exception)
{
return(BadRequest());
}
return(RedirectToAction("SearchByClass"));
}
public ContentResult DelStudent(SafeUserModel student)
{
bool result = DeleteStudent.Delete(student);
if (result)
{
return(new ContentResult
{
StatusCode = (int)HttpStatusCode.OK
});
}
else
{
return(new ContentResult
{
StatusCode = (int)HttpStatusCode.BadRequest
});
}
}
private void btDelDelete_Click(object sender, EventArgs e)
{
short level = 2;
if (rbDelPostGrad.Checked)
{
level = 1;
}
else if (rbDelUnderGrad.Checked)
{
level = 0;
}
DeleteStudent ds = new DeleteStudent(tbDelStuID.Text, tbDelFName.Text, tbDelLName.Text, tbDelEmail.Text,
tbDelPhone.Text, tbDelA1.Text, tbDelA2.Text, tbDelCity.Text,
cbDelCounty.Text, level, cbDelCourse.Text, username);
MessageBox.Show($"Deleted Student: {tbDelFName.Text} {tbDelLName.Text}");
}
public bool BLL_DeleteStudent(DeleteStudent deleteStudent)
{
return(dBAccess.DeleteStudent(deleteStudent));
}
public IActionResult DeleteStudent(DeleteStudent delete)
{
return(dbService.DeleteStudent(delete));
}
public IActionResult DeleteStudent(DeleteStudent IndexNumber)
{
return(_service.DeleteStudent(IndexNumber));
}
public IActionResult DeleteStudent(DeleteStudent model)
{
_StudentRepository.DeleteStudent(model);
return(RedirectToAction("StudentsList", "Student"));
}
