public static int SaveMeetingVenueBooking(ATTMeetingVenueBooking objVenueBok) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { int venueAlreadyExistCount = CheckVenueIfVenueAlreadyBooked(objVenueBok, Tran); if (venueAlreadyExistCount > 0) { Tran.Commit(); //return false; return(0); } string sp = "SP_ADD_MEETING_VENUE_BOOKING"; int countBookedResources = objVenueBok.LstBookedResources.Count; OracleParameter[] paramArray = new OracleParameter[11]; paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objVenueBok.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":P_VENUE_ID", objVenueBok.VenueID, OracleDbType.Int64, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":P_BOOKING_ID", objVenueBok.BookingID, OracleDbType.Int64, ParameterDirection.InputOutput); paramArray[3] = Utilities.GetOraParam(":P_BOOKED_BY", objVenueBok.BookedBy, OracleDbType.Int64, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":P_PURPOSE", objVenueBok.Purpose, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":P_BOOKING_DATE", objVenueBok.BookingDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":P_START_TIME", objVenueBok.StartTime, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":P_END_TIME", objVenueBok.EndTime, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":P_ACTIVE", objVenueBok.Active, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":P_ENTRY_BY", objVenueBok.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":P_ENTRY_ON", objVenueBok.EntryOn, OracleDbType.Date, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray); objVenueBok.BookingID = int.Parse(paramArray[2].Value.ToString()); if (countBookedResources > 0) { DLLMeetingVenueResources.SaveBookedResources(objVenueBok, Tran); } Tran.Commit(); return(objVenueBok.BookingID); //return true; } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }
public static int CheckVenueIfVenueAlreadyBooked(ATTMeetingVenueBooking objVBooked, OracleTransaction Tran) { try { string SQL = "SELECT CHECK_IF_VENUE_ALREADY_BOOKED(" + objVBooked.OrgID + "," + objVBooked.VenueID + ",'" + objVBooked.BookingDate + "','" + objVBooked.StartTime + "','" + objVBooked.EndTime + "')" + "FROM DUAL"; DataSet ds = SqlHelper.ExecuteDataset(Tran, CommandType.Text, SQL); DataTable tbl = new DataTable(); tbl = (DataTable)ds.Tables[0]; int bookedVenueCount = int.Parse(tbl.Rows[0][0].ToString()); return(bookedVenueCount); } catch (Exception ex) { throw (ex); } }
public static DataTable CheckVenueIfVenueAlreadyBooked(ATTMeetingVenueBooking objVBooked) { try { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); string SQL = " SELECT * FROM vw_meeting_booking " + " WHERE ORG_ID = " + objVBooked.OrgID + " AND VENUE_ID = " + objVBooked.VenueID + " AND BOOKING_DATE = '" + objVBooked.BookingDate + "'" + " AND ACTIVE = 'Y'" + " AND ((START_TIME BETWEEN '" + objVBooked.StartTime + "' AND '" + objVBooked.EndTime + "') " + " OR (END_TIME BETWEEN '" + objVBooked.StartTime + "' AND '" + objVBooked.EndTime + "') " + " OR (START_TIME < '" + objVBooked.StartTime + "' AND END_TIME > '" + objVBooked.EndTime + "' ) )"; DataSet ds = SqlHelper.ExecuteDataset(Tran, CommandType.Text, SQL); DataTable tbl = new DataTable(); tbl = (DataTable)ds.Tables[0]; //int bookedVenueCount = int.Parse(tbl.Rows[0][0].ToString()); return(tbl); } catch (Exception ex) { throw (ex); } }
//public static bool DeleteBookedResources(ATTMeetingParticipant objMeetingParticipant, OracleTransaction Tran) //{ // try // { // if (objMeetingParticipant.Action == "D") // { // string deleteSQL = "SP_DEL_MEETING_PARTICIPANT"; // OracleParameter[] paramArray = new OracleParameter[3]; // paramArray[0] = Utilities.GetOraParam(":P_ORG_ID", objMeetingParticipant.OrgID, OracleDbType.Int64, ParameterDirection.Input); // paramArray[1] = Utilities.GetOraParam(":P_MEETING_ID", objMeetingParticipant.MeetingID, OracleDbType.Int64, ParameterDirection.Input); // paramArray[2] = Utilities.GetOraParam(":P_PARTICIPANT_ID", objMeetingParticipant.ParticipantID, OracleDbType.Int64, ParameterDirection.Input); // SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, deleteSQL, paramArray); // } // return true; // } // catch (Exception ex) // { // throw (ex); // } //} public static bool SaveBookedResources(ATTMeetingVenueBooking objVenueBok, OracleTransaction Tran) { try { string sp = "SP_ADD_MEETING_VENUE_RESOURCES"; List <OracleParameter> paramArray = new List <OracleParameter>(); foreach (ATTMeetingVenueResources objRes in objVenueBok.LstBookedResources) { objRes.OrgID = objVenueBok.OrgID; objRes.VenueID = objVenueBok.VenueID; objRes.BookingID = objVenueBok.BookingID; paramArray.Add(Utilities.GetOraParam(":p_ORG_ID", objRes.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_VENUE_ID", objRes.VenueID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_BOOKING_ID", objRes.BookingID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_RESOURCE_BOOK_ID", objRes.ResourceBookID, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":P_RESOURCE_ID", objRes.ResourceID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_RESOURCE_QTY", objRes.ResourceQty, OracleDbType.Int64, ParameterDirection.Input)); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray.ToArray()); paramArray.Clear(); } return(true); } catch (Exception ex) { throw(ex); } }
public static DataTable GetBookedResourceDetailsTable(ATTMeetingVenueBooking objVBooked) { try { return(DLLMeetingVenueResources.GetBookedResourceDetailsTable(objVBooked)); } catch (Exception ex) { throw(ex); } }
public static bool UpdateMeetingVenueBooking(ATTMeetingVenueBooking objVenueBok) { try { return(DLLMeetingVenueBooking.UpdateMeetingVenueBooking(objVenueBok)); } catch (Exception ex) { throw ex; } }
public static DataTable GetBookedVenueDetailsTable(ATTMeetingVenueBooking objVBooked) { try { string SQL = " SELECT distinct ORG_ID,VENUE_ID,BOOKING_ID,ORG_NAME,VENUE_NAME,BOOKED_BY,FIRST_NAME,MID_NAME,SUR_NAME, " + " BOOKING_DATE,START_TIME,END_TIME,PURPOSE,ACTIVE " + " FROM vw_meeting_venue_details WHERE 1=1 "; List <OracleParameter> paramArray = new List <OracleParameter>(); if (objVBooked != null) { if (objVBooked.OrgID > 0) { SQL = SQL + " AND ORG_ID=:org_id "; paramArray.Add(Utilities.GetOraParam(":org_id", objVBooked.OrgID, OracleDbType.Int32, ParameterDirection.Input)); } if (objVBooked.VenueID > 0) { SQL = SQL + " AND VENUE_ID=:venue_id"; paramArray.Add(Utilities.GetOraParam(":venue_id", objVBooked.VenueID, OracleDbType.Int32, ParameterDirection.Input)); } if (objVBooked.BookedBy > 0) { SQL = SQL + " AND BOOKED_BY = :bookedBy"; paramArray.Add(Utilities.GetOraParam(":bookedBy", objVBooked.BookedBy, OracleDbType.Int32, ParameterDirection.Input)); } if (objVBooked.BookingID > 0) { SQL = SQL + " AND BOOKING_ID = :bookedID"; paramArray.Add(Utilities.GetOraParam(":bookedID", objVBooked.BookingID, OracleDbType.Int32, ParameterDirection.Input)); } if (objVBooked.BookingDate != "") { SQL = SQL + " AND booking_date= :bookingDate"; paramArray.Add(Utilities.GetOraParam(":bookingDate", objVBooked.BookingDate, OracleDbType.Varchar2, ParameterDirection.Input)); } } SQL = SQL + " order by BOOKING_ID DESC"; return(SqlHelper.ExecuteDataset(CommandType.Text, SQL, Module.OAS, paramArray.ToArray()).Tables[0]); } catch (Exception ex) { throw(ex); } }
public static DataTable GetVenueAlreadyBookedDetails(ATTMeetingVenueBooking objVBooked) { try { string SQL = " SELECT * FROM vw_venue_booker_detail WHERE 1=1 "; List <OracleParameter> paramArray = new List <OracleParameter>(); if (objVBooked != null) { if (objVBooked.OrgID > 0) { SQL = SQL + " AND ORG_ID=:org_id "; paramArray.Add(Utilities.GetOraParam(":org_id", objVBooked.OrgID, OracleDbType.Int32, ParameterDirection.Input)); } if (objVBooked.VenueID > 0) { SQL = SQL + " AND VENUE_ID=:venue_id"; paramArray.Add(Utilities.GetOraParam(":venue_id", objVBooked.VenueID, OracleDbType.Int32, ParameterDirection.Input)); } if (objVBooked.BookingDate != "") { SQL = SQL + " AND booking_date= :bookingDate"; paramArray.Add(Utilities.GetOraParam(":bookingDate", objVBooked.BookingDate, OracleDbType.Varchar2, ParameterDirection.Input)); } if (objVBooked.StartTime != "" && objVBooked.EndTime != "") { SQL = SQL + " AND ((start_time BETWEEN :start_time AND :end_time) OR (end_time BETWEEN :start_time AND :end_time) OR (start_time < :start_time AND end_time > :end_time))"; paramArray.Add(Utilities.GetOraParam(":START_TIME", objVBooked.StartTime, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":END_TIME", objVBooked.EndTime, OracleDbType.Varchar2, ParameterDirection.Input)); } SQL += " ORDER BY start_time"; } return(SqlHelper.ExecuteDataset(CommandType.Text, SQL, Module.OAS, paramArray.ToArray()).Tables[0]); } catch (Exception ex) { throw (ex); } }
public static List <ATTMeetingVenueBooking> GetBookedVenueDetails(ATTMeetingVenueBooking objVBooked) { List <ATTMeetingVenueBooking> lst = new List <ATTMeetingVenueBooking>(); try { tblVenue = new DataTable(); tblRes = new DataTable(); tblVenue = DLLMeetingVenueBooking.GetBookedVenueDetailsTable(objVBooked); tblRes = BLLMeetingVenueResources.GetBookedResourceDetailsTable(objVBooked); foreach (DataRow row in tblVenue.Rows) { ATTMeetingVenueBooking obj = new ATTMeetingVenueBooking(); obj.OrgID = int.Parse(row["ORG_ID"].ToString()); obj.VenueID = int.Parse(row["VENUE_ID"].ToString()); obj.BookingID = int.Parse(row["BOOKING_ID"].ToString()); obj.OrgName = row["ORG_NAME"].ToString(); obj.VenueName = row["VENUE_NAME"].ToString(); obj.BookedBy = int.Parse(row["BOOKED_BY"].ToString()); obj.BookedByName = row["FIRST_NAME"].ToString() + (row["MID_NAME"].ToString() == "" ? "" : " " + row["MID_NAME"].ToString()) + (row["SUR_NAME"].ToString() == "" ? "" : " " + row["SUR_NAME"].ToString()); obj.BookingDate = row["BOOKING_DATE"].ToString(); obj.StartTime = row["START_TIME"].ToString(); obj.EndTime = row["END_TIME"].ToString(); obj.Purpose = row["PURPOSE"].ToString(); obj.Active = row["ACTIVE"].ToString(); //obj.LstBookedResources = SetVenueResources(obj.OrgID, obj.VenueID, obj.BookingID); obj.LstBookedResources = SetVenueResources(obj.BookingID); lst.Add(obj); } return(lst); } catch (Exception ex) { throw ex; } }
protected void btnSearch_Click(object sender, EventArgs e) { try { ATTMeetingVenueBooking obj = new ATTMeetingVenueBooking(); if (ddlOrganization.SelectedIndex > 0) { obj.OrgID = int.Parse(ddlOrganization.SelectedValue.ToString()); } if (ddlVenue.SelectedIndex > 0) { obj.VenueID = int.Parse(ddlVenue.SelectedValue.ToString()); } if (ddlPerson.SelectedIndex > 0) { obj.BookedBy = int.Parse(ddlPerson.SelectedValue.ToString()); } if (txtBookingDate.Text != "") { obj.BookingDate = txtBookingDate.Text; } if (txtBookingID.Text != "") { obj.BookingID = int.Parse(txtBookingID.Text); } VenueSrchCritera = obj; LoadBookedVenue(); } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static List <ATTMeetingVenueBooking> CheckVenueIfVenueAlreadyBooked(ATTMeetingVenueBooking objVBooked) { try { DataTable tbl = new DataTable(); tbl = DLLMeetingVenueBooking.CheckVenueIfVenueAlreadyBooked(objVBooked); List <ATTMeetingVenueBooking> lst = new List <ATTMeetingVenueBooking>(); foreach (DataRow row in tbl.Rows) { ATTMeetingVenueBooking obj = new ATTMeetingVenueBooking(); obj.OrgID = int.Parse(row["ORG_ID"].ToString()); obj.BookingID = int.Parse(row["BOOKING_ID"].ToString()); lst.Add(obj); } return(lst); } catch (Exception ex) { throw (ex); } }
public static int SaveMeetingVenueBooking(ATTMeetingVenueBooking objVenueBok) { try { int bookingID = 0; bookingID = DLLMeetingVenueBooking.SaveMeetingVenueBooking(objVenueBok); if (bookingID == 0) { string bookedDetails = ""; //bookedDetails = GetVenueAlreadyBookedDetails(objVenueBok); return(0); } else { return(bookingID); } } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { int len = Session["NowDate"].ToString().Length; string nowDate = Session["NowDate"].ToString().Substring(0, len - 5); string bookingDate = ""; if (this.txtBookingDate_RDT.Text.Trim() != "") { bookingDate = txtBookingDate_RDT.Text.Trim(); //if (Convert.ToDateTime(nowDate) <= Convert.ToDateTime(bookingDate)) //{ if (CompareDate(nowDate, bookingDate)) { string time = "00:00:00"; if (this.drpHr1_rqd.SelectedIndex > 0 && this.drpMin1_rqd.SelectedIndex > 0) { time = drpHr1_rqd.SelectedValue.ToString() + ":" + drpMin1_rqd.SelectedValue.ToString(); } if (CompareTime(time, nowDate, bookingDate)) { ATTMeetingVenueBooking objVenueBooked = new ATTMeetingVenueBooking(); objVenueBooked.OrgID = int.Parse(ddlOrganisation_rqd.SelectedValue); objVenueBooked.VenueID = int.Parse(ddlVenue_rqd.SelectedValue); objVenueBooked.VenueName = ddlVenue_rqd.SelectedItem.ToString(); objVenueBooked.BookedBy = int.Parse(ddlBookingPerson_rqd.SelectedValue); objVenueBooked.BookedByName = ddlBookingPerson_rqd.SelectedItem.ToString(); objVenueBooked.Purpose = txtBookingPurpose.Text.Trim(); if (this.drpHr1_rqd.SelectedIndex > 0 && this.drpMin1_rqd.SelectedIndex > 0) { objVenueBooked.StartTime = drpHr1_rqd.SelectedValue.ToString() + ":" + drpMin1_rqd.SelectedValue.ToString(); } if (this.drpHr2_rqd.SelectedIndex > 0 && this.drpMin2_rqd.SelectedIndex > 0) { objVenueBooked.EndTime = drpHr2_rqd.SelectedValue.ToString() + ":" + drpMin2_rqd.SelectedValue.ToString(); } objVenueBooked.BookingDate = txtBookingDate_RDT.Text.Trim(); objVenueBooked.EntryBy = entryBy; objVenueBooked.LstBookedResources = GetBookedResources(); int bookingID = 0; bookingID = BLLMeetingVenueBooking.SaveMeetingVenueBooking(objVenueBooked); if (bookingID != 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "ClearForm", "javascript:clearForm();", true); LoadResources(); this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = "नयाँ स्थल सफलतापूर्वक बुकिङ्ग भयो!!! " + "<br> तपाईको बुकिङ्ग नं <b><font color = 'black'>" + bookingID + " </font></b> हो ।" + "<br> समय : <b><font color = 'black'>(" + objVenueBooked.StartTime + "-" + objVenueBooked.EndTime + ")</font></b>" + "<br> मिति : <b><font color = 'black'>" + objVenueBooked.BookingDate + "</font></b>" + "<br> स्थल : <b><font color = 'black'>" + objVenueBooked.VenueName + "</font></b>" + "<br> बुकिङ्ग गर्नेको नाम :<b><font color = 'black'>" + objVenueBooked.BookedByName + "</font></b>"; this.programmaticModalPopup.Show(); } else { List <ATTMeetingVenueAlreadyBookedDetails> lst = new List <ATTMeetingVenueAlreadyBookedDetails>(); lst = BLLMeetingVenueAlreadyBookedDetails.GetVenueAlreadyBookedDetails(objVenueBooked); grdBooked.DataSource = lst; grdBooked.DataBind(); programmaticBookedVenueModalPopup.Show(); } } else { this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = "स्थल व्यवस्थापनको शुरु समय नागीसक्यो !!! <br> त्यसैले अर्को शुरु समयमा स्थल व्यवस्थापन गर्नुहोस्"; this.programmaticModalPopup.Show(); } } else { this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = " मिति नागीसक्यो !!! <br> त्यसैले अर्को मितिमा राख्नुहोस्"; this.programmaticModalPopup.Show(); } } else { this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = " बुकिङ्ग मिति राख्न अनिवार्य छ । "; this.programmaticModalPopup.Show(); } } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static List <ATTMeetingVenueAlreadyBookedDetails> GetVenueAlreadyBookedDetails(ATTMeetingVenueBooking objVenueBok) { try { DataTable tbl = new DataTable(); tbl = DLLMeetingVenueAlreadyBookedDetails.GetVenueAlreadyBookedDetails(objVenueBok); List <ATTMeetingVenueAlreadyBookedDetails> lst = new List <ATTMeetingVenueAlreadyBookedDetails>(); foreach (DataRow row in tbl.Rows) { ATTMeetingVenueAlreadyBookedDetails obj = new ATTMeetingVenueAlreadyBookedDetails(); obj.OrgID = int.Parse(row["ORG_ID"].ToString()); obj.OrgName = row["ORG_NAME"].ToString(); obj.VenueID = int.Parse(row["VENUE_ID"].ToString()); obj.VenueName = row["VENUE_NAME"].ToString(); obj.BookedBy = int.Parse(row["BOOKED_BY"].ToString()); obj.BookerName = row["FIRST_NAME"].ToString() + (row["MID_NAME"].ToString() == "" ? "" : " " + row["MID_NAME"].ToString()) + (row["SUR_NAME"].ToString() == "" ? "" : " " + row["SUR_NAME"].ToString()); obj.BookingDate = row["BOOKING_DATE"].ToString(); obj.StartTime = row["START_TIME"].ToString(); obj.EndTime = row["END_TIME"].ToString(); obj.Purpose = row["PURPOSE"].ToString(); lst.Add(obj); } return(lst); } catch (Exception ex) { throw (ex); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { int ID = int.Parse(txtUpdBookingNo_rqd.Text.Trim()); int count = BLLMeetingVenueBooking.CheckBookingIDInUse(ID); if (count > 0) { this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = "यो बुकिङ्ग नम्बर प्रयोगमा छ,त्यसैले अहिले परिवर्तन गर्न मिल्दैन।"; this.programmaticModalPopup.Show(); } else { int len = Session["UpdNowDate"].ToString().Length; string nowDate = Session["UpdNowDate"].ToString().Substring(0, len - 5); string bookingDate = ""; if (this.txtUpdBookingDate_RDT.Text.Trim() != "") { bookingDate = txtUpdBookingDate_RDT.Text.Trim(); if (CompareDate(nowDate, bookingDate)) { string time = "00:00:00"; if (this.ddlHr1_rqd.SelectedIndex > 0 && this.ddlMin1_rqd.SelectedIndex > 0) { time = ddlHr1_rqd.SelectedValue.ToString() + ":" + ddlMin1_rqd.SelectedValue.ToString(); } if (CompareTime(time, nowDate, bookingDate)) { ATTMeetingVenueBooking objRqdUpd = (ATTMeetingVenueBooking)Session["objRqdDetail"]; objRqdUpd.OrgID = int.Parse(ddlUpdOrganization_rqd.SelectedValue); objRqdUpd.VenueID = int.Parse(ddlUpdVenue_rqd.SelectedValue); objRqdUpd.BookedBy = int.Parse(ddlUpdPerson_rqd.SelectedValue); if (this.ddlHr1_rqd.SelectedIndex > 0 && this.ddlMin1_rqd.SelectedIndex > 0) { objRqdUpd.StartTime = ddlHr1_rqd.SelectedValue.ToString() + ":" + ddlMin1_rqd.SelectedValue.ToString(); } if (this.ddlHr2_rqd.SelectedIndex > 0 && this.ddlMin2_rqd.SelectedIndex > 0) { objRqdUpd.EndTime = ddlHr2_rqd.SelectedValue.ToString() + ":" + ddlMin2_rqd.SelectedValue.ToString(); } objRqdUpd.BookingDate = txtUpdBookingDate_RDT.Text.Trim(); objRqdUpd.Purpose = txtUpdPurpose.Text.Trim(); objRqdUpd.EntryBy = entryBy; objRqdUpd.LstBookedResources = GetUpdatedResourcesData(); List <ATTMeetingVenueBooking> lst = new List <ATTMeetingVenueBooking>(); lst = BLLMeetingVenueBooking.CheckVenueIfVenueAlreadyBooked(objRqdUpd); lst.RemoveAll( (delegate(ATTMeetingVenueBooking obj) { return(objRqdUpd.OrgID == obj.OrgID && objRqdUpd.BookingID == obj.BookingID); } ) ); if (lst.Count > 0) { this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = "अरु प्रायोजनको निमित्त स्थल बुकिङ्ग भईसकेको छ,त्यसैले अर्को स्थल छान्नुहोस् !!!"; this.programmaticModalPopup.Show(); } else { if (BLLMeetingVenueBooking.UpdateMeetingVenueBooking(objRqdUpd)) { ddlUpdOrganization_rqd.SelectedIndex = -1; ddlUpdPerson_rqd.SelectedIndex = -1; ddlUpdVenue_rqd.SelectedIndex = -1; ddlHr1_rqd.SelectedIndex = -1; ddlMin1_rqd.SelectedIndex = -1; ddlHr2_rqd.SelectedIndex = -1; ddlMin2_rqd.SelectedIndex = -1; txtUpdBookingDate_RDT.Text = ""; txtUpdBookingNo_rqd.Text = ""; txtUpdPurpose.Text = ""; grdBookedVenue.SelectedIndex = -1; programmaticBookedVenueModalPopup.Hide(); btnSearch_Click(null, null); this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = "स्थल बुकिङ्गको विवरण परिवर्तन सफलतापूर्वक भयो !!!"; this.programmaticModalPopup.Show(); } } } else { this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = "स्थल व्यवस्थापनको शुरु समय नागीसक्यो !!! <br> त्यसैले अर्को शुरु समयमा स्थल व्यवस्थापन गर्नुहोस्"; this.programmaticModalPopup.Show(); } } else { this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = " मिति नागीसक्यो !!! <br> त्यसैले अर्को मितिमा राख्नुहोस्"; this.programmaticModalPopup.Show(); } } else { this.lblStatusMessageTitle.Text = "स्थल व्यवस्थापन"; this.lblStatusMessage.Text = " बुकिङ्ग मिति राख्न अनिवार्य छ । "; this.programmaticModalPopup.Show(); } } } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public void ShowBookedVenueDetails() { try { List <ATTMeetingVenueBooking> lst = (List <ATTMeetingVenueBooking>)Session["BookedVenueSearchList"]; ATTMeetingVenueBooking objRqd = lst.Find(delegate(ATTMeetingVenueBooking obj) { return((obj.OrgID == orgId) && (obj.VenueID == venueID) && (obj.BookingID == bookingId)); } ); ddlUpdOrganization_rqd.SelectedValue = objRqd.OrgID.ToString(); LoadUpdateControls(int.Parse(objRqd.OrgID.ToString())); txtUpdBookingDate_RDT.Text = objRqd.BookingDate.ToString(); txtUpdBookingNo_rqd.Text = objRqd.BookingID.ToString(); ddlUpdPerson_rqd.SelectedValue = objRqd.BookedBy.ToString(); ddlUpdVenue_rqd.SelectedValue = objRqd.VenueID.ToString(); string startTime = objRqd.StartTime; string hr1, min1; hr1 = startTime.Substring(0, startTime.Length - 3).ToString(); if (startTime.Length == 4) { min1 = startTime.Substring(2, startTime.Length - 2).ToString(); } else { min1 = startTime.Substring(3, startTime.Length - 3).ToString(); } ddlHr1_rqd.SelectedValue = hr1; ddlMin1_rqd.SelectedValue = min1; string endTime = objRqd.EndTime; string hr2, min2; hr2 = endTime.Substring(0, endTime.Length - 3).ToString(); if (endTime.Length == 4) { min2 = endTime.Substring(2, endTime.Length - 2).ToString(); } else { min2 = endTime.Substring(3, endTime.Length - 3).ToString(); } ddlHr2_rqd.SelectedValue = hr2; ddlMin2_rqd.SelectedValue = min2; txtUpdPurpose.Text = objRqd.Purpose; CheckResources(objRqd.LstBookedResources); Session["objRqdDetail"] = objRqd; this.programmaticBookedVenueModalPopup.Show(); } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }