protected void viewJob(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["MyDbConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("viewJob", conn);
cmd.CommandType = CommandType.StoredProcedure;
string JobT = Job_titleVJ.Text;
cmd.Parameters.Add(new SqlParameter("@user_name", Session["Username"].ToString()));
cmd.Parameters.Add(new SqlParameter("@title", JobT));
conn.Open();
cmd.ExecuteNonQuery();
GridViewJobs.EmptyDataText = "No Records Found";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
if (ds.Tables.Count == 0)
{
GridViewJobs.Visible = false;
Response.Write("no records");
}
else
{
GridViewJobs.DataSource = ds;
GridViewJobs.DataBind();
GridViewJobs.Visible = true;
}
conn.Close();
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
JobBAL jobBal = new JobBAL();
var table = jobBal.SearchJobs(
Convert.ToInt32(DropDownListCity.SelectedValue),
Convert.ToInt32(Session["JobCategoryId"])
);
GridViewJobs.DataSource = table;
GridViewJobs.DataBind();
LabelHidden.InnerText = "divViewJobs";
}
private void BindJoblist()
{
DataTable dtPrintJobsOriginal = new DataTable();
dtPrintJobsOriginal.Locale = CultureInfo.InvariantCulture;
userSource = Session["UserSource"] as string;
if (Session["UserSource"] == null)
{
string deviceIpAddress = Request.Params["REMOTE_ADDR"].ToString();
Session["UserSource"] = DataManagerDevice.ProviderDevice.Device.ProvideDeviceAuthenticationSource(deviceIpAddress);
userSource = Session["UserSource"] as string;
}
dtPrintJobsOriginal = FileServerPrintJobProvider.ProvidePrintJobs(Session["UserID"].ToString(), userSource, domainName);
GridViewJobs.DataSource = dtPrintJobsOriginal;
GridViewJobs.DataBind();
GridViewJobs.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
GridViewJobs.DataSource = repository.GetJobs();
GridViewJobs.DataBind();
}
