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();
}
}
