public Teacher TeacherAssociationDetails(Teacher entity)
{
string[] addParams = new string[] { Teacher_Constants.TEACHERID };
return _TeacherRepository.Get(entity, addParams, Teacher_Constants.SPROC_TEACHERASSOCIATIONDETAILS);
}
public int AddEdit(Teacher entity)
{
int i = 0;
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (entity != null && string.IsNullOrEmpty(entity.SchoolID))
{
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
}
if (string.IsNullOrEmpty(entity.TeacherID))
{
entity.TeacherID = Utility.GeneratorUniqueId(ID_PREFIX_CONSTANTS.TEACHER_ID_PREFIX);
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
{
entity.CreatedByID = objUser.UserID;
entity.ModifiedByID = objUser.UserID;
}
else
{
entity.CreatedByID = "1";
entity.ModifiedByID = "1";
}
}
else
{
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
entity.ModifiedByID = objUser.UserID;
else
entity.ModifiedByID = "1";
}
string[] addParams = { Teacher_Constants.TEACHERID,
Teacher_Constants.TEACHERID,
Teacher_Constants.TEACHEREMPID,
Teacher_Constants.TEACHERNAME,
Teacher_Constants.EMAILADDRESS,
Teacher_Constants.MOBILENO,
Teacher_Constants.FATHERNAME,
Teacher_Constants.MOTHERNAME,
Teacher_Constants.FATHEROCCUPATION,
Teacher_Constants.DOB,
Teacher_Constants.PLACEOFBIRTH,
Teacher_Constants.GENDER,
Teacher_Constants.RELIGION,
Teacher_Constants.CASTE,
Teacher_Constants.PERMANANTADDRESS,
Teacher_Constants.LOCAADDRESS,
Teacher_Constants.PHONENO,
Teacher_Constants.NATIONALITY,
Teacher_Constants.TOTALFAMILYMEMBERS,
Teacher_Constants.DATEOFAPPOINTMENT,
Teacher_Constants.DATEOFJOINING,
Teacher_Constants.GRADUATION,
Teacher_Constants.POSTGRADUATION,
Teacher_Constants.DESIGNATION,
Teacher_Constants.PAYSCALE,
Teacher_Constants.BANKNAME,
Teacher_Constants.BANKBRANCHNAME,
Teacher_Constants.BANKACCOUNTNUMBER,
Teacher_Constants.ALLOWSYSTEMACCESS,
Teacher_Constants.SYSTEMACCESSUSERID,
Teacher_Constants.SYSTEMACCESSPASSWORD,
Teacher_Constants.CREATED_BY_ID,
Teacher_Constants.MODIFIED_BY_ID
};
i = _TeacherRepository.ExecuteNonQuery(entity, addParams, Teacher_Constants.SPROC_TEACHERMST_UPS);
return i;
}
public object GetScalar(Teacher entity)
{
throw new NotImplementedException();
}
public int SaveTeacherAssociation(Teacher entity)
{
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
{
entity.CreatedByID = objUser.UserID;
entity.ModifiedByID = objUser.UserID;
}
string[] addParams = new string[] { Teacher_Constants.TEACHERSCHOOLID, Teacher_Constants.TEACHERID, Teacher_Constants.SCHOOL_ID, Teacher_Constants.SESSIONID, Teacher_Constants.CLASSID, Teacher_Constants.SECTIONID, Teacher_Constants.SUBJECTID, Teacher_Constants.ISCLASSTEACHER, Teacher_Constants.ISPRIMARYSUBJECT, Teacher_Constants.ISASSOCIATED, Teacher_Constants.CREATED_BY_ID, Teacher_Constants.DATE_CREATED, Teacher_Constants.MODIFIED_BY_ID, Teacher_Constants.DATE_MODIFIED };
return _TeacherRepository.ExecuteNonQuery(entity, addParams, Teacher_Constants.SPROC_TEACHERASSOCIATION_UPS);
}
public IEnumerable<Teacher> GetAllForLookup(Teacher entity)
{
//User objUser = null;
//if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
// objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
//if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
// entity.SchoolID = objUser.SchoolID;
//string[] addParams = { Teacher_Constants.SCHOOL_ID };
//return _TeacherRepository.GetAll(entity, addParams, Teacher_Constants.SPROC_TEACHERMST_LSTALL_FOR_LOOKUP);
throw new NotImplementedException();
}
public Teacher GetAssociation(Teacher obj)
{
string[] addParams = new string[] { Teacher_Constants.TEACHERSCHOOLID };
return _TeacherRepository.Get(obj, addParams, Teacher_Constants.SPROC_TEACHERASSOCIATION_SEL);
}
public IEnumerable<Teacher> GetAllAssociation(Teacher obj)
{
string[] addParams = new string[] { Constants.PAGEINDEX, Constants.PAGESIZE, Constants.SORTEXP, Teacher_Constants.TEACHERID };
return _TeacherRepository.GetAll(obj, addParams, Teacher_Constants.SPROC_TEACHERSCHOOLASSOCIATION_LSTALL);
}
public IEnumerable<Teacher> GetAll(Teacher entity)
{
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID))
entity.SchoolID = objUser.SchoolID;
string[] addParams = { Constants.PAGEINDEX, Constants.PAGESIZE, Constants.SORTEXP, Teacher_Constants.SCHOOL_ID };
return _TeacherRepository.GetAll(entity, addParams, Teacher_Constants.SPROC_TEACHERMST_LSTALL);
}
public Teacher Get(Teacher entity)
{
string[] addParams = { Teacher_Constants.TEACHERID };
return _TeacherRepository.Get(entity, addParams, Teacher_Constants.SPROC_TEACHERMST_SEL);
}
public int DeleteTeacherAssociation(Teacher obj)
{
string[] addParams = new string[] { Teacher_Constants.TEACHERSCHOOLID };
return _TeacherRepository.ExecuteNonQuery(obj, addParams, Teacher_Constants.SPROC_TEACHERASSOCIATION_DEL);
}
public int Delete(Teacher entity)
{
int i = 0;
string[] addParams = { Teacher_Constants.TEACHERID };
i = _TeacherRepository.ExecuteNonQuery(entity, addParams, Teacher_Constants.SPROC_TEACHERMST_DEL);
return i;
}
