public void AddedStudensRecountLineNumber()
{
var contract = new Contract();
var student1 = new RegisterStudent()
{
StudentKey = Guid.NewGuid()
};
var student2 = new RegisterStudent()
{
StudentKey = Guid.NewGuid()
};
var student3 = new RegisterStudent()
{
StudentKey = Guid.NewGuid()
};
contract.AddRegisterUnit(student1);
contract.AddRegisterUnit(student2);
contract.AddRegisterUnit(student3);
Assert.AreEqual(3, contract.Registry.Count);
var count = 1;
foreach (var item in contract.Registry)
{
Assert.AreEqual(count.ToString(), item.LineNumber);
count++;
}
}
public RegisterStudent StudentInfoByStdId(int studentId)
{
Query = "SELECT * FROM RegisterStudents WHERE Id=" + studentId;
Command = new SqlCommand()
{
Connection = Connection, CommandText = Query
};
Connection.Open();
Reader = Command.ExecuteReader();
RegisterStudent student = null;
while (Reader.Read())
{
student = new RegisterStudent()
{
Name = Reader["Name"].ToString(),
Email = Reader["Email"].ToString(),
DepartmentId = Convert.ToInt32(Reader["DepartmentId"])
};
}
Reader.Close();
Connection.Close();
return(student);
}
public void RemovertudensRecountLineNumber()
{
var contract = new Contract();
var key = Guid.NewGuid();
var student1 = new RegisterStudent()
{
StudentKey = Guid.NewGuid()
};
var student2 = new RegisterStudent()
{
StudentKey = key
};
var student3 = new RegisterStudent()
{
StudentKey = Guid.NewGuid()
};
contract.AddRegisterUnit(student1);
contract.AddRegisterUnit(student2);
contract.AddRegisterUnit(student3);
var removingUnit = contract.Registry.FirstOrDefault(x => x.StudentKey == key);
contract.RemoveRegisterUnit(removingUnit);
var count = 1;
foreach (var item in contract.Registry)
{
Assert.AreEqual(count.ToString(), item.LineNumber);
count++;
}
}
public async Task <ActionResult <int> > RegisterStudent(RegisterStudent student)
{
if (!ModelState.IsValid)
{
}
return(await Mediator.Send(student));
}
public ActionResult StudentRegister(RegisterStudent regStu)
{
if (ModelState.IsValid)
{
if (!db.tbl_Student.Any(x => x.Student_Email == regStu.Student_Email))
{
tbl_Student stu = new tbl_Student();
stu.Student_Name = regStu.Student_Name;
stu.Student_Email = regStu.Student_Email;
stu.Student_Phone = regStu.Student_Phone;
stu.Student_Password = regStu.Password;
stu.Student_CreatedOn = DateTime.Now;
stu.Level_Id = regStu.Level_Id;
stu.Department_Id = regStu.Department_ID;
stu.IsDeleted = false;
db.tbl_Student.Add(stu);
db.SaveChanges();
return(RedirectToAction("StudentLogin"));
}
else
{
ViewBag.mssg = "هذا الحساب موجود بالفعل";
List <tbl_Level> levlist = db.tbl_Level.ToList();
List <tbl_Department> Deplist = db.tbl_Department.ToList();
ViewData["Levels"] = new SelectList(levlist, "Level_Id", "Level_Name");
ViewData["Departments"] = new SelectList(Deplist, "Department_Id", "Department_Name");
}
}
return(View(regStu));
}
public IActionResult RegisterStudent(RegisterStudent dto)
{
var course = Course.FromId(dto.FavoriteCourseId);
var suffix = Suffix.FromId(dto.NameSuffixId);
//course is not from db context so state is detached if we do
//_schoolContext.Students.Add(student);
//here course state is added and
//_schoolContext.SaveChanges(); causes
// error because course is already exists
//old way to fix
//_schoolContext.Entry(course).State == EntityState.Unchanged;
var emailResult = Email.Create(dto.Email);
if (emailResult.IsFailure)
{
return(BadRequest(emailResult.Error));
}
var nameResult = Name.Create(dto.FirstName, dto.LastName, suffix);
if (nameResult.IsFailure)
{
return(BadRequest(nameResult.Error));
}
var student = new Student(nameResult.Value, emailResult.Value, course, dto.FavoriteCourseGrade);
_studentRepo.Save(student);
_schoolContext.SaveChanges();
return(Ok());
}
private void registerToolStripMenuItem_Click(object sender, EventArgs e)
{
RegisterStudent register = new RegisterStudent();
//this.Hide();
register.Show();
//this.Close();
}
public ActionResult DeleteConfirmed(int id)
{
RegisterStudent registerStudent = db.RegisterStudents.Find(id);
db.RegisterStudents.Remove(registerStudent);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult GetCourseByStdId(int studentId)
{
RegisterStudent student = enrollCourseManager.StudentInfoByStdId(studentId);
List <Course> courses = enrollCourseManager.GetCourseByDepId(student.DepartmentId);
return(Json(courses));
}
// GET: /RegisterStudent/Create
public ActionResult Create()
{
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Code");
var register = new RegisterStudent()
{
Date = DateTime.Today
};
return(View(register));
}
public ActionResult Save(RegisterStudent registerStudent)
{
ViewBag.Title = "Register Student ";
ViewBag.departments = registerStudentManager.GetDepartmentList();
string message = registerStudentManager.Save(registerStudent);
ViewBag.Message = message;
return(View());
}
private void registerStudentToolStripMenuItem_Click(object sender, EventArgs e)
{
MainPanel.Controls.Clear();
if (register != null)
{
register.Close();
}
register = new RegisterStudent();
FormSetUp(register);
}
//[HttpPost]
//public ActionResult Index(int studentId)
//{
// var registerstudents = db.RegisterStudents;
// ViewBag.Student = registerstudents;
// return View();
//}
//Pdf View.............
public ActionResult MarkSheetPdf(ResultPdfVM resultPdf)
{
RegisterStudent student = viewResultManager.StudentInfoByStdIdViewResult(resultPdf.StudentId);
List <ViewResultVM> viewResultVms = viewResultManager.GetResultByStdId(resultPdf.StudentId);
ViewBag.Result = viewResultVms;
ViewBag.StudentInfo = student;
ViewBag.Department = resultPdf.Department;
return(View());
}
public void CannotRegisterStudentIfAlreadyExists()
{
var studentRegistration = new RegisterStudent(new StudentRepositoryStub());
studentRegistration.Execute(new RegisterStudentRequest
{
Registration = "REG001",
Name = "John Doe",
BirthDate = new DateTime(1993, 11, 29)
});
}
public ActionResult Edit([Bind(Include = "Id,Name,Email,ContactNo,DueDate,Address,DepartmentId,RegNo")] RegisterStudent registerStudent)
{
if (ModelState.IsValid)
{
db.Entry(registerStudent).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Code", registerStudent.DepartmentId);
return(View(registerStudent));
}
//Json Methods.................................................................................
public JsonResult StudentInfoByStdId(int studentId)
{
RegisterStudent student = enrollCourseManager.StudentInfoByStdId(studentId);
EnrollCourse enrollCourse = new EnrollCourse()
{
Name = student.Name,
Email = student.Email,
Department = enrollCourseManager.GetDepartmentName(student.DepartmentId)
};
return(Json(enrollCourse));
}
public async Task ShouldSucceedOnValidCommand()
{
IMediator mediator = GetMediator();
RegisterStudent command = GetValidCommand();
var student = await mediator.Send(command);
Assert.Equal(command.Id, student.Id);
Assert.Equal(command.FirstName, student.FirstName);
Assert.Equal(command.LastName, student.LastName);
Assert.Equal(command.BirthDate, student.BirthDate);
}
public ActionResult Create([Bind(Include = "Id,Name,Email,Contact,Date,Address,DepartmentId")] RegisterStudent registerstudent)
{
if (ModelState.IsValid)
{
registerstudent.RegistationNumber = GenareteRegNo(registerstudent);
db.RegisterStudents.Add(registerstudent);
db.SaveChanges();
return(RedirectToAction("Details", new { Id = registerstudent.Id }));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Code", registerstudent.DepartmentId);
return(View(registerstudent));
}
// GET: RegisterStudents/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RegisterStudent registerStudent = db.RegisterStudents.Find(id);
if (registerStudent == null)
{
return(HttpNotFound());
}
return(View(registerStudent));
}
// GET: RegisterStudents/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RegisterStudent registerStudent = db.RegisterStudents.Find(id);
if (registerStudent == null)
{
return(HttpNotFound());
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Code", registerStudent.DepartmentId);
return(View(registerStudent));
}
public ActionResult Create([Bind(Include = "Id,Name,Email,ContactNo,DueDate,Address,DepartmentId,RegNo")] RegisterStudent registerStudent)
{
if (ModelState.IsValid)
{
RegisterStudentManager aManager = new RegisterStudentManager();
// registerStudent.RegNo = aManager.GetStudentRegNo(registerStudent);
registerStudent.RegNo = aManager.GetStudentRegNo(registerStudent);
db.RegisterStudents.Add(registerStudent);
db.SaveChanges();
// return RedirectToAction("Create");
}
ViewBag.RegNo = "Registeration Number : " + registerStudent.RegNo;
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Code", registerStudent.DepartmentId);
return(View(registerStudent));
}
public async Task UnauthorizedRequestShouldThrowUnauthorizedAccessException()
{
IMediator mediator = GetMediator(builder =>
{
var authService = new Mock <IAuthenticationService>();
authService.Setup(x => x.HasPermission(It.IsAny <ClaimsPrincipal>(), It.IsAny <ApplicationPermission>()))
.Returns(false);
builder.Register <IAuthenticationService>(c => authService.Object);
});
RegisterStudent command = GetValidCommand();
await Assert.ThrowsAsync <UnauthorizedAccessException>(async() => await mediator.Send(command));
}
public ActionResult Create(RegisterStudent model)
{
if (ModelState.IsValid)
{
Department department = db.Departments.Where(x => x.DepartmentName == model.DepartmentName).FirstOrDefault();
var deparmentName = department.DepartmentCode;
var year = model.Date.Year;
model.RegstrationNo = model.DepartmentName + "-" + year + "-" + deparmentName;
db.RegisterStudents.Add(model);
db.SaveChanges();
return(RedirectToAction("Index", model));
}
return(View());
}
public IActionResult RegisterStudent(RegisterStudent model)
{
// map model to entity
var student = _mapper.Map <Student>(model);
try
{
// create user
_adminService.CreateStudent(student, model.Password, model.Semigrupa, model.Specializare);
return(Ok());
}
catch (AppException ex)
{
// return error message if there was an exception
return(BadRequest(new { message = ex.Message }));
}
}
public string GetStudentRegNo(RegisterStudent aRegisterStudent)
{
Department aDepartment = db.Departments.FirstOrDefault(x => x.Id == aRegisterStudent.DepartmentId);
int countDepartmentSId =
db.RegisterStudents.Count(
x =>
(x.DepartmentId == aRegisterStudent.DepartmentId) &&
(x.DueDate.Year == aRegisterStudent.DueDate.Year)) + 1;
int ZeroToBeAdded = 3 - countDepartmentSId.ToString().Length;
string number = "";
for (int i = 0; i < ZeroToBeAdded; i++)
{
number += 0;
}
return(aDepartment.Code + "-" + aRegisterStudent.DueDate.Year + "-" + number + countDepartmentSId);
}
public string GenareteRegNo(RegisterStudent student)
{
string depCode = (from d in db.Departments where (d.Id == student.DepartmentId) select d.Code).FirstOrDefault();
var count = ((from s in db.RegisterStudents
where (s.Date.Year == student.Date.Year && s.DepartmentId == student.DepartmentId)
select s.RegistationNumber).Count());
//if (count==null)
//{
// count = 0;
//}
count++;
string regNo = depCode + "-" + student.Date.Year + "-" + count.ToString("D3");
return(regNo);
}
public string Save(RegisterStudent registerStudent)
{
if (registerStudentGateway.IsEmailExists(registerStudent.Email))
{
return("Email already exists");
}
else
{
int rowAffect = registerStudentGateway.Save(registerStudent);
if (rowAffect > 0)
{
return("Save Successful");
}
else
{
return("Register Failed");
}
}
}
public void AddedStudenUnittHasLineNumber()
{
var contract = new Contract();
var key = Guid.NewGuid();
var student = new RegisterStudent()
{
StudentKey = key
};
contract.AddRegisterUnit(student);
var unit = contract.Registry.FirstOrDefault(x => x.StudentKey == key);
Assert.IsNotNull(unit);
Assert.IsFalse(String.IsNullOrEmpty(unit.LineNumber));
Assert.AreEqual("1", unit.LineNumber);
}
public int Save(RegisterStudent registerStudent)
{
string RegNo = GenerateRegNo(registerStudent.DepartmentId, registerStudent.Date);
string query = "INSERT INTO RegisterStudentTable VALUES('" + RegNo + "',@name,@email,@contactno,@date,@address,@departmentid)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@name", registerStudent.Name);
Command.Parameters.AddWithValue("@email", registerStudent.Email);
Command.Parameters.AddWithValue("@contactno", registerStudent.ContactNo);
Command.Parameters.AddWithValue("@date", registerStudent.Date);
Command.Parameters.AddWithValue("@address", registerStudent.Address);
Command.Parameters.AddWithValue("@departmentId", registerStudent.DepartmentId);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
//Json Methods.................................................................................
public JsonResult GetAllStudentInfoByStdIdViewResult(int studentId)
{
RegisterStudent student = viewResultManager.StudentInfoByStdIdViewResult(studentId);
return(Json(student));
}
