public bool IdPresent(string Id)
{
string sp_Name = "Check_Id";
string[] param = { "std_Id" };
string[] value = { Id };
if (_sql.Get_Count(sp_Name, param, value) >= 1)
{
return(true);
}
return(false);
}
private bool CheckReservation()
{
bool flag = false;
string ReserveCheckSp = "Check_Reservation";
string[] param = { "Date", "Time", "Device" };
object[] value = { tp_Date.Value.ToShortDateString(), cmb_TimeSlot.SelectedIndex + 1, cmb_Device.SelectedIndex + 1 };
_reservation = _sql.checkReservation(ReserveCheckSp, param, value);
if (_reservation.Date.ToShortDateString() == tp_Date.Value.ToShortDateString() &&
_reservation.Slot == (cmb_TimeSlot.SelectedIndex + 1) &&
_reservation.Device == (cmb_Device.SelectedIndex + 1))
{
flag = true;
MessageBox.Show("Slot is already Reserverd");
}
else
{
string spName = "Reservation_Count_Approved";
int id = _student.ID;
string[] _param = { "std_ID" };
object[] _value = { id };
int reserverCount = _sql.Get_Count(spName, _param, _value);
if (reserverCount > 2)
{
MessageBox.Show("You already have 2 reservations");
flag = true;
}
else
{
flag = false;
}
}
return(flag);
}
public void InitLabels()
{
string dates = "";
string status = "";
lbl_ProfID.Text = lbl_ProfID.Text + _student.RegID.ToString();
lbl_ProfName.Text = lbl_ProfName.Text + _student.FName + " " + _student.LName;
lbl_ProfDesig.Text = lbl_ProfDesig.Text + "Student";
lbl_ReservationNo.Text = lbl_ReservationNo.Text + _sql.Get_Count("Count_Reservations", new string[] { "std_Id" }, new string[] { _student.ID.ToString() }).ToString();
foreach (DataRow row in ReservationsDT.Rows)
{
dates = dates + " & " + row["r_date"].ToString();
status = status + " & " + row["r_status"].ToString();
}
lbl_ReservationDates.Text = lbl_ReservationDates.Text + " " + dates;
lbl_ReservationStatus.Text = lbl_ReservationStatus.Text + " " + status;
}