public string getMeetingRoomBookingCalendar(string bookingdate, string userid)
{
if (bookingdate != "")
{
}
SqlDataReader dr = BLL_BookingCalendar.BookingCalenderListForDate(Convert.ToDateTime(bookingdate), Convert.ToInt32(userid.ToString()));
return(GetJsArray(dr));
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidationOnSave())
{
int?bookingid = null;
int crewfbmidout = 0;
if (Request.QueryString["bookingid"] != null)
{
bookingid = Convert.ToInt32(Request.QueryString["bookingid"]);
if ((ddltimefrom.SelectedItem.Text != ViewState["OldTimeFrom"].ToString()) || (ddltimeto.SelectedItem.Text != ViewState["OldTimeTo"].ToString()))
{
/* if previous time (timefrom OR timeTo) is differ from current selected time then Email should go to attendees */
ViewState["ISMEETINGTIMECHANGED"] = "1";
}
}
string SelectedDate = "";
if (ViewState["SelectedDate"] != null)
{
SelectedDate = ViewState["SelectedDate"].ToString();
}
else
{
SelectedDate = System.DateTime.Now.ToString("dd/MM/yyyy");
}
int bookingid_out = 0;
int ret = BLL_BookingCalendar.BookingCalenderSave(Convert.ToInt32(Session["userid"].ToString()), bookingid, Convert.ToDateTime(SelectedDate)
, ddltimefrom.SelectedValue, ddltimeto.SelectedValue, hdfRoomid.Value, txtRoom.Text, txtRemarks.Text, ref bookingid_out);
if (bookingid_out != 0)
{
int retval = BLL_BookingCalendar.BookingCalenderAttendeesSave(Convert.ToInt32(Session["userid"].ToString()), bookingid_out, Convert.ToInt32(ViewState["ISMEETINGTIMECHANGED"]), (DataTable)ViewState["vdtAttendees"]);
String script = String.Format("parent.hideModal('dvBookingPopUp');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", script, true);
String Reload = String.Format("parent.RefreshFromchild();");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg1", Reload, true);
}
else
{
lblError.Text = "The selected time slot is Conflicting with an existing booking ! Please select a different time slot.";
}
}
}
public void BindInviteUserList()
{
try
{
DataTable dt = BLL_BookingCalendar.BookingCalenderInviteUserList(Convert.ToInt32(Session["userid"].ToString()));
chklistInviteUser.DataSource = dt;
chklistInviteUser.DataTextField = "UserName";
chklistInviteUser.DataValueField = "UserID";
chklistInviteUser.DataBind();
}
catch (Exception ex)
{
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int bookingid_out = 0;
int retval = BLL_BookingCalendar.BookingCalenderDelete(Convert.ToInt32(Session["userid"].ToString()), Convert.ToInt32(Request.QueryString["bookingid"].ToString()), ref bookingid_out);
if (bookingid_out != 0)
{
String Reload = String.Format("parent.RefreshFromchild();");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgdelete", Reload, true);
}
else
{
lblError.Text = "Booking made for the past, cannot be deleted.";
}
}
public string CheckValidBookingDateTime(string bookingdate, string bookingtimefrom, string bookingtimeto)
{
return(BLL_BookingCalendar.BookingCalenderCheckValidBokingDateTime(Convert.ToDateTime(bookingdate), bookingtimefrom, bookingtimeto));
}
protected void Page_Load(object sender, EventArgs e)
{
DivUserList.Visible = false;
lblError.Text = "";
txtBookingDate.Enabled = false;
if (!IsPostBack)
{
DataTable dtAttendees = new DataTable();
DataColumn dtclm = new DataColumn("UserId");
dtAttendees.Columns.Add(dtclm);
dtAttendees.Columns.Add("UserName");
dtAttendees.PrimaryKey = new DataColumn[] { dtclm };
ViewState["vdtAttendees"] = dtAttendees;
ViewState["SelectedDate"] = null;
ViewState["ISMEETINGTIMECHANGED"] = "0";
btnDelete.Enabled = false;
if (Request.QueryString["bookingid"] != null)
{
DataTable dt = BLL_BookingCalendar.BookingCalenderList(Convert.ToInt32(Request.QueryString["bookingid"].ToString()), Convert.ToInt32(Session["userid"].ToString()));
DataTable dtAttendeesinfo = BLL_BookingCalendar.BooingCalenderGetAttendeesInfo(Convert.ToInt32(Request.QueryString["bookingid"]));
if (dtAttendeesinfo.Rows.Count > 0)
{
dtAttendeesinfo.PrimaryKey = new DataColumn[] { dtAttendeesinfo.Columns["UserID"] };
ViewState["vdtAttendees"] = dtAttendeesinfo;
lstAttendees.DataTextField = "username";
lstAttendees.DataValueField = "userid";
lstAttendees.DataSource = dtAttendeesinfo;
lstAttendees.DataBind();
}
if (dt.Rows.Count > 0)
{
ddltimefrom.ClearSelection();
ddltimeto.ClearSelection();
DataRow dr = dt.Rows[0];
txtBookingDate.Text = dr["BOOKING_ON"].ToString();
txtRemarks.Text = dr["REMARKS"].ToString();
txtRoom.Text = dr["ROOM"].ToString();
ddltimefrom.Items.FindByValue(dr["TIME_FROM"].ToString()).Selected = true;
ddltimeto.Items.FindByValue(dr["TIME_TO"].ToString()).Selected = true;
ViewState["OldTimeFrom"] = dr["TIME_FROM"].ToString();
ViewState["OldTimeTo"] = dr["TIME_TO"].ToString();
hdfRoomid.Value = dr["ROOMID"].ToString();
lblBookedby.Text = dr["First_Name"].ToString();
lblBookedOn.Text = dr["CREATED_ON"].ToString();
ViewState["SelectedDate"] = dr["BOOKING_ON"].ToString();
ViewState["BOOKING_BY"] = dr["BOOKING_BY"].ToString();
/* User can edit his own booking :: for other button will be disable */
if (ViewState["BOOKING_BY"].ToString() == Session["userid"].ToString())
{
btnDelete.Enabled = true;
btnSave.Enabled = true;
}
else
{
btnDelete.Enabled = false;
btnSave.Enabled = false;
}
ButtonEnableDisable(Convert.ToDateTime(ViewState["SelectedDate"]));
//RemovePastTimeToDropDown();
}
}
else
{
string TimeFrom = Request.QueryString["TimeFrom"].ToString();
string RoomID = Request.QueryString["RoomID"].ToString();
txtBookingDate.Text = Request.QueryString["SelDate"].ToString();
ViewState["SelectedDate"] = Convert.ToDateTime(txtBookingDate.Text);
ButtonEnableDisable(Convert.ToDateTime(ViewState["SelectedDate"]));
if (RoomID == "R1")
{
txtRoom.Text = "Board Room";
hdfRoomid.Value = "1";
}
else if (RoomID == "R2")
{
txtRoom.Text = "Crew Briefing Room";
hdfRoomid.Value = "2";
}
else if (RoomID == "R3")
{
txtRoom.Text = "Mgmt Meeting Room";
hdfRoomid.Value = "3";
}
ddltimefrom.ClearSelection();
ddltimefrom.Items.FindByValue(TimeFrom).Selected = true;
ddltimeto.ClearSelection();
ddltimeto.SelectedIndex = ddltimefrom.SelectedIndex + 1;
RemovePastTimeToDropDown();
ddltimeto.SelectedIndex = 0;
}
BindInviteUserList();
}
UserAccessValidation();
}
