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