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