public void setJobAlerts(BEJobAlerts beAlerts)
{
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@jobSeekerID", SqlDbType.NVarChar, 100);
param[0].Value = beAlerts.jobSeekerID;
param[1] = new SqlParameter("@createdDate", SqlDbType.DateTime);
param[1].Value = beAlerts.createdDate;
param[2] = new SqlParameter("@keywords", SqlDbType.NVarChar, 100);
param[2].Value = beAlerts.keywords;
param[3] = new SqlParameter("@location", SqlDbType.VarChar, 100);
param[3].Value = beAlerts.location;
param[4] = new SqlParameter("@category", SqlDbType.NVarChar, 150);
param[4].Value = beAlerts.category;
param[5] = new SqlParameter("@functionalarea", SqlDbType.NVarChar, 150);
param[5].Value = beAlerts.functionalarea;
param[6] = new SqlParameter("@expYears", SqlDbType.Int);
param[6].Value = beAlerts.expYears;
param[7] = new SqlParameter("@expMonths", SqlDbType.Int);
param[7].Value = beAlerts.expMonths;
param[8] = new SqlParameter("@id", SqlDbType.Int);
param[8].Value = beAlerts.id;
param[9] = new SqlParameter("@type", SqlDbType.Int);
param[9].Value = beAlerts.type;
SqlHelper.ExecuteNonQuery(connnectionString, CommandType.StoredProcedure, "spsSetJobAlert", param);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
BEJobAlerts beJob = new BEJobAlerts();
BA_JobAlerts baJob = new BA_JobAlerts();
beJob.jobSeekerID = Session["PSJUID"].ToString();
beJob.keywords = txtKeywords.Text;
beJob.location = ddlLocation.SelectedItem.Text;
beJob.category = ddlCategory.SelectedItem.Text;;
beJob.functionalarea = ddlFunctionalArea.SelectedItem.Text;
beJob.expYears = Convert.ToInt32(ddlYears.SelectedValue);
beJob.expMonths = Convert.ToInt32(ddlMonths.SelectedValue);
beJob.type = 1;
beJob.id = 0;
baJob.SetJobAlert(beJob);
txtKeywords.Text = "";
ddlLocation.SelectedValue = "Select";
ddlCategory.SelectedValue = "Select";
ddlMonths.SelectedValue = "-1";
ddlYears.SelectedValue = "-1";
ddlFunctionalArea.Items.Clear();
GetJobs();
lblmsg.Text = "Job Alert Successfully Created";
}
catch (Exception eg)
{
throw (eg);
}
}
public DataSet getJsJobAlertModify(BEJobAlerts bejob)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@type", SqlDbType.Int);
param[0].Value = bejob.type;
param[1] = new SqlParameter("@id", SqlDbType.Int);
param[1].Value = bejob.id;
return(SqlHelper.ExecuteDataset(connnectionString, CommandType.StoredProcedure, "spsJsJobAlertModify", param));
}
public string deleteJsJobAlert(BEJobAlerts bejob)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@id", SqlDbType.Int);
param[0].Value = bejob.id;
param[1] = new SqlParameter("@message", SqlDbType.VarChar, 200);
param[1].Direction = ParameterDirection.Output;
SqlHelper.ExecuteDataset(connnectionString, CommandType.StoredProcedure, "spsDeleteJsJobAlert", param);
return(Convert.ToString(param[1].Value));
}
public DataSet getdesiredjobs(BEJobAlerts beJobAlert)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@location", SqlDbType.VarChar, 100);
param[0].Value = beJobAlert.location;
param[1] = new SqlParameter("@category", SqlDbType.VarChar, 100);
param[1].Value = beJobAlert.category;
param[2] = new SqlParameter("@keyword", SqlDbType.VarChar, 100);
param[2].Value = beJobAlert.keywords;
return(SqlHelper.ExecuteDataset(conn, CommandType.StoredProcedure, "spsGetJobSeekerDesiredJobs", param));
}
public DataSet getJobAlerts(BEJobAlerts beAlerts)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@jobSeekerID", SqlDbType.NVarChar, 100);
param[0].Value = beAlerts.jobSeekerID;
param[1] = new SqlParameter("@type", SqlDbType.Int);
param[1].Value = beAlerts.type;
param[2] = new SqlParameter("@id", SqlDbType.Int);
param[2].Value = beAlerts.id;
return(SqlHelper.ExecuteDataset(connnectionString, CommandType.StoredProcedure, "spsGetJobAlerts", param));
}
private void GetJobs()
{
BEJobAlerts beJob = new BEJobAlerts();
BA_JobAlerts baJob = new BA_JobAlerts();
beJob.jobSeekerID = Session["PSJUID"].ToString();
beJob.type = 1;
DataSet ds = new DataSet();
ds = baJob.GetJobAlerts(beJob);
dlJobAlerts.DataSource = ds.Tables[0];
dlJobAlerts.DataBind();
dlJobAlerts.Visible = true;
}
protected void btnupdate_Click(object sender, EventArgs e)
{
BEJobAlerts beJob = new BEJobAlerts();
BA_JobAlerts baJob = new BA_JobAlerts();
beJob.jobSeekerID = Session["PSJUID"].ToString();
beJob.keywords = txtKeyword.Text;
beJob.location = ddlStateEdit.SelectedItem.Text;
beJob.category = ddlCategoryEdit.SelectedItem.Text;;
beJob.functionalarea = ddlFuncAreaEdit.SelectedItem.Text;
beJob.expYears = Convert.ToInt32(ddlExpFrom.SelectedValue);
beJob.expMonths = Convert.ToInt32(ddlExpTo.SelectedValue);
beJob.id = int.Parse(ViewState["JobId"].ToString());
beJob.type = 2;
baJob.SetJobAlert(beJob);
txtKeywords.Text = "";
ddlStateEdit.SelectedValue = "Select";
ddlCategoryEdit.SelectedValue = "Select";
ddlExpFrom.SelectedValue = "-1";
ddlExpTo.SelectedValue = "-1";
ddlFuncAreaEdit.Items.Clear();
GetJobs();
lblmsg.Text = "Job Alert Modified";
}
protected void dlJobAlerts_RowCommand(object sender, GridViewCommandEventArgs e)
{
//lblmsg.Text = string.Empty;
if (e.CommandName.ToString() == "Edit")
{
try
{
BEJobAlerts bejob = new BEJobAlerts();
BA_JobAlerts baJob = new BA_JobAlerts();
beEss = new BEEssentials();
ddlCategoryEdit.DataSource = baEss.getCategories();
ddlCategoryEdit.DataValueField = "CategoryID";
ddlCategoryEdit.DataTextField = "CategoryName";
ddlCategoryEdit.DataBind();
ddlCategoryEdit.Items.Insert(0, new ListItem("Select", "Select"));
bejob.id = int.Parse(e.CommandArgument.ToString());
ViewState["JobId"] = int.Parse(e.CommandArgument.ToString());
bejob.type = 1;
ds = new DataSet();
ds = baJob.GetJsJobAlertModify(bejob);
txtKeyword.Text = ds.Tables[0].Rows[0]["Keywords"].ToString();
ddlStateEdit.SelectedValue = ds.Tables[0].Rows[0]["Location"].ToString();
ddlCategoryEdit.SelectedValue = ds.Tables[0].Rows[0]["CategoryID"].ToString();
beEss.catagory = ddlCategoryEdit.SelectedValue.ToString();
ddlFuncAreaEdit.DataSource = baEss.getFunctionalAreas(beEss);
ddlFuncAreaEdit.DataValueField = "funid";
ddlFuncAreaEdit.DataTextField = "FuncArea";
ddlFuncAreaEdit.DataBind();
ddlFuncAreaEdit.Items.Insert(0, new ListItem("Select", "Select"));
ddlFuncAreaEdit.SelectedValue = ds.Tables[0].Rows[0]["funid"].ToString();
ddlExpFrom.SelectedValue = ds.Tables[0].Rows[0]["YearsExp"].ToString();
ddlExpTo.SelectedValue = ds.Tables[0].Rows[0]["MonthsExp"].ToString();
modalEdit.Show();
}
catch (Exception ex)
{ }
}
if (e.CommandName.ToString() == "Delete")
{
try
{
BEJobAlerts bejob = new BEJobAlerts();
BA_JobAlerts baJob = new BA_JobAlerts();
bejob.id = int.Parse(e.CommandArgument.ToString());
string result = baJob.DeleteJsJobAlert(bejob);
if (result == "Success")
{
lblmsg.Text = "Job ALert deleted";
GetJobs();
}
else
{
lblmsg.Text = "Job ALert not deleted";
}
}
catch (Exception ex1)
{
}
}
if (e.CommandName.ToString() == "View")
{
try
{
BEJobAlerts bejob = new BEJobAlerts();
BA_JobAlerts baJob = new BA_JobAlerts();
bejob.id = int.Parse(e.CommandArgument.ToString());
bejob.type = 1;
ViewState["JobId"] = int.Parse(e.CommandArgument.ToString());
ds = new DataSet();
ds = baJob.GetJsJobAlertModify(bejob);
dlistJobAlertView.DataSource = ds.Tables[0];
dlistJobAlertView.DataBind();
modalViewAlert.Show();
}
catch (Exception exe)
{
}
}
}
public DataSet GetDesiredJobAlerts(BEJobAlerts beJobAlert)
{
return(jobseekerdesired.getdesiredjobs(beJobAlert));
}
public string DeleteJsJobAlert(BEJobAlerts bejob)
{
return(daJob.deleteJsJobAlert(bejob));
}
public DataSet GetJsJobAlertModify(BEJobAlerts bejob)
{
return(daJob.getJsJobAlertModify(bejob));
}
public DataSet GetJobAlerts(BEJobAlerts beJobAlert)
{
return(daJob.getJobAlerts(beJobAlert));
}
public void SetJobAlert(BEJobAlerts beJobAlert)
{
daJob.setJobAlerts(beJobAlert);
}
