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);
            }
        }
コード例 #4
0
        //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);
            }
        }
コード例 #5
0
 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;
            }
        }
コード例 #10
0
    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;
            }
        }
コード例 #13
0
    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();
        }
    }
コード例 #14
0
        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);
            }
        }
コード例 #15
0
    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();
        }
    }
コード例 #16
0
    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();
        }
    }