private ArrayList GetDataForWeeklyEvents(DateTime objStartDateTime, DateTime objEndDateTime)
{
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
_sqlCon = new SqlConnection(ConfigurationManager.AppSettings["Connection_String"]);
_arrayList = new ArrayList();
try
{
_sqlCon.Open();
_sqlCmd = new SqlCommand("GET_ROOM_DETAILS_WEEK", _sqlCon);
_sqlCmd.CommandType = CommandType.StoredProcedure;
_sqlCmd.Parameters.AddWithValue("@SZ_CASE_ID", "");
_sqlCmd.Parameters.AddWithValue("@DT_START_DATE", objStartDateTime);
_sqlCmd.Parameters.AddWithValue("@DT_END_DATE", objEndDateTime);
_sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_ID", ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
_sqlCmd.Parameters.AddWithValue("@SZ_REFERRING_ID", extddlReferringFacility.Text);
_sqlDr = _sqlCmd.ExecuteReader();
while (_sqlDr.Read())
{
Schedule_DAO objDAO = null;
objDAO = new Schedule_DAO(_sqlDr["DT_EVENT_DATE"].ToString(), _sqlDr["DESCRIPTION"].ToString(), _sqlDr["TIME"].ToString());
_arrayList.Add(objDAO);
}
return(_arrayList);
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
return(null);
}
finally
{
if (_sqlCon.State == ConnectionState.Open)
{
_sqlCon.Close();
}
}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
private void getWeekSchedule(DateTime objWeekStart, DateTime objWeekEnd)
{
TimeSpan objSpan = objWeekEnd.Subtract(objWeekStart);
Label1.Text = Label1.Text + " __ " + objSpan.Days;
DateTime objTemp = objWeekStart;
int iCounter = 0;
Label1.Text = "<table width='100%'>";
ArrayList objDataList = GetDataForWeeklyEvents(objWeekStart, objWeekEnd);
// ArrayList objDataList = getWeekScheduleData();
while (iCounter < 6)
{
Label1.Text = Label1.Text + "<tr>";
Label1.Text = Label1.Text + "<td width='100%'>";
Label1.Text = Label1.Text + "<div style='background-color:#FFFFD5;border: gray 1px solid;width:100%;height:200px;overflow:auto;'>";
Label1.Text = Label1.Text + String.Format("{0:dddd, MMMM d, yyyy}", objTemp); //Weekday
Label1.Text = Label1.Text + "<div style='width:100%;height:20px'> </div>";
// Data loop goes here
// Label1.Text = Label1.Text + objTemp.ToString();
string[] sTmpArray = null;
for (int i = 0; i < objDataList.Count; i++)
{
Schedule_DAO obj = (Schedule_DAO)objDataList[i];
sTmpArray = objTemp.ToString("MM/dd/yyyy").Split(' ');
if (sTmpArray[0].Equals(obj.Date))
{
Label1.Text = Label1.Text + "<p style='background-color: #FFFF66;margin-top:1px;margin-bottom:1px'>";
Label1.Text = Label1.Text + obj.Time + " " + obj.Description;
Label1.Text = Label1.Text + "</p>";
}
}
// Data loop ends here
//Label1.Text = Label1.Text + "Nunc aliquet pharetra leo. Nulla facilisi. Proin consectetuer dictum felis. Cras lacinia. Quisque bibendum libero id quam. Etiam mollis euismod ante. Duis vitae est sodales justo cursus ullamcorper. Donec volutpat eros sit amet nibh aliquam malesuada. Morbi nunc. Fusce vestibulum ipsum id massa. Ut a orci. Sed et sapien sit amet tellus faucibus hendrerit. Maecenas bibendum, felis a dictum mollis, tellus tortor blandit odio, et convallis massa lorem at metus. ";
Label1.Text = Label1.Text + "</div>";
Label1.Text = Label1.Text + "</td>";
Label1.Text = Label1.Text + "</tr>";
objTemp = objTemp.AddDays(1);
iCounter++;
}
Label1.Text = Label1.Text + "</table>";
// return "";
}