public void test_GetLastStudentId() { databaseContextMock.Setup(t => t.Student.GetAll()).Returns(GetStudentData); var formInsertStudent = new InsertStudent(databaseContextMock.Object); var nextStudentId = formInsertStudent.getLastStudentId(); Assert.IsTrue(nextStudentId == 3); }
public IActionResult InsertStudent(InsertStudent insertStudent) { var st = new Student { IndexNumber = insertStudent.IndexNumber, FirstName = insertStudent.FirstName, LastName = insertStudent.LastName, BirthDate = insertStudent.BirthDate, IdEnrollment = insertStudent.IdEnrollment }; _studentContext.Student.Add(st); _studentContext.SaveChanges(); return(Ok("New student added to database!")); }
public void test_InsertStudent() { databaseContextMock.Setup(t => t.Student.GetAll()).Returns(GetStudentData); var formInsertStudent = new InsertStudent(databaseContextMock.Object); var nextStudentId = formInsertStudent.getLastStudentId(); var newStudent = new StudentDo() { Id = nextStudentId, FirstName = "Mihai", LastName = "Popa", Age = "25", EmailAddress = "*****@*****.**", Gender = "M" }; Assert.IsTrue(formInsertStudent.insertStudent(newStudent)); }
public ContentResult AddStudent(StudentsGroupsModel model) { if (ModelState.IsValid) { InsertStudent.Insert(model); return(new ContentResult { StatusCode = (int)HttpStatusCode.OK }); } else { return(new ContentResult { StatusCode = (int)HttpStatusCode.InternalServerError }); } }
public async Task <int> InsertStudentAdmission(InsertStudent student) { using (IDbConnection conn = Connection) { var list = new List <Student>(); list.Add(student.student); try { var sqlparam = new DynamicParameters(); sqlparam.Add("@Student", this.service.ToDataTable(list).AsTableValuedParameter("[ams].[Student]")); sqlparam.Add("@coursemap", this.service.ToDataTable(student.courses).AsTableValuedParameter("[ams].[StudentCourse]")); sqlparam.Add("@Returnstatus", dbType: DbType.Int32, direction: ParameterDirection.Output); var result = await conn.QueryMultipleAsync(sql : "ams.InsertStudentAdmission", param : sqlparam, commandType : CommandType.StoredProcedure); int status = sqlparam.Get <int>("@Returnstatus"); return(status); } catch (Exception e) { Console.WriteLine("Error", e); throw; } } }
public async Task <int> InsertStudentAdmission(InsertStudent student) { return(await repository.InsertStudentAdmission(student)); }
public async Task <IActionResult> InsertStudentAdmission(InsertStudent student) { int stat = await studentmanger.InsertStudentAdmission(student); return(Ok(stat)); }
public JsonResult InsertStudent(IndexStudentsListVM obj) { var result = (dynamic)null; string message = (dynamic)null; try { if (obj.Students != null) { var Students = new InsertStudent_Students() { ClassId = obj.Students.ClassId, GenderId = obj.Students.GenderId, RegistrationNo = obj.Students.RegistrationNo, FirstName = obj.Students.FirstName, LastName = obj.Students.LastName, FatherName = obj.Students.FatherName, MotherName = obj.Students.MotherName, IP300X200 = obj.Students.IP300X200, Year = obj.Students.Year, PresentAddress = obj.Students.PresentAddress, PermanentAddress = obj.Students.PermanentAddress, DOB = obj.Students.DOB, fleImage = obj.Students.fleImage, IsActive = obj.Students.IsActive, AddedBy = 0, AddedDate = DateTime.Now, ModifiedBy = 0, ModifiedDate = DateTime.Now, DataType = null }; var StudentPromotions = new InsertStudent_StudentPromotions() { ClassId = obj.Students.ClassId, StudentId = obj.Students.Id, Year = obj.Students.Year, RollNo = obj.StudentPromotions.RollNo, IsActive = obj.Students.IsActive, AddedBy = 0, AddedDate = DateTime.Now, ModifiedBy = 0, ModifiedDate = DateTime.Now, DataType = null }; var model = new InsertStudent() { WebRootPath = _he.WebRootPath, Students = Students, StudentPromotions = StudentPromotions }; message = _studentsServ.InsertStudent(model); result = Json(new { success = true, Message = message }); } } // catch (Exception) catch (Exception ex) { result = Json(new { success = false, Message = "ERROR101:Students/InsertStudent - " + ex.Message }); } return(result); }
public string InsertStudent(InsertStudent obj) { string returnResult = (dynamic)null; try { var studentsList = _studentsRepo.GetAll().ToList(); var getregistration = (from stu in studentsList where stu.RegistrationNo == obj.Students.RegistrationNo select stu).SingleOrDefault(); //var Studentlist = _studentsRepo.Get(obj.Students.Id); //var query=(from stu) if (getregistration == null) { if (obj != null) { var AdmittedYear = DateTime.ParseExact(obj.Students.Year, "yyyy", null); //[Note: insert 'states' table] if (obj.Students != null) { var Students = new InsertStudent_Students() { ClassId = obj.Students.ClassId, GenderId = obj.Students.GenderId, RegistrationNo = obj.Students.RegistrationNo, FirstName = obj.Students.FirstName, LastName = obj.Students.LastName, IP300X200 = obj.Students.IP300X200, AdmittedYear = AdmittedYear, PresentAddress = obj.Students.PresentAddress, PermanentAddress = obj.Students.PermanentAddress, DOB = obj.Students.DOB, IsActive = obj.Students.IsActive, AddedBy = obj.Students.AddedBy = 0, AddedDate = DateTime.Now, ModifiedBy = 0, ModifiedDate = DateTime.Now, FatherName = obj.Students.FatherName, MotherName = obj.Students.MotherName, DataType = null }; //[NOTE: Student table] _studentsRepo.Insert(Students); if (obj.Students.fleImage != null) { string imagePathIP300X200 = "ClientDictionary/Students/IP300X200/"; string extension = Path.GetExtension(obj.Students.fleImage.FileName); var lastAddingRecord = _studentsRepo.GetAll().Last(); if (_commonServ.CommImage_ImageFormat(lastAddingRecord.Id.ToString(), obj.Students.fleImage, obj.WebRootPath, imagePathIP300X200, 200, 300, extension).Equals(true)) { //[NOTE:Update image file] var imgStudent = _studentsRepo.Get(lastAddingRecord.Id); imgStudent.IP300X200 = imagePathIP300X200 + lastAddingRecord.Id + extension; _studentsRepo.Update(imgStudent); } } } Int64 getLastId = _studentsRepo.GetLastId(); //[NOTE: Student promotion table table] if (obj.StudentPromotions != null) { var StudentPromotions = new InsertStudent_StudentPromotions() { StudentId = getLastId, ClassId = obj.Students.ClassId, RollNo = obj.StudentPromotions.RollNo, ClassYear = AdmittedYear, IsActive = obj.Students.IsActive, AddedBy = 0, AddedDate = DateTime.Now, ModifiedBy = 0, ModifiedDate = DateTime.Now, DataType = null }; _StudentPromotionsRepo.Insert(StudentPromotions); } } returnResult = "Saved"; } else { returnResult = "this registration number already exist"; } } catch (Exception ex) { returnResult = "ERROR102:Insert all required Info - " + ex.Message; } return(returnResult); }