public IQueryable <StudentClassChange> GetStudentClassChange(int ClassDivisionId, int schoolId)
{
try
{
List <StudentClassChange> entities = new List <StudentClassChange>();
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@ClassDivisionId", ClassDivisionId);
parameterlist.Add("@SchoolId", schoolId);
//ExecuteProcedureReader
DataSet ds = CommanMethodsForSQL.ExecuteProcedureReader("sp_GetStudentByClassDivision", parameterlist);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr != null)
{
StudentClassChange entity = new StudentClassChange();
entity.StudentId = Convert.ToInt32(dr["StudentId"]);
entity.StudentFullNameWithTitle = Convert.ToString(dr["StudentName"]);
entity.RegisterId = Convert.ToInt32(dr["RegisterId"]);
entities.Add(entity);
}
}
}
return(entities.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public void StudentChangeClassDivision(StudentClassChange entity, int schoolId)
{
try
{
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@SchoolId", schoolId);
parameterlist.Add("@PreviousClassDivisionId", entity.PreviousClassDivisionId);
parameterlist.Add("@CurrentClassDivisionId", entity.CurrentClassDivisionId);
parameterlist.Add("@Status", 1);
parameterlist.Add("@CreatedBy", 0);
parameterlist.Add("@CreatedDate", DateTime.Today.Date);
DataTable dt = new DataTable();
dt.Columns.Add("StudentId", typeof(int));
dt.Columns.Add("Remark", typeof(string));
for (int i = 0; i < entity.SelectedStudent.Length; i++)
{
DataRow dr = dt.NewRow();
dr["StudentId"] = entity.SelectedStudent[i];
dr["Remark"] = entity.Remark;
dt.Rows.Add(dr);
}
parameterlist.Add("@ClassChangeDataType", dt);
int effetedRows = CommanMethodsForSQL.StudentChangeClassDivision("sp_StudentChangeClassDivision", parameterlist);
if (effetedRows > 0)
{
}
}
catch (Exception ex)
{
throw;
}
}
public void StudentChangeClassDivision(StudentClassChange entity, int schoolId)
{
StudentDAL dalObject = new StudentDAL();
dalObject.StudentChangeClassDivision(entity, schoolId);
}
