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."; } }