private void FillCrewData()
{
Crew CurrentCrew = new Crew();
CurrentCrew.GetCrewByUserName(Page.User.Identity.Name);
uiLabelName.Text = CurrentCrew.Name;
uiLabelStaffNo.Text = CurrentCrew.StaffNo.ToString();
uiLabelLicenseNo.Text = CurrentCrew.LicenseNo;
if (!CurrentCrew.IsColumnNull("Competenecycheck"))
uiLabelCompetencyCheck.Text = CurrentCrew.Competenecycheck.ToString("dd/MM/yyyy"); ;
if (!CurrentCrew.IsColumnNull("MEDICALLICENSEEXPIRYFrom"))
uiLabelFrom.Text = CurrentCrew.MEDICALLICENSEEXPIRYFrom.ToString("dd/MM/yyyy"); ;
if (!CurrentCrew.IsColumnNull("MEDICALLICENSEEXPIRYTo"))
uiLabelTo.Text = CurrentCrew.MEDICALLICENSEEXPIRYTo.ToString("dd/MM/yyyy"); ;
if (!CurrentCrew.IsColumnNull("InstructorRenewal"))
uiLabelInstructorRenewal.Text = CurrentCrew.InstructorRenewal.ToString("dd/MM/yyyy"); ;
if (!CurrentCrew.IsColumnNull("TRANSITIONCOURSE"))
uiLabeltransitionCourse.Text = CurrentCrew.TRANSITIONCOURSE.ToString("dd/MM/yyyy"); ;
if (!CurrentCrew.IsColumnNull("RECURRENT12"))
uiLabelRecurrent12.Text = CurrentCrew.RECURRENT12.ToString("dd/MM/yyyy"); ;
if (!CurrentCrew.IsColumnNull("RECURRENT24"))
uiLabelRecurrent24.Text = CurrentCrew.RECURRENT24.ToString("dd/MM/yyyy"); ;
if (!CurrentCrew.IsColumnNull("SMS"))
uiLabelSMS.Text = CurrentCrew.SMS.ToString("dd/MM/yyyy"); ;
if (!CurrentCrew.IsColumnNull("Security"))
uiLabelSecurity.Text = CurrentCrew.Security.ToString("dd/MM/yyyy"); ;
uiLabelUsername.Text = CurrentCrew.Username;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadDDLs();
}
if (Request.IsAuthenticated)
{
if (Roles.IsUserInRole(Page.User.Identity.Name, "CabinCrew"))
{
uiRadioButtonListReports.Items[2].Attributes.Add("style", "display:none");
Crew C = new Crew();
C.GetCrewByUserName(Page.User.Identity.Name);
uiDropDownListCrew.SelectedValue = C.CrewID.ToString();
uiDropDownListCrew.Enabled = false;
}
}
}
protected void uiLinkButtonGetReport_Click(object sender, EventArgs e)
{
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource();
FlightReportDataSetTableAdapters.GetCrewScheduleTableAdapter ta = new FlightReportDataSetTableAdapters.GetCrewScheduleTableAdapter();
rds.Name = "CabinCrewScheduleDataSet";
ta.ClearBeforeFill = true;
try
{
CultureInfo provider = CultureInfo.InvariantCulture;
provider = new CultureInfo("fr-FR");
DateTime? From = null;
DateTime? To = null;
if (!string.IsNullOrEmpty(uiTextBoxFrom.Text))
{
From = DateTime.ParseExact(uiTextBoxFrom.Text, "dd/MM/yyyy", provider);
}
if (!string.IsNullOrEmpty(uiTextBoxTo.Text))
{
To = DateTime.ParseExact(uiTextBoxTo.Text, "dd/MM/yyyy", provider);
}
Crew current = new Crew();
current.GetCrewByUserName(Page.User.Identity.Name);
if (current.RowCount > 0)
rds.Value = ta.GetData(current.CrewID, From, To);
else
rds.Value = ta.GetData(0, From, To);
}
catch (Exception ex)
{
throw;
}
uiReportViewer.LocalReport.DataSources.Clear();
uiReportViewer.LocalReport.DataSources.Add(rds);
//uiReportViewer.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("From", uiTextBoxFrom.Text));
//uiReportViewer.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("To", uiTextBoxTo.Text));
uiReportViewer.LocalReport.Refresh();
}
private void BindData()
{
Crew current = new Crew();
current.GetCrewByUserName(Page.User.Identity.Name);
Crew p = new Crew();
DateTime? From = null;
DateTime? To = null;
CultureInfo provider = CultureInfo.InvariantCulture;
provider = new CultureInfo("fr-FR");
if (!string.IsNullOrEmpty(uiTextBoxFrom.Text))
{
From = DateTime.ParseExact(uiTextBoxFrom.Text, "dd/MM/yyyy", provider);
}
if (!string.IsNullOrEmpty(uiTextBoxTo.Text))
{
To = DateTime.ParseExact(uiTextBoxTo.Text, "dd/MM/yyyy", provider);
}
if (current.RowCount > 0)
p.GetCrewSchedule(current.CrewID, From, To);
else
p.GetCrewSchedule(0, From, To);
uiGridViewSchedule.DataSource = p.DefaultView;
uiGridViewSchedule.DataBind();
}
