protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["JobId"] != null)
{
jobId = Convert.ToInt32(Request.QueryString["JobId"]);
}
Dal.SubstituteExceptions substituteExceptions = new Miami.Substitute.Dal.SubstituteExceptions();
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
substituteId = substitute.SubstituteId;
Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job();
job.LoadByPrimaryKeyBase(jobId);
bool isApplied = job.LoadSubstituteJob(jobId, substituteId);
lbApply.Visible = !isApplied;
lblApplyHelpText.Visible = isApplied;
bool overlap = job.IsOverlap(jobId, substituteId);
bool overlapExceptions = substituteExceptions.IsOverlapped(substitute.UserId, job.DatetimeStart.Date, job.DatetimeEnd.Date);
OverlapLabel.Visible = overlap;
lblApplyHelpText.Visible = lblApplyHelpText.Visible & !overlap;
lbApply.Enabled = lbApply.Enabled & !overlap;
lbCancel.Visible = isApplied;
if (overlapExceptions && lbApply.Enabled)
{
lbApply.OnClientClick = (string)GetLocalResourceObject("OverlapConfirmText");
}
orLiteral.Visible = ReturnJobsListLinkButton.Visible = lbApply.Visible;
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
int id;
int.TryParse(tbEmployeeId.Text, out id);
DataView dv = substitute.SearchSubstitute(id);
SubstituteList.Visible = true;
SubstituteList.DataSource = dv;
SubstituteList.DataBind();
}
public DataView LoadAllRegion()
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalRegion.LoadBySubstituteId(substitute.SubstituteId))
{
return DalRegion.DefaultView;
}
else throw new ArgumentException();
}
protected void btnSearchName_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbEmployeeName.Text))
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
DataView dv = substitute.SearchSubstitute(tbEmployeeName.Text);
SubstituteList.Visible = true;
SubstituteList.DataSource = dv;
SubstituteList.DataBind();
}
}
protected void btnSearchName_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbEmployeeName.Text))
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
DataView dv = substitute.SearchSubstitute(tbEmployeeName.Text);
SubstituteList.Visible = true;
SubstituteList.DataSource = dv;
SubstituteList.DataBind();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
int id;
int.TryParse(tbEmployeeId.Text, out id);
DataView dv = substitute.SearchSubstitute(id);
SubstituteList.Visible = true;
SubstituteList.DataSource = dv;
SubstituteList.DataBind();
}
public DataView LoadAllRegion()
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalRegion.LoadBySubstituteId(substitute.SubstituteId))
{
return(DalRegion.DefaultView);
}
else
{
throw new ArgumentException();
}
}
protected void JobList_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
int jobId; int.TryParse(JobList.DataKeys[e.RowIndex].Value.ToString(), out jobId);
Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job();
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
job.DeleteSubstituteFromJob(jobId, substitute.SubstituteId);
Miami.Substitute.Bll.NoticeSystem noticeSystem = new Miami.Substitute.Bll.NoticeSystem(jobId, Miami.Substitute.Bll.NoticeSystem.NoticeType.AcceptedJobCancelledBySubstitute, Micajah.Common.Security.UserContext.Current.UserId, 0);
noticeSystem.Send();
Response.Redirect("Default.aspx");
}
public DataView LoadAllLocation(int regionId)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalLocation.LoadByRegionId(regionId, substitute.SubstituteId))
{
return(DalLocation.DefaultView);
}
else
{
return(null);
}
}
public DataView LoadLocationForSearch()
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalLocation.LoadLocationForSearch(substitute.SubstituteId))
{
return(DalLocation.DefaultView);
}
else
{
return(null);
}
}
public void DeleteForSubstitute()
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
DalPreferred.Query.ClearAll();
DalPreferred.Where.SubstituteId.Operator = WhereParameter.Operand.Equal;
DalPreferred.Where.SubstituteId.Value = substitute.SubstituteId;
if (DalPreferred.Query.Load())
{
DalPreferred.DeleteAll();
DalPreferred.Save();
}
}
public DataView SearchOpenJobs(DateTime from, DateTime to, int status)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalJob.SearchOpenJobs(from, to, substitute.SubstituteId, status))
{
return(DalJob.DefaultView);
}
else
{
return(null);
}
}
private void FillCalendar()
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId(Micajah.Common.Security.UserContext.Current.UserId);
((DropDownList)AvailabilityForm.FindControl("availabilityTimeStart")).SelectedValue = substitute.AvailabilityTimeStart;
((DropDownList)AvailabilityForm.FindControl("availabilityTimeEnd")).SelectedValue = substitute.AvailabilityTimeEnd;
Miami.Substitute.Bll.SubstituteExceptions subExceptions = new Miami.Substitute.Bll.SubstituteExceptions();
DataView dv = subExceptions.LoadAllByUserId();
if (dv != null)
{
foreach (DataRowView drv in dv)
{
if (substitute.AvailabilityWeekDays.Contains((((int)(Convert.ToDateTime(drv["DateStart"]).DayOfWeek)) + 1).ToString()))
{
RadCalendarExceptions.SelectedDates.Add(new Telerik.WebControls.RadDate(Convert.ToDateTime(drv["DateStart"])));
}
}
}
DateTime curDate = DateTime.Now.AddDays(-(DateTime.Now.Day - 1));
Bll.Job job = new Miami.Substitute.Bll.Job();
acceptedJobs = job.SearchOpenJobs(DateTime.Now, DateTime.Now.AddYears(10), 2);
while (curDate < DateTime.Now.AddYears(1))
{
Telerik.WebControls.RadCalendarDay radCalendarDay = new Telerik.WebControls.RadCalendarDay();
radCalendarDay.Date = curDate;
if (IsOverlapDay(curDate))
{
radCalendarDay.ItemStyle.CssClass = "overlap";
radCalendarDay.IsSelectable = false;
}
else if (curDate >= DateTime.Now && substitute.AvailabilityWeekDays.Contains((((int)(curDate.DayOfWeek)) + 1).ToString()))
{
radCalendarDay.ItemStyle.ForeColor = System.Drawing.Color.Green;
radCalendarDay.IsSelectable = true;
radCalendarDay.IsDisabled = false;
}
else
{
radCalendarDay.IsSelectable = false;
radCalendarDay.IsDisabled = true;
}
RadCalendarExceptions.SpecialDays.Add(radCalendarDay);
curDate = curDate.AddDays(1);
}
}
protected void SubstituteList_SelectedIndexChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(SubstituteList.SelectedValue.ToString()))
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
int id;
int.TryParse(SubstituteList.SelectedValue.ToString(), out id);
int locationId;
int.TryParse(Request.QueryString["LocationId"].ToString(), out locationId);
substitute.LoadByUserId(id);
substitute.AddSubstituteToList(locationId);
Response.Redirect("PrintLocation.aspx");
}
}
protected void SubstituteList_SelectedIndexChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(SubstituteList.SelectedValue.ToString()))
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
int id;
int.TryParse(SubstituteList.SelectedValue.ToString(), out id);
int locationId;
int.TryParse(Request.QueryString["LocationId"].ToString(), out locationId);
substitute.LoadByUserId(id);
substitute.AddSubstituteToList(locationId);
Response.Redirect("PrintLocation.aspx");
}
}
public int Insert(int locationId)
{
Reset();
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
m_LocationId = locationId;
m_SubstituteId = substitute.SubstituteId;
SetDirty();
Update();
return(m_PreferredId);
}
public DataView SearchOpenJobs(DateTime from, DateTime to, string locName)
{
locName = locName == "" ? "0" : locName;
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalJob.SearchOpenJobs(from, to, locName, substitute.SubstituteId, Micajah.Common.Security.UserContext.Current.UserId))
{
return(DalJob.DefaultView);
}
else
{
return(null);
}
}
protected void JobList_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
int jobId; int.TryParse(JobList.DataKeys[e.RowIndex].Value.ToString(), out jobId);
Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job();
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
job.DeleteSubstituteFromJob(jobId, substitute.SubstituteId);
Miami.Substitute.Bll.NoticeSystem noticeSystem = new Miami.Substitute.Bll.NoticeSystem(jobId, Miami.Substitute.Bll.NoticeSystem.NoticeType.AcceptedJobCancelledBySubstitute, Micajah.Common.Security.UserContext.Current.UserId, 0);
noticeSystem.Send();
Response.Redirect("Default.aspx");
}
private void FillCalendar()
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId(Micajah.Common.Security.UserContext.Current.UserId);
((DropDownList)AvailabilityForm.FindControl("availabilityTimeStart")).SelectedValue = substitute.AvailabilityTimeStart;
((DropDownList)AvailabilityForm.FindControl("availabilityTimeEnd")).SelectedValue = substitute.AvailabilityTimeEnd;
Miami.Substitute.Bll.SubstituteExceptions subExceptions = new Miami.Substitute.Bll.SubstituteExceptions();
DataView dv = subExceptions.LoadAllByUserId();
if (dv != null)
foreach (DataRowView drv in dv)
if (substitute.AvailabilityWeekDays.Contains((((int)(Convert.ToDateTime(drv["DateStart"]).DayOfWeek)) + 1).ToString()))
RadCalendarExceptions.SelectedDates.Add(new Telerik.WebControls.RadDate(Convert.ToDateTime(drv["DateStart"])));
DateTime curDate = DateTime.Now.AddDays(-(DateTime.Now.Day - 1));
Bll.Job job = new Miami.Substitute.Bll.Job();
acceptedJobs = job.SearchOpenJobs(DateTime.Now, DateTime.Now.AddYears(10), 2);
while (curDate < DateTime.Now.AddYears(1))
{
Telerik.WebControls.RadCalendarDay radCalendarDay = new Telerik.WebControls.RadCalendarDay();
radCalendarDay.Date = curDate;
if (IsOverlapDay(curDate))
{
radCalendarDay.ItemStyle.CssClass= "overlap";
radCalendarDay.IsSelectable = false;
}
else if (curDate >= DateTime.Now && substitute.AvailabilityWeekDays.Contains((((int)(curDate.DayOfWeek))+1).ToString()))
{
radCalendarDay.ItemStyle.ForeColor = System.Drawing.Color.Green;
radCalendarDay.IsSelectable = true;
radCalendarDay.IsDisabled = false;
}
else
{
radCalendarDay.IsSelectable = false;
radCalendarDay.IsDisabled = true;
}
RadCalendarExceptions.SpecialDays.Add(radCalendarDay);
curDate = curDate.AddDays(1);
}
}
public DataView LoadLocationForSearch()
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalLocation.LoadLocationForSearch(substitute.SubstituteId))
{
return DalLocation.DefaultView;
}
else
return null;
}
public void DeleteByRegion(int regionId)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
DalPreferred.DeleteByRegion(regionId, substitute.SubstituteId);
}
public bool LoadSubstituteJob(int jobId)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
return(DalJob.LoadJobSubstitute(jobId, substitute.SubstituteId));
}
public DataView LoadAllLocation(int regionId)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalLocation.LoadByRegionId(regionId, substitute.SubstituteId))
{
return DalLocation.DefaultView;
}
else
return null;
}
public void DeleteByRegion(int regionId)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
DalPreferred.DeleteByRegion(regionId, substitute.SubstituteId);
}
public DataView SearchOpenJobs(DateTime from, DateTime to, int status)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalJob.SearchOpenJobs(from, to, substitute.SubstituteId, status))
return (DalJob.DefaultView);
else
return null;
}
public DataView SearchOpenJobs(DateTime from, DateTime to, string locName)
{
locName = locName == "" ? "0" : locName;
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
if (DalJob.SearchOpenJobs(from, to, locName, substitute.SubstituteId, Micajah.Common.Security.UserContext.Current.UserId))
return (DalJob.DefaultView);
else
return null;
}
public bool LoadSubstituteJob(int jobId)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
return DalJob.LoadJobSubstitute(jobId, substitute.SubstituteId);
}
public int Insert(int locationId)
{
Reset();
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
m_LocationId = locationId;
m_SubstituteId = substitute.SubstituteId;
SetDirty();
Update();
return m_PreferredId;
}
public void Delete(int locationId)
{
Miami.Substitute.Bll.Substitute substitute = new Miami.Substitute.Bll.Substitute();
substitute.LoadByUserId();
DalPreferred.Query.ClearAll();
DalPreferred.Where.LocationId.Operator = WhereParameter.Operand.Equal;
DalPreferred.Where.LocationId.Value = locationId;
DalPreferred.Where.SubstituteId.Operator = WhereParameter.Operand.Equal;
DalPreferred.Where.SubstituteId.Value = substitute.SubstituteId;
if (DalPreferred.Query.Load())
{
DalPreferred.DeleteAll();
DalPreferred.Save();
}
}
