public void GetFilteredVenue() { try { if (Session["venueBookedVenueList"] != null) { List <ATTMeetingVenue> lstVenue = (List <ATTMeetingVenue>)Session["venueBookedVenueList"]; ATTMeetingVenue objVenue = new ATTMeetingVenue(); objVenue.LstVenue = lstVenue.FindAll(delegate(ATTMeetingVenue obj) { return(obj.OrgID == int.Parse(ddlOrganization.SelectedValue) || (obj.OrgID == -1)); } ); this.ddlVenue.DataSource = objVenue.LstVenue; this.ddlVenue.DataTextField = "VenueName"; this.ddlVenue.DataValueField = "VenueID"; this.ddlVenue.DataBind(); ddlVenue.Enabled = true; } } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public void LoadUpdateControls(int updOrgID) { try { if (Session["venueBookedVenueList"] != null) { List <ATTMeetingVenue> lstVenue = (List <ATTMeetingVenue>)Session["venueBookedVenueList"]; ATTMeetingVenue objVenue = new ATTMeetingVenue(); objVenue.LstVenue = lstVenue.FindAll(delegate(ATTMeetingVenue obj) { return(obj.OrgID == updOrgID || (obj.OrgID == -1)); } ); this.ddlUpdVenue_rqd.DataSource = objVenue.LstVenue;; this.ddlUpdVenue_rqd.DataTextField = "VenueName"; this.ddlUpdVenue_rqd.DataValueField = "VenueID"; this.ddlUpdVenue_rqd.DataBind(); } if (Session["venueBookedPersonList"] != null) { List <ATTEmployeePosting> lstEmp = (List <ATTEmployeePosting>)Session["venueBookedPersonList"]; List <ATTEmployeePosting> lst = new List <ATTEmployeePosting>(); lst = lstEmp.FindAll(delegate(ATTEmployeePosting obj) { return(obj.OrgID == updOrgID); } ); this.ddlUpdPerson_rqd.DataSource = lst; this.ddlUpdPerson_rqd.DataTextField = "EmpName"; this.ddlUpdPerson_rqd.DataValueField = "EmpID"; this.ddlUpdPerson_rqd.DataBind(); ListItem a = new ListItem(); a.Selected = true; a.Text = " छान्नुहोस्"; a.Value = "0"; ddlUpdPerson_rqd.Items.Insert(0, a); } } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static bool AddMeetingVenue(ATTMeetingVenue obj) { try { DLLMeetingVenue.AddMeetingVenue(obj); return(true); } catch (Exception ex) { throw ex; } }
protected void lstVenue_SelectedIndexChanged(object sender, EventArgs e) { this.ddlOrg.SelectedIndex = 0; this.txtVenue.Text = ""; this.txtLocation.Text = ""; ATTMeetingVenue obj = ((List <ATTMeetingVenue>)Session["VenueLst"])[this.lstVenue.SelectedIndex]; this.ddlOrg.SelectedValue = obj.OrgID.ToString(); this.txtVenue.Text = obj.VenueName; this.txtLocation.Text = obj.VenueLocation; }
public static ObjectValidation Validate(ATTMeetingVenue obj) { ObjectValidation result = new ObjectValidation(); if (obj.VenueName == "") { result.IsValid = false; result.ErrorMessage = "Venue name cannot be blank."; return(result); } return(result); }
public void SetFilteredVenue() { try { if (ddlOrganisation_rqd.SelectedIndex > 0) { if (Session["BookingVenueList"] != null) { List <ATTMeetingVenue> lstVenue = (List <ATTMeetingVenue>)Session["BookingVenueList"]; if (lstVenue.Count > 0) { ATTMeetingVenue objVenue = new ATTMeetingVenue(); objVenue.LstVenue = lstVenue.FindAll(delegate(ATTMeetingVenue objMeetingVenue) { return(objMeetingVenue.OrgID == int.Parse(ddlOrganisation_rqd.SelectedValue) || (objMeetingVenue.OrgID == -1)); } ); this.ddlVenue_rqd.DataSource = objVenue.LstVenue; this.ddlVenue_rqd.DataTextField = "VenueName"; this.ddlVenue_rqd.DataValueField = "VenueID"; this.ddlVenue_rqd.DataBind(); ddlVenue_rqd.Enabled = true; } else { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = "Venue Couldn't be loaded"; this.programmaticModalPopup.Show(); } } } else { ListItem a = new ListItem(); a.Selected = true; a.Text = " छान्नुहोस्"; a.Value = "0"; ddlVenue_rqd.Items.Insert(0, a); } } catch (Exception ex) { throw(ex); } }
public static bool AddMeetingVenue(ATTMeetingVenue obj) { string SP = ""; if (obj.Action == "A") { SP = "SP_ADD_VENUE"; } else { SP = "SP_EDIT_VENUE"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("p_org_id", obj.OrgID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_venue_id", obj.VenueID, OracleDbType.Int16, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("p_venue_name", obj.VenueName, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_v_location", obj.VenueLocation, OracleDbType.Varchar2, ParameterDirection.Input)); GetConnection DBConn = new GetConnection(); try { OracleConnection Conn = DBConn.GetDbConn(Module.OAS); SqlHelper.ExecuteNonQuery(Conn, CommandType.StoredProcedure, SP, paramArray.ToArray()); obj.VenueID = int.Parse(paramArray[1].Value.ToString()); return(true); } catch (Exception ex) { throw ex; } finally { DBConn.CloseDbConn(); } }
public static List <ATTMeetingVenue> GetMeetingVenueList(int?orgID) { List <ATTMeetingVenue> lstMeetingVenue = new List <ATTMeetingVenue>(); try { foreach (DataRow row in DLLMeetingVenue.GetMeetingVenueListTable(orgID).Rows) { ATTMeetingVenue objMeetingVenue = new ATTMeetingVenue( int.Parse(row["ORG_ID"].ToString()), int.Parse(row["VENUE_ID"].ToString()), row["VENUE_NAME"].ToString(), row["VENUE_LOCATION"].ToString() ); lstMeetingVenue.Add(objMeetingVenue); } if (lstMeetingVenue.Count > 0) { ATTMeetingVenue objDefault = new ATTMeetingVenue(); objDefault.OrgID = -1; objDefault.VenueID = -1; objDefault.VenueName = "छान्नुहोस्"; lstMeetingVenue.Insert(0, objDefault); } return(lstMeetingVenue); } catch (Exception ex) { throw(ex); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (this.ddlOrg.SelectedIndex <= 0) { this.lblStatusMessage.Text = "Please select organization from list."; this.programmaticModalPopup.Show(); return; } ATTMeetingVenue obj = new ATTMeetingVenue(); obj.OrgID = int.Parse(this.ddlOrg.SelectedValue); obj.VenueID = 0; obj.VenueName = this.txtVenue.Text; obj.VenueLocation = this.txtLocation.Text; ObjectValidation result = BLLMeetingVenue.Validate(obj); if (result.IsValid == false) { this.lblStatusMessage.Text = result.ErrorMessage; this.programmaticModalPopup.Show(); return; } if (this.lstVenue.SelectedIndex < 0) { obj.Action = "A"; } else { obj.VenueID = int.Parse(this.lstVenue.SelectedValue); obj.Action = "E"; } try { BLLMeetingVenue.AddMeetingVenue(obj); if (obj.Action == "A") { ((List <ATTMeetingVenue>)Session["VenueLst"]).Add(obj); } else { ((List <ATTMeetingVenue>)Session["VenueLst"])[this.lstVenue.SelectedIndex] = obj; } Session["VenueLst"] = BLLMeetingVenue.GetMeetingVenueList(int.Parse(this.ddlOrg.SelectedValue)); this.lstVenue.DataSource = Session["VenueLst"]; this.lstVenue.DataTextField = "VenueName"; this.lstVenue.DataValueField = "VenueID"; this.lstVenue.DataBind(); this.ClearME(); this.lblStatusMessage.Text = "Venue successfully saved."; this.programmaticModalPopup.Show(); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }