protected void btnSearch_Click(object sender, EventArgs e)
{
if (this.ddlOrganization.SelectedIndex <= 0)
{
this.lblStatusMessage.Text = " कृपया पहिला कार्यलय छान्नुहोस्।";
this.programmaticModalPopup.Show();
return;
}
ATTMeetingInfo mInfo = new ATTMeetingInfo();
mInfo.OrgID = int.Parse(this.ddlOrganization.SelectedValue);
mInfo.FromDate = this.txtFromDate.Text;
mInfo.ToDate = this.txtToDate.Text;
mInfo.CalledBy = this.ddlCommittee.SelectedValue;
mInfo.CalledBy = mInfo.CalledBy == "" ? "0" : mInfo.CalledBy;
mInfo.Venue = this.ddlVenue.SelectedValue;
mInfo.Venue = mInfo.Venue == "" ? "0" : mInfo.Venue;
mInfo.Status = this.ddlStatus.SelectedValue;
mInfo.MeetingTypeName = this.ddlMeetingType.SelectedValue;
try
{
this.grdMeeting.DataSource = BLLMeetingInfo.GetMeetingInfoList(mInfo);
this.grdMeeting.DataBind();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public static List <ATTMeetingInfo> GetMeetingInfoList(ATTMeetingInfo infox)
{
List <ATTMeetingInfo> lst = new List <ATTMeetingInfo>();
try
{
foreach (DataRow row in DLLMeetingInfo.GetMeetingInfoTable(infox).Rows)
{
ATTMeetingInfo info = new ATTMeetingInfo();
info.OrgID = int.Parse(row["org_id"].ToString());
info.MeetingID = int.Parse(row["meeting_id"].ToString());
info.Subject = row["meeting_subject"].ToString();
info.MeetingTypeName = row["mtype_name"].ToString();
info.Venue = row["venue_name"].ToString();
info.MeetingDate = row["meeting_date"].ToString();
info.CalledBy = row["group_name"].ToString();
info.StartTime = row["start_time"].ToString();
info.EndTime = row["end_time"].ToString();
info.Status = row["mstatus_name"].ToString();
info.CalledPID = row["p_name"].ToString();
lst.Add(info);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetMeetingInfoTable(ATTMeetingInfo info)
{
string SP = "select vw.org_id, vw.meeting_id,vw.mtype_name, vw.venue_name, vw.meeting_subject, vw.meeting_date, vw.group_name, vw.start_time, vw.end_time, vw.mstatus_name,vw.p_name from vw_meeting_info vw where 1=1 " + DLLMeetingInfo.GetFilterString(info);
try
{
return(SqlHelper.ExecuteDataset(CommandType.Text, SP, Module.OAS, new OracleParameter[0]).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
private static string GetFilterString(ATTMeetingInfo info)
{
string filter = "";
if (info.OrgID > 0)
{
filter += " and vw.org_id=" + info.OrgID.ToString();
}
if (info.FromDate != "")
{
filter += " and vw.meeting_date>='" + info.FromDate + "'";
}
if (info.ToDate != "")
{
filter += " and vw.meeting_date<='" + info.ToDate + "'";
}
if (int.Parse(info.CalledBy) > 0)
{
filter += " and vw.Called_by=" + info.CalledBy;
}
if (int.Parse(info.Venue) > 0)
{
filter += " and vw.venue_id=" + info.Venue;
}
if (int.Parse(info.Status) > 0)
{
filter += " and vw.status=" + info.Status;
}
if (int.Parse(info.MeetingTypeName) > 0)
{
filter += " and vw.mtype_id=" + info.MeetingTypeName;
}
return(filter);
}
