public ContractEntity(CurrentJobDetailsEntity cjde, EmployeeView empl) { this.EndDate = cjde.EndDate; this.FunctionalLevelId = cjde.FunctionalLevelId; this.FunctionalLevelTitle = cjde.FunctionalLevelTitle; this.GradeEntry = cjde.GradeEntry; this.GradeId = cjde.GradeId; this.GradeKCB = cjde.GradeKCB; this.GrossValue = cjde.GrossValue; this.JobCode = cjde.JobCode; this.JobTitle = cjde.JobTitle; this.OrganizationalUnitId = cjde.OrganizationalUnitId; this.OrganizationalUnitTitle = cjde.OrganizationalUnitTitle; this.StartDate = cjde.StartDate; this.Status = StatusEnum.Active; this.StepEntry = cjde.StepEntry; this.StepId = cjde.StepId; this.Type = cjde.IsWithoutEndDate; this.EmployeeId = empl.Id; this.EmployeeFirstname = empl.Firstname; this.EmployeeLastname = empl.Lastname; this.EmployeeNo = empl.EmployeeNo; this.EmployeePersonalNumber = empl.PersonalNumber; }
public string ReplaceTemplateContractWithConcreteContract(string content, JobDetailsSessionView jbs, EmployeeView employeeView) { //Employee content = content.Replace(@"{#EmployeeName}", employeeView.ToString()); content = content.Replace(@"{#EmployeeNo}", employeeView.EmployeeNo); content = content.Replace(@"{#DateOfBirth}", employeeView.DateOfBirth.ToString("dd.MM.yyyy")); content = content.Replace(@"{#PersonalNo}", employeeView.PersonalNumber); content = content.Replace(@"{#Gender}", employeeView.Gender.ToString()); content = content.Replace(@"{#Address}", employeeView.Address); content = content.Replace(@"{#Country}", employeeView.Country); //JobTitle content = content.Replace(@"{#JobCode}", jbs.Job.Code); content = content.Replace(@"{#JobTitle}", jbs.Job.Title); content = content.Replace(@"{#OrganisationalUnit}", jbs.OrganisationalUnit.Title); #warning changed please review and edit //content = content.Replace(@"{#GradeKCB}", jbs.Grade.KCB.ToString("f2")); content = content.Replace(@"{#Step}", jbs.Step.Id); //content = content.Replace(@"{#StepEntry}", jbs.Step.Entry.ToString("f2")); content = content.Replace(@"{#Step}", jbs.Step.Id); content = content.Replace(@"{#Grade}", jbs.Grade.Id); content = content.Replace(@"{#JobDescription}", jbs.Job.Description); //content = content.Replace(@"{#ReportsTo}", jbs.Job.Description); //Contract content = content.Replace(@"{#OfficiallyApprovedDate}", DateTime.Now.ToString("dd.MM.yyyy")); //content = content.Replace(@"{#GrossValue}", jbs.Job.Code); //General content = content.Replace(@"{#TodayDate}", DateTime.Now.ToString("dd.MM.yyyy")); content = content.Replace(@"{#Time}", DateTime.Now.ToString("HH:mm")); return content; }
public EmployeeView Get(EmployeeEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_GetEmployeeById", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", t.Id); SqlDataReader rdr = cmd.ExecuteReader(); EmployeeView content = new EmployeeView(); if (rdr.Read()) { content.Id = Convert.ToInt32(rdr["Id"]); content.EmployeeNo = Convert.ToString(rdr["EmployeeNo"]); content.Firstname = Convert.ToString(rdr["Firstname"]); content.Middlename = Convert.ToString(rdr["Middlename"]); content.Lastname = Convert.ToString(rdr["Lastname"]); content.DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]); content.Nationality = Convert.ToString(rdr["Nationality"]); content.Gender = (GenderEnum)Convert.ToInt32(rdr["Gender"]); content.PersonalNumber = Convert.ToString(rdr["PersonalNumber"]); content.Address = Convert.ToString(rdr["Address"]); content.Country = Convert.ToString(rdr["Country"]); content.City = Convert.ToString(rdr["City"]); content.MobilePhone = Convert.ToString(rdr["MobilePhone"]); content.WorkEmail = Convert.ToString(rdr["WorkEmail"]); content.OtherEmail = Convert.ToString(rdr["OtherEmail"]); content.Bank = Convert.ToString(rdr["Bank"]); content.AccountNumber = Convert.ToString(rdr["AccountNumber"]); content.Job = Convert.ToString(rdr["Job"]); content.OrganizationalUnit = Convert.ToString(rdr["OrganizationalUnit"]); content.MaritalStatus = (MaritalStatusEnum)Convert.ToInt32(rdr["MaritalStatus"]); if (rdr["Image"] != DBNull.Value) { content.Image = (byte[])rdr["Image"]; } content.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); } return content; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["EmployeeId"] == null || Request.QueryString["ContractTemplateId"] == null) { Response.Redirect("List.aspx"); } if (!IsPostBack) { ContractTemplateEntity ctemplate = new ContractTemplateMapper() .Get(Convert.ToInt32(Request.QueryString["ContractTemplateId"])); ContractTypeHeaderText.Text = "(" + ctemplate.Title + " Contract)"; ContractTemplateTitleLabel.InnerText = ctemplate.Title; string s = DateTime.Now.ToString("dd.MM.yyyy"); s = s.Replace(".", ""); EmployeeView employeeView = new EmployeeView(); employeeView = new EmployeeMapper().Get(new EmployeeEntity() { Id = Convert.ToInt32(Request.QueryString["EmployeeId"]) }); ContractNumberTextBox.Text = employeeView.EmployeeNo.Replace("AKP", "") + " / " + ctemplate.Preffix + " / " + s; } Generate(); }
private void GenerateContractVersions(string LanguageTitle, ContractTemplateEntity cte) { HtmlGenericControl parent = new HtmlGenericControl("div"); parent.Attributes.Add("width", "100%"); parent.Attributes.Add("clear", "both"); HtmlGenericControl h2 = new HtmlGenericControl("h2"); h2.Attributes.Add("id", LanguageTitle + "Title"); HtmlGenericControl font = new HtmlGenericControl("font"); font.Attributes.Add("color", "#707070"); HtmlGenericControl strong = new HtmlGenericControl("strong"); Label text = new Label(); text.Text = LanguageTitle + " Version "; HyperLink link = new HyperLink(); link.ID = LanguageTitle + "ShowHyperLink"; link.CssClass = "fltrht employeeLinkLast employeeLink employeeLinkWithoutEm"; link.Text = "Show"; strong.Controls.Add(text); font.Controls.Add(strong); h2.Controls.Add(font); h2.Controls.Add(link); HtmlGenericControl container = new HtmlGenericControl("div"); container.Attributes.Add("id", (LanguageTitle + "Div")); container.Attributes.Add("style", "display:none"); CKEditor.NET.CKEditorControl ckEditor = new CKEditor.NET.CKEditorControl(); ckEditor.ID = LanguageTitle; ckEditor.Height = 500; ckEditor.BasePath = "~/ckeditor"; ckEditor.ReadOnly = true; ckEditor.FilebrowserBrowseUrl = "/HRM/ckfinder/ckfinder.html"; ckEditor.FilebrowserImageBrowseUrl = "/HRM/ckfinder/ckfinder.html?type=Images"; ckEditor.FilebrowserImageUploadUrl = "/HRM/ckfinder/core/connector/aspx/connector.aBspx?command=QuickUpload&type=Images"; ckEditor.config.toolbar = new object[] { new object[] { "Print"} }; ckEditor.Text = cte.Content; #region replaceContractTemplate JobDetailsSessionView jbs = (JobDetailsSessionView)Session["JobDetails"]; jbs.IsGenerated = true; EmployeeView employeeView = new EmployeeView(); employeeView = new EmployeeMapper().Get(new EmployeeEntity() { Id = Convert.ToInt32(Request.QueryString["EmployeeId"]) }); ckEditor.Text = ckEditor.Text.Replace(@"{#ContractNumber}", ContractNumberTextBox.Text); DateTime dt; if (DateTime.TryParseExact(StartDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dt)) { ckEditor.Text = ckEditor.Text.Replace(@"{#StartDate}", dt.ToString("dd.MM.yyyy")); } if (DateTime.TryParseExact(EndDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dt)) { ckEditor.Text = ckEditor.Text.Replace(@"{#EndDate}", dt.ToString("dd.MM.yyyy")); } else { ckEditor.Text = ckEditor.Text.Replace(@"{#EndDate}", ""); } ckEditor.Text = new GUIHelper().ReplaceTemplateContractWithConcreteContract(ckEditor.Text, jbs, employeeView); #endregion container.Controls.Add(ckEditor); parent.Controls.Add(h2); parent.Controls.Add(container); contractVersion.Controls.Add(parent); StringBuilder sb = new StringBuilder(); sb.Append("<script language='javascript'>"); sb.Append("\n"); sb.Append("$('#" + link.ClientID + "').click(function () {"); sb.Append("\n"); sb.Append("if($('#" + link.ClientID + "').text() == 'Hide') {"); sb.Append("\n"); sb.Append("$('#" + container.ClientID + "').fadeOut('slow');"); sb.Append("\n"); sb.Append("$('#" + link.ClientID + "').text('Show'); }"); sb.Append("\n"); sb.Append("else { $('#" + container.ClientID + "').fadeIn('slow');"); sb.Append("\n"); sb.Append("$('#" + link.ClientID + "').text('Hide');"); sb.Append("\n"); sb.Append("$('html,body').animate({ scrollTop: $('#" + container.ClientID + "').offset().top }, 'slow'); } });"); sb.Append("\n"); sb.Append("</script>"); // if the script is not already registered if (!Page.ClientScript.IsClientScriptBlockRegistered(Page.GetType(), ("HeyPopup" + LanguageTitle))) ClientScript.RegisterStartupScript(Page.GetType(), ("HeyPopup" + LanguageTitle), sb.ToString()); }
public List<EmployeeView> ListWithAdvancedFilterWithoutContract(string employeeNo, string searchName, string personalNumber, int? organizationalUnitId, string jobCode, StatusEnum? status) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ListEmployeesWithoutContract", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; if (employeeNo != "") { cmd.Parameters.AddWithValue("@EmployeeNo", employeeNo); } cmd.Parameters.AddWithValue("@SearchName", searchName); if (personalNumber != "") { cmd.Parameters.AddWithValue("@PersonalNumber", personalNumber); } if (jobCode != "") { cmd.Parameters.AddWithValue("@JobCode", jobCode); } if (organizationalUnitId != null) { cmd.Parameters.AddWithValue("@OrganizationalUnitId", organizationalUnitId); } if (status != null) { cmd.Parameters.AddWithValue("@Status", status); } SqlDataReader rdr = cmd.ExecuteReader(); List<EmployeeView> list = new List<EmployeeView>(); while (rdr.Read()) { EmployeeView view = new EmployeeView(); view.Id = Convert.ToInt32(rdr["Id"]); view.EmployeeNo = Convert.ToString(rdr["EmployeeNo"]); view.Firstname = Convert.ToString(rdr["Firstname"]); view.Middlename = Convert.ToString(rdr["Middlename"]); view.Lastname = Convert.ToString(rdr["Lastname"]); view.DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]); view.Nationality = Convert.ToString(rdr["Nationality"]); view.Gender = (GenderEnum)Convert.ToInt32(rdr["Gender"]); view.PersonalNumber = Convert.ToString(rdr["PersonalNumber"]); view.Address = Convert.ToString(rdr["Address"]); view.Country = Convert.ToString(rdr["Country"]); view.City = Convert.ToString(rdr["City"]); view.MobilePhone = Convert.ToString(rdr["MobilePhone"]); view.WorkEmail = Convert.ToString(rdr["WorkEmail"]); view.OtherEmail = Convert.ToString(rdr["OtherEmail"]); view.Bank = Convert.ToString(rdr["Bank"]); view.AccountNumber = Convert.ToString(rdr["AccountNumber"]); view.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); view.MaritalStatus = (MaritalStatusEnum)Convert.ToInt32(rdr["MaritalStatus"]); list.Add(view); } return list; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }