public ActionResult Normal_search(drug_active_name_serach model)
{
Session.Abandon();
ViewBag.serchFor = model.name;
if (model.name != null)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
//drug-data
//Each Single Data for The Drug Will Be Returned Here In Var data
SqlParameter[] par_active = new SqlParameter[] {
new SqlParameter("@name", model.name)
};
var data = db.Database.SqlQuery <drug_serach_result>("normal_search @name", par_active).ToList();
List <side_effect> effect = new List <side_effect>();
List <drug_trade_search_name> actives = new List <drug_trade_search_name>();
//side_effect
//Each Side Effect For The Drug Will Be Returned Here In Var effect
SqlParameter[] par_effect = new SqlParameter[] {
new SqlParameter("@name", model.name)
};
effect = db.Database.SqlQuery <side_effect>("side_effects @name", par_effect).ToList();
//find If The Enterd Name is a Trade Name Or Not ... If Data Retured In The actives Var Then It Is A Trade Name
SqlParameter[] par_actives = new SqlParameter[] {
new SqlParameter("@name", model.name)
};
actives = db.Database.SqlQuery <drug_trade_search_name>("get_active_for_trade @name", par_actives).ToList();
var result = new drug_serach_result_finsh()
{
active_name_for_trade = actives,
drug = data,
side_effect = effect,
};
return(View(result));
}
}
return(View());
}
public ActionResult LoadData(drug_active_name_serach model)
{
try
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
ApplicationDbContext db = new ApplicationDbContext();
SqlParameter[] par_trade = new SqlParameter[] {
new SqlParameter("@name", model.name)
};
var trade = db.Database.SqlQuery <drug_trade_name>("trad_names @name", par_trade).ToList();
//Search
if (!string.IsNullOrEmpty(searchValue))
{
trade = trade.Where(m => (m.trade_name.Contains(searchValue)) || (m.Manufacturer_company.Contains(searchValue))).ToList();
}
//total number of rows count
recordsTotal = trade.Count();
//Paging
var data = trade.Skip(skip).Take(pageSize).ToList();
//Returning Json Data
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
catch (Exception)
{
throw;
}
}