protected void btnExpDel_Click(object sender, ImageClickEventArgs e)
{
try
{
ImageButton imgedt = sender as ImageButton;
int rowno = Convert.ToInt32(imgedt.Attributes["RowIndex"].ToString());
HiddenField hfid = (HiddenField)grdExperience.Rows[rowno].FindControl("hfExpID");
CLOVA.DeleteEmployerExperience(Convert.ToInt32(hfid.Value));
DataTable dt;
CLOVA.GetEmployerExperience(Convert.ToInt32(hndID.Value), out dt);
grdExperience.DataSource = dt;
grdExperience.DataBind();
if (dt.Rows.Count > 0)
{
ExperienceID.Disabled = false;
}
else
{
ExperienceID.Disabled = true;
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnExpDel_Click", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void btnReferencesAdd(object sender, EventArgs e)
{
try
{
string id = string.IsNullOrEmpty((hndRefID.Value)) ? "0" : hndRefID.Value;
string desc = CLOVA.AddUpdateEmployerRef(Convert.ToInt32(id), Convert.ToInt32(hndID.Value), txtReferenceName.Text,
txtReferenceJob.Text, txtReferenceCompany.Text, txtReferenceContact.Text, txtReferenceEmail.Text, Convert.ToInt32(hndUserID.Value), Convert.ToInt32(hndUserID.Value));
if (desc.ToLower().Contains("success"))
{
hndRefID.Value = txtReferenceName.Text = txtReferenceJob.Text = txtReferenceCompany.Text = txtReferenceContact.Text =
txtReferenceEmail.Text = string.Empty;
DataTable dt;
CLOVA.GetEmployerReferences(Convert.ToInt32(hndID.Value), out dt);
grdReferences.DataSource = dt;
grdReferences.DataBind();
Session["Success"] = desc;
return;
}
else
{
Session["Error"] = desc;
return;
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnSkillsAdd", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
DataTable dt;
string sessionID = GetSessionId();
string desc = CLOVA.UserAuth(txtEmail.Text, txtPassword.Text, sessionID, out dt);
if (desc.ToLower().Contains("success"))
{
if (dt != null)
{
Session["UserID"] = dt.Rows[0]["ID"].ToString();
Session["Name"] = dt.Rows[0]["EName"].ToString();
Session["Email"] = dt.Rows[0]["EmailID"].ToString();
Session["ContactNo"] = dt.Rows[0]["ContactNo"].ToString();
Session["SessionID"] = sessionID;
}
Session["Success"] = desc;
Response.Redirect("CreateProfile.aspx");
}
else
{
Session["Error"] = desc;
return;
}
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnLogin_Click", "2030", "0", "Login");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void lnkApply_Click(object sender, EventArgs e)
{
try
{
LinkButton lnk = sender as LinkButton;
int rowno = Convert.ToInt32(lnk.Attributes["RowIndex"].ToString());
HiddenField hfid = (HiddenField)grdJobs.Rows[rowno].FindControl("hfID");
string desc = CLOVA.EmployerJobApply(Convert.ToInt32(Session["UserID"].ToString()), Convert.ToInt32(hfid.Value));
if (desc.ToLower().Contains("success"))
{
GetData();
Session["Success"] = desc;
return;
}
else
{
Session["Error"] = desc;
return;
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "lnkApply_Click", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "Jobs");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
hndUserID.Value = Session["UserID"].ToString();
DataTable dt;
string desc = CLOVA.GetEmployerPhoto(Convert.ToInt32(hndUserID.Value), out dt);
if (desc.ToLower().Contains("success"))
{
try
{
if (dt != null)
{
hndID.Value = dt.Rows[0]["ID"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["Photo"].ToString()))
{
Byte[] data = Convert.FromBase64String(dt.Rows[0]["Photo"].ToString());
ProfileImg.ImageUrl = "data:image;base64," + Convert.ToBase64String(data);
}
}
}
catch (Exception)
{
}
}
else
{
Session["Error"] = desc;
return;
}
GetEmployerData();
}
}
protected void btnChangePass_Click(object sender, EventArgs e)
{
try
{
if (txtCurPassword.Text == txtNewPassword.Text)
{
Session["Error"] = "Current Password & New Password must be different.";
return;
}
string desc = CLOVA.UserChangePassword(Convert.ToInt32(Session["UserID"]), txtCurPassword.Text, txtNewPassword.Text);
if (desc.ToLower().Contains("success"))
{
Session["Success"] = desc;
}
else
{
Session["Error"] = desc;
return;
}
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnChangePass_Click", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "ChangePassword");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
private void GetConnectionString()
{
try
{
string guid = string.Empty;
guid = Request.QueryString["Guid"];
DataTable dt;
string desc = CLOVA.GetConnectionString(guid, out dt);
if (desc.ToLower().Contains("success"))
{
if (dt != null)
{
if (dt.Rows.Count > 0)
{
Session["ConnString"] = dt.Rows[0]["ConnString"].ToString();
}
}
}
else
{
Session["Error"] = "9999 - Other Vendor Software related Error on Server.";
return;
}
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
Log.FileLogError(ex.Message, ex.StackTrace.ToString(), "GetConnectionString", "2030", "0", "Login");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void lnkUpload_Click(object sender, EventArgs e)
{
try
{
string id = string.IsNullOrEmpty((hndID.Value)) ? "0" : hndID.Value;
string employerID = "";
string desc = CLOVA.AddUpdateEmployerPhoto(Convert.ToInt32(id), Convert.ToInt32(hndUserID.Value), Convert.ToBase64String(data), Convert.ToInt32(hndUserID.Value),
Convert.ToInt32(hndUserID.Value), out employerID);
if (desc.ToLower().Contains("success"))
{
hndID.Value = employerID;
Session["EmployerID"] = employerID;
lnkUpload.Visible = false;
Session["Success"] = desc;
Response.Redirect("CreateProfile.aspx");
}
else
{
Session["Error"] = desc;
return;
}
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "lnkUpload_Click", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "Layout");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
try
{
string desc = CLOVA.RegisterUser(txtEmail.Text, txtPassword.Text, txtName.Text, txtContact.Text);
if (desc.ToLower().Contains("success"))
{
Session["Success"] = desc;
Response.Redirect("Login.aspx");
}
else
{
Session["Error"] = desc;
return;
}
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnRegister_Click", "2030", "0", "Register");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void btnLanguagesAdd(object sender, EventArgs e)
{
try
{
string id = string.IsNullOrEmpty((hndLngID.Value)) ? "0" : hndLngID.Value;
string desc = CLOVA.AddUpdateEmployerLng(Convert.ToInt32(id), Convert.ToInt32(hndID.Value), txtLanguage.Text,
Convert.ToInt32(cbLanguageProficiency.SelectedValue), Convert.ToInt32(hndUserID.Value), Convert.ToInt32(hndUserID.Value));
if (desc.ToLower().Contains("success"))
{
hndLngID.Value = txtLanguage.Text = string.Empty;
cbLanguageProficiency.SelectedValue = "0";
DataTable dt;
CLOVA.GetEmployerLanguage(Convert.ToInt32(hndID.Value), out dt);
grdLanguage.DataSource = dt;
grdLanguage.DataBind();
Session["Success"] = desc;
return;
}
else
{
Session["Error"] = desc;
return;
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnLanguagesAdd", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
private void GetData()
{
try
{
DataTable dt;
string desc = CLOVA.GetJobsData(Convert.ToInt32(Session["UserID"].ToString()), out dt);
if (desc.ToLower().Contains("success"))
{
if (dt.Rows.Count > 0)
{
grdJobs.DataSource = dt;
grdJobs.DataBind();
lblMsg.Visible = false;
}
else
{
lblMsg.Text = "No records has been added.";
lblMsg.Visible = true;
}
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "GetData", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "Jobs");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
internal static void LogError(string ErrorMessage, string ErrorStackTrace, string ClassMethodName, string ErrorCode, string CurrentID, string PageName)
{
string desc = CLOVA.DBErrorLog(ErrorMessage, ErrorStackTrace, ClassMethodName, ErrorCode, CurrentID, PageName);
if (!desc.ToLower().Contains("success"))
{
FileLogError(ErrorMessage, ErrorStackTrace, ClassMethodName, ErrorCode, CurrentID, PageName);
}
}
private void GetEmployerData()
{
try
{
DataSet ds;
string desc = CLOVA.GetEmployerData(Convert.ToInt32(hndUserID.Value), out ds);
if (desc.ToLower().Contains("success"))
{
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
hndUserID.Value = ds.Tables[0].Rows[0]["UserID"].ToString();
lblName.InnerText = ds.Tables[0].Rows[0]["NameFirst"].ToString() + " " + ds.Tables[0].Rows[0]["NameMiddle"].ToString() + " " + ds.Tables[0].Rows[0]["NameLast"].ToString();
lblSpecilization.InnerText = ds.Tables[0].Rows[0]["Specilization"].ToString();
lblObjective.InnerText = ds.Tables[0].Rows[0]["Objective"].ToString();
lblEmail.InnerText = ds.Tables[0].Rows[0]["Email"].ToString();
lblContactNo.InnerText = ds.Tables[0].Rows[0]["Mobile"].ToString();
lblAddress.InnerText = ds.Tables[0].Rows[0]["City"].ToString() + ", " + ds.Tables[0].Rows[0]["Country"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
EduData(ds.Tables[1]);
}
if (ds.Tables[2].Rows.Count > 0)
{
ExpData(ds.Tables[2]);
}
if (ds.Tables[3].Rows.Count > 0)
{
LanguagesData(ds.Tables[3]);
}
if (ds.Tables[4].Rows.Count > 0)
{
SkillsData(ds.Tables[4]);
}
if (ds.Tables[5].Rows.Count > 0)
{
ReferencesData(ds.Tables[5]);
}
}
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "Page_Load/CLOVA.GetEmployerData", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "GetEmployerData");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void btnForget_Click(object sender, EventArgs e)
{
try
{
DataTable dt;
string desc = CLOVA.EmployerForgotPassword(txtEmail.Text, out dt);
if (desc.ToLower().Contains("success"))
{
if (dt != null)
{
MailMessage mail = new MailMessage(_Email, txtEmail.Text);
mail.Subject = "Share It: Password Recovery";
mail.Body = "Hi, " + dt.Rows[0]["Name"] + "<br />As requested, here is your login details:<br /><br />Your Username: "******"<br /><br />Your Password: "******"Password"] + "<br /><br />Thank you for trusting us! Hope to hear from you soon!<br /><br /><br />Regards,<br />Cloud Valley";
mail.IsBodyHtml = true;
SmtpClient SmtpServer = new SmtpClient();
SmtpServer.Host = _Server;
SmtpServer.EnableSsl = true;
System.Net.NetworkCredential NetworkCred = new System.Net.NetworkCredential();
NetworkCred.UserName = _Email;
NetworkCred.Password = _Pwd;
SmtpServer.UseDefaultCredentials = true;
SmtpServer.DeliveryMethod = SmtpDeliveryMethod.Network;
SmtpServer.Credentials = NetworkCred;
SmtpServer.Port = _Port;
SmtpServer.Send(mail);
Session["Success"] = "Your Password Details Sent to your mail.";
Response.Redirect("Login.aspx");
}
}
else
{
Session["Success"] = "Password Reset request initiated!";
return;
}
txtEmail.Text = string.Empty;
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnForget_Click", "2030", "0", "ForgetPassword");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void btnExperienceAdd(object sender, EventArgs e)
{
try
{
string id = string.IsNullOrEmpty((hndExpID.Value)) ? "0" : hndExpID.Value;
string desc = CLOVA.AddUpdateEmployerExp(Convert.ToInt32(id), Convert.ToInt32(hndID.Value), txtCompanyName.Text,
Convert.ToInt32(cbCompanyType.SelectedValue), Convert.ToInt32(cbExperienceCountry.SelectedValue), Convert.ToInt32(cbRole.SelectedValue),
Convert.ToDateTime(dtStartDate.SelectedDate), Convert.ToDateTime(dtEndDate.SelectedDate),
Convert.ToInt32(chkPresent.Checked), txtDescription.Text, txtLeavingReason.Text,
Convert.ToInt32(hndUserID.Value), Convert.ToInt32(hndUserID.Value));
if (desc.ToLower().Contains("success"))
{
hndExpID.Value = txtCompanyName.Text = txtDescription.Text = txtLeavingReason.Text = string.Empty;
cbCompanyType.SelectedValue = "0";
cbRole.SelectedValue = "0";
cbExperienceCountry.SelectedValue = "0";
dtStartDate.Clear();
dtEndDate.Clear();
chkPresent.Checked = false;
txtLeavingReason.Text = string.Empty;
txtLeavingReason.Enabled = true;
dtEndDate.Enabled = true;
DataTable dt;
CLOVA.GetEmployerExperience(Convert.ToInt32(hndID.Value), out dt);
grdExperience.DataSource = dt;
grdExperience.DataBind();
ExperienceID.Disabled = false;
Session["Success"] = desc;
return;
}
else
{
Session["Error"] = desc;
return;
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnEducationAdd", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void btnEducationAdd(object sender, EventArgs e)
{
try
{
string id = string.IsNullOrEmpty((hndEduID.Value)) ? "0" : hndEduID.Value;
string desc = CLOVA.AddUpdateEmployerEdu(Convert.ToInt32(id), Convert.ToInt32(hndID.Value), txtInstitute.Text,
Convert.ToInt32(cbDegree.SelectedValue), txtMajorSubjects.Text, ddlCompletionYear.Text, txtCity.Text, Convert.ToInt32(cbEduCountry.SelectedValue),
Convert.ToInt32(txtObtainMarks.Text), Convert.ToInt32(txtTotalMarks.Text), Convert.ToDouble(txtPercentage.Text),
Convert.ToInt32(hndUserID.Value), Convert.ToInt32(hndUserID.Value));
if (desc.ToLower().Contains("success"))
{
hndEduID.Value = txtInstitute.Text = txtMajorSubjects.Text = txtEduCity.Text = txtObtainMarks.Text =
txtTotalMarks.Text = txtPercentage.Text = string.Empty;
cbDegree.SelectedValue = "0";
cbEduCountry.SelectedValue = "0";
ddlCompletionYear.ClearSelection();
ddlCompletionYear.Items.FindByValue(System.DateTime.Now.Year.ToString()).Selected = true;
DataTable dt;
CLOVA.GetEmployerEducation(Convert.ToInt32(hndID.Value), out dt);
grdEducation.DataSource = dt;
grdEducation.DataBind();
EducationID.Disabled = false;
Session["Success"] = desc;
return;
}
else
{
Session["Error"] = desc;
return;
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnEducationAdd", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
protected void btnPersonalInfo(object sender, EventArgs e)
{
try
{
string id = string.IsNullOrEmpty((hndID.Value)) ? "0" : hndID.Value;
DateTime dob = Convert.ToDateTime(ddlYear.Text + "-" + ddlMonth.Text + "-" + ddlDay.Text);
string employerID = "";
string desc = CLOVA.AddUpdateEmployerInfo(Convert.ToInt32(id), Convert.ToInt32(hndUserID.Value), txtFirstName.Text,
txtMiddleName.Text, txtLastName.Text, txtArabicName.Text, txtFatherName.Text, Convert.ToInt32(cbEmployeesGender.SelectedValue),
Convert.ToInt32(cbMaritialStatus.SelectedValue), dob, txtEmail.Text, txtMobile.Text, txtCity.Text,
Convert.ToInt32(cbCountry.SelectedValue), txtPresentAddress.Text, txtPermanentAddress.Text, "", txtSpecilization.Text, txtObjective.Text, Convert.ToInt32(rdIqamaTransfer.SelectedValue), txtExperience.Text, Convert.ToInt32(hndUserID.Value),
Convert.ToInt32(hndUserID.Value), out employerID);
Session["employerID"] = employerID;
hndID.Value = employerID;
if (desc.ToLower().Contains("success"))
{
RadTab eduTab = RadTabStrip1.FindTabByText("Education");
eduTab.Enabled = true;
eduTab.Selected = true;
RadMultiPage1.SelectedIndex = 1;
RadTab perTab = RadTabStrip1.FindTabByText("Personal");
perTab.Enabled = false;
hndEduID.Value = hndExpID.Value = hndLngID.Value = hndSklID.Value = hndRefID.Value = "";
}
else
{
Session["Error"] = desc;
return;
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "btnPersonalInfo", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
private void FillLovs()
{
try
{
DataTable dt;
DataRow dr;
// Gender //
CLOVA.GetEmployerLovs("Gender", out dt);
dr = dt.NewRow();
dr["ID"] = 0;
dr["EName"] = "-Select One-";
dt.Rows.InsertAt(dr, 0);
cbEmployeesGender.DataSource = dt;
cbEmployeesGender.DataTextField = "EName";
cbEmployeesGender.DataValueField = "ID";
cbEmployeesGender.DataBind();
// Marital Status //
CLOVA.GetEmployerLovs("Marital Status", out dt);
dr = dt.NewRow();
dr["ID"] = 0;
dr["EName"] = "-Select One-";
dt.Rows.InsertAt(dr, 0);
cbMaritialStatus.DataSource = dt;
cbMaritialStatus.DataTextField = "EName";
cbMaritialStatus.DataValueField = "ID";
cbMaritialStatus.DataBind();
// Degree //
CLOVA.GetEmployerLovs("Degree", out dt);
dr = dt.NewRow();
dr["ID"] = 0;
dr["EName"] = "-Select One-";
dt.Rows.InsertAt(dr, 0);
cbDegree.DataSource = dt;
cbDegree.DataTextField = "EName";
cbDegree.DataValueField = "ID";
cbDegree.DataBind();
// Degree Completion Year//
FillCompletionYear();
// Company Type //
CLOVA.GetEmployerLovs("Company Type", out dt);
dr = dt.NewRow();
dr["ID"] = 0;
dr["EName"] = "-Select One-";
dt.Rows.InsertAt(dr, 0);
cbCompanyType.DataSource = dt;
cbCompanyType.DataTextField = "EName";
cbCompanyType.DataValueField = "ID";
cbCompanyType.DataBind();
// Role //
CLOVA.GetEmployerLovs("Role", out dt);
dr = dt.NewRow();
dr["ID"] = 0;
dr["EName"] = "-Select One-";
dt.Rows.InsertAt(dr, 0);
cbRole.DataSource = dt;
cbRole.DataTextField = "EName";
cbRole.DataValueField = "ID";
cbRole.DataBind();
// Proficiency //
CLOVA.GetEmployerLovs("Proficiency", out dt);
dr = dt.NewRow();
dr["ID"] = 0;
dr["EName"] = "-Select One-";
dt.Rows.InsertAt(dr, 0);
cbSkillProficiency.DataSource = dt;
cbSkillProficiency.DataTextField = "EName";
cbSkillProficiency.DataValueField = "ID";
cbSkillProficiency.DataBind();
cbLanguageProficiency.DataSource = dt;
cbLanguageProficiency.DataTextField = "EName";
cbLanguageProficiency.DataValueField = "ID";
cbLanguageProficiency.DataBind();
// Nationality //
CLOVA.GetEmployerLovs("Nationality", out dt);
dr = dt.NewRow();
dr["ID"] = 0;
dr["EName"] = "-Select One-";
dt.Rows.InsertAt(dr, 0);
cbCountry.DataSource = dt;
cbCountry.DataTextField = "EName";
cbCountry.DataValueField = "ID";
cbCountry.DataBind();
cbEduCountry.DataSource = dt;
cbEduCountry.DataTextField = "EName";
cbEduCountry.DataValueField = "ID";
cbEduCountry.DataBind();
cbExperienceCountry.DataSource = dt;
cbExperienceCountry.DataTextField = "EName";
cbExperienceCountry.DataValueField = "ID";
cbExperienceCountry.DataBind();
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "FillLovs", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["UserID"] != null)
{
string sessionID = Convert.ToString(Session["SessionID"]);
lblTitle.InnerText = Session["Name"].ToString();
lblEmail.InnerText = Session["Email"].ToString();
lblMobile.InnerText = Session["ContactNo"].ToString();
hndUserID.Value = Session["UserID"].ToString();
string desc = CLOVA.ValidateUserSession(Convert.ToInt32(Session["UserID"]), sessionID);
if (!desc.ToLower().Contains("success"))
{
Session["Error"] = desc;
Response.Redirect("~/Logout.aspx");
}
}
else
{
Response.Redirect("~/Logout.aspx");
}
}
catch (Exception)
{
}
if (!Page.IsPostBack)
{
try
{
if (!string.IsNullOrEmpty((hndUserID.Value)))
{
DataTable dt;
string desc = CLOVA.GetEmployerPhoto(Convert.ToInt32(hndUserID.Value), out dt);
if (desc.ToLower().Contains("success"))
{
try
{
if (dt != null)
{
hndID.Value = dt.Rows[0]["ID"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["Photo"].ToString()))
{
Byte[] data = Convert.FromBase64String(dt.Rows[0]["Photo"].ToString());
previewImage.ImageUrl = "data:image;base64," + Convert.ToBase64String(data);
}
}
}
catch (Exception)
{
}
}
else
{
Session["Error"] = desc;
return;
}
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "Page_Load", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "Layout");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
}
private void GetEmployerData()
{
try
{
DataSet ds;
string desc = CLOVA.GetEmployerData(Convert.ToInt32(hndUserID.Value), out ds);
if (desc.ToLower().Contains("success"))
{
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
hndID.Value = ds.Tables[0].Rows[0]["ID"].ToString();
hndUserID.Value = ds.Tables[0].Rows[0]["UserID"].ToString();
txtFirstName.Text = ds.Tables[0].Rows[0]["NameFirst"].ToString();
txtMiddleName.Text = ds.Tables[0].Rows[0]["NameMiddle"].ToString();
txtLastName.Text = ds.Tables[0].Rows[0]["NameLast"].ToString();
txtArabicName.Text = ds.Tables[0].Rows[0]["ArabicName"].ToString();
txtFatherName.Text = ds.Tables[0].Rows[0]["FathersName"].ToString();
cbEmployeesGender.SelectedValue = ds.Tables[0].Rows[0]["GenderID"].ToString();
cbMaritialStatus.SelectedValue = ds.Tables[0].Rows[0]["MaritialStatus"].ToString();
try
{
string[] dob = ds.Tables[0].Rows[0]["DateOfBirth"].ToString().Split('-');
ddlYear.Text = dob[0];
ddlMonth.SelectedIndex = Convert.ToInt32(dob[1]) - 1;
ddlDay.Text = dob[2];
}
catch (Exception) {}
txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString();
txtMobile.Text = ds.Tables[0].Rows[0]["Mobile"].ToString();
txtCity.Text = ds.Tables[0].Rows[0]["City"].ToString();
cbCountry.SelectedValue = ds.Tables[0].Rows[0]["Country"].ToString();
txtPresentAddress.Text = ds.Tables[0].Rows[0]["PresentAddress"].ToString();
txtPermanentAddress.Text = ds.Tables[0].Rows[0]["PermanentAddress"].ToString();
txtSpecilization.Text = ds.Tables[0].Rows[0]["Specilization"].ToString();
txtObjective.Text = ds.Tables[0].Rows[0]["Objective"].ToString();
rdIqamaTransfer.SelectedValue = ds.Tables[0].Rows[0]["IqamaTransfer"].ToString().ToLower() == "true"?"1":"0";
txtExperience.Text = ds.Tables[0].Rows[0]["Experience"].ToString();
//hndID.Value = ds.Tables[0].Rows[0]["Photo"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
grdEducation.DataSource = ds.Tables[1];
grdEducation.DataBind();
EducationID.Disabled = false;
}
else
{
EducationID.Disabled = true;
}
if (ds.Tables[2].Rows.Count > 0)
{
grdExperience.DataSource = ds.Tables[2];
grdExperience.DataBind();
ExperienceID.Disabled = false;
}
else
{
ExperienceID.Disabled = true;
}
if (ds.Tables[3].Rows.Count > 0)
{
grdLanguage.DataSource = ds.Tables[3];
grdLanguage.DataBind();
}
if (ds.Tables[4].Rows.Count > 0)
{
grdSkills.DataSource = ds.Tables[4];
grdSkills.DataBind();
}
if (ds.Tables[5].Rows.Count > 0)
{
grdReferences.DataSource = ds.Tables[5];
grdReferences.DataBind();
}
}
}
}
catch (Exception ex)
{
Log.LogError(ex.Message, ex.StackTrace.ToString(), "Page_Load/CLOVA.GetEmployerData", "2030", Convert.ToInt32(Session["UserID"]).ToString(), "CreateProfile");
Session["Error"] = "2030 - Other Vendor Software related Error on Server.";
}
}
