public void ViewDetails()
{
BL_ScheduleEvents obj = new BL_ScheduleEvents();
DataTable dt = obj.getScheduleDetail();
dataGridView1.DataSource = dt;
dataGridView1.Columns["BookedEventId"].Visible = false;
}
public void FillGridView()
{
BL_ScheduleEvents obj = new BL_ScheduleEvents();
DataTable dt = obj.getAllEventsSchedule();
GridView1.DataSource = dt;
GridView1.DataBind();
//dataGridView1.Columns["BookedEventId"].Visible = false;
}
private void btnDelete_Click(object sender, EventArgs e)
{
BL_ScheduleEvents obj = new BL_ScheduleEvents();
obj.DEventId = Convert.ToInt32(txtEventid.Text);
obj.DeleteEvent();
MessageBox.Show("Event Deleted Successfully");
ViewDetails();
AllClear();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
BL_ScheduleEvents obj = new BL_ScheduleEvents();
obj.DEventId = Convert.ToInt32(TextBox1.Text);
obj.DeleteEvent();
Label1.Text = "Event Deleted Successfully";
AllClear();
TextBox1.Text = "";
FillGridView();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)
{
//delete
BL_ScheduleEvents obj = new BL_ScheduleEvents();
obj.DEventId = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["BookedEventId"].Value);
dataGridView1.Columns["BookedEventId"].Visible = false;
obj.DeleteEvent();
ViewDetails();
}
}
protected void btnInsert_Click(object sender, EventArgs e)
{
int n = 0;
if (string.IsNullOrEmpty(txtStartdate.Text))
{
n += 1;
}
if (string.IsNullOrEmpty(txtEndDate.Text))
{
n += 1;
}
if (n == 0)
{
BL_ScheduleEvents obj = new BL_ScheduleEvents();
obj.CustomerId = Convert.ToInt32(ddlCustomer.SelectedValue);
obj.EventTypeId = Convert.ToInt32(ddlEventType.SelectedValue);
obj.StartTime = Convert.ToDateTime(txtStartdate.Text);
obj.EndTime = Convert.ToDateTime(txtEndDate.Text);
obj.EntryDate = DateTime.Now;
if (obj.Save())
{
//MessageBox.Show("Event Booked Successfully");
Label1.Text = "Event Booked Successfully";
AllClear();
}
else
{
//MessageBox.Show("Error! Please Try Again");
Label1.Text = "Error! Please Try Again";
}
}
if (n != 0)
{
//MessageBox.Show("All Feilds Are Required");
Label1.Text = "All Feilds Are Required";
}
FillGridView();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
BL_ScheduleEvents obj = new BL_ScheduleEvents();
obj.CustomerId = Convert.ToInt32(ddlcustomers.SelectedValue);
obj.EventTypeId = Convert.ToInt32(ddleventtypes.SelectedValue);
obj.StartTime = dtpstart.Value;
obj.EndTime = dtpend.Value;
obj.EntryDate = DateTime.Now;
obj.BookedEventId = Convert.ToInt32(txtEventid.Text);
if (obj.UpdateEvent())
{
MessageBox.Show("Event Updated Successfully");
}
else
{
MessageBox.Show("Error! Please Try Again");
}
ViewDetails();
AllClear();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
BL_ScheduleEvents obj = new BL_ScheduleEvents();
obj.CustomerId = Convert.ToInt32(ddlCustomer.SelectedValue);
obj.EventTypeId = Convert.ToInt32(ddlEventType.SelectedValue);
obj.StartTime = Convert.ToDateTime(txtStartdate.Text);
obj.EndTime = Convert.ToDateTime(txtEndDate.Text);
obj.BookedEventId = Convert.ToInt32(TextBox1.Text);
obj.EntryDate = DateTime.Now;
if (obj.UpdateEvent())
{
Label1.Text = "Event Updated Successfully";
}
else
{
Label1.Text = "Error! Please Try Again";
}
AllClear();
FillGridView();
}
private void btnbooking_Click(object sender, EventArgs e)
{
int n = 0;
if (string.IsNullOrEmpty(ddlcustomers.Text))
{
n += 1;
}
if (string.IsNullOrEmpty(ddleventtypes.Text))
{
n += 1;
}
if (n == 0)
{
BL_ScheduleEvents obj = new BL_ScheduleEvents();
obj.CustomerId = Convert.ToInt32(ddlcustomers.SelectedValue);
obj.EventTypeId = Convert.ToInt32(ddleventtypes.SelectedValue);
obj.StartTime = dtpstart.Value;
obj.EndTime = dtpend.Value;
obj.EntryDate = DateTime.Now;
if (obj.Save())
{
MessageBox.Show("Event Booked Successfully");
}
else
{
MessageBox.Show("Error! Please Try Again");
}
}
if (n != 0)
{
MessageBox.Show("All Feilds Are Required");
}
ViewDetails();
AllClear();
}
