/// <summary> /// Method to search tributes based on the entered criteria. /// </summary> /// <param name="objTribute">TributeSearch entity containing search criteria.</param> /// <returns>List of Tributes.</returns> public List<TributeSearch> SearchTributes(TributeSearch objTribute) { return FacadeManager.TributeManager.SearchTribute(objTribute); }
/// <summary> /// Method to get the search tributes based on the entered criteria. /// </summary> /// <param name="objTribute">Filled TributeSearch entity containing search criteria.</param> /// <returns>List of tributes.</returns> public List<TributeSearch> SearchTributes(object[] objTribute) { List<TributeSearch> objTributeList = new List<TributeSearch>(); TributeSearch objTrib = (TributeSearch)objTribute[0]; object[] objParam = {objTrib.SearchTributeId, objTrib.TributeName, objTrib.UserName, objTrib.SearchUserId, objTrib.City, objTrib.State, objTrib.Country, objTrib.TypeDescription, objTrib.TributeStatus, objTrib.CreatedAfter, objTrib.CreatedBefore, objTrib.PurchasedAfter, objTrib.PurchasedBefore,objTrib.ApplicationType}; DataSet dsTributes = GetDataSet("usp_SearchTribute", objParam); if (dsTributes.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsTributes.Tables[0].Rows) { TributeSearch obj = new TributeSearch(); //add data to tribute object //Tributes objTributes = new Tributes(); obj.TributeId = int.Parse(dr["TributeId"].ToString()); obj.TributeName = dr["TributeName"].ToString(); obj.City = dr["City"].ToString(); obj.TypeDescription = dr["TributeTypeName"].ToString(); obj.CreatedDate = DateTime.Parse(dr["CreatedDate"].ToString()); obj.CreationDate = DateTime.Parse(dr["CreatedDate"].ToString()).ToString("MMMM dd, yyyy"); //set tribute entity to TributeSearch.Tributes //obj.Tributes = objTributes; //set tribute serach entity obj.StateName = dr["StateName"].ToString(); obj.CountryName = dr["CountryName"].ToString(); obj.TributeStatus = dr["TributeStatus"].ToString(); obj.EndDate = dr["EndDate"].ToString() == string.Empty ? string.Empty : DateTime.Parse(dr["EndDate"].ToString()).ToString("MMMM dd, yyyy"); obj.IsActive = bool.Parse(dr["IsActive"].ToString()); //set usertributeId ---03-Feb-09---- ANKI obj.UserTributeId = int.Parse(dr["CreatedBy"].ToString()); obj.TributeUrl = dr["TributeUrl"].ToString(); //add data to list objTributeList.Add(obj); //objTributes = null; obj = null; } } return objTributeList; }
private TributeSearch GetTributeObject() { TributeSearch objTribute = new TributeSearch(); //Tributes objTrib = new Tributes(); objTribute.TributeName = txtTributeName.Text.Replace("?", "_").Replace("*", "%").Trim(); objTribute.City = txtCity.Text.Replace("?", "_").Replace("*", "%").Trim(); objTribute.State = int.Parse(ddlStateProvince.SelectedValue); objTribute.Country = int.Parse(ddlCountry.SelectedValue); //to get selected tribute types string selTypes = string.Empty; for (int i = 0; i < chklstTypes.Items.Count; i++) { if (chklstTypes.Items[i].Selected) { selTypes = selTypes + chklstTypes.Items[i].Value + ","; } } if (!Equals(selTypes, string.Empty)) objTribute.TypeDescription = selTypes.Remove(selTypes.LastIndexOf(",")); //to set values to tribute in tributesearch entity //objTribute.Tributes = objTrib; objTribute.SearchTributeId = txtTributeId.Text.Trim(); objTribute.UserName = txtUserName.Text.Trim(); objTribute.SearchUserId = txtUserId.Text.Trim(); objTribute.ApplicationType = ConfigurationManager.AppSettings["ApplicationType"].ToString().ToLower(); //to get selected tribute status string selStatus = string.Empty; for (int i = 0; i < chklstStatus.Items.Count; i++) { if (chklstStatus.Items[i].Selected) { if (i == 3) chklstStatus.Items[i].Value = "0"; selStatus = selStatus + chklstStatus.Items[i].Value+ ","; } } if (chklstStatus.Items[0].Selected) { selStatus = selStatus + "8,"; } if (chklstStatus.Items[1].Selected) { selStatus = selStatus + "5,7,"; } if (chklstStatus.Items[2].Selected) { selStatus = selStatus + "4,6,"; } if (!Equals(selStatus, string.Empty)) objTribute.TributeStatus = selStatus.Remove(selStatus.LastIndexOf(",")); if (drpBeforeDay.SelectedValue != string.Empty && drpBeforeMonth.SelectedValue != string.Empty && txtBeforeYear.Text != string.Empty) objTribute.CreatedBefore = DateTime.Parse(drpBeforeMonth.SelectedValue + "/" + drpBeforeDay.SelectedValue + "/" + txtBeforeYear.Text); if (drpAfterDay.SelectedValue != string.Empty && drpAfterMonth.SelectedValue != string.Empty && txtAfterYear.Text != string.Empty) objTribute.CreatedAfter = DateTime.Parse(drpAfterMonth.SelectedValue + "/" + drpAfterDay.SelectedValue + "/" + txtAfterYear.Text); if (drpPurchasedBeforeDay.SelectedValue != string.Empty && drpPurchasedBeforeMonth.SelectedValue != string.Empty && txtPurchasedBeforeYear.Text != string.Empty) objTribute.PurchasedBefore = DateTime.Parse(drpPurchasedBeforeMonth.SelectedValue + "/" + drpPurchasedBeforeDay.SelectedValue + "/" + txtPurchasedBeforeYear.Text); if (drpPurchasedAfterDay.SelectedValue != string.Empty && drpPurchasedAfterMonth.SelectedValue != string.Empty && txtPurchasedAfterYear.Text != string.Empty) objTribute.PurchasedAfter = DateTime.Parse(drpPurchasedAfterMonth.SelectedValue + "/" + drpPurchasedAfterDay.SelectedValue + "/" + txtPurchasedAfterYear.Text); return objTribute; }
/// <summary> /// Method to search tributes based on the entered criteria. /// </summary> /// <param name="objTribute">Filled TributeSearch entity containing search criteria.</param> /// <returns>List of tributes.</returns> public List<TributeSearch> SearchTribute(TributeSearch objTribute) { TributeResource objTributeResource = new TributeResource(); object[] objParam = { objTribute }; return objTributeResource.SearchTributes(objParam); }