public JsonResult GetBolumList(FilterObjModel FilterObj) { try { tercih t = new tercih(); return(Json(t.GetBolumList(FilterObj), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { dbOp dbOp = new dbOp(); dbOp.errLog("Home", "GetBolumList", ex.Source, ex.Message); return(Json(new { Result = false })); } }
public List <TercihListModel> GetBolumList(FilterObjModel FilterObj) //Tercih listesiyle aynı data model kullanıldı!!! { DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(myConn)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "dbo.GetBolumListByFilter"; cmd.CommandType = CommandType.StoredProcedure; var tmpTX = ""; if (string.IsNullOrEmpty(FilterObj.TX) == true) { tmpTX = ""; } else { tmpTX = FilterObj.TX; } SqlParameter parameter1 = cmd.Parameters.AddWithValue("@DVFilter", CreateDataTable(FilterObj, "DV")); SqlParameter parameter2 = cmd.Parameters.AddWithValue("@PTFilter", CreateDataTable(FilterObj, "PT")); SqlParameter parameter3 = cmd.Parameters.AddWithValue("@SHFilter", CreateDataTable(FilterObj, "SH")); SqlParameter parameter4 = cmd.Parameters.AddWithValue("@TxtFilter", tmpTX); SqlParameter parameter5 = cmd.Parameters.AddWithValue("@PageNumber", FilterObj.PG - 1); parameter1.SqlDbType = SqlDbType.Structured; parameter1.TypeName = "dbo.IDType"; parameter2.SqlDbType = SqlDbType.Structured; parameter2.TypeName = "dbo.IDType"; parameter3.SqlDbType = SqlDbType.Structured; parameter3.TypeName = "dbo.IDType"; parameter4.SqlDbType = SqlDbType.VarChar; parameter5.SqlDbType = SqlDbType.Int; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } } } return(ConvertToTercihListType(dt)); }
private DataTable CreateDataTable(FilterObjModel FilterObj, string Tip) { DataTable dt = new DataTable(); dt.Columns.Add("Id", typeof(System.Int32)); switch (Tip) { case "DV": foreach (var obj in FilterObj.DV) { DataRow dr = dt.NewRow(); dr["Id"] = obj.Id; dt.Rows.Add(dr); } break; case "PT": foreach (var obj in FilterObj.PT) { DataRow dr = dt.NewRow(); dr["Id"] = obj.Id; dt.Rows.Add(dr); } break; case "SH": foreach (var obj in FilterObj.SH) { DataRow dr = dt.NewRow(); dr["Id"] = obj.Id; dt.Rows.Add(dr); } break; } return(dt); }