public List <ATTMeetingVenueResources> GetBookedResources()
{
try
{
List <ATTMeetingVenueResources> lst = new List <ATTMeetingVenueResources>();
CheckBox cb = new CheckBox();
DropDownList dd = new DropDownList();
foreach (GridViewRow gvrow in this.grdResources.Rows)
{
ATTMeetingVenueResources objVenueResources = new ATTMeetingVenueResources();
cb = (CheckBox)(gvrow.Cells[0].FindControl("chkResource"));
dd = (DropDownList)(gvrow.Cells[3].FindControl("ddlQuantity"));
if (cb.Checked)
{
objVenueResources.ResourceID = int.Parse(gvrow.Cells[1].Text);
objVenueResources.ResourceQty = int.Parse(dd.SelectedValue);
lst.Add(objVenueResources);
}
}
return(lst);
}
catch (Exception ex)
{
throw(ex);
}
}
// public static List<ATTMeetingVenueResources> SetVenueResources(int orgID, int venueID, int bookingID)
public static List <ATTMeetingVenueResources> SetVenueResources(int bookingID)
{
try
{
List <ATTMeetingVenueResources> lst = new List <ATTMeetingVenueResources>();
foreach (DataRow row in tblRes.Rows)
{
/* if(orgID == int.Parse(row["ORG_ID"].ToString()) &&
* venueID == int.Parse(row["VENUE_ID"].ToString()) &&
* bookingID == int.Parse(row["BOOKING_ID"].ToString()))*/
if (bookingID == int.Parse(row["BOOKING_ID"].ToString()))
{
ATTMeetingVenueResources objRes = new ATTMeetingVenueResources();
objRes.OrgID = int.Parse(row["ORG_ID"].ToString());
objRes.VenueID = int.Parse(row["VENUE_ID"].ToString());
objRes.BookingID = int.Parse(row["BOOKING_ID"].ToString());
objRes.ResourceID = int.Parse(row["RESOURCE_ID"].ToString());
objRes.ResourceBookID = int.Parse(row["RESOURCE_BOOK_ID"].ToString());
objRes.ResourceQty = int.Parse(row["RESOURCE_QTY"].ToString());
objRes.Action = "N";
lst.Add(objRes);
}
//string SQL = " SELECT distinct ORG_ID,VENUE_ID,BOOKING_ID,RESOURCE_BOOK_ID,RESOURCE_ID,RESOURCE_NAME,RESOURCE_QTY " +
// " FROM vw_meeting_venue_details WHERE 1=1 ";
}
return(lst);
}
catch (Exception ex)
{
throw(ex);
}
}
public List <ATTMeetingVenueResources> GetUpdatedResourcesData()
{
List <ATTMeetingVenueResources> lst = new List <ATTMeetingVenueResources>();
try
{
if (Session["ResToUpdate"] != null)
{
bool flag = false;
CheckBox chkResource;
DropDownList ddlQuantity;
List <ATTMeetingVenueResources> lstRes = (List <ATTMeetingVenueResources>)Session["ResToUpdate"];
if (grdResources.Rows.Count > 0)
{
foreach (GridViewRow gvr in grdResources.Rows)
{
int resourceID = int.Parse(gvr.Cells[1].Text);
chkResource = (CheckBox)gvr.FindControl("chkResource");
ddlQuantity = (DropDownList)gvr.FindControl("ddlQuantity");
foreach (ATTMeetingVenueResources objRes in lstRes)
{
if (resourceID == objRes.ResourceID)
{
if (chkResource.Checked)
{
if (int.Parse(ddlQuantity.SelectedValue) == objRes.ResourceQty)
{
objRes.Action = "N";
}
else
{
objRes.Action = "E";
objRes.ResourceQty = int.Parse(ddlQuantity.SelectedValue);
}
}
else
{
objRes.Action = "D";
}
lst.Add(objRes);
flag = true;
break;
}
}
if (!flag)
{
if (chkResource.Checked)
{
ATTMeetingVenueResources obj = new ATTMeetingVenueResources();
obj.Action = "A";
obj.ResourceID = resourceID;
obj.ResourceQty = int.Parse(ddlQuantity.SelectedValue);
obj.ResourceBookID = null;
lst.Add(obj);
}
}
else
{
flag = false;
}
}
}
}
return(lst);
}
catch (Exception ex)
{
this.lblStatusMessageTitle.Text = "Error Status";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return(lst);
}
}
