protected void DayPilotCalendar1_BeforeEventRender(object sender, BeforeEventRenderEventArgs e)
{
cSchemeReservation scheme = new cSchemeReservation();
dataACC dacc = new dataACC();
e.DurationBarColor = "green";
}
protected void DayPilotCalendar1_EventClick(object sender, DayPilot.Web.Ui.Events.EventClickEventArgs e)
{
cSchemeReservation scheme = new cSchemeReservation();
dataACC dacc = new dataACC();
scheme = dacc.getDataOnScheme(Convert.ToInt16(e.Id));
tb.Text = scheme.InformationBox.ToString();
tb1.Text = scheme.SchemeStartDate.ToString();
tb2.Text = scheme.SchemeEndDate.ToString();
tb3.Text = scheme.ArtistName.ToString();
tbSchemaId.Text = scheme.SchemeID.ToString();
if (scheme.ReservationID != 0)
{
btnSubmit.Enabled = false;
}
else if (scheme.TimeType == 2)
{
btnSubmit.Enabled = false;
}
else
{
btnSubmit.Enabled = true;
}
}
public DataTable getScheme(int WeekNumber, int ArtistID)
{
cSchemeReservation csr = new cSchemeReservation();
DataTable dt = new DataTable();
SqlConnection sqlcon = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand("uspScheme", sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
try
{
sqlcon.Open();
cmd.Parameters.AddWithValue("@WeekNumber", WeekNumber);
cmd.Parameters.AddWithValue("@Artist", ArtistID);
dt.Load(cmd.ExecuteReader());
return(dt);
}
catch
{
throw;
}
finally
{
cmd.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
}
public cSchemeReservation getDataOnScheme(Int16 SchemeID)
{
// New object
cSchemeReservation csr = new cSchemeReservation();
// Create a connection
SqlConnection conn = new SqlConnection(connstr);
// Name of the Procedure I want to call
SqlCommand cmd = new SqlCommand("uspSchemeInfo", conn);
// Type of commad I want to execute
cmd.CommandType = CommandType.StoredProcedure;
try
{
// Open the connection to the database
conn.Open();
// Insert the Parameter to the procedure
cmd.Parameters.AddWithValue("@SchemeID", SchemeID);
// Execute my procedure and load the result to dr
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
csr.SchemeID = Convert.ToInt16(dr["SchemeID"]);
csr.ArtistName = dr["ArtistName"].ToString();
csr.SchemeStartDate = Convert.ToDateTime(dr["SchemeStartDate"].ToString());
csr.SchemeEndDate = Convert.ToDateTime(dr["SchemeEndDate"].ToString());
csr.InformationBox = dr["InformationBox"].ToString();
csr.ReservationID = Convert.ToInt16(dr["ReservationID"]);
csr.TimeType = Convert.ToInt16(dr["TimeType"]);
}
}
return(csr);
}
catch
{
// If error
throw;
}
finally
{
// Close and dispose all connections to the databse
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
