public void Delete(OrganizationalUnitEntity t)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_DeleteOrganizationalUnit", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", t.Id);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
protected void ProceedButton_Click(object sender, EventArgs e)
{
OrganizationalUnitEntity entity = new OrganizationalUnitEntity();
entity.Title = TitleTextBox.Text;
entity.Description = OtherInfoTextBox.Text;
entity.OrganizationaUnitGroupId = Convert.ToInt32(OrganizationalUnitGroupDropDownList.SelectedValue);
if (ParentDropDownList.SelectedValue != "")
{
new OrganizationalUnitMapper().InsertWithParent(entity, Convert.ToInt32(ParentDropDownList.SelectedValue));
}
else
{
new OrganizationalUnitMapper().InsertWithParent(entity, null);
}
Response.Redirect("List.aspx");
}
protected void ProceedButton_Click(object sender, EventArgs e)
{
JobDetailsSessionView jbs = new JobDetailsSessionView();
FunctionalLevelEntity flentity = new FunctionalLevelEntity();
flentity.Id = Convert.ToInt32(FunctionalLevelDropDownList.SelectedValue);
flentity = new FunctionalLevelMapper().Get(flentity);
jbs.FunctionalLevel = flentity;
OrganizationalUnitEntity ouentity = new OrganizationalUnitEntity();
ouentity.Id = Convert.ToInt32(OrganisationalUnitDropDownList.SelectedValue);
OrganizationalUnitView ouView = new OrganizationalUnitMapper().Get(ouentity);
jbs.OrganisationalUnit = ouView;
GradeEntity gentity = new GradeEntity();
gentity.Id = GradeDropDownList.SelectedValue;
gentity = new GradeMapper().Get(gentity);
jbs.Grade = gentity;
JobTitleEntity job = new JobTitleEntity();
job.JobCode = JobDetailsDropDownList.SelectedValue;
JobTitleView jobview = new JobTitleMapper().Get(job);
jbs.Job = jobview;
StepEntity sentity = new StepEntity();
sentity.Id = StepDropDownList.SelectedValue;
sentity = new StepMapper().Get(sentity);
jbs.Step = sentity;
foreach (ListItem item in ContractsCheckBoxList.Items)
{
if (item.Selected == true)
{
jbs.ContractsTemplates.Add(new ContractTemplateEntity() { Id = Convert.ToInt32(item.Value), Title = item.Text });
}
}
Session.Add("JobDetails", jbs);
Response.Redirect("Contract.aspx?EmployeeId=" + Request.QueryString["EmployeeId"] + "&ContractTemplateId=" + jbs.ContractsTemplates[0].Id);
}
public OrganizationalUnitView Get(OrganizationalUnitEntity t)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_GetOrganisationalUnitById", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", t.Id);
SqlDataReader rdr = cmd.ExecuteReader();
OrganizationalUnitView organisationalUnitView = new OrganizationalUnitView();
if (rdr.Read())
{
organisationalUnitView.Id = Convert.ToInt32(rdr["Id"]);
organisationalUnitView.Title = Convert.ToString(rdr["Title"]);
organisationalUnitView.Description = Convert.ToString(rdr["Description"]);
organisationalUnitView.OrganizationaUnitGroup = Convert.ToString(rdr["OrganizationaUnitGroup"]);
organisationalUnitView.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]);
}
return organisationalUnitView;
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public void Update(OrganizationalUnitEntity t, int? ParentId)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_UpdateOrganizationalUnit", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", t.Id);
cmd.Parameters.AddWithValue("@Title", t.Title);
cmd.Parameters.AddWithValue("@Description", t.Description);
if (ParentId != null)
{
cmd.Parameters.AddWithValue("@ParentId", ParentId);
}
cmd.Parameters.AddWithValue("@OrganizationalUnitGroupId", t.OrganizationaUnitGroupId);
cmd.Parameters.AddWithValue("@Status", t.Status);
t.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public void Insert(OrganizationalUnitEntity t)
{
throw new NotImplementedException();
}
