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