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();
}
}
