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);
}
