public async Task <IActionResult> Edit(int id, [Bind("Id,StudentId,MarkId")] StudentMark studentMark) { if (id != studentMark.StudentId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(studentMark); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentMarkExists(studentMark.StudentId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["MarkId"] = new SelectList(_context.Marks, "Id", "Id", studentMark.MarkId); ViewData["StudentId"] = new SelectList(_context.Students, "Id", "Id", studentMark.StudentId); return(View(studentMark)); }
//Created By Vivek on 17.07.2013 /// <summary> /// Students the mark update. /// </summary> /// <param name="studentMarkUpdate">The student mark update.</param> public void StudentMarkUpdate(StudentMark studentMarkUpdate) { using (var sqlcon = new SqlConnection(GetConnectionString())) { using (var sqlcmd = sqlcon.CreateCommand()) { sqlcon.Open(); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.CommandText = "[dbo].[usp_student_mark_update]"; sqlcmd.Parameters.Add(new SqlParameter("@student_mark_id", studentMarkUpdate.StudentMarkId)); sqlcmd.Parameters.Add(new SqlParameter("@roll_number", studentMarkUpdate.RollNumber)); sqlcmd.Parameters.Add(new SqlParameter("@language", studentMarkUpdate.Language)); sqlcmd.Parameters.Add(new SqlParameter("@english", studentMarkUpdate.English)); sqlcmd.Parameters.Add(new SqlParameter("@maths", studentMarkUpdate.Maths)); sqlcmd.Parameters.Add(new SqlParameter("@science", studentMarkUpdate.Science)); sqlcmd.Parameters.Add(new SqlParameter("@social", studentMarkUpdate.Social)); sqlcmd.Parameters.Add(new SqlParameter("@total", studentMarkUpdate.Total)); sqlcmd.Parameters.Add(new SqlParameter("@percentage", studentMarkUpdate.Percentage)); sqlcmd.Parameters.Add(new SqlParameter("@result", studentMarkUpdate.Result)); sqlcmd.Parameters.Add(new SqlParameter("@remarks", studentMarkUpdate.Remarks)); sqlcmd.Parameters.Add(new SqlParameter("@modified_by", 1)); sqlcmd.ExecuteNonQuery(); } } }
[HttpGet("GetStudentsMarks")]//methoad name or action public IActionResult GetStudentsMarks() { List <StudentMark> SMlist = new List <StudentMark>(); //list try { using (SqlConnection connection = new SqlConnection("Data Source=dev;Initial Catalog=Test;Persist Security Info=True;User ID=sa;Password=admin@123")) { connection.Open(); SqlCommand command = new SqlCommand("SP_GetStudentsMarks", connection); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { StudentMark sm = new StudentMark(); // model name(same table coloumn) sm.ID = new Guid(dataReader["ID"].ToString()); sm.NAME = Convert.ToString(dataReader["NAME"]); sm.AGE = Convert.ToInt32(dataReader["AGE"]); sm.DATE = Convert.ToDateTime(dataReader["DATE"]); sm.M1 = dataReader["MARK1"] as int? ?? default(int); sm.M2 = dataReader["MARK2"] as int? ?? default(int); sm.M3 = dataReader["MARK3"] as int? ?? default(int); SMlist.Add(sm); } } } } catch (Exception ex) { throw; } return(Ok(SMlist)); //return the list }
public void Update(StudentModel Model) { DuckTaleInterviewDBEntities _db = new DuckTaleInterviewDBEntities(); Student student = _db.Students.Where(x => x.Deleted == false).Where(x => x.StudentID == Model.StudentID).FirstOrDefault(); if (student != null) { student.FirstName = Model.FirstName; student.LastName = Model.LastName; _db.SaveChanges(); } foreach (MarksModel marks in Model.Marks) { StudentMark studentMark = _db.StudentMarks.Where(x => x.StudentID == Model.StudentID).Where(x => x.SubjectID == marks.SubjectID).FirstOrDefault(); if (studentMark != null) { studentMark.Marks = marks.Marks; _db.SaveChanges(); } else { StudentMark sm = new StudentMark() { Marks = marks.Marks, StudentID = Model.StudentID, SubjectID = marks.SubjectID }; _db.StudentMarks.Add(sm); _db.SaveChanges(); } } }
public void PrintStudentMark() { StudentMark sm = new StudentMark(); sm.TotalMark = 200; sm.PrintTotalMark(); }
//Created by Prasa on 17.07.2013 /// <summary> /// Adds the student mark. /// </summary> /// <param name="studentMark">The student mark.</param> /// <returns>StudentMarkId</returns> public int AddStudentMark(StudentMark studentMark) { int studentMarkId = 0; object IdentityValue = 0; using (var connection = new SqlConnection(GetConnectionString())) { using (SqlCommand cmd = connection.CreateCommand()) { connection.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[dbo].[usp_student_mark_insert]"; cmd.Parameters.Add(new SqlParameter("@roll_number", studentMark.RollNumber)); cmd.Parameters.Add(new SqlParameter("@language", studentMark.Language)); cmd.Parameters.Add(new SqlParameter("@english", studentMark.English)); cmd.Parameters.Add(new SqlParameter("@maths", studentMark.Maths)); cmd.Parameters.Add(new SqlParameter("@science", studentMark.Science)); cmd.Parameters.Add(new SqlParameter("@social", studentMark.Social)); cmd.Parameters.Add(new SqlParameter("@total", studentMark.Total)); cmd.Parameters.Add(new SqlParameter("@percentage", studentMark.Percentage)); cmd.Parameters.Add(new SqlParameter("@result", studentMark.Result)); cmd.Parameters.Add(new SqlParameter("@remarks", studentMark.Remarks)); cmd.Parameters.Add(new SqlParameter("@created_by", 1)); IdentityValue = cmd.ExecuteScalar(); } if (IdentityValue != DBNull.Value) { studentMarkId = Convert.ToInt32(IdentityValue); } } return(studentMarkId); }
//Created by Vivek on 18.07.2013 /// <summary> /// Students the mark delete. /// </summary> /// <returns>StudentMark</returns> public static StudentMark StudentMarkDelete() { var markDelete = new StudentMark { RollNumber = 5, Modified_By = 2, }; return(markDelete); }
//Created by Vivek on 18.07.2013 /// <summary> /// Students the mark delete. /// </summary> /// <returns></returns> public static StudentMark StudentMarkDelete() { StudentMark studentMarkDelete = new StudentMark(); var studentDelete = new StudentMark { RollNumber = 45, Modified_By = 2, }; return(studentDelete); }
public void AddStudentMarkTest() { //Creating StudentMark StudentMark studentMark = CreateStudentMark(); Assert.AreNotEqual(0, studentMark.StudentMarkId); //Getting StudetnMark details by StudentMarkId StudentMark expected = mStudentRepository.GetStudentMarkByRollNumber(studentMark.RollNumber); Assert.AreEqual(expected.StudentMarkId, studentMark.StudentMarkId); }
public void AddStudentMarkTest() { //Creating StudentMark StudentMark studentMark = CreateStudentMark(); Assert.AreNotEqual(0, studentMark.StudentMarkId); //Getting StudentMark Details StudentMark expected = mStudentDataService.GetStudentMarkByStudentMarkId(studentMark.StudentMarkId); Assert.AreEqual(expected.StudentMarkId, studentMark.StudentMarkId); }
public ActionResult Create(StudentMark modeobj) { Student_Detail tableobj = new Student_Detail(); tableobj.Name = modeobj.Name; tableobj.Email = modeobj.Email; tableobj.Gender = modeobj.Gender; tableobj.Dep_Id = modeobj.Dep_Id; entityobj.Student_Detail.Add(tableobj); entityobj.SaveChanges(); return(RedirectToAction("Showdetails")); }
public async Task <IActionResult> Create([Bind("Id,StudentId,MarkId")] StudentMark studentMark) { if (ModelState.IsValid) { _context.Add(studentMark); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["MarkId"] = new SelectList(_context.Marks, "Id", "Id", studentMark.MarkId); ViewData["StudentId"] = new SelectList(_context.Students, "Id", "Id", studentMark.StudentId); return(View(studentMark)); }
//Created by Yogalakshmi on 23.07.2013 /// <summary> /// Gets the student info by roll number. /// </summary> /// <param name="rollNumber">The roll number.</param> /// <returns>Student</returns> public StudentMark GetStudentMarkByRollNumber(int rollNumber) { StudentMark studentmark = null; using (var connection = new SqlConnection(GetConnectionString())) { using (SqlCommand cmd = connection.CreateCommand()) { connection.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[dbo].[usp_get_student_mark_by_roll_number]"; cmd.Parameters.Add(new SqlParameter("@roll_number", rollNumber)); using (SqlDataReader dataReader = cmd.ExecuteReader()) { if (dataReader.HasRows) { int studentMarkIdOrdinal = dataReader.GetOrdinal("student_mark_id"); int rollNumberOrdinal = dataReader.GetOrdinal("roll_number"); int languageOrdinal = dataReader.GetOrdinal("language"); int englishOrdinal = dataReader.GetOrdinal("english"); int mathsOrdinal = dataReader.GetOrdinal("maths"); int scienceOrdinal = dataReader.GetOrdinal("science"); int socialOrdinal = dataReader.GetOrdinal("social"); int totalOrdinal = dataReader.GetOrdinal("total"); int resultOrdinal = dataReader.GetOrdinal("result"); int percentageOrdinal = dataReader.GetOrdinal("percentage"); int remarksOrdinal = dataReader.GetOrdinal("remarks"); int createdByOrdinal = dataReader.GetOrdinal("modified_by"); while (dataReader.Read()) { studentmark = new StudentMark(); studentmark.StudentMarkId = dataReader.GetInt32(studentMarkIdOrdinal); studentmark.RollNumber = dataReader.GetInt32(rollNumberOrdinal); studentmark.RollNumber = dataReader.GetInt32(rollNumberOrdinal); studentmark.Language = dataReader.GetInt32(languageOrdinal); studentmark.English = dataReader.GetInt32(englishOrdinal); studentmark.Maths = dataReader.GetInt32(mathsOrdinal); studentmark.Science = dataReader.GetInt32(scienceOrdinal); studentmark.Social = dataReader.GetInt32(socialOrdinal); studentmark.Total = dataReader.GetInt32(totalOrdinal); studentmark.Result = Convert.ToChar(dataReader.GetValue(resultOrdinal)); studentmark.Percentage = Convert.ToSingle(dataReader.GetValue(percentageOrdinal).ToString()); studentmark.Remarks = dataReader.GetString(remarksOrdinal); studentmark.Modified_By = dataReader.GetInt32(createdByOrdinal); } } } } } return(studentmark); }
public void UpdateStudentMarkTest() { //Creating StudentMark StudentMark studentMark = CreateStudentMark(); Assert.AreNotEqual(studentMark.StudentMarkId, 0); //Updating StudentMark studentMark.Language = 50; mStudentDataService.StudentMarkUpdate(studentMark); //Getting StudentMark details by StudentMarkId var getUpdatedStudentMark = mStudentDataService.GetStudentMarkByStudentMarkId(studentMark.StudentMarkId); Assert.AreEqual(studentMark.Language, getUpdatedStudentMark.Language); }
public void DeleteStudentMark() { //Creating StudentMark StudentMark studentMark = CreateStudentMark(); Assert.AreNotEqual(studentMark.StudentMarkId, 0); //Deleting StudentMark studentMark.RollNumber = 2; var detetedStudent = StudentMarkDelete(); //Getting StudentMark by StudentMarkId var getUpdatedStudentMark = mStudentDataService.GetStudentMarkByStudentMarkId(studentMark.StudentMarkId); Assert.AreEqual(studentMark.IsDeleted, getUpdatedStudentMark.IsDeleted); }
public void StudentMarkUpdateTest() { //Creating StudentMark StudentMark studentMark = CreateStudentMark(); Assert.AreNotEqual(studentMark.StudentMarkId, 0); //Updating a StudentMark studentMark.Language = 99; studentMark.Modified_By = 2; mStudentRepository.StudentMarkUpdate(studentMark); //Getting StudentMark Details var updatedStudentMark = mStudentRepository.GetStudentMarkByRollNumber(studentMark.RollNumber); Assert.AreEqual(studentMark.Language, updatedStudentMark.Language); }
public ActionResult AddStudentMark(StudentMark studentMark, int id) { try { StudentRepository studentRepository = new StudentRepository(); studentMark.RollNumber = id; studentRepository.AddStudentMark(studentMark); //ViewData["Message1"] = "Student Marks Inserted Sucessfully"; //return View(); return(RedirectToAction("Search", "Student")); } catch (Exception ex) { ViewData["Message2"] = "Error in Inserting"; return(View()); } }
private List <StudentMark> UpsertStudentMarks(int studentId, int lessonId, List <StudentMark> marks) { var result = new List <StudentMark>(); using (var objconnection = new SqlConnection(ApiConfig.ConnectionString)) { objconnection.Open(); using (var objcmd = new SqlCommand("dbo.p_UpsertStudentMarksByLesson", objconnection)) { objcmd.CommandType = CommandType.StoredProcedure; objcmd.Parameters.Add("@studentId", SqlDbType.Int); objcmd.Parameters["@studentId"].Value = studentId; objcmd.Parameters.Add("@lessonId", SqlDbType.Int); objcmd.Parameters["@lessonId"].Value = lessonId; var marksWithDates = new DataTable("marksWithDates"); marksWithDates.Columns.Add("Mark", typeof(int)); marksWithDates.Columns.Add("MarkDate", typeof(DateTime)); marksWithDates.Columns.Add("Reason", typeof(string)); foreach (var mark in marks) { marksWithDates.Rows.Add(mark.Mark, mark.Date, mark.Reason); } SqlParameter tvpParam = objcmd.Parameters.AddWithValue("@marksWithDates", marksWithDates); tvpParam.SqlDbType = SqlDbType.Structured; var res = objcmd.ExecuteReader(); while (res.Read()) { var mark = new StudentMark() { Mark = int.Parse(res["Mark"].ToString()), Date = Convert.ToDateTime(res["MarkDate"].ToString()), Reason = res["Reason"].ToString() }; result.Add(mark); } } return(result); } }
public bool DeleteStudentSubject(int StudentID, int SubjectID) { try { DuckTaleInterviewDBEntities _db = new DuckTaleInterviewDBEntities(); StudentMark marks = _db.StudentMarks.Where(x => x.StudentID == StudentID).Where(x => x.SubjectID == SubjectID).FirstOrDefault(); if (marks != null) { marks.Deleted = true; _db.SaveChanges(); return(true); } return(false); } catch { return(false); } }
//Created by Vivek on 17.07.2013 /// <summary> /// Students the mark delete. /// </summary> /// <param name="studentDelete">The student delete.</param> /// <returns>StudentMark</returns> public StudentMark StudentMarkDelete(int rollNumber) { StudentMark sMarkDelete = null; using (var sqlcon = new SqlConnection(GetConnectionString())) { using (var sqlcmd = sqlcon.CreateCommand()) { sqlcon.Open(); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.CommandText = "[dbo].[usp_student_mark_delete]"; sqlcmd.Parameters.Add(new SqlParameter("@roll_number", rollNumber)); sqlcmd.Parameters.Add(new SqlParameter("@modified_by", 1)); sqlcmd.ExecuteNonQuery(); //sqlcon.Close(); } } return(sMarkDelete); }
public void StudentSearchTest() { //Creating a Student Student student = CreateStudent(); Assert.AreNotEqual(0, student.RollNumber); //Creating StudentMark StudentMark studentMark = CreateStudentMark(); Assert.AreNotEqual(0, studentMark.StudentMarkId); //Searching Student Details var studentDSR = StudentSearch(); //Getting Student Info by RollNumber var expectedsearchDAR = mStudentDataService.GetStudentInfoByRollNumber(studentDSR.roll_number); //Assert.AreEqual(studentDSR.student_name, expectedsearchDAR.Name); }
public static void CreatNew() { var student = new StudentMark(); Id = Id + 1; student.Id = Id; Console.Write("Please input student fullname: "); student.FullName = Console.ReadLine(); Console.Write("Please input class name: "); student.Class1 = Console.ReadLine(); Console.Write("Please input semester: "); student.Semester = int.Parse(Console.ReadLine()); for (int i = 0; i < student.SubjecMarkList.Length; i++) { Console.Write("Please input marks of subject " + (i + 1) + ":"); student.SubjecMarkList[i] = int.Parse(Console.ReadLine()); } StudentList.Add(student); }
//Created by Prasana on 18.07.2013 /// <summary> /// Creates the student mark. /// </summary> /// <returns></returns> public static StudentMark CreateStudentMark() { var studentMark = new StudentMark { RollNumber = 4, Language = 100, English = 100, Maths = 100, Science = 100, Social = 100, Result = 'P', Remarks = "Outstanding", Total = 500, Percentage = 100, Created_By = 1 }; studentMark.StudentMarkId = studentDataService.AddStudentMark(studentMark); return(studentMark); }
public void StudentMarkDeleteTest() { //Creating a Student Student student = CreateStudent(); Assert.AreNotEqual(0, student.RollNumber); //Creating StudentMark StudentMark studentMark = CreateStudentMark(); Assert.AreNotEqual(studentMark.StudentMarkId, 0); //Searching Student var searchStudent = StudentMarkDelete(); //Getting Student details var expected = mStudentRepository.GetStudentInfoByRollNumber(student.RollNumber); Assert.AreEqual(searchStudent.RollNumber, student.RollNumber); }
//Created by Prasana on 18.07.2013 /// <summary> /// Students the mark update. /// </summary> /// <returns></returns> public static StudentMark StudentMarkUpdate() { StudentMark studentMark = new StudentMark(); var updata = new StudentMark { StudentMarkId = 1, RollNumber = 34, Language = 50, English = 50, Maths = 50, Science = 50, Social = 50, Total = 250, Percentage = 50, Result = 'P', Remarks = "Good", Modified_By = 1, }; return(updata); }
//Created by Prasanaon 18.07.2013 /// <summary> /// Creates the student mark. /// </summary> /// <returns>StudentMark</returns> public static StudentMark CreateStudentMark() { StudentRepository studentRepository = new StudentRepository(); var studentMark = new StudentMark { RollNumber = 4, Language = 90, English = 90, Maths = 100, Science = 100, Social = 100, Result = 'P', Remarks = "Good", Total = 480, Percentage = 96, Created_By = 1 }; studentMark.StudentMarkId = studentRepository.AddStudentMark(studentMark); return(studentMark); }
private LessonMark ProcessMarksRow(HtmlElement row) { var i = 0; var tmpMarks = row; var lessonName = string.Empty; foreach (HtmlElement cell in row.GetElementsByTagName("td")) { if (i == 1) { lessonName = cell.InnerHtml; } if (i == 3) { tmpMarks = cell; } i++; } var marks = new LessonMark { LessonName = lessonName, Marks = new List <StudentMark>() }; foreach (HtmlElement mark in tmpMarks.GetElementsByTagName("a")) { var studentMark = new StudentMark { Mark = int.Parse(mark.InnerText), Reason = GetTextBetweenSubstrings(mark.GetAttribute("title"), "За что получена:", string.Empty), Date = GetDateFromComment(mark.GetAttribute("title")) }; marks.Marks.Add(studentMark); } return(marks); }
public ActionResult Showdetails() { //var dblist = entityobj.Student_Detail.Where(x => !x.Is_Delete).Select(x => x).ToList(); var studetailobj = entityobj.Student_Detail.Where(x => x.Is_Delete != true).Select(x => x).ToList(); // var studetailsobj = entityobj.Student_Detail.Select(s => s).ToList(); var studentdeptobj = entityobj.Student_Dep.Select(s => s).ToList(); var studentlist = new List <StudentMark>(); if (studetailobj != null) { foreach (var item in studetailobj) { StudentMark modelobj = new StudentMark(); modelobj.Std_Id = item.Std_Id; modelobj.Name = item.Name; modelobj.Email = item.Email; modelobj.Gender = item.Gender; modelobj.Dept_Name = studentdeptobj.Where(s => s.Dep_Id == item.Dep_Id).Select(s => s.Dep_Name).SingleOrDefault(); studentlist.Add(modelobj); } } return(View(studentlist)); }
private List <MarksModel> PrepareMarksList(List <MarksModel> marks, int StudentID) { DuckTaleInterviewDBEntities _db = new DuckTaleInterviewDBEntities(); List <StudentMark> stdmarks; using (_db) { foreach (MarksModel model in marks) { StudentMark studentMark = new StudentMark() { Marks = model.Marks, StudentID = StudentID, SubjectID = model.SubjectID, Deleted = false }; _db.StudentMarks.Add(studentMark); _db.SaveChanges(); } stdmarks = _db.StudentMarks.Where(x => x.StudentID == StudentID).Where(x => x.Deleted == false).ToList(); } List <MarksModel> mModel = new List <MarksModel>(); foreach (var m in stdmarks) { MarksModel marksModel = new MarksModel() { Marks = m.Marks, SubjectID = m.SubjectID, SubjectName = GetSubjectName(m.SubjectID) }; mModel.Add(marksModel); } return(mModel); }
//Created by Vivek on 18.07.2013 /// <summary> /// Students the mark update. /// </summary> /// <param name="studentMarkUpdate">The student mark update.</param> public void StudentMarkUpdate(StudentMark studentMarkUpdate) { studentDataService.StudentMarkUpdate(studentMarkUpdate); }