private int InsertExamMark()
{
int Returnvalue = 0;
ExamMark TheExamMark = new ExamMark();
try
{
TheExamMark.ExamScheduleID = int.Parse(drpdwn_ExamMarkSeheduleID.SelectedValue);
TheExamMark.MarksObtained = int.Parse(txt_MarksObtained.Text);
TheExamMark.StudentID = drpdwn_StudentOnSeheduleID.SelectedValue;
TheExamMark.VarifiedBy = txt_VarifiedBy.Text;
TheExamMark.AddedBy = 44; //:TO DO Kanhu HARD CODE
TheExamMark.OfficeID = 1; //:TO DO Kanhu HARD CODE
TheExamMark.CompanyID = 1; //:TO DO Kanhu HARD CODE
TheExamMark.IsActive = true;
TheExamMark.IsDeleted = false;
}
catch (Exception ex)
{
}
finally
{
}
Returnvalue = ExamMarkManagement.InsertExamMarks(TheExamMark);
return(Returnvalue);
}
public ExamMark GetMark(int studentId)
{
ExamMark examMark = new ExamMark();
using (SqlConnection con = new SqlConnection(path))
{
con.Open();
SqlCommand cmd = new SqlCommand($"sp_StudentDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", studentId);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
examMark.UserID = Convert.ToInt32(dr["UserID"]);
examMark.Name = Convert.ToString(dr["Name"]);
examMark.Class = Convert.ToInt32(dr["Class"]);
examMark.Malayalam = Convert.ToInt32(dr["Malayalam"]);
examMark.English = Convert.ToInt32(dr["English"]);
examMark.Hindi = Convert.ToInt32(dr["Hindi"]);
examMark.Mathematics = Convert.ToInt32(dr["Mathematics"]);
examMark.Science = Convert.ToInt32(dr["Science"]);
examMark.SocialScience = Convert.ToInt32(dr["SocialScience"]);
examMark.Total = Convert.ToInt32(dr["Total"]);
examMark.Percentage = Convert.ToInt32(dr["Percentage"]);
examMark.Grade = Convert.ToString(dr["Grade"]);
}
}
return(examMark);
}
public async Task <IActionResult> Edit(int id, [Bind("ExamMarkId,ExamId,ClassSubjectId,StudentId,UserId,TotalMarks,ObtainMarks")] ExamMark examMark)
{
var user = await GetCurrentUserAsync();
examMark.ApplicationUserId = user?.Id;
if (id != examMark.ExamMarkId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(examMark);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ExamMarkExists(examMark.ExamMarkId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(examMark));
}
public ActionResult DeleteConfirmed(int id)
{
ExamMark examMark = db.ExamMarks.Find(id);
db.ExamMarks.Remove(examMark);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void UpdateExamMarks(ExamMark entity, ExamMark model)
{
entity.ExamId = model.ExamId;
entity.ClassSubjectId = model.ClassSubjectId;
entity.StudentId = model.StudentId;
// entity.UserId = model.UserId;
entity.TotalMarks = model.TotalMarks;
entity.ObtainMarks = model.ObtainMarks;
}
// GET: ExamMarks/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExamMark examMark = db.ExamMarks.Find(id);
if (examMark == null)
{
return(HttpNotFound());
}
return(View(examMark));
}
public ActionResult Edit([Bind(Include = "Id,StudentId,SubjectCode,Marks,ExamName,SemesterId,Session,DepartmentId,AddedDate,AddedBy")] ExamMark examMark)
{
if (ModelState.IsValid)
{
db.Entry(examMark).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentName", examMark.DepartmentId);
ViewBag.AddedBy = new SelectList(db.Users, "UserId", "UserName", examMark.AddedBy);
ViewBag.SemesterId = new SelectList(db.Semesters, "SemesterId", "SemesterName", examMark.SemesterId);
ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentName", examMark.StudentId);
return(View(examMark));
}
private void PopulateFormField(ExamMark TheExamMark, int Record)
{
lbl_Hidden_ExamMarkID.Text = Record.ToString();
drpdwn_ExamMarkSeheduleID.SelectedValue = TheExamMark.ExamScheduleID.ToString();
Student objStudent = new Student();
objStudent = (from xyzl in StudentManagement.GetInstance.GetStudentList()
where xyzl.StudentID == int.Parse(TheExamMark.StudentID)
select xyzl).Single();
drpdwn_StudentOnSeheduleID.Items.Insert(0, new ListItem(objStudent.StudentName, TheExamMark.StudentID));
//drpdwn_StudentOnSeheduleID.SelectedValue = TheExamMark.StudentID;
txt_MarksObtained.Text = TheExamMark.MarksObtained.ToString();
txt_VarifiedBy.Text = TheExamMark.VarifiedBy;
}
private int DeleteExamMark(int Record)
{
int Returnvalue = 0;
ExamMark DeleteExamMark = new ExamMark();
DeleteExamMark.Exam_Mark_ScheduleID = Record;
DeleteExamMark.ModifiedBy = 1; //:TO DO Kanhu HARD CODE
DeleteExamMark.OfficeID = 44; //:TO DO Kanhu HARD CODE
DeleteExamMark.CompanyID = 8; //:TO DO Kanhu HARD CODE
DeleteExamMark.IsActive = false;
DeleteExamMark.IsDeleted = true;
Returnvalue = ExamMarkManagement.DeleteExamMarks(DeleteExamMark);
return(Returnvalue);
}
public async Task <IActionResult> Create(ExamMark examMark)
{
var user = await GetCurrentUserAsync();
examMark.ApplicationUserId = user?.Id;
if (ModelState.IsValid)
{
_context.Add(examMark);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(examMark));
}
// GET: ExamMarks/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExamMark examMark = db.ExamMarks.Find(id);
if (examMark == null)
{
return(HttpNotFound());
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentName", examMark.DepartmentId);
ViewBag.AddedBy = new SelectList(db.Users, "UserId", "UserName", examMark.AddedBy);
ViewBag.SemesterId = new SelectList(db.Semesters, "SemesterId", "SemesterName", examMark.SemesterId);
ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentName", examMark.StudentId);
return(View(examMark));
}
public ActionResult <ExamMark> saveMark(ExamMark examMarks)
{
try
{
var examMrk = _examMarkRepo.AddExamMark(examMarks);
if (examMrk == null)
{
return(NotFound());
}
return(Ok(examMrk));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
}
public int DeleteExamMarks(ExamMark TheExamMark)
{
int ReturnValue = 0;
using (SqlCommand DeleteCommand = new SqlCommand())
{
DeleteCommand.CommandType = CommandType.StoredProcedure;
//DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
DeleteCommand.Parameters.Add(GetParameter("@Exam_Mark_ScheduleID", SqlDbType.Int, TheExamMark.Exam_Mark_ScheduleID));
DeleteCommand.Parameters.Add(GetParameter("@ExamScheduleID", SqlDbType.Int, TheExamMark.ExamScheduleID));
DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, TheExamMark.ModifiedBy));
DeleteCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, TheExamMark.OfficeID));
DeleteCommand.Parameters.Add(GetParameter("@CompanyID", SqlDbType.Int, TheExamMark.CompanyID));
DeleteCommand.CommandText = "pICAS_ExamMarks_Delete";
ExecuteStoredProcedure(DeleteCommand);
ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString());
}
return(ReturnValue);
}
public ActionResult DeleteConfirmed(int id)
{
Admission admsn = db.Admission.Where(x => x.StudentId == id).SingleOrDefault();
if (admsn != null)
{
db.Admission.Remove(admsn);
db.SaveChanges();
}
Guardian grdn = db.Guardian.Where(x => x.StudentId == id).SingleOrDefault();
if (grdn != null)
{
db.Guardian.Remove(grdn);
db.SaveChanges();
}
int arId = db.AssignRoll.Where(x => x.StudentId == id).Select(x => x.Id).SingleOrDefault();
ExamMark em = db.ExamMark.Where(x => x.AssignRollId == arId).SingleOrDefault();
if (em != null)
{
db.ExamMark.Remove(em);
db.SaveChanges();
}
AssignRoll ar = db.AssignRoll.Where(x => x.StudentId == id).SingleOrDefault();
if (ar != null)
{
db.AssignRoll.Remove(ar);
db.SaveChanges();
}
Student student = db.Student.Find(id);
db.Student.Remove(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(ExamMark examMark)
{
if (ModelState.IsValid)
{
db.Entry(examMark).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
var studentClass = db.StudentClass.Select(c => new
{
Id = c.Id,
Name = c.ClassName.Name + " || " + c.Shift.Name + " ||" + c.Section.Name
}).OrderBy(o => o.Name).ToList();
ViewBag.SessionId = new SelectList(db.Session, "Id", "Name");
ViewBag.CourseId = new SelectList(db.Course, "Id", "Name");
ViewBag.StudentClassId = new SelectList(studentClass, "Id", "Name");
ViewBag.AssignRollId = new SelectList(db.AssignRoll, "Id", "Roll");
return(View(examMark));
}
private int UpdateExamMark()
{
int Returnvalue = 0;
ExamMark UpdateExamMark = new ExamMark();
UpdateExamMark.Exam_Mark_ScheduleID = int.Parse(lbl_Hidden_ExamMarkID.Text);
UpdateExamMark.ExamScheduleID = int.Parse(drpdwn_ExamMarkSeheduleID.SelectedValue);
UpdateExamMark.MarksObtained = int.Parse(txt_MarksObtained.Text);
UpdateExamMark.StudentID = drpdwn_StudentOnSeheduleID.SelectedValue;
UpdateExamMark.VarifiedBy = txt_VarifiedBy.Text;
UpdateExamMark.ModifiedBy = 44; //:TO DO Kanhu HARD CODE
UpdateExamMark.OfficeID = 1; //:TO DO Kanhu HARD CODE
UpdateExamMark.CompanyID = 1; //:TO DO Kanhu HARD CODE
UpdateExamMark.IsActive = true;
UpdateExamMark.IsDeleted = false;
Returnvalue = ExamMarkManagement.UpdateExamMarks(UpdateExamMark);
return(Returnvalue);
}
public void UpdateMark(ExamMark examMark)
{
using (SqlConnection con = new SqlConnection(path))
{
con.Open();
SqlCommand cmd = new SqlCommand($"sp_UpdateMark", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", examMark.UserID);
cmd.Parameters.AddWithValue("@Malayalam", examMark.Malayalam);
cmd.Parameters.AddWithValue("@English", examMark.English);
cmd.Parameters.AddWithValue("@Hindi", examMark.Hindi);
cmd.Parameters.AddWithValue("@Mathematics", examMark.Mathematics);
cmd.Parameters.AddWithValue("@Science", examMark.Science);
cmd.Parameters.AddWithValue("@SocialScience", examMark.SocialScience);
cmd.Parameters.AddWithValue("@Total", examMark.Total);
cmd.Parameters.AddWithValue("@Percentage", examMark.Percentage);
cmd.Parameters.AddWithValue("@Grade", examMark.Grade);
int RowCount = cmd.ExecuteNonQuery();
con.Close();
}
}
public int UpdateExamMarks(ExamMark TheExamMark)
{
int ReturnValue = 0;
using (SqlCommand UpdateExamCommand = new SqlCommand())
{
UpdateExamCommand.CommandType = CommandType.StoredProcedure;
//UpdateExamCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateExamCommand.Parameters.Add(GetParameter("@Exam_Mark_ScheduleID", SqlDbType.Int, TheExamMark.Exam_Mark_ScheduleID));
UpdateExamCommand.Parameters.Add(GetParameter("@ExamScheduleID", SqlDbType.Int, TheExamMark.ExamScheduleID));
UpdateExamCommand.Parameters.Add(GetParameter("@StudentID", SqlDbType.Int, TheExamMark.StudentID));
UpdateExamCommand.Parameters.Add(GetParameter("@MarksObtained", SqlDbType.Int, TheExamMark.MarksObtained));
UpdateExamCommand.Parameters.Add(GetParameter("@VarifiedBy", SqlDbType.VarChar, TheExamMark.VarifiedBy));
UpdateExamCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, TheExamMark.AddedBy));
UpdateExamCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, TheExamMark.OfficeID));
UpdateExamCommand.Parameters.Add(GetParameter("@CompanyID", SqlDbType.Int, TheExamMark.CompanyID));
UpdateExamCommand.CommandText = "pICAS_ExamMarks_Update";
ExecuteStoredProcedure(UpdateExamCommand);
ReturnValue = int.Parse(UpdateExamCommand.Parameters[0].Value.ToString());
}
return(ReturnValue);
}
public IActionResult AssignMark(int userId)
{
try
{
int Logged = Convert.ToInt32(HttpContext.Session.GetInt32("Logged"));
int User = Convert.ToInt32(HttpContext.Session.GetInt32("User"));
if (Logged == 1 && User == 2)
{
StudentDA student = new StudentDA();
examMark = student.GetMark(userId);
return(View(examMark));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
string exMessage = "oops! There is a problem in loading the page for assigning marks.";
return(RedirectToAction("Index", "ExeptionHandler", new { Exeption = exMessage }));
}
}
private static List <ExamMark> ConvertDatarowToObject(DataTable ExamListTable)
{
List <ExamMark> ExamList = new List <ExamMark>();
foreach (DataRow dr in ExamListTable.Rows)
{
ExamMark theExamMark = new ExamMark();
theExamMark.Exam_Mark_ScheduleID = int.Parse(dr["Exam_Mark_ScheduleID"].ToString());
theExamMark.ExamScheduleID = int.Parse(dr["ExamScheduleID"].ToString());
theExamMark.StudentID = dr["StudentID"].ToString();
theExamMark.MarksObtained = int.Parse(dr["MarksObtained"].ToString());
theExamMark.VarifiedBy = dr["VarifiedBy"].ToString();
theExamMark.IsActive = bool.Parse(dr["IsActive"].ToString());
//theExamMark.ModifiedBy = int.Parse(dr["ModifiedBy"].ToString());
//theExamMark.DateModified = dr["DateModified"].ToString();
theExamMark.AddedBy = int.Parse(dr["AddedBy"].ToString());
theExamMark.OfficeID = (string.IsNullOrEmpty(dr["OfficeID"].ToString()) ? 0 : int.Parse(dr["OfficeID"].ToString()));
theExamMark.CompanyID = (string.IsNullOrEmpty(dr["CompanyID"].ToString()) ? 0 : int.Parse(dr["CompanyID"].ToString()));
ExamList.Add(theExamMark);
}
return(ExamList);
}
public IActionResult Home(UserInfo userInfo)
{
try
{
int Logged = Convert.ToInt32(HttpContext.Session.GetInt32("Logged"));
if (Logged == 1)
{
StudentDA student = new StudentDA();
examMark = student.GetMark(userInfo.UserID);
ViewBag.StudentId = userInfo.UserID;
return(View(examMark));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
string exMessage = "oops! There is a problem in loading the home page.";
return(RedirectToAction("Index", "ExeptionHandler", new { Exeption = exMessage }));
}
}
// GET: ExamMarks/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExamMark examMark = db.ExamMark.Find(id);
if (examMark == null)
{
return(HttpNotFound());
}
var studentClass = db.StudentClass.Select(c => new
{
Id = c.Id,
Name = c.ClassName.Name + " || " + c.Shift.Name + " ||" + c.Section.Name
}).OrderBy(o => o.Name).ToList();
ViewBag.SessionId = new SelectList(db.Session, "Id", "Name");
ViewBag.CourseId = new SelectList(db.Course, "Id", "Name");
ViewBag.StudentClassId = new SelectList(studentClass, "Id", "Name");
ViewBag.AssignRollId = new SelectList(db.AssignRoll, "Id", "Roll");
return(View(examMark));
}
public IActionResult AssignMark(ExamMark examMark)
{
try
{
int Logged = Convert.ToInt32(HttpContext.Session.GetInt32("Logged"));
int User = Convert.ToInt32(HttpContext.Session.GetInt32("User"));
if (Logged == 1 && User == 2)
{
examMark.Calculate();
teacherDA.UpdateMark(examMark);
string success = "Marks entered successfully";
return(RedirectToAction("StudentList", new { message = success }));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
string exMessage = "oops! There is a problem in assigning marks.";
return(RedirectToAction("Index", "ExeptionHandler", new { Exeption = exMessage }));
}
}
protected void gridview_ExamMarkList_RowCommand(object sender, GridViewCommandEventArgs e)
{
int RowIndex = 0;
if (!e.CommandName.Equals(MicroEnums.DataOperation.Page.GetStringValue()))
{
RowIndex = Convert.ToInt32(e.CommandArgument);
int RecordID = int.Parse(((Label)gridview_ExamMarkList.Rows[RowIndex].FindControl("lbl_ExamMarkID")).Text);
ExamMark ObjExamMark = new ExamMark();
ObjExamMark = (from xyz2 in ExamMarkManagement.GetExamsMarkList()
where xyz2.Exam_Mark_ScheduleID == RecordID
select xyz2).Single();
if (e.CommandName.Equals(MicroEnums.DataOperation.Edit.GetStringValue()))
{
PopulateFormField(ObjExamMark, RecordID);
ExamMarks_Multi.SetActiveView(InputControls);
btn_Submit.Text = MicroEnums.DataOperation.Update.GetStringValue();
}
else if (e.CommandName.Equals(MicroEnums.DataOperation.Delete.GetStringValue()))
{
int ProcReturnValue = (int)MicroEnums.DataOperationResult.Failure;
ProcReturnValue = DeleteExamMark(RecordID);
if (ProcReturnValue > (int)MicroEnums.DataOperationResult.Success)
{
lbl_TheMessage.Text = ReadXML.GetSuccessMessage("OK_DATA_DELETED");
Bind_ExamMark_List();
}
else
{
lbl_TheMessage.Text = ReadXML.GetSuccessMessage("KO_DATA_DELETED");
}
dialog_Message.Show();
}
}
}
public static int InsertExamMark(ExamMark theExamMark)
{
return(ExamMarkDataAccess.GetInstance.InsertExamMarks(theExamMark));
}
public static int DeleteExamMark(ExamMark theExamMark)
{
return(ExamMarkDataAccess.GetInstance.DeleteExamMarks(theExamMark));
}
public static int DeleteExamMarks(ExamMark theExamMark)
{
return(ExamMarkIntegration.DeleteExamMark(theExamMark));
}
public static int UpdateExamMarks(ExamMark theExamMark)
{
return(ExamMarkIntegration.UpdateExamMark(theExamMark));
}
public static int InsertExamMarks(ExamMark theExamMark)
{
return(ExamMarkIntegration.InsertExamMark(theExamMark));
}
public void Add(StudentResult type)
{
lock (type)
{
if (Count == Date.Length)
{
var newLength = Date.Length + 1000;
var _Date = new System.DateTime[newLength];
Date.CopyTo(_Date);
Date = _Date;
var _ExamResultId = new string[newLength];
ExamResultId.CopyTo(_ExamResultId);
ExamResultId = _ExamResultId;
var _StudentId = new string[newLength];
StudentId.CopyTo(_StudentId);
StudentId = _StudentId;
var _AcademicYear = new string[newLength];
AcademicYear.CopyTo(_AcademicYear);
AcademicYear = _AcademicYear;
var _Semester = new string[newLength];
Semester.CopyTo(_Semester);
Semester = _Semester;
var _Credit = new int[newLength];
Credit.CopyTo(_Credit);
Credit = _Credit;
var _ProgramId = new string[newLength];
ProgramId.CopyTo(_ProgramId);
ProgramId = _ProgramId;
var _Level = new string[newLength];
Level.CopyTo(_Level);
Level = _Level;
var _RegisteredCourseId = new string[newLength];
RegisteredCourseId.CopyTo(_RegisteredCourseId);
RegisteredCourseId = _RegisteredCourseId;
var _Grade = new string[newLength];
Grade.CopyTo(_Grade);
Grade = _Grade;
var _GradePoint = new decimal[newLength];
GradePoint.CopyTo(_GradePoint);
GradePoint = _GradePoint;
var _ClassMark = new decimal[newLength];
ClassMark.CopyTo(_ClassMark);
ClassMark = _ClassMark;
var _ExamMark = new decimal[newLength];
ExamMark.CopyTo(_ExamMark);
ExamMark = _ExamMark;
var _TotalMark = new decimal[newLength];
TotalMark.CopyTo(_TotalMark);
TotalMark = _TotalMark;
var _Scoring = new bool[newLength];
Scoring.CopyTo(_Scoring);
Scoring = _Scoring;
var _LecturerId = new string[newLength];
LecturerId.CopyTo(_LecturerId);
LecturerId = _LecturerId;
}
Date.Span[Count] = type.Date;
ExamResultId.Span[Count] = type.ExamResultId;
StudentId.Span[Count] = type.StudentId;
AcademicYear.Span[Count] = type.AcademicYear;
Semester.Span[Count] = type.Semester;
Credit.Span[Count] = type.Credit;
ProgramId.Span[Count] = type.ProgramId;
Level.Span[Count] = type.Level;
RegisteredCourseId.Span[Count] = type.RegisteredCourseId;
Grade.Span[Count] = type.Grade;
GradePoint.Span[Count] = type.GradePoint;
ClassMark.Span[Count] = type.ClassMark;
ExamMark.Span[Count] = type.ExamMark;
TotalMark.Span[Count] = type.TotalMark;
Scoring.Span[Count] = type.Scoring;
LecturerId.Span[Count] = type.LecturerId;
}
}
