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 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 GetUserTypes()
{
DataTable dtUser = new DataTable();
try
{
dtUser = DBCommon.ExecuteDataAdapterDataTable("GetUserTypes", null);
}
catch (Exception ex)
{
throw;
}
return(dtUser);
}
public int EliminarVentas(Ventas pEN)
{
IDbConnection _conn = DBCommon.Conexion();
_conn.Open();
SqlCommand _command = new SqlCommand("ELIMINAR_VENTAS", _conn as SqlConnection);
_command.CommandType = CommandType.StoredProcedure;
_command.Parameters.Add(new SqlParameter("@ID", pEN.Id));
int resultado = _command.ExecuteNonQuery();
_conn.Close();
return(resultado);
}
public DataSet ExamPapers(int examId, long studentId)
{
DataSet ds = new DataSet();
try
{
SqlParameter objSqlParameter = new SqlParameter("StudentId", studentId);
SqlParameter objSqlParameter1 = new SqlParameter("ExamId", examId);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1 });
ds = DBCommon.ExecuteDataAdapterDataDataset("uspSelectQuestionPaper", lstSqlParams);
}
catch (Exception ex)
{
}
return(ds);
}
public int AgregarVenta(Ventas pEN)
{
IDbConnection _conn = DBCommon.Conexion();
_conn.Open();
SqlCommand _command = new SqlCommand("AGREGAR_VENTAS", _conn as SqlConnection);
_command.CommandType = CommandType.StoredProcedure;
_command.Parameters.Add(new SqlParameter("@NOMBRE", pEN.Nombre));
_command.Parameters.Add(new SqlParameter("@TOTAL_VENTAS", pEN.Total_Ventas));
_command.Parameters.Add(new SqlParameter("@ESTADO", pEN.Estado));
int resultado = _command.ExecuteNonQuery();
_conn.Close();
return(resultado);
}
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 List <Ventas> MostrarVentas()
{
IDbConnection _conn = DBCommon.Conexion();
_conn.Open();
SqlCommand _command = new SqlCommand("CONSULTAR_VENTAS", _conn as SqlConnection);
_command.CommandType = CommandType.StoredProcedure;
IDataReader _reader = _command.ExecuteReader();
List <Ventas> lista = new List <Ventas>();
while (_reader.Read())
{
Ventas _ventas = new Ventas();
_ventas.Id = _reader.GetInt32(0);
_ventas.Nombre = _reader.GetString(1);
_ventas.Total_Ventas = _reader.GetInt32(2);
_ventas.Estado = _reader.GetString(3);
lista.Add(_ventas);
}
_conn.Close();
return(lista);
}
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);
}
