public ContractTemplateEntity Get(int Id) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_GetContractTemplateById", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ContractTemplateId", Id); SqlDataReader rdr = cmd.ExecuteReader(); ContractTemplateEntity content = new ContractTemplateEntity(); while (rdr.Read()) { content.Id = Convert.ToInt32(rdr["Id"]); content.Title = Convert.ToString(rdr["Title"]); content.Preffix = Convert.ToString(rdr["Preffix"]); content.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); content.LeaveDaysPerMonth = Convert.ToDouble(rdr["LeaveDaysPerMonth"]); content.LeaveDaysPerYearExperience = Convert.ToDouble(rdr["LeaveDaysPerYearExperience"]); content.DaysCarriedForwardPerYear = Convert.ToDouble(rdr["DaysCarriedForwardPerYear"]); } return content; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
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 ContractTemplateEntity GetContentById(int ContractTemplateId, int LanguageId) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_GetContractTemplateContentById", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ContractTemplateId", ContractTemplateId); cmd.Parameters.AddWithValue("@LanguageId", LanguageId); SqlDataReader rdr = cmd.ExecuteReader(); ContractTemplateEntity content = new ContractTemplateEntity(); while (rdr.Read()) { content.Id = Convert.ToInt32(rdr["ContractTemplateId"]); content.Title = Convert.ToString(rdr["Title"]); content.Preffix = Convert.ToString(rdr["Preffix"]); content.LanguageId = Convert.ToInt32(rdr["LanguageId"]); content.Content = Convert.ToString(rdr["Content"]); } return content; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void Update(ContractTemplateEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_UpdateContractTemplate", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", t.Id); cmd.Parameters.AddWithValue("@Title", t.Title); cmd.Parameters.AddWithValue("@Preffix", t.Preffix); cmd.Parameters.AddWithValue("@Status", t.Status); cmd.Parameters.AddWithValue("@LanguageId", t.LanguageId); cmd.Parameters.AddWithValue("@Content", t.Content); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public List<ContractTemplateEntity> ListWithAdvancedFilter(string search, StatusEnum? status) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ListContractsTemplates", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Search", search); if (status != null) { cmd.Parameters.AddWithValue("@Status", status); } SqlDataReader rdr = cmd.ExecuteReader(); List<ContractTemplateEntity> list = new List<ContractTemplateEntity>(); while (rdr.Read()) { ContractTemplateEntity entity = new ContractTemplateEntity(); entity.Id = Convert.ToInt32(rdr["Id"]); entity.Title = Convert.ToString(rdr["Title"]); entity.Preffix = Convert.ToString(rdr["Preffix"]); entity.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); list.Add(entity); } return list; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void Insert(ContractTemplateEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_InsertContractTemplate", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Title", t.Title); cmd.Parameters.AddWithValue("@Preffix", t.Preffix); cmd.Parameters.AddWithValue("@Status", t.Status); cmd.Parameters.AddWithValue("@LanguageId", t.LanguageId); cmd.Parameters.AddWithValue("@Content", t.Content); cmd.Parameters.AddWithValue("@LeaveDaysPerMonth", t.LeaveDaysPerMonth); cmd.Parameters.AddWithValue("@LeaveDaysPerYearExperience", t.LeaveDaysPerYearExperience); cmd.Parameters.AddWithValue("@DaysCarriedForwardPerYear", t.DaysCarriedForwardPerYear); t.Id = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
protected void ProceedButton_Click(object sender, EventArgs e) { if (CKEditor1.Text != "") { ContractTemplatePreDataSessionView view = (ContractTemplatePreDataSessionView)Session["ContractTemplatePreData"]; ContractTemplateEntity entity = new ContractTemplateEntity(); entity.Content = CKEditor1.Text; entity.Title = ContractTemplateTitleBox.Text; entity.Preffix = ContractPreffixTextBox.Text; entity.Status = StatusEnum.Active; entity.LeaveDaysPerMonth = view.LeaveDaysPerMonth; entity.LeaveDaysPerYearExperience = view.LeaveDaysPerYearExperience; entity.DaysCarriedForwardPerYear = view.DaysCarriedForward; entity.LanguageId = Convert.ToInt32(Request.QueryString["LanguageId"]); ContractTemplateMapper mapper = new ContractTemplateMapper(); if (Request.QueryString["ContractTemplateId"] != null) { entity.Id = Convert.ToInt32(Request.QueryString["ContractTemplateId"]); mapper.InsertContentForLanguage(entity); } else { mapper.Insert(entity); foreach (HolidayGroupEntity en in view.HolidayGroups) { new HolidayGroupMapper().InsertForContractTemplate(en, entity.Id); } } if (view.Languages.Count > 0) { int languageId = view.Languages[0].Id; view.Languages.RemoveAt(0); Response.Redirect("Edit.aspx?LanguageId=" + languageId+"&ContractTemplateId="+entity.Id.ToString()); } else { Session.Remove("ContractTemplatePreData"); Response.Redirect("PayScale.aspx?ContractTemplateId=" + entity.Id.ToString()); } } }