public DataTable CRUDAddExams(StudentsExams stdExam, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("StudentExamId", stdExam.ExamTimesId);
SqlParameter objSqlParameter1 = new SqlParameter("StudentId", stdExam.StudentId);
SqlParameter objSqlParameter2 = new SqlParameter("Description", stdExam.Description);
SqlParameter objSqlParameter3 = new SqlParameter("CourseId", stdExam.CourseId);
SqlParameter objSqlParameter4 = new SqlParameter("ExamTime", stdExam.ExamTimesId);
SqlParameter objSqlParameter5 = new SqlParameter("ExamDate", stdExam.ExamDate);
SqlParameter objSqlParameter6 = new SqlParameter("Fees", stdExam.Fees);
SqlParameter objSqlParameter7 = new SqlParameter("IsExpired", stdExam.IsExpired);
SqlParameter objSqlParameter8 = new SqlParameter("ExamResult", stdExam.ExamResult);
SqlParameter objSqlParameter9 = new SqlParameter("IsAppeared", stdExam.IsAppeared);
SqlParameter objSqlParameter10 = new SqlParameter("LoggedInUser", stdExam.LoggedInUser);
SqlParameter objSqlParameter11 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7, objSqlParameter8, objSqlParameter9, objSqlParameter10, objSqlParameter11 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDExams", lstSqlParams);
}
catch (Exception ex)
{
}
return(dtResult);
}
public DataTable CRUDUsers(User objUser, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("UserId", objUser.UserId);
SqlParameter objSqlParameter1 = new SqlParameter("UserPassword", objUser.UserPassword);
SqlParameter objSqlParameter2 = new SqlParameter("FirstName", objUser.FirstName);
SqlParameter objSqlParameter3 = new SqlParameter("LastName", objUser.LastName);
SqlParameter objSqlParameter4 = new SqlParameter("MobileNo", objUser.MobileNo);
SqlParameter objSqlParameter5 = new SqlParameter("EmailId", objUser.EmailId);
SqlParameter objSqlParameter6 = new SqlParameter("UserTypeId", objUser.UserTypeId);
SqlParameter objSqlParameter7 = new SqlParameter("IsActive", objUser.IsActive);
SqlParameter objSqlParameter8 = new SqlParameter("LoggedInUser", objUser.LoggedInUser);
SqlParameter objSqlParameter9 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7, objSqlParameter8, objSqlParameter9 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDUsers", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtResult);
}
public DataTable CRUDFeess(FeesMaster objFees, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("FeesId", objFees.FeesId);
SqlParameter objSqlParameter1 = new SqlParameter("CourseId", objFees.CourseId);
SqlParameter objSqlParameter2 = new SqlParameter("Description", objFees.Description);
SqlParameter objSqlParameter3 = new SqlParameter("Offer", objFees.Offer);
SqlParameter objSqlParameter4 = new SqlParameter("Amount", objFees.Amount);
SqlParameter objSqlParameter5 = new SqlParameter("SGST", objFees.SGST);
SqlParameter objSqlParameter6 = new SqlParameter("CGST", objFees.CGST);
SqlParameter objSqlParameter7 = new SqlParameter("LoggedInUser", objFees.LoggedInUser);
SqlParameter objSqlParameter8 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7, objSqlParameter8 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDFees", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtResult);
}
public DataTable GetUserTypes()
{
DataTable dtUser = new DataTable();
try
{
dtUser = DBCommon.ExecuteDataAdapterDataTable("GetUserTypes", null);
}
catch (Exception ex)
{
throw;
}
return(dtUser);
}
public DataTable GetUserList(User objUser)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("UserId", objUser.UserId);
SqlParameter objSqlParameter1 = new SqlParameter("Username", objUser.LoggedInUser);
SqlParameter objSqlParameter2 = new SqlParameter("UserTypeId", objUser.UserTypeId);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("uspUserList", lstSqlParams);
}
catch (Exception ex)
{
}
return(dtResult);
}
public DataTable SignIn(string loginId, string password)
{
DataTable dtUser = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("LoginId", loginId);
SqlParameter objSqlParameter1 = new SqlParameter("UserPassword", password);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1 });
dtUser = DBCommon.ExecuteDataAdapterDataTable("UserLogin", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtUser);
}
public DataTable CRUDExamTimes(ExamTimes ansType, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("ExamTimesId", ansType.ExamTimesId);
SqlParameter objSqlParameter1 = new SqlParameter("ExamTime", ansType.ExamTime);
SqlParameter objSqlParameter2 = new SqlParameter("Description", ansType.Description);
SqlParameter objSqlParameter3 = new SqlParameter("LoggedInUser", ansType.LoggedInUser);
SqlParameter objSqlParameter4 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("uspCrudExamTimes", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtResult);
}
public DataTable CRUDAnswers(AnswerMaster ansType, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("AnswerId", ansType.AnswerId);
SqlParameter objSqlParameter1 = new SqlParameter("Answer", ansType.Answer);
SqlParameter objSqlParameter2 = new SqlParameter("QuestionId", ansType.QuestionId);
SqlParameter objSqlParameter3 = new SqlParameter("IsRight", ansType.IsRight);
SqlParameter objSqlParameter4 = new SqlParameter("LoggedInUser", ansType.LoggedInUser);
SqlParameter objSqlParameter5 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDAnswers", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtResult);
}
public DataTable CRUDCourses(CourseMaster objCourse, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("CourseId", objCourse.CourseId);
SqlParameter objSqlParameter1 = new SqlParameter("CourseName", objCourse.CourseName);
SqlParameter objSqlParameter2 = new SqlParameter("Description", objCourse.Description);
SqlParameter objSqlParameter3 = new SqlParameter("Eligibility", objCourse.Eligibility);
SqlParameter objSqlParameter4 = new SqlParameter("LoggedInUser", objCourse.LoggedInUser);
SqlParameter objSqlParameter5 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDCourses", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtResult);
}
public DataTable SaveExamPapers(List <QuestionMaster> questionMaster)
{
DataTable ds = new DataTable();
try
{
foreach (QuestionMaster question in questionMaster)
{
SqlParameter objSqlParameter = new SqlParameter("StudentId", question.StudentId);
SqlParameter objSqlParameter1 = new SqlParameter("QuestionAnswerId", question.QuestionAnswerId);
SqlParameter objSqlParameter2 = new SqlParameter("QuestionId", question.QuestionId);
SqlParameter objSqlParameter3 = new SqlParameter("CourseId", question.CourseId);
SqlParameter objSqlParameter4 = new SqlParameter("AnswerId", question.AnswerId);
SqlParameter objSqlParameter5 = new SqlParameter("StudentExamId", question.StudentExamId);
SqlParameter objSqlParameter6 = new SqlParameter("LoggedInUser", question.LoggedInUser);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6 });
ds = DBCommon.ExecuteDataAdapterDataTable("uspAddQuestionAnswer", lstSqlParams);
}
}
catch (Exception ex)
{
}
return(ds);
}
public DataTable CRUDFeess(StudentDetails objFees, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("StudentId", objFees.StudentId);
SqlParameter objSqlParameter1 = new SqlParameter("StudentUniqueId", objFees.StudentUniqueId);
SqlParameter objSqlParameter2 = new SqlParameter("FirstName", objFees.FirstName);
SqlParameter objSqlParameter3 = new SqlParameter("LastName", objFees.LastName);
SqlParameter objSqlParameter4 = new SqlParameter("MobileNo", objFees.MobileNo);
SqlParameter objSqlParameter5 = new SqlParameter("EmailId", objFees.EmailId);
SqlParameter objSqlParameter6 = new SqlParameter("LoggedInUser", objFees.LoggedInUser);
SqlParameter objSqlParameter7 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDStudentDetails", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtResult);
}