public MainCatogoryViewModel SearchMainAssests(MainCatogoryViewModel model)
{
PetaPoco.Database db = null;
var dbConn = DataContext.Database.Connection;
MainCatogoryViewModel assestDetails = new MainCatogoryViewModel();
try
{
using (DataContext)
{
dbConn.Open();
db = new PetaPoco.Database(dbConn);
db.EnableAutoSelect = false;
assestDetails.MainAssestsList = db.Query <MainCatogory>("exec usp_SearchMainAssests " + "@MCName,@MCSymbol",
new { MCName = model.MCName, MCSymbol = model.MCSymbol }).ToList();
dbConn.Close();
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (dbConn != null)
{
dbConn.Close();
}
}
return(assestDetails);
}
public ActionResult SearchMainAssests(MainCatogoryViewModel mainAssestsModel)
{
UserService service = new UserService();
mainAssestsModel = service.SearchMainAssests(mainAssestsModel);
return(PartialView("_MainCategoryGrid", mainAssestsModel.MainAssestsList));
}
public ActionResult ManageMainAssests(MainCatogoryViewModel mainAssestsModel)
{
UserService service = new UserService();
//ViewBag.Divisions = new SelectList(AllDivisions(), "Value", "Text");
mainAssestsModel = service.SearchMainAssests(mainAssestsModel);
if (Request.IsAjaxRequest())
{
return(PartialView("_MainCategoryGrid", mainAssestsModel.MainAssestsList));
}
return(View("ManageMainAssests", mainAssestsModel));
}
public MainCatogoryViewModel SearchMainAssests(MainCatogoryViewModel model)
{
MainCatogoryViewModel assestDetails = new MainCatogoryViewModel();
try
{
assestDetails = _repository.SearchMainAssests(model);
}
catch (Exception ex)
{
throw;
}
return(assestDetails);
}
