private void BtnManageUpdate_Click(object sender, EventArgs e)
{
dgvTutorRequest.DataSource = bll.GetTutorRequest();
dgvTutorRequest.BackgroundColor = Color.White;
try
{
DAL.TutorRequestClass tutorRequest = new DAL.TutorRequestClass(int.Parse(cmbRequestCode.SelectedValue.ToString()), Convert.ToDateTime(dateRequest.Text), cmbStartTime.SelectedItem.ToString(), cmbEndTime.SelectedItem.ToString(), int.Parse(cmbModuleCode.SelectedValue.ToString()), int.Parse(cmbVenueCode.SelectedValue.ToString()), cmbStatus.SelectedItem.ToString());
int x = bll.UpdateTutorRequest(tutorRequest);
if (x > 0)
{
cmbRequestCode.Text = "";
dateRequest.ResetText();
cmbStartTime.Text = "";
cmbEndTime.Text = "";
cmbRequestCode.Text = "";
cmbModuleCode.Text = "";
cmbVenueCode.Text = "";
cmbStatus.Text = "";
}
else
{
MessageBox.Show("Please input valid data.");
}
}
#pragma warning disable CS0168 // The variable 'error' is declared but never used
catch (Exception error)
#pragma warning restore CS0168 // The variable 'error' is declared but never used
{
MessageBox.Show("Please Enter a valid Time.");
}
dgvTutorRequest.DataSource = bll.GetTutorRequest();
}
protected void btnManageAdd(object sender, EventArgs e)
{
try
{
DAL.TutorRequestClass tutorRequest = new DAL.TutorRequestClass(int.Parse(cmbRequestCode.SelectedValue.ToString()), Convert.ToDateTime(dateTutorRequest.SelectedDate), cmbStartTime.SelectedItem.ToString(), cmbEndTime.SelectedItem.ToString(), int.Parse(cmbModuleCode.SelectedValue.ToString()), int.Parse(cmbVenueCode.SelectedValue.ToString()), cmbStatus.SelectedItem.ToString());
int x = bll.AddTutorRequest(tutorRequest);
if (x > 0)
{
cmbRequestCode.Text = " ";
dateTutorRequest.SelectedDate = DateTime.Today;
cmbStartTime.Text = " ";
cmbEndTime.Text = " ";
cmbRequestCode.Text = " ";
cmbModuleCode.Text = " ";
cmbVenueCode.Text = " ";
cmbStatus.Text = "";
}
else
{
}
}
#pragma warning disable CS0168 // The variable 'error' is declared but never used
catch (Exception error)
#pragma warning restore CS0168 // The variable 'error' is declared but never used
{
}
dgTutorRequest.DataSource = bll.GetTutorRequest();
dgTutorRequest.DataBind();
}
private void dateRequest_ValueChanged(object sender, EventArgs e)
{
try
{
DAL.TutorRequestClass tutor = new DAL.TutorRequestClass
{
Date = Convert.ToDateTime(dateRequest.Text)
};
dgvTutorRequestReport.DataSource = bll.Report_DisplayTutorRequestByRequestDate(tutor);
}
#pragma warning disable CS0168 // The variable 'b' is declared but never used
catch (Exception b)
#pragma warning restore CS0168 // The variable 'b' is declared but never used
{
}
}
private void cmbStartTime_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cmbStartTime.SelectedText != "")
{
DAL.TutorRequestClass tutor = new DAL.TutorRequestClass
{
StartTime = cmbStartTime.SelectedItem.ToString()
};
dgvTutorRequestReport.DataSource = bll.Report_DisplayTutorRequestByRequestStartTime(tutor);
}
}
#pragma warning disable CS0168 // The variable 'b' is declared but never used
catch (Exception b)
#pragma warning restore CS0168 // The variable 'b' is declared but never used
{
}
}
private void cmbVenueCode_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cmbVenueCode.ValueMember != "")
{
DAL.TutorRequestClass tutor = new DAL.TutorRequestClass
{
VenueCode = int.Parse(cmbVenueCode.SelectedValue.ToString())
};
dgvTutorRequestReport.DataSource = bll.Report_DisplayTutorRequestByRequestVenue(tutor);
}
}
#pragma warning disable CS0168 // The variable 'b' is declared but never used
catch (Exception b)
#pragma warning restore CS0168 // The variable 'b' is declared but never used
{
}
}
private void dgvTutorRequest_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
DAL.TutorRequestClass request = new DAL.TutorRequestClass(int.Parse(dgvTutorRequest.SelectedRows[0].Cells[0].Value.ToString()));
var values = bll.SelectedForUpdateTutorRequest(request);
cmbRequestCode.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[1];
dateRequest.Value = Convert.ToDateTime(values.Rows[0].Table.Rows[0].ItemArray[2].ToString());
cmbModuleCode.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[5];
cmbVenueCode.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[6];
cmbStartTime.SelectedItem = values.Rows[0].Table.Rows[0].ItemArray[3].ToString();
cmbEndTime.SelectedItem = values.Rows[0].Table.Rows[0].ItemArray[4].ToString();
cmbStatus.SelectedItem = values.Rows[0].Table.Rows[0].ItemArray[7].ToString();
}
#pragma warning disable CS0168 // The variable 'b' is declared but never used
catch (Exception b)
#pragma warning restore CS0168 // The variable 'b' is declared but never used
{
}
}
protected void dgTutorRequest_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DAL.TutorRequestClass request = new DAL.TutorRequestClass(int.Parse(dgTutorRequest.SelectedItem.Cells[1].Text.ToString()));
var values = bll.SelectedForUpdateTutorRequest(request);
cmbRequestCode.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[1].ToString();
dateTutorRequest.SelectedDate = DateTime.Parse(values.Rows[0].Table.Rows[0].ItemArray[2].ToString());
dateTutorRequest.VisibleDate = DateTime.Parse(values.Rows[0].Table.Rows[0].ItemArray[2].ToString());
cmbModuleCode.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[5].ToString();
cmbVenueCode.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[6].ToString();
cmbStartTime.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[3].ToString();
cmbEndTime.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[4].ToString();
cmbStatus.SelectedValue = values.Rows[0].Table.Rows[0].ItemArray[7].ToString();
}
#pragma warning disable CS0168 // The variable 'b' is declared but never used
catch (Exception b)
#pragma warning restore CS0168 // The variable 'b' is declared but never used
{
}
}