protected void btnSearch_Click(object sender, EventArgs e)
{
lblError.Text = "";
if (txtAdvSearch.Text.Trim() == "" && dtpFromDate.SelectedDate.ToString() == "" && dtpToDate.SelectedDate.ToString() == "")
{
lblError.Text = "Atleast one criteria need to entered for search";
}
else
{
EBirdUtility objUtil = new EBirdUtility();
EBErrorMessages objError = new EBErrorMessages();
string dt1 = "", dt2 = "";
string errMsg = "";
if (dtpFromDate.SelectedDate.ToString() != "")
dt1 = objUtil.FormDBDate(Convert.ToDateTime(dtpFromDate.SelectedDate));
if (dtpToDate.SelectedDate.ToString() != "")
dt2 = objUtil.FormDBDate(Convert.ToDateTime(dtpToDate.SelectedDate));
if (dt1 != "" && dt2 != "")
{
TimeSpan span = (Convert.ToDateTime(dtpToDate.SelectedDate)).Subtract(Convert.ToDateTime(dtpFromDate.SelectedDate));
if (span.Days < 0)
errMsg = objError.getMessage("SS0002");
}
if (errMsg != "")
lblError.Text = errMsg;
else
{
Session["ADV_SEARCH"] = txtAdvSearch.Text.Trim() + ";" + optSearchOption.SelectedValue + ";" + dtpFromDate.SelectedDate.ToString() + ";" + dtpToDate.SelectedDate.ToString();
hModalStatusFlg.Value = "1";
}
}
}
// 2/19/2013 - renamed the method to get my webinar for adv search
// sqlGetMyCompanyWebinar -> sqlGetMyWebinar, clientID -> userID
public List<WebinarBE> GetMyWebinarAdvSearchListDA(int userID, string fromDate, string toDate, string webinarTitle, string advFilter)
{
EBirdUtility objUtil = new EBirdUtility();
bool isAdvFilter = false;
string advTitle = string.Empty;
string advFieldSearch = string.Empty;
string advStDate = string.Empty;
string advEnDate = string.Empty;
string sql2 = string.Empty;
if (advFilter.Trim() != "")
{
ArrayList arr1 = objUtil.StringToArrayList(advFilter, new char[] { ';' });
if (arr1.Count == 4)
{
isAdvFilter = true;
advTitle = arr1[0].ToString();
advFieldSearch = arr1[1].ToString();
advStDate = arr1[2].ToString();
advEnDate = arr1[3].ToString();
if (advTitle != "")
{
switch (advFieldSearch.ToUpper())
{
case "TITLE":
sql2 += "webinarTitle like '%" + advTitle + "%'";
break;
case "DESCRIPTION":
sql2 += "description like '%" + advTitle + "%'";
break;
case "ALL":
sql2 += "webinarTitle like '%" + advTitle + "%' or description like '%" + advTitle + "%'";
break;
}
}
if (advStDate != "" && fromDate != "")
{
advStDate = objUtil.FormDBDate(Convert.ToDateTime(advStDate));
TimeSpan span = (Convert.ToDateTime(fromDate)).Subtract(Convert.ToDateTime(advStDate));
if (span.Days < 0)
{
fromDate = advStDate;
}
}
if (advEnDate != "" && toDate != "")
{
advEnDate = objUtil.FormDBDate(Convert.ToDateTime(advEnDate));
TimeSpan span1 = (Convert.ToDateTime(advEnDate)).Subtract(Convert.ToDateTime(toDate));
if (span1.Days < 0)
{
toDate = advEnDate;
}
}
}
}
string sql1 = DBQuery.sqlGetMyWebinar;
if (webinarTitle != "")
sql1 += " and webinarTitle like '%" + webinarTitle + "%'";
if (fromDate != "" && toDate != "")
sql1 += " and startDate BETWEEN '" + fromDate + "' AND '" + toDate + "'";
else if (fromDate == "" && toDate != "")
sql1 += " and createdOn <= '" + toDate + "'";
else if (toDate == "" && fromDate != "")
sql1 += " and startDate >= '" + fromDate + "'";
if (sql2 != string.Empty)
{
sql1 += " and (" + sql2 + ")";
}
List<WebinarBE> objWebinarBE = new List<WebinarBE>();
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
using (MySqlCommand sqlCmd = new MySqlCommand(sql1, sqlCon))
{
sqlCon.Open();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Parameters.Add(new MySqlParameter("@createdBy", userID));
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
objWebinarBE.Add(new WebinarBE
{
//ClientID = clientID,
WebinarID = reader["WebinarID"] == DBNull.Value ? -1 : Convert.ToInt32(reader["WebinarID"]),
Title = reader["webinartitle"] == DBNull.Value ? string.Empty : Convert.ToString(reader["webinartitle"]),
Description = reader["description"] == DBNull.Value ? string.Empty : Convert.ToString(reader["description"]),
StartDate = reader["startdate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(reader["startdate"]),
StartTime = reader["starttime"] == DBNull.Value ? string.Empty : reader["starttime"].ToString(),
EndTime = reader["endTime"] == DBNull.Value ? string.Empty : reader["endTime"].ToString(),
TimeZoneID = reader["TimeZoneID"] == DBNull.Value ? -1 : Convert.ToInt32(reader["TimeZoneID"]),
isRecurrence = reader["recurrence"] == DBNull.Value ? false : Convert.ToBoolean(reader["recurrence"]),
Registered = reader["registered"] == DBNull.Value ? 0 : Convert.ToInt32(reader["registered"]),
Live = reader["live"] == DBNull.Value ? 0 : Convert.ToInt32(reader["live"]),
OnDemand = reader["OnDemand"] == DBNull.Value ? 0 : Convert.ToInt32(reader["OnDemand"]),
Createdby = reader["Createdby"] == DBNull.Value ? -1 : Convert.ToInt32(reader["Createdby"]),
CreatedOn = reader["CreatedOn"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(reader["CreatedOn"]),
ModifiedOn = reader["ModifiedOn"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(reader["ModifiedOn"]),
Modifiedby = reader["Modifiedby"] == DBNull.Value ? -1 : Convert.ToInt32(reader["Modifiedby"]),
WebinarStatus = reader["webinarStatus"] == DBNull.Value ? string.Empty : Convert.ToString(reader["webinarStatus"])
});
}
}
reader.Close();
reader = null;
}
sqlCon.Close();
}
}
catch (Exception ex)
{
throw;
}
return objWebinarBE;
}
