public List <BolumListModel> GetBolumListBySearchText(SearchTextModel SearchObj)
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(myConn))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "dbo.GetBolumListBySearchText";
cmd.CommandType = CommandType.StoredProcedure;
var tmpTX = "";
if (string.IsNullOrEmpty(SearchObj.TX) == true)
{
tmpTX = "";
}
else
{
tmpTX = SearchObj.TX;
}
SqlParameter parameter1 = cmd.Parameters.AddWithValue("@TxtFilter", tmpTX);
SqlParameter parameter2 = cmd.Parameters.AddWithValue("@PageNumber", SearchObj.PG - 1);
parameter1.SqlDbType = SqlDbType.VarChar;
parameter2.SqlDbType = SqlDbType.Int;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
}
}
return(ConvertToBolumListType(dt));
}
public void AddFirstNonDuplicate(SearchTextModel model)
{
if (SearchedTexts.Count == 0 || !SearchedTexts[0].Text.Equals(model.Text, StringComparison.OrdinalIgnoreCase))
{
SearchedTexts.Insert(0, model);
}
}
public JsonResult GetBolumListBySearchText(SearchTextModel SearchObj)
{
tercih t = new tercih();
return(Json(t.GetBolumListBySearchText(SearchObj), JsonRequestBehavior.AllowGet));
}
public void Remove(SearchTextModel model)
{
SearchedTexts.Remove(model);
}
