public List <ExamDM.FillInternalMarksDM> FillStudentForEnternalSubjectGrouping(int Course_ID, int SemesterID, string SessionID, int EgroupId, int Subject_Category_Id, int instid, int spclid)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.CreateParameters(7);
objDB.AddParameters(0, "CourseID", Course_ID, DbType.Int32);
objDB.AddParameters(1, "SemesterID", SemesterID, DbType.Int32);
objDB.AddParameters(2, "SessionID", SessionID, DbType.String);
objDB.AddParameters(3, "EgroupId", EgroupId, DbType.Int32);
objDB.AddParameters(4, "Subject_CategoryID", Subject_Category_Id, DbType.Int32);
objDB.AddParameters(5, "spclID", spclid, DbType.Int32);
objDB.AddParameters(6, "intid", instid, DbType.Int32);
IDataReader dr = (IDataReader)objDB.ExecuteReader(CommandType.StoredProcedure, "FillStudentListForIntGrouping");
var listOfStudent = new List <ExamDM.FillInternalMarksDM>();
while (dr.Read())
{
var item = new ExamDM.FillInternalMarksDM();
item.RecordId = Education.DataHelper.GetInt(dr, "RecordId");
item.StudentID = Education.DataHelper.GetInt(dr, "StudentID");
item.Name = Education.DataHelper.GetString(dr, "Name");
item.RollNo = Education.DataHelper.GetString(dr, "RollNo");
item.Group = Education.DataHelper.GetString(dr, "GroupName");
listOfStudent.Add(item);
}
objDB.DataReader.Close();
objDB.Connection.Close();
return(listOfStudent);
}
public List <ExamDM.FillInternalMarksDM> FillStudentForEditIntAttendance(int InstituteID, int Course_ID, int SemesterID, string SessionID, string BatchID, int SplID, int SubjectID, int testtypeid, int testid, int Flag)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.CreateParameters(9);
objDB.AddParameters(0, "CourseID", Course_ID, DbType.Int32);
objDB.AddParameters(1, "SemesterID", SemesterID, DbType.Int32);
objDB.AddParameters(2, "SessionID", SessionID, DbType.String);
objDB.AddParameters(3, "BatchID", BatchID, DbType.String);
objDB.AddParameters(4, "SplID", SplID, DbType.Int32);
objDB.AddParameters(5, "testtypeid", testtypeid, DbType.Int32);
objDB.AddParameters(6, "testid", testid, DbType.Int32);
objDB.AddParameters(7, "SubjectID", SubjectID, DbType.Int32);
objDB.AddParameters(8, "Flag", Flag, DbType.Int32);
IDataReader dr = (IDataReader)objDB.ExecuteReader(CommandType.StoredProcedure, "FillStudentAttendance");
var listOfStudent = new List <ExamDM.FillInternalMarksDM>();
while (dr.Read())
{
var item = new ExamDM.FillInternalMarksDM();
item.StudentID = Education.DataHelper.GetInt(dr, "StudentID");
item.Name = Education.DataHelper.GetString(dr, "Name");
// item.ID_Student = Education.DataHelper.GetString(dr, "ID_Student");
item.RollNo = Education.DataHelper.GetString(dr, "RollNo");
item.marksObtained = Education.DataHelper.GetDecimal(dr, "marksObtained");
item.Batch_Name = Education.DataHelper.GetString(dr, "Batch_Name");
item.RegNo = Education.DataHelper.GetString(dr, "RegNo");
item.AttId = Education.DataHelper.GetInt(dr, "AttId");
item.marksId = Education.DataHelper.GetInt(dr, "marksId");
item.Status = Education.DataHelper.GetBoolean(dr, "Status");
listOfStudent.Add(item);
}
objDB.DataReader.Close();
objDB.Connection.Close();
return(listOfStudent);
}
