public void InsertContent(ContractContentEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_InsertContractContent", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ContractNumber", t.ContractNumber); cmd.Parameters.AddWithValue("@LanguageId", t.LanguageId); cmd.Parameters.AddWithValue("@Content", t.Content); cmd.ExecuteScalar(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public List <ContractContentEntity> ListLastContractsContents(ContractEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ListLastContractsContents", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ContractNumber", t.ContractNumber); SqlDataReader rdr = cmd.ExecuteReader(); List <ContractContentEntity> list = new List <ContractContentEntity>(); while (rdr.Read()) { ContractContentEntity view = new ContractContentEntity(); view.Content = Convert.ToString(rdr["Content"]); list.Add(view); } return(list); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
protected void ProceedButton_Click(object sender, EventArgs e) { JobDetailsSessionView jbs = new JobDetailsSessionView(); if (Session["JobDetails"] != null) { jbs = (JobDetailsSessionView)Session["JobDetails"]; if (jbs.IsGenerated != false) { ContractEntity entity = new ContractEntity(); entity.ContractNumber = ContractNumberTextBox.Text; entity.ContractTemplateTitle = jbs.ContractsTemplates[0].Title; entity.OrganizationalUnitId = jbs.OrganisationalUnit.Id; entity.OrganizationalUnitTitle = jbs.OrganisationalUnit.Title; entity.JobCode = jbs.Job.Code; entity.JobTitle = jbs.Job.Title; entity.GradeId = jbs.Grade.Id; #warning changed review and edit //entity.GradeKCB = jbs.Grade.KCB; //entity.GradeEntry = jbs.Grade.Entry; entity.StepId = jbs.Step.Id; //entity.StepEntry = jbs.Step.Entry; entity.OfficiallyApprovedDate = DateTime.Now; entity.FunctionalLevelId = jbs.FunctionalLevel.Id; entity.FunctionalLevelTitle = jbs.FunctionalLevel.Title; entity.EmployeeId = Convert.ToInt32(Request.QueryString["EmployeeId"]); DateTime dt; if (DateTime.TryParseExact(StartDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dt)) { entity.StartDate = dt; } if (DateTime.TryParseExact(EndDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dt) == true) { entity.EndDate = dt; entity.Type = ContractType.Limited; TimeSpan span = entity.EndDate.Value.Subtract(entity.StartDate); double years = span.TotalDays / 365; if (years > 10) { StringBuilder sb = new StringBuilder(); sb.Append("<script language='javascript'>displayNoty('The contract that is not idifinite cannot be for more than 10 years.');</script>"); // if the script is not already registered if (!Page.ClientScript.IsClientScriptBlockRegistered(Page.GetType(), "HeyPopup")) { ClientScript.RegisterClientScriptBlock(Page.GetType(), "HeyPopup", sb.ToString()); } return; } } else { entity.Type = ContractType.Permanent; } entity.GrossValue = entity.GradeEntry + entity.StepEntry; EmployeeView employeeView = new EmployeeMapper().Get(new EmployeeEntity() { Id = Convert.ToInt32(Request.QueryString["EmployeeId"]) }); entity.EmployeeNo = employeeView.EmployeeNo; entity.EmployeeFirstname = employeeView.Firstname; entity.EmployeeLastname = employeeView.Lastname; entity.EmployeePersonalNumber = employeeView.PersonalNumber; entity.ContractStatus = ContractStatus.Aproved; entity.NextContractNumber = ""; entity.Status = StatusEnum.Active; entity.Content.ContentStatus = StatusEnum.Active; new ContractMapper().Insert(entity); foreach (LanguageEntity lang in new LanguageMapper().ListForContractTemplate(Convert.ToInt32(Request.QueryString["ContractTemplateId"]))) { ContractContentEntity contentEntity = new ContractContentEntity(); contentEntity.Content = ((CKEditor.NET.CKEditorControl)contractVersion.FindControl(lang.Title)).Text; contentEntity.ContractNumber = entity.ContractNumber; contentEntity.LanguageId = lang.Id; new ContractMapper().InsertContent(contentEntity); } jbs.ContractsTemplates.Remove(jbs.ContractsTemplates.Where(s => s.Id == Convert.ToInt32(Request.QueryString["ContractTemplateId"])).First()); if (jbs.ContractsTemplates.Count != 0) { Response.Redirect("Contract.aspx?EmployeeId=" + Request.QueryString["EmployeeId"] + "&ContractTemplateId=" + jbs.ContractsTemplates[0].Id); } else { Response.Redirect("Details.aspx?EmployeeId=" + Request.QueryString["EmployeeId"]); } } } Response.Redirect("List.aspx"); }