public AmandamentTemplateEntity Get(int AmandamentTemplateId)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_GetAmandamentTemplateById", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AmandmentTemplateId", AmandamentTemplateId);
SqlDataReader rdr = cmd.ExecuteReader();
AmandamentTemplateEntity content = new AmandamentTemplateEntity();
if (rdr.Read())
{
content.AmandamentTemplateId = Convert.ToInt32(rdr["AmandamentTemplateId"]);
content.Title = Convert.ToString(rdr["Title"]);
}
return(content);
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
protected void ProceedButton_Click(object sender, EventArgs e)
{
if (CKEditor1.Text != "")
{
AmandmentTemplatePreDataSessionView view = (AmandmentTemplatePreDataSessionView)Session["AmandamentTemplatePreData"];
AmandamentTemplateEntity entity = new AmandamentTemplateEntity();
entity.Content = CKEditor1.Text;
entity.Title = AmandamentTemplateTitleBox.Text;
entity.Status = StatusEnum.Active;
entity.AmandamentTemplateId = Convert.ToInt32(Request.QueryString["AmandamentTemplateId"]);
entity.LanguageId = Convert.ToInt32(Request.QueryString["LanguageId"]);
AmandamentTemplateMapper mapper = new AmandamentTemplateMapper();
mapper.Update(entity);
if (view.Languages.Count > 0)
{
int languageId = view.Languages[0].Id;
view.Languages.RemoveAt(0);
Response.Redirect("Edit.aspx?AmandamentTemplateId=" + Request.QueryString["AmandamentTemplateId"] + "&LanguageId=" + languageId);
}
else
{
Session.Remove("AmandamentTemplatePreData");
Response.Redirect("List.aspx");
}
}
}
public void Update(AmandamentTemplateEntity t)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_UpdateAmandamentTemplate", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AmandamentId", t.AmandamentTemplateId);
cmd.Parameters.AddWithValue("@Title", t.Title);
cmd.Parameters.AddWithValue("@Status", t.Status);
cmd.Parameters.AddWithValue("@LanguageId", t.LanguageId);
cmd.Parameters.AddWithValue("@Content", t.Content);
t.AmandamentTemplateId = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public List <AmandamentTemplateEntity> ListWithAdvancedFilter(string search, StatusEnum?status)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_ListAmandamentsTemplates", 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 <AmandamentTemplateEntity> list = new List <AmandamentTemplateEntity>();
while (rdr.Read())
{
AmandamentTemplateEntity entity = new AmandamentTemplateEntity();
entity.AmandamentTemplateId = Convert.ToInt32(rdr["AmandamentTemplateId"]);
entity.Title = Convert.ToString(rdr["Title"]);
entity.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]);
list.Add(entity);
}
return(list);
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
private void GenerateContractVersions(string LanguageTitle, AmandamentTemplateEntity 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;
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());
}
}
protected void ProceedButton_Click(object sender, EventArgs e)
{
if (CKEditor1.Text != "")
{
AmandmentTemplatePreDataSessionView view = (AmandmentTemplatePreDataSessionView)Session["AmandamentTemplatePreData"];
AmandamentTemplateEntity entity = new AmandamentTemplateEntity();
entity.Content = CKEditor1.Text;
entity.Title = AmandamentTemplateTitleBox.Text;
entity.LanguageId = Convert.ToInt32(Request.QueryString["LanguageId"]);
entity.Status = StatusEnum.Active;
AmandamentTemplateMapper mapper = new AmandamentTemplateMapper();
mapper.Insert(entity);
if (view.Languages.Count > 0)
{
int languageId = view.Languages[0].Id;
view.Languages.RemoveAt(0);
Response.Redirect("Edit.aspx?LanguageId=" + languageId + "&AmandamentTemplateId=" + entity.AmandamentTemplateId.ToString());
}
else
{
Session.Remove("AmandamentTemplatePreData");
Response.Redirect("List.aspx");
}
}
}
public void Delete(AmandamentTemplateEntity t)
{
throw new NotImplementedException();
}
