public AmandamentEntity GetByLanguageId(AmandamentEntity t, int languageId)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_GetAmandamentById", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AmandamentId", t.AmandamentId);
cmd.Parameters.AddWithValue("@LanguageId", languageId);
SqlDataReader rdr = cmd.ExecuteReader();
AmandamentEntity entity = new AmandamentEntity();
while (rdr.Read())
{
entity.AmandamentId = Convert.ToInt32(rdr["AmandamentId"]);
entity.ContractNumber = Convert.ToString(rdr["ContractNumber"]);
entity.OrganizationalUnitTitle = Convert.ToString(rdr["OrganizationalUnitTitle"]);
entity.JobCode = Convert.ToString(rdr["JobCode"]);
entity.JobTitle = Convert.ToString(rdr["JobTitle"]);
entity.GradeId = Convert.ToString(rdr["GradeId"]);
entity.GradeKCB = Convert.ToDouble(rdr["GradeKCB"]);
entity.GradeEntry = Convert.ToDouble(rdr["GradeEntry"]);
entity.StepId = Convert.ToString(rdr["StepId"]);
entity.StepEntry = Convert.ToDouble(rdr["StepEntry"]);
entity.OfficiallyApprovedDate = Convert.ToDateTime(rdr["OfficiallyApprovedDate"]);
entity.GrossValue = Convert.ToDouble(rdr["GrossValue"]);
entity.StartDate = Convert.ToDateTime(rdr["StartDate"]);
if (rdr["EndDate"] != DBNull.Value)
{
entity.EndDate = Convert.ToDateTime(rdr["EndDate"]);
}
entity.Content.Content = Convert.ToString(rdr["Content"]);
}
return entity;
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public AmandamentEntity GetLastAmandament(AmandamentEntity t)
{
return GetByLanguageId(ListWithAdvancedFilter(t, StatusEnum.Active)[0], 1);
}
public void Update(AmandamentEntity t)
{
throw new NotImplementedException();
}
public AmandamentEntity Get(AmandamentEntity t)
{
throw new NotImplementedException();
}
public List<AmandamentEntity> ListWithAdvancedFilter(AmandamentEntity entity, StatusEnum? status)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("[usp_ListAmandaments]", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ContractNumber", entity.ContractNumber);
if (status != null)
{
cmd.Parameters.AddWithValue("@Status", status);
}
SqlDataReader rdr = cmd.ExecuteReader();
List<AmandamentEntity> list = new List<AmandamentEntity>();
while (rdr.Read())
{
AmandamentEntity view = new AmandamentEntity();
view.AmandamentId = Convert.ToInt32(rdr["AmandamentId"]);
view.ContractNumber = Convert.ToString(rdr["ContractNumber"]);
view.OrganizationalUnitTitle = Convert.ToString(rdr["OrganizationalUnitTitle"]);
view.JobTitle = Convert.ToString(rdr["JobTitle"]);
view.StartDate = Convert.ToDateTime(rdr["StartDate"]);
if (rdr["EndDate"] != DBNull.Value)
{
view.EndDate = Convert.ToDateTime(rdr["EndDate"]);
}
list.Add(view);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public void Insert(AmandamentEntity t, int employeeId)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_InsertAmandamentWithContent", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//@Status int,
//@LanguageId int = 1,
cmd.Parameters.AddWithValue("@EmployeeId", employeeId);
cmd.Parameters.AddWithValue("@ContractNumber", t.ContractNumber);
cmd.Parameters.AddWithValue("@FunctionalLevelId", t.FunctionalLevelId);
cmd.Parameters.AddWithValue("@FunctionalLevelTitle", t.FunctionalLevelTitle);
cmd.Parameters.AddWithValue("@OrganizationalUnitId", t.OrganizationalUnitId);
cmd.Parameters.AddWithValue("@OrganizationalUnitTitle", t.OrganizationalUnitTitle);
cmd.Parameters.AddWithValue("@JobCode", t.JobCode);
cmd.Parameters.AddWithValue("@JobTitle", t.JobTitle);
if (t.GradeId != "")
{
cmd.Parameters.AddWithValue("@GradeId", t.GradeId);
}
if (t.GradeKCB != 0)
{
cmd.Parameters.AddWithValue("@GradeKCB", t.GradeKCB);
}
if (t.GradeEntry != 0)
{
cmd.Parameters.AddWithValue("@GradeEntry", t.GradeEntry);
}
if (t.StepId != "")
{
cmd.Parameters.AddWithValue("@StepId", t.StepId);
}
if (t.StepEntry != 0)
{
cmd.Parameters.AddWithValue("@StepEntry", t.StepEntry);
}
cmd.Parameters.AddWithValue("@OfficiallyApprovedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@StartDate", t.StartDate);
if (t.Type != ContractType.Permanent)
{
cmd.Parameters.AddWithValue("@EndDate", t.EndDate);
}
cmd.Parameters.AddWithValue("@IsWithoutEndDate", t.Type);
cmd.Parameters.AddWithValue("@GrossValue", t.GrossValue);
cmd.Parameters.AddWithValue("@Status", t.Status);
//cmd.Parameters.AddWithValue("@LanguageId", t.Content.LanguageId);
cmd.Parameters.AddWithValue("@Content", t.Content.Content);
cmd.ExecuteScalar();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public void Insert(AmandamentEntity t)
{
throw new NotImplementedException();
}
protected void ProceedButton_Click(object sender, EventArgs e)
{
string strings = jsfields.Value;
StringBuilder stb = new StringBuilder();
stb.Append("employeeId=");
stb.Append(strings);
List<string> list = strings.Split(',').ToList();
DateTime startdt;
DateTime enddt;
DateTime.TryParseExact(StartDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out startdt);
DateTime.TryParseExact(EndDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out enddt);
foreach (string s in list)
{
if (!s.StartsWith("0"))
{
int i = Convert.ToInt32(s);
EmployeeView employeeView = new EmployeeMapper().Get(new EmployeeEntity() { Id = Convert.ToInt32(s) });
ContractEntity lastContract = new ContractMapper().GetLastContract(new ContractEntity() { EmployeeId = employeeView.Id });
#warning change the 1 value parameter of getContentById
ContractTemplateEntity cte = new ContractTemplateMapper().GetContentById(Convert.ToInt32(ContractTemplateDropDownList.SelectedValue), 1);
JobDetailsSessionView jsv = new JobDetailsSessionView();
CurrentJobDetailsEntity cjde = new CurrentJobDetailsMapper().Get(new CurrentJobDetailsEntity() { EmployeeId = employeeView.Id, ContractNumber = (employeeView.Id + " / " + cte.Preffix) });
jsv.FunctionalLevel.Id = cjde.FunctionalLevelId;
jsv.FunctionalLevel.Title = cjde.FunctionalLevelTitle;
jsv.Grade.Id = cjde.GradeId;
jsv.Grade = new GradeMapper().Get(jsv.Grade);
jsv.Job.Code = cjde.JobCode;
jsv.Job.Title = cjde.JobTitle;
jsv.OrganisationalUnit.Id = cjde.OrganizationalUnitId;
jsv.OrganisationalUnit.Title = cjde.OrganizationalUnitTitle;
#warning changed review and edit
jsv.Step.Id = cjde.StepId;
//jsv.Step.Entry = cjde.StepEntry;
if (RadioButtonList1.SelectedItem.Value != "1")
{
AmandamentTemplateEntity amte = new AmandamentTemplateMapper().GetContentById(Convert.ToInt32(RadioButtonList1.SelectedValue), null);
AmandamentEntity am = new AmandamentEntity(cjde);
am.Status = StatusEnum.Active;
am.Content.Content = new GUIHelper().ReplaceTemplateContractWithConcreteContract(amte.Content, jsv, employeeView);
am.ContractNumber = cjde.ContractNumber;
am.Content.Content = am.Content.Content.Replace(@"{#ContractNumber}", am.ContractNumber);
am.StartDate = startdt;
#warning check for contract type Probation if this is first contract it is probation and also check if it is special contract
if (enddt != null)
{
am.EndDate = enddt;
am.Type = ContractType.Limited;
TimeSpan span = am.EndDate.Value.Subtract(am.StartDate);
double years = span.TotalDays / 365;
if (years > 10)
{
StringBuilder sb = new StringBuilder();
sb.Append("<script language='javascript'>displayNoty('The amandment that is not for idifinite period 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
{
am.Type = ContractType.Permanent;
}
new AmandamentMapper().Insert(am, employeeView.Id);
}
else
{
ContractEntity ct = new ContractEntity(cjde, employeeView);
ct.Content.Content = new GUIHelper().ReplaceTemplateContractWithConcreteContract(cte.Content, jsv, employeeView);
string dt = DateTime.Now.ToString("dd.MM.yyyy");
dt = dt.Replace(".", "");
ct.ContractNumber = (employeeView.EmployeeNo.Replace("AKP", "") + " / " + cte.Preffix + " / " + dt);
ct.Status = StatusEnum.Active;
ct.ContractStatus = ContractStatus.Aproved;
ct.OfficiallyApprovedDate = DateTime.Now;
ct.ContractTemplateTitle = cte.Preffix;
ct.Content.Content = ct.Content.Content.Replace(@"{#ContractNumber}", ct.ContractNumber);
ct.StartDate = startdt;
if (enddt != null)
{
ct.EndDate = enddt;
ct.Type = ContractType.Limited;
TimeSpan span = ct.EndDate.Value.Subtract(ct.StartDate);
double years = span.TotalDays / 365;
if (years > 10)
{
StringBuilder sb = new StringBuilder();
sb.Append("<script language='javascript'>displayNoty('The contract that is not for idifinite period 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
{
ct.Type = ContractType.Permanent;
}
#warning bug please check
//new ContractMapper().Insert(ct);
#warning this dosent exists why
//new ContractMapper().UpdatePreviousContract(new ContractEntity() { ContractNumber = lastContract.ContractNumber, NextContractNumber = ct.ContractNumber, ContractStatus = Entities.ContractStatus.Changed, Status = StatusEnum.Pasive });
}
}
}
if (RadioButtonList1.SelectedItem.Value != "1")
{
Response.Redirect("Print.aspx?" + stb + "&type=newAmandament");
}
else
{
Response.Redirect("Print.aspx?" + stb + "&type=newContract");
}
}
protected void ProceedButton_Click(object sender, EventArgs e)
{
string strings = jsfields.Value;
StringBuilder stb = new StringBuilder();
stb.Append("employeeId=");
stb.Append(strings);
List<string> list = strings.Split(',').ToList();
foreach (string s in list)
{
if (!s.StartsWith("0"))
{
int i = Convert.ToInt32(s);
EmployeeView employeeView = new EmployeeMapper().Get(new EmployeeEntity() { Id = Convert.ToInt32(s) });
ContractEntity lastContract = new ContractMapper().GetLastContract(new ContractEntity() { EmployeeId = employeeView.Id });
#warning change the 1 value parameter of getContentById
ContractTemplateEntity cte = new ContractTemplateMapper().GetContentById(Convert.ToInt32(ContractTemplateDropDownList.SelectedValue), 1);
JobDetailsSessionView jsv = new JobDetailsSessionView();
CurrentJobDetailsEntity cjde = new CurrentJobDetailsMapper().Get(new CurrentJobDetailsEntity() { EmployeeId = employeeView.Id, ContractNumber = (employeeView.Id + " / " + cte.Preffix) });
jsv.FunctionalLevel.Id = cjde.FunctionalLevelId;
jsv.FunctionalLevel.Title = cjde.FunctionalLevelTitle;
jsv.Grade.Id = cjde.GradeId;
jsv.Grade = new GradeMapper().Get(jsv.Grade);
jsv.Job.Code = cjde.JobCode;
jsv.Job.Title = cjde.JobTitle;
jsv.OrganisationalUnit.Id = cjde.OrganizationalUnitId;
jsv.OrganisationalUnit.Title = cjde.OrganizationalUnitTitle;
jsv.Step.Id = cjde.StepId;
#warning changed review and edit
//jsv.Step.Entry = cjde.StepEntry;
if (RadioButtonList1.SelectedItem.Value != "1")
{
AmandamentTemplateEntity amte = new AmandamentTemplateMapper().GetContentById(Convert.ToInt32(RadioButtonList1.SelectedValue), null);
AmandamentEntity am = new AmandamentEntity(cjde);
am.Status = StatusEnum.Active;
am.Content.Content = new GUIHelper().ReplaceTemplateContractWithConcreteContract(amte.Content, jsv, employeeView);
am.ContractNumber = cjde.ContractNumber;
am.Content.Content = am.Content.Content.Replace(@"{#ContractNumber}", am.ContractNumber);
new AmandamentMapper().Insert(am, employeeView.Id);
}
else
{
ContractEntity ct = new ContractEntity(cjde, employeeView);
ct.Content.Content = new GUIHelper().ReplaceTemplateContractWithConcreteContract(cte.Content, jsv, employeeView);
string dt = DateTime.Now.ToString("dd.MM.yyyy");
dt = dt.Replace(".", "");
ct.ContractNumber = (employeeView.EmployeeNo.Replace("AKP", "") + " / " + cte.Preffix + " / " + dt);
ct.Status = StatusEnum.Active;
ct.ContractStatus = ContractStatus.Aproved;
ct.OfficiallyApprovedDate = DateTime.Now;
ct.ContractTemplateTitle = cte.Preffix;
ct.Content.Content = ct.Content.Content.Replace(@"{#ContractNumber}", ct.ContractNumber);
new ContractMapper().Insert(ct);
new ContractMapper().UpdatePreviousContract(new ContractEntity() { ContractNumber = lastContract.ContractNumber, NextContractNumber = ct.ContractNumber, ContractStatus = Entities.ContractStatus.Changed });
}
}
}
if (RadioButtonList1.SelectedItem.Value != "1")
{
Response.Redirect("Print.aspx?" + stb + "&type=newAmandament");
}
else
{
Response.Redirect("Print.aspx?" + stb + "&type=newContract");
}
}
