protected void Page_Load(object sender, EventArgs e)
{
List <Experience> experiences = new List <Experience>();
var explist = BLL.ExperienceManager.GetAllExperience((Guid)Membership
.GetUser().ProviderUserKey).ToList();
foreach (User_Com_Experience item in explist)
{
Experience experience = (Experience)Page.LoadControl("Controllers/Experience.ascx");
experiences.Add(experience);
experience.DataBind();
this.Controls.Add(experience);
experience.ComName.InnerHtml = item.Company.Name;
experience.FromDate.InnerHtml = item.from.ToString();
experience.ToDate.InnerHtml = item.to.ToString();
experience.JobTitle.InnerHtml = item.title;
}
AppManager UOW = new AppManager();
var edlist = EducationManager.GetAllByUserId((Guid)Membership
.GetUser().ProviderUserKey).ToList();
foreach (User_Education item in edlist)
{
education education = (education)Page.LoadControl("Controllers/education.ascx");
this.Controls.Add(education);
education.eduName.InnerHtml = UOW.Education_Organization
.GetById(item.FK_EduId)[0].Name;
education.dateFrom.InnerHtml = item.Date_From.ToString();
education.dateTo.InnerHtml = item.Date_To.ToString();
education.grade.InnerHtml = item.Grade.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
// (Master.FindControl("lblheader") as Label).Text = "Customise List";
IEducation EducationManager;
try
{
if (!IsPostBack)
{
EducationManager = (IEducation)ObjectFactory.CreateInstance("BusinessProcess.Administration.BEducation, BusinessProcess.Administration");
DataSet theDS = EducationManager.GetEducation();
this.grdEducation.DataSource = theDS.Tables[0];
this.grdEducation.DataBind();
BindGrid();
}
}
catch (Exception err)
{
MsgBuilder theMsgBuilder = new MsgBuilder();
theMsgBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareMsgBox.Show("#C1", theMsgBuilder, this);
return;
}
finally
{
EducationManager = null;
}
}
public ApplicationFormController()
{
_degreeManager = new DegreeManager();
_applicationManager = new ApplicantManager();
_educationManager = new EducationManager();
_workExperienceManager = new WorkExperienceManager();
_languageManager = new LanguageManager();
}
public EducationOpsComplexManager()
{
uow = new UnitOfWork(new Database.Context.AydinUniversityProjectContext());
educationManager = uow.GetManager <EducationManager, Education>();
noteManager = uow.GetManager <NoteManager, Note>();
periodManager = uow.GetManager <PeriodManager, Period>();
lessonManager = uow.GetManager <LessonManager, Lesson>();
studentManager = uow.GetManager <StudentManager, Student>();
}
public ScreenShareOpsComplexManager()
{
uow = new UnitOfWork(new Database.Context.AydinUniversityProjectContext());
connectionManager = uow.GetManager <ConnectionManager, Connection>();
userManager = uow.GetManager <UserManager, User>();
eduManager = uow.GetManager <EducationManager, Education>();
lessonManager = uow.GetManager <LessonManager, Lesson>();
screenShareManager = uow.GetManager <ScreenShareManager, ScreenShareRequest>();
reviewManager = uow.GetManager <ReviewManager, Review>();
}
public JsonResult GetEducationManagerDashboard()
{
EduData = new EducationManagerData();
EducationManager manager = new EducationManager();
try
{
manager = EduData.GetEducationDashboard();
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(manager, JsonRequestBehavior.AllowGet));
}
public void Dispose()
{
#region Hossam
SkillManager.Dispose();
CourseManager.Dispose();
EmploymentTypeManager.Dispose();
UserPhotoManager.Dispose();
UserConnectionManager.Dispose();
#endregion
#region Nora
UserProjectManager.Dispose();
LanguageManager.Dispose();
UserLanguageManager.Dispose();
EducationManager.Dispose();
#endregion
#region Wafaa
ExperienceManager.Dispose();
CountryManager.Dispose();
CompanyManager.Dispose();
JobManager.Dispose();
CertificationManager.Dispose();
#endregion
#region Aya
PostManager.Dispose();
CommentManager.Dispose();
ReplyManager.Dispose();
PostPhotoManager.Dispose();
CommentPhotoManager.Dispose();
ReplyPhotoManager.Dispose();
#endregion
ApplicationUserManager.Dispose();
ApplicationRoleManager.Dispose();
ApplicationSignInManager.Dispose();
context = null;
}
private void SetEduBackground(string empId)
{
EducationManager mEduManager = new EducationManager();
List <EducationItem> eduBackgroundList = new List <EducationItem>();
if (!string.IsNullOrEmpty(tbSchoolNamePrimary.Text))
{
selectedPrimaryEdu._EMP_ID = empId;
selectedPrimaryEdu._EDU_LEVEL = "Primary";
selectedPrimaryEdu._EDU_SCHOOL_NAME = tbSchoolNamePrimary.Text;
selectedPrimaryEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressPrimary.Text;
selectedPrimaryEdu._EDU_DATE_GRADUATED = dpEduPrimaryDate.Text;
eduBackgroundList.Add(selectedPrimaryEdu);
}
if (!string.IsNullOrEmpty(tbSchoolNameSecondary.Text))
{
selectedSecondaryEdu._EMP_ID = empId;
selectedSecondaryEdu._EDU_LEVEL = "Secondary";
selectedSecondaryEdu._EDU_SCHOOL_NAME = tbSchoolNameSecondary.Text;
selectedSecondaryEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressSecondary.Text;
selectedSecondaryEdu._EDU_DATE_GRADUATED = dpEduSecondaryDate.Text;
eduBackgroundList.Add(selectedSecondaryEdu);
}
if (!string.IsNullOrEmpty(tbSchoolNameTertiary.Text))
{
selectedTertiaryEdu._EMP_ID = empId;
selectedTertiaryEdu._EDU_LEVEL = "Tertiary";
selectedTertiaryEdu._EDU_SCHOOL_NAME = tbSchoolNameTertiary.Text;
selectedTertiaryEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressTertiary.Text;
selectedTertiaryEdu._EDU_DATE_GRADUATED = dpEduTertiaryDate.Text;
selectedTertiaryEdu._EDU_DEGREE_EARNED = tbDegreeTertiary.Text;
eduBackgroundList.Add(selectedTertiaryEdu);
}
if (!string.IsNullOrEmpty(tbSchoolNameMasteral.Text))
{
selectedMasteralEdu._EMP_ID = empId;
selectedMasteralEdu._EDU_LEVEL = "Masteral";
selectedMasteralEdu._EDU_SCHOOL_NAME = tbSchoolNameMasteral.Text;
selectedMasteralEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressMasteral.Text;
selectedMasteralEdu._EDU_DATE_GRADUATED = dpEduMasteralDate.Text;
selectedMasteralEdu._EDU_DEGREE_EARNED = tbDegreeMasteral.Text;
eduBackgroundList.Add(selectedMasteralEdu);
}
if (!string.IsNullOrEmpty(tbSchoolNameDoctoral.Text))
{
selectedDoctoralEdu._EMP_ID = empId;
selectedDoctoralEdu._EDU_LEVEL = "Doctoral";
selectedDoctoralEdu._EDU_SCHOOL_NAME = tbSchoolNameDoctoral.Text;
selectedDoctoralEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressDoctoral.Text;
selectedDoctoralEdu._EDU_DATE_GRADUATED = dpEduDoctoralDate.Text;
selectedDoctoralEdu._EDU_DEGREE_EARNED = tbDegreeDoctoral.Text;
eduBackgroundList.Add(selectedDoctoralEdu);
}
if (vocationalEduCollection.Count != 0)
{
vocationalEduCollection.Remove(selectedVocationalEdu);
foreach (var item in vocationalEduCollection)
{
eduBackgroundList.Add(item);
}
}
if (!string.IsNullOrEmpty(tbSchoolNameVocational.Text))
{
var eduItem = new EducationItem();
eduItem._EMP_ID = empId;
eduItem._EDU_LEVEL = "Vocational";
eduItem._EDU_SCHOOL_NAME = tbSchoolNameVocational.Text;
eduItem._EDU_SCHOOL_ADDRESS = tbSchoolAddressVocational.Text;
eduItem._EDU_DATE_GRADUATED = dpEduVocationalDate.Text;
eduItem._EDU_DEGREE_EARNED = tbDegreeVocational.Text;
eduBackgroundList.Add(eduItem);
}
mEduManager.DeleteEduData(empId);
foreach (var item in eduBackgroundList)
{
mEduManager.SaveEduData(item);
}
}
//DataTable _dataTable = null;
public EducationManager GetEducationDashboard()
{
EducationManager per = new EducationManager();
try
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
StaffDetails staff = new StaffDetails();
_dataset = new DataSet();
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", staff.AgencyId));
command.Parameters.Add(new SqlParameter("@userid", staff.UserId));
command.Parameters.Add(new SqlParameter("@RoleId", staff.RoleId));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_GetTeachersEducationLevel";
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(_dataset);
if (_dataset.Tables[0] != null && _dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
switch (dr["HighestEducation"].ToString())
{
case "0":
per.EduLevel0 = Convert.ToInt32(dr["EducationCount"]);
break;
case "2":
per.EduLevel2 = Convert.ToInt32(dr["EducationCount"]);
break;
case "3":
per.EduLevel3 = Convert.ToInt32(dr["EducationCount"]);
break;
case "4":
per.EduLevel4 = Convert.ToInt32(dr["EducationCount"]);
break;
}
}
}
if (_dataset.Tables[1] != null && _dataset.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in _dataset.Tables[1].Rows)
{
if (dr["GettingDegree"] == DBNull.Value)
{
per.GettingDegree = 0;
per.NotGettingDegree = 0;
}
else
{
switch (dr["GettingDegree"].ToString())
{
case "0":
per.GettingDegree = Convert.ToInt32(dr["DegreeCount"]);
break;
case "1":
per.NotGettingDegree = Convert.ToInt32(dr["DegreeCount"]);
break;
}
}
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(per);
}
