protected void btnJobs_Click(object sender, EventArgs e)
{
Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job();
JobList.DataSource = job.SearchOpenJobs(drJobs.DateStart, drJobs.DateEnd, tbJobs.Value);
JobList.DataBind();
Highlight();
}
protected void Page_Load(object sender, EventArgs e)
{
Miami.Substitute.Bll.Preferred preferred = new Miami.Substitute.Bll.Preferred();
VisibleControls(preferred.IsPreferredExists);
Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job();
lblLegend.Text = String.Empty;
JobList.DataSource = job.SearchOpenJobs(drJobs.DateStart, drJobs.DateEnd, tbJobs.Value);
JobList.DataBind();
Highlight();
}
private void Bind()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString);
string sql = "select J_ID 班种编号,J_Name 班种名称,J_Property 班种性质,J_Onwork1 上半时间一,J_Offwork1 下班时间一,J_Onwork2 上班时间二,J_Offwork2 下班时间二 from [Tb_job_kind]";
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
sda.Fill(ds, "temp");
con.Close();
JobList.DataSource = ds.Tables["temp"].DefaultView;
JobList.DataBind();
}
//Method that binds all of the data to the dropdown menus
protected void BindBasicData()
{
SchoolList.DataSource = CreateSchoolList();
SchoolList.DataTextField = "SchoolName";
SchoolList.DataValueField = "SchoolValue";
JobList.DataSource = CreateJobList();
JobList.DataTextField = "JobName";
JobList.DataValueField = "JobValue";
JobList_HS.DataSource = CreateJobList();
JobList_HS.DataTextField = "JobName";
JobList_HS.DataValueField = "JobValue";
SchoolList.DataBind();
JobList.DataBind();
JobList_HS.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Miami.Substitute.Dal.User user = new Miami.Substitute.Dal.User();
DataView dv = user.LoadForMain(Micajah.Common.Security.UserContext.Current.UserId);
lblLocationSelected.Text = dv[0]["LocationId"].ToString();
DefaultLocationLabel.Text = "Location: <b>" + dv[0]["RegionName"] + " " + dv[0]["LocationName"] + "</b>";
if (Request.QueryString["Assign"] != null && Request.QueryString["Assign"].ToString().Length > 0)
{
Session["Assign"] = Request.QueryString["Assign"].ToString();
Response.Redirect("Worksheet.aspx");
}
if (Session["lblStatusSelected"] != null && Session["lblStatusSelected"].ToString().Length > 0)
{
lblStatusSelected.Text = Session["lblStatusSelected"].ToString();
}
else
{
lblStatusSelected.Text = "1";
}
if (Session["lblDateSelected"] != null && Session["lblDateSelected"].ToString().Length > 0)
{
lblDateSelected.Text = Session["lblDateSelected"].ToString();
}
else
{
lblDateSelected.Text = string.Empty;
}
if (Session["lblDateSelectedTo"] != null && Session["lblDateSelectedTo"].ToString().Length > 0)
{
lblDateSelectedTo.Text = Session["lblDateSelectedTo"].ToString();
}
else
{
lblDateSelectedTo.Text = string.Empty;
}
IndicateSelected();
JobList.DataBind();
bool isNoRecords = JobList.MasterTableView.Items.Count == 0;
lblNoRecords.Visible = isNoRecords;
JobList.Visible = !isNoRecords;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["pageid"] != null)
{
return;
}
Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job();
JobList.DataSource = job.SearchOpenJobs(DateTime.Now.Date.AddDays(-1), DateTime.Now.AddYears(10), 2);
JobList.DataBind();
DataView dv = job.SearchOpenJobs(DateTime.Now.Date.AddDays(-1), DateTime.Now.AddYears(10), 3);
if (dv != null && dv.Count > 0)
{
ResponseGridView.DataSource = dv;
ResponseGridView.DataBind();
}
else
{
ResponseGridView.Visible = false;
lblResponseTitle.Visible = false;
}
Miami.Substitute.Dal.User user = new Miami.Substitute.Dal.User();
dv = user.LoadForMain(Micajah.Common.Security.UserContext.Current.UserId);
if (Session["IsCounted"] == null || Convert.ToInt32(Session["IsCounted"]) == 0)
{
user.InsertUsage(2, Convert.ToInt32(dv[0]["LocationId"].ToString()));
Session["IsCounted"] = 1;
}
dv.Table.Columns.Add("FullName", Type.GetType("System.String"));
dv[0]["FullName"] = dv[0]["FirstName"] + " " + dv[0]["MiddleName"] + (String)(dv[0]["MiddleName"].ToString().Length > 0 ? ". " : "") + dv[0]["LastName"];
dv.Table.Columns.Add("ContactInfo", Type.GetType("System.String"));
dv[0]["ContactInfo"] = dv[0]["Address"] + "<br>" + dv[0]["Address2"] + "<br>" + dv[0]["Phone"] + "<br>" + dv[0]["EmailProfile"];
dv.Table.Columns.Add("JobCode", Type.GetType("System.String"));
dv[0]["JobCode"] = dv[0]["JobPosition"] + " / " + dv[0]["JobAssignmentDescription"];
if (user.FirstName.Length > 0)
{
lblName.Text = "Hi, " + Convert.ToString(user.FirstName[0].ToString().ToUpper() + user.FirstName.ToLower().Substring(1, user.FirstName.Length - 1)).TrimEnd(' ');
}
dv.Table.Columns.Add("SubjectLevel", Type.GetType("System.String"));
dv[0]["SubjectLevel"] = "<table border='0' cellspacing='0' cellpadding='0'>";
//DataView dvCoverage = user.LoadCoverage(Micajah.Common.Security.UserContext.Current.UserId);
//if (dvCoverage != null && dvCoverage.Table != null && dvCoverage.Table.Rows.Count > 0)
//{
// foreach (DataRow dr in dvCoverage.Table.Rows)
// {
// if (!dr.IsNull("SubjectName") && !dr.IsNull("LevelName") && !dr.IsNull("ExpireYear") != null)
// dv[0]["SubjectLevel"] += "<tr><td><b>" + dr["SubjectName"].ToString() + "</b></td><td><b> / </b></td><td><b>" + dr["LevelName"].ToString() + "</b></td><td><b> / </b></td><td><b>" + dr["ExpireYear"].ToString() + "</b></td></tr>";
// }
//}
dv[0]["SubjectLevel"] += "</table>";
ViewProfile.DataSource = dv;
ViewProfile.DataBind();
Master.VisibleLeftArea = false;
Master.VisibleMainMenu = false;
Master.VisiblePageTitle = false;
Master.VisibleBreadCrumbs = false;
}
