public DataSet GetUsersListInSubUsers(BE_Employer beemp)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@email", SqlDbType.VarChar, 100);
param[0].Value = beemp.Company;
return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsGetDetails", param));
}
public int updatejob(BE_Employer beemp)
{
SqlParameter[] param = new SqlParameter[18];
param[0] = new SqlParameter("@jobtitle", SqlDbType.VarChar, 100);
param[0].Value = beemp.JobTitle;
param[1] = new SqlParameter("@jobDescription", SqlDbType.VarChar, 1000);
param[1].Value = beemp.jobdesc;
param[2] = new SqlParameter("@industry", SqlDbType.VarChar, 200);
param[2].Value = beemp.Industry;
param[3] = new SqlParameter("@functionalarea", SqlDbType.VarChar, 100);
param[3].Value = beemp.Functionalarea;
param[4] = new SqlParameter("@expmin", SqlDbType.VarChar, 100);
param[4].Value = beemp.Expmin;
param[5] = new SqlParameter("@expmax", SqlDbType.VarChar, 100);
param[5].Value = beemp.Expmax;
param[6] = new SqlParameter("@rate", SqlDbType.VarChar, 100);
param[6].Value = beemp.Rate;
param[7] = new SqlParameter("@location", SqlDbType.VarChar, 100);
param[7].Value = beemp.Location;
param[8] = new SqlParameter("@jobtype", SqlDbType.VarChar, 100);
param[8].Value = beemp.Jobtype;
param[9] = new SqlParameter("@Vacancies", SqlDbType.VarChar, 100);
param[9].Value = beemp.Vacancies;
param[10] = new SqlParameter("@responsibilities", SqlDbType.VarChar, 100);
param[10].Value = beemp.Responsibilities;
param[11] = new SqlParameter("@skills", SqlDbType.VarChar, 1000);
param[11].Value = beemp.Skills;
param[12] = new SqlParameter("@jobpostedby", SqlDbType.VarChar, 100);
param[12].Value = beemp.Jobpostedby;
param[13] = new SqlParameter("@contactno", SqlDbType.VarChar, 100);
param[13].Value = beemp.Contactno;
param[14] = new SqlParameter("@email", SqlDbType.VarChar, 100);
param[14].Value = beemp.Email;
param[15] = new SqlParameter("@company", SqlDbType.VarChar, 100);
param[15].Value = beemp.Company;
param[16] = new SqlParameter("@status", SqlDbType.Int);
param[16].Value = beemp.Status;
param[17] = new SqlParameter("@jobid", SqlDbType.NVarChar, 100);
param[17].Value = beemp.Jobid;
return(SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "spsJobsPostingUpdate", param));
}
protected void Page_Load(object sender, EventArgs e)
{
lblsuccess.Visible = false;
pnlStatus.Visible = false;
email = Session["PSEMail"].ToString();
DA_SubUsers dasubuser = new DA_SubUsers();
BE_Employer beemp = new BE_Employer();
BA_SubUsers basub = new BA_SubUsers();
beemp.Company = email;
DataSet ds = new DataSet();
ds = basub.getUserListInSubUser(beemp);
company = ds.Tables[0].Rows[0]["companyname"].ToString();
MemID = ds.Tables[0].Rows[0]["MemID"].ToString();
Category = ds.Tables[0].Rows[0]["Category"].ToString();
ContactNo = ds.Tables[0].Rows[0]["ContactNo"].ToString();
City = ds.Tables[0].Rows[0]["City"].ToString();
State = ds.Tables[0].Rows[0]["State"].ToString();
ZipCode = ds.Tables[0].Rows[0]["zipcode"].ToString();
Address = ds.Tables[0].Rows[0]["Address1"].ToString();
Website = ds.Tables[0].Rows[0]["Website"].ToString();
// code forchecking number of users
DataSet dsChk = new DataSet();
BE_SubUSers besub = new BE_SubUSers();
besub.MemID = MemID;
dsChk = basub.getNumUsers(besub);
if (dsChk.Tables[0].Rows.Count > 1)
{
pnl.Visible = false;
pnlStatus.Visible = true;
}
}
protected void btPost_Click(object sender, EventArgs e)
{
int max = Convert.ToInt16(ddlmax.SelectedItem.Text);
int min = Convert.ToInt16(ddlmin.SelectedItem.Text);
if (max < min)
{
lblError.Visible = true;
lblError.Text = "Max experience should be greater than Min experience";
lblError.Focus();
}
else
{
BE_Employer beemp = new BE_Employer();
BA_postjobs bapostjob = new BA_postjobs();
beemp.JobTitle = txtJobTitle.Text;
beemp.jobdesc = txtJobDesc.Text;
List <String> industries_list = new List <string>();
foreach (System.Web.UI.WebControls.ListItem item in ddlcbIndustry.Items)
{
if (item.Selected)
{
industries_list.Add(item.Text);
}
beemp.Industry = String.Join(",", industries_list.ToArray());
}
// beemp.Functionalarea = ddlFunctionalArea.SelectedItem.ToString();
beemp.Functionalarea = "";
beemp.Expmin = ddlmin.SelectedItem.ToString();
beemp.Expmax = ddlmax.SelectedItem.ToString();
// beemp.Dollor = ddldolor.SelectedItem.ToString();
beemp.Dollor = "";
beemp.Rate = txtRate.Text + beemp.Dollor;
if (ddlLocation.SelectedIndex == 1)
{
beemp.Location = txtLoc.Text;
beemp.Status = 1;
}
else
{
beemp.Location = ddlLocation.SelectedItem.ToString();
beemp.Status = 2;
}
// beemp.Jobtype = ddlJobType.SelectedItem.ToString();
beemp.Jobtype = "";
// beemp.Vacancies = Convert.ToInt16(txtVacancy.Text);
beemp.Vacancies = 0;
beemp.Responsibilities = "<ul>";
//foreach (RepeaterItem item in repeater1.Items)
//{
// if (((TextBox)item.FindControl("txtJobRes")).Text != "")
// {
// //getting the values of user entered fields
// beemp.Responsibilities = beemp.Responsibilities + "<li>" + ((TextBox)item.FindControl("txtJobRes")).Text + "</li>";
// }
//}
beemp.Responsibilities = beemp.Responsibilities + "</ul>";
beemp.Skills = txtSkills.Text;
beemp.Jobpostedby = ds.Tables[0].Rows[0]["ContactPerson"].ToString();
beemp.Email = ds.Tables[0].Rows[0]["email"].ToString();
beemp.Contactno = ds.Tables[0].Rows[0]["Mobile"].ToString();
beemp.Company = ds.Tables[0].Rows[0]["companyname"].ToString();
beemp.Jobid = jobid;
try
{
int res = bapostjob.updatejob(beemp);
lblError.Visible = true;
if (res >= 1)
{
//lblError.Text = "inserted sucessfully";
//txtJobTitle.Text = "";
//txtJobDesc.Text = "";
//ddIndustry.SelectedIndex = 0;
//ddlFunctionalArea.SelectedIndex = 0;
//ddlmax.SelectedIndex = 0;
//ddlmin.SelectedIndex = 0;
//txtRate.Text = "";
//ddlLocation.SelectedIndex = 0;
//ddlJobType.SelectedIndex = 0;
//txtVacancy.Text = "";
//txtSkills.Text = "";
//txtPostedBy.Text = "";
//txtEmail.Text = "";
//txtContactNo.Text = "";
//BindRepeater();
Response.Redirect("../Employer/EntViewJobs.aspx?id=" + w + "&title=" + jobtitle + "");
}
else
{
lblError.Text = "not inserted";
}
}
catch (Exception ex)
{
lblError.Visible = true;
lblError.Text = ex.Message.ToString();
}
}
}
public int editjobs(BE_Employer beemp)
{
return(edit.EditJobs(beemp));
}
public int updatejob(BE_Employer beemployer)
{
return(pst.updatejob(beemployer));
}
public int postjob(BE_Employer beemployer)
{
return(pst.PostJob(beemployer));
}
public DataSet getUserListInSubUser(BE_Employer beemp)
{
return(dasubusers.GetUsersListInSubUsers(beemp));
}
//public void BindRepeater()
//{
// DataTable dt = new DataTable();
// DataRow dr = null;
// //Create DataTable columns
// dt.Columns.Add(new DataColumn("skill", typeof(string)));
// //Create Row for each columns
// dr = dt.NewRow();
// dr["skill"] = string.Empty;
// dt.Rows.Add(dr);
// repeater1.DataSource = dt;
// repeater1.DataBind();
//}
//protected void repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
//{
// if (e.CommandName == "AddRows")
// {
// DataTable dt = new DataTable();
// DataRow dr = null;
// //Create DataTable columns
// dt.Columns.Add(new DataColumn("skill", typeof(string)));
// foreach (RepeaterItem item in repeater1.Items)
// {
// //getting the values of user entered fields
// dr = dt.NewRow();
// dr["skill"] = ((TextBox)item.FindControl("txtJobRes")).Text;
// dt.Rows.Add(dr);
// }
// //Create Row for each columns
// dr = dt.NewRow();
// dr["skill"] = string.Empty;
// dt.Rows.Add(dr);
// repeater1.DataSource = dt;
// repeater1.DataBind();
// }
// else if (e.CommandName == "DeleteRows")
// {
// DataTable dt = new DataTable();
// DataRow dr = null;
// dt.Columns.Add(new DataColumn("skill", typeof(string)));
// foreach (RepeaterItem item in repeater1.Items)
// {
// //getting the values of user entered fields
// dr = dt.NewRow();
// dr["skill"] = ((TextBox)item.FindControl("txtJobRes")).Text;
// dt.Rows.Add(dr);
// }
// RepeaterItem item1 = e.Item;
// dt.Rows[item1.ItemIndex].Delete();
// dt.AcceptChanges();
// //rebind the Repeater with the updated DataTable
// repeater1.DataSource = dt;
// repeater1.DataBind();
// }
//}
protected void btUpdate_Click(object sender, EventArgs e)
{
dsload.Tables.Add("tblJobPosting");
daload = new SqlDataAdapter("select * from tblJobPosting where id='" + Session["PSEJobId"].ToString() + "'", con);
daload.Fill(dsload.Tables["tblJobPosting"]);
daload.Dispose();
int max = Convert.ToInt16(ddlmax.SelectedValue);
int min = Convert.ToInt16(ddlmin.SelectedValue);
if (max < min)
{
lblError.Visible = true;
lblError.Text = "Max experience should be greater than Min experience";
lblError.Focus();
}
else
{
try
{
BE_Employer beemp = new BE_Employer();
BA_EditJobs baedit = new BA_EditJobs();
beemp.JobID = PSEJobId;
beemp.JobTitle = txtJobTitle.Text;
beemp.Jobtype = txtJobDesc.Text;
beemp.Industry = ddIndustry.SelectedItem.ToString();
beemp.Functionalarea = ddlFunctionalArea.SelectedItem.ToString();
beemp.Expmin = ddlmin.SelectedItem.ToString();
beemp.Expmax = ddlmax.SelectedItem.ToString();
//beemp.Dollor= ddldolor.SelectedItem.ToString();
//beemp.Rate = txtRate.Text + dollor;
beemp.Rate = txtRate.Text;
beemp.Location = ddlLocation.SelectedItem.ToString();
beemp.Jobtype = ddlJobType.SelectedItem.ToString();
beemp.Vacancies = Convert.ToInt16(txtVacancy.Text);
//string Responsibilities = "<ul>";
//foreach (RepeaterItem item in repeater1.Items)
//{
// if (((TextBox)item.FindControl("txtJobRes")).Text != "")
// {
// //getting the values of user entered fields
// Responsibilities = Responsibilities + "<li>" + ((TextBox)item.FindControl("txtJobRes")).Text + "</li>";
// }
//}
//Responsibilities = Responsibilities + "</ul>";
beemp.Skills = txtSkills.Text;
beemp.Jobpostedby = dsload.Tables[0].Rows[0]["PostedBy"].ToString();
//string jobposteddate = DateTime.Now.ToString("yyyy-MM-dd");
beemp.Email = dsload.Tables[0].Rows[0]["EmailID"].ToString();
beemp.Contactno = dsload.Tables[0].Rows[0]["ContactNumber"].ToString();
int res = baedit.editjobs(beemp);
lblError.Visible = true;
if (res == 1)
{
//BindRepeater();
Response.Redirect("~/Employer/JobUpdate.aspx");
}
else
{
lblError.Text = "not updated";
}
}
catch (Exception ex)
{
lblError.Visible = true;
lblError.Text = ex.Message.ToString();
}
}
}
