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