public SubCatogoryViewModel SearchSubAssests(SubCatogoryViewModel model)
{
PetaPoco.Database db = null;
var dbConn = DataContext.Database.Connection;
SubCatogoryViewModel assestDetails = new SubCatogoryViewModel();
try
{
using (DataContext)
{
dbConn.Open();
db = new PetaPoco.Database(dbConn);
db.EnableAutoSelect = false;
assestDetails.SubAssestsList = db.Query <SubCatogory>("exec usp_SearchSubAssests " + "@MCId,@SCName,@SCSymbol",
new { MCId = model.MCId, SCName = model.SCName, SCSymbol = model.SCSymbol }).ToList();
dbConn.Close();
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (dbConn != null)
{
dbConn.Close();
}
}
return(assestDetails);
}
public ActionResult SearchSubAssests(SubCatogoryViewModel AssestsModel)
{
UserService service = new UserService();
AssestsModel = service.SearchSubAssests(AssestsModel);
return(PartialView("_SubCategoryGrid", AssestsModel.SubAssestsList));
}
public ActionResult ManageSubAssests(SubCatogoryViewModel AssestsModel)
{
UserService service = new UserService();
ViewBag.MainAssests = new SelectList(AllMainAssests(), "Value", "Text");
AssestsModel = service.SearchSubAssests(AssestsModel);
if (Request.IsAjaxRequest())
{
return(PartialView("_SubCategoryGrid", AssestsModel.SubAssestsList));
}
return(View("ManageSubAssests", AssestsModel));
}
public SubCatogoryViewModel SearchSubAssests(SubCatogoryViewModel model)
{
SubCatogoryViewModel assestDetails = new SubCatogoryViewModel();
try
{
assestDetails = _repository.SearchSubAssests(model);
}
catch (Exception ex)
{
throw;
}
return(assestDetails);
}
