public int FachTopicwiseResult(SYS_TeacherActivityFeedback TA)
{
DAccess = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("SchoolID", TA.SchoolID));
arrParameter.Add(new parameter("BMSSCTID", TA.BMSSCTID));
arrParameter.Add(new parameter("EmployeeID", TA.EmployeeID));
arrParameter.Add(new parameter("DivisionID", TA.DivisionID));
arrParameter.Add(new parameter("Feedback", TA.Feedback));
arrParameter.Add(new parameter("CreatedBy", TA.CreatedBy));
arrParameter.Add(new parameter("FeedbackTable", TA.FeedbackQuestion));
return(DAccess.executescalre("PROC_INSERT_TeacherActivityFeedback", arrParameter));
}
public int SaveStudentFeeback(SYS_TeacherActivityFeedback TA)
{
//DataAccessEpathshalaStudent objDAL = new DataAccessEpathshalaStudent();
DataAccess objDAL = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("SchoolID", TA.SchoolID));
arrParameter.Add(new parameter("BMSSCTID", TA.BMSSCTID));
arrParameter.Add(new parameter("StudentID", TA.StudentID));
arrParameter.Add(new parameter("DivisionID", TA.DivisionID));
arrParameter.Add(new parameter("Feedback", TA.Feedback));
arrParameter.Add(new parameter("CreatedBy", TA.CreatedBy));
arrParameter.Add(new parameter("FeedbackTable", TA.FeedbackQuestion));
return(objDAL.executescalre("PROC_INSERT_TeacherActivityFeedbackForStudent", arrParameter));
}
public DataTable GetFeedbackDetail1(SYS_TeacherActivityFeedback TA)
{
try
{
objDAL = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("SchoolID", TA.SchoolID));
arrParameter.Add(new parameter("BMSSCTID", TA.BMSSCTID));
arrParameter.Add(new parameter("DivisionID", TA.DivisionID));
//return objDAL.DAL_SelectAll("Proc_SelectFeedbackQuestionList").Tables[0];
return(objDAL.DAL_Select("Proc_SelectFeedbackQuestionListNew1", arrParameter).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
//public string Covered(SYS_TeacherActivityFeedback TA)
//{
// DAccess = new DataAccess();
// arrParameter = new ArrayList();
// arrParameter.Add(new parameter("BMSSCTID", TA.BMSSCTID));
// arrParameter.Add(new parameter("DivisionID", TA.DivisionID));
// // return DAccess.executescalre("Proc_Activity", arrParameter);
// return DAccess.executescalre("Proc_Activity", arrParameter);
//}
public string Covered(SYS_TeacherActivityFeedback TA)
{
DAccess = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSSCTID", TA.BMSSCTID));
arrParameter.Add(new parameter("DivisionID", TA.DivisionID));
// return DAccess.executescalre("Proc_Activity", arrParameter);
DataSet ds = new DataSet();
ds = DAccess.DAL_Select("Proc_Activity", arrParameter);
string rtnStr = "";
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
rtnStr = ds.Tables[0].Rows[0][0].ToString();
}
}
return(rtnStr);
}
public DataTable GetFeedbackDetailStudent1(SYS_TeacherActivityFeedback TA)
{
try
{
//DataAccessEpathshalaStudent objDAL = new DataAccessEpathshalaStudent();
DataAccess objDAL = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("SchoolID", TA.SchoolID));
arrParameter.Add(new parameter("BMSSCTID", TA.BMSSCTID));
arrParameter.Add(new parameter("StudentID", TA.StudentID));
return(objDAL.DAL_Select("Proc_SelectFeedbackQuestionListForStudent1", arrParameter).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}