protected void Page_Load(object sender, EventArgs e)
{
//System.Diagnostics.Debugger.Break();
GetCookie();
if (!IsPostBack)
{
for (int year = DateTime.Now.Year; year > (DateTime.Now.Year - 58); year--)
{
ListItem item = new ListItem(year.ToString(), year.ToString());
DDListFromYear.Items.Add(item);
DDListToYear.Items.Add(item);
}
EmploymentId = Convert.ToInt64(Request.QueryString["EmploymentId"]);
ProviderEmployment = new ProviderEmploymentDTO();
Provideremploymentbl = new ProviderEmploymentBL();
ProviderEmployment = Provideremploymentbl.GetEmploymentById(EmploymentId, ProviderId);
TxtOrganizationName.Text = ProviderEmployment.OrganizationName;
TxtPosition.Text = ProviderEmployment.Position;
TxtOrganizationName.Text = ProviderEmployment.OrganizationName;
//if (ProviderEmployment.FromMonth != "")
//{
// DDListFromMonth.Items.FindByValue(ProviderEmployment.FromMonth).Selected = true;
//}
//else
// DDListFromMonth.Items.FindByValue("0").Selected = true;
//if (ProviderEmployment.FromYear != "")
// DDListFromYear.Items.FindByValue(ProviderEmployment.FromYear).Selected = true;
//else
// DDListFromYear.Items.FindByValue("0").Selected = true;
//if (ProviderEmployment.ToMonth != "")
// DDListToMonth.Items.FindByValue(ProviderEmployment.ToMonth).Selected = true;
//else
// DDListToMonth.Items.FindByValue("0").Selected = true;
//if (ProviderEmployment.ToYear != "")
// DDListToYear.Items.FindByValue(ProviderEmployment.ToYear).Selected = true;
//else
// DDListToYear.Items.FindByValue("0").Selected = true;
string[] responsibilities = ProviderEmployment.Responsibilities.Split(',');
foreach (string responsibility in responsibilities)
{
ListItem responsibilitiesitem = new ListItem(responsibility);
lstResponsibilites.Items.Add(responsibilitiesitem);
}
string[] employmentSkills = ProviderEmployment.EmploymentSkills.Split(',');
foreach (string employmentSkill in employmentSkills)
{
ListItem employmentSkillitem = new ListItem(employmentSkill);
lstSkills.Items.Add(employmentSkillitem);
}
}
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
ProviderEmployment = new ProviderEmploymentDTO();
Provideremploymentbl = new ProviderEmploymentBL();
EmploymentId = Convert.ToInt64(Request.QueryString["EmploymentId"]);
ProviderEmployment.EmploymentId = EmploymentId;
ProviderEmployment.ProviderId = ProviderId;
ProviderEmployment.OrganizationName = TxtOrganizationName.Text;
ProviderEmployment.Position = TxtPosition.Text;
if (DDListFromMonth.SelectedItem.Value != 0.ToString() && DDListFromYear.SelectedItem.Value != 0.ToString())
{
ProviderEmployment.FromMonth = DDListFromMonth.SelectedItem.Value;
ProviderEmployment.FromYear = DDListFromYear.SelectedItem.Value;
}
if (DDListToMonth.SelectedItem.Value != 0.ToString() && DDListToYear.SelectedItem.Value != 0.ToString())
{
ProviderEmployment.ToMonth = DDListToMonth.SelectedItem.Value;
ProviderEmployment.ToYear = DDListToYear.SelectedItem.Value;
}
if (ChkCurrentlyWorkHere.Checked == true)
{
ProviderEmployment.CurrentlyWorkhere = ChkCurrentlyWorkHere.Checked;
}
ProviderEmployment.Responsibilities = lstResponsibilites.Text;
string strresponsibilities = "";
if (Convert.ToInt32(lstResponsibilites.Items.Count) > 0)
{
for (int i = 0; i < lstResponsibilites.Items.Count; i++)
{
strresponsibilities += lstResponsibilites.Items[i].ToString();
strresponsibilities += ",";
}
ProviderEmployment.Responsibilities = strresponsibilities;
}
string strlstSkills = "";
if (Convert.ToInt32(lstSkills.Items.Count) > 0)
{
for (int i = 0; i < lstSkills.Items.Count; i++)
{
strlstSkills += lstSkills.Items[i].ToString();
strlstSkills += ", ";
}
ProviderEmployment.EmploymentSkills = strlstSkills;
}
ProviderEmployment.CurrentlyWorkhere = (bool)ChkCurrentlyWorkHere.Checked;
Provideremploymentbl.UpdateProviderEmployment(ProviderEmployment);
Response.Redirect("~/Provider/ProfilePage.aspx");
}
public int UpdateProviderEmployment(ProviderEmploymentDTO provideremployment)
{
command = new SqlCommand(StoredProcedureName.Names.UpdateEmployment.ToString(), connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ProviderId", SqlDbType.BigInt);
command.Parameters.Add("@EmploymentId", SqlDbType.BigInt);
command.Parameters.Add("@OrganizationName", SqlDbType.VarChar, 50);
command.Parameters.Add("@Position", SqlDbType.VarChar, 50);
command.Parameters.Add("@FromMonth", SqlDbType.VarChar, 100);
command.Parameters.Add("@FromYear", SqlDbType.VarChar, 100);
command.Parameters.Add("@Description", SqlDbType.VarChar, 50);
command.Parameters.Add("@Current", SqlDbType.VarChar, 50);
command.Parameters.Add("@Responsibilities", SqlDbType.VarChar, 50);
command.Parameters.Add("@ToMonth", SqlDbType.VarChar, 50);
command.Parameters.Add("@ToYear", SqlDbType.VarChar, 50);
command.Parameters.Add("@EmploymentSkills", SqlDbType.VarChar);
command.Parameters[0].Value = provideremployment.ProviderId;
command.Parameters[1].Value = provideremployment.EmploymentId;
command.Parameters[2].Value = provideremployment.OrganizationName;
command.Parameters[3].Value = provideremployment.Position;
command.Parameters[4].Value = provideremployment.FromMonth;
command.Parameters[5].Value = provideremployment.FromYear;
command.Parameters[6].Value = provideremployment.Description;
command.Parameters[7].Value = provideremployment.CurrentlyWorkhere;
command.Parameters[8].Value = provideremployment.Responsibilities;
command.Parameters[9].Value = provideremployment.ToMonth;
command.Parameters[10].Value = provideremployment.ToYear;
command.Parameters[11].Value = provideremployment.EmploymentSkills;
int rowaffected = 0;
connection.Open();
rowaffected = command.ExecuteNonQuery();
connection.Close();
return(rowaffected);
}
public List <ProviderEmploymentDTO> GetEmploymentByProviderId(long providerid)
{
ProviderEmploymentList = new List <ProviderEmploymentDTO>();
command = new SqlCommand(StoredProcedureName.Names.GetEmploymentByProviderId.ToString(), connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ProviderId", SqlDbType.BigInt);
command.Parameters[0].Value = providerid;
connection.Open();
datareader = command.ExecuteReader();
if (!datareader.HasRows)
{
return(null);
}
while (datareader.Read())
{
ProviderEmployment = new ProviderEmploymentDTO();
ProviderEmployment.EmploymentId = Convert.ToInt64(datareader["EmploymentId"]);
ProviderEmployment.ProviderId = Convert.ToInt64(datareader["ProviderId"]);
ProviderEmployment.CurrentlyWorkhere = false;
ProviderEmployment.Description = datareader["Description"].ToString();
ProviderEmployment.FromMonth = datareader["FromMonth"].ToString();
ProviderEmployment.FromYear = datareader["FromYear"].ToString();
ProviderEmployment.ToMonth = datareader["ToMonth"].ToString();
ProviderEmployment.ToYear = datareader["ToYear"].ToString();
ProviderEmployment.Responsibilities = datareader["Responsibilities"].ToString();
ProviderEmployment.Position = datareader["Position"].ToString();
ProviderEmployment.OrganizationName = datareader["OrganizationName"].ToString();
ProviderEmployment.EmploymentSkills = datareader["EmploymentSkills"].ToString();
ProviderEmploymentList.Add(ProviderEmployment);
}
connection.Close();
return(ProviderEmploymentList);
}
public long InsertEmployment(ProviderEmploymentDTO provideremployment)
{
command = new SqlCommand(StoredProcedureName.Names.InsertEmployment.ToString(), connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ProviderId", SqlDbType.VarChar, 50);
command.Parameters.Add("@OrganizationName", SqlDbType.VarChar, 50);
command.Parameters.Add("@Position", SqlDbType.VarChar, 50);
command.Parameters.Add("@FromMonth", SqlDbType.VarChar, 100);
command.Parameters.Add("@FromYear", SqlDbType.VarChar, 100);
command.Parameters.Add("@Description", SqlDbType.VarChar, 50);
command.Parameters.Add("@Current", SqlDbType.VarChar, 50);
command.Parameters.Add("@Responsibilities", SqlDbType.VarChar, 50);
command.Parameters.Add("@ToMonth", SqlDbType.VarChar, 50);
command.Parameters.Add("@ToYear", SqlDbType.VarChar, 50);
command.Parameters.Add("@EmploymentSkills", SqlDbType.VarChar);
command.Parameters[0].Value = provideremployment.ProviderId;
command.Parameters[1].Value = provideremployment.OrganizationName;
command.Parameters[2].Value = provideremployment.Position;
command.Parameters[3].Value = provideremployment.FromMonth;
command.Parameters[4].Value = provideremployment.FromYear;
command.Parameters[5].Value = provideremployment.Description;
command.Parameters[6].Value = provideremployment.CurrentlyWorkhere;
command.Parameters[7].Value = provideremployment.Responsibilities;
command.Parameters[8].Value = provideremployment.ToMonth;
command.Parameters[9].Value = provideremployment.ToYear;
command.Parameters[10].Value = provideremployment.EmploymentSkills;
connection.Open();
employmentid = Convert.ToInt64(command.ExecuteScalar());
connection.Close();
return(employmentid);
}
public int UpdateProviderEmployment(ProviderEmploymentDTO provideremployment)
{
ProviderEmploymentdal = new ProviderEmploymentDAL();
return(ProviderEmploymentdal.UpdateProviderEmployment(provideremployment));
}
public long InsertProviderEmployment(ProviderEmploymentDTO provideremployment)
{
ProviderEmploymentdal = new ProviderEmploymentDAL();
return(ProviderEmploymentdal.InsertEmployment(provideremployment));
}
