public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TerritoryBattlePhase territoryBattlePhase = db.TerritoryBattlePhases.Include(x => x.PhaseTerritories).SingleOrDefault(x => x.Id == id);
if (territoryBattlePhase == null)
{
return(HttpNotFound());
}
TerritoryBattlePhaseModel model = Mapper.Map <TerritoryBattlePhase, TerritoryBattlePhaseModel>(territoryBattlePhase);
return(View(model));
}
public virtual ActionResult PlatoonCharacters(DataSourceRequest command, TerritoryBattlePhaseModel model)
{
var gridModel = new DataSourceResult();
DataSet ds = new DataSet("Counts");
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SwgohDb"].ConnectionString))
{
SqlCommand sqlComm = new SqlCommand("sp_RequiredPlatoonCharacters", conn);
sqlComm.Parameters.AddWithValue("@phaseGuid", model.Id);
sqlComm.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = sqlComm;
da.Fill(ds);
gridModel.Data = ds.Tables[0].AsEnumerable().Select(
dataRow => new CharCount
{
Id = dataRow.Field <Guid>("Character_Id"),
Name = dataRow.Field <string>("Name"),
Alignment = dataRow.Field <string>("Alignment"),
OneStarCount = dataRow.Field <int>("OneStarCount"),
TwoStarCount = dataRow.Field <int>("TwoStarCount"),
ThreeStarCount = dataRow.Field <int>("ThreeStarCount"),
FourStarCount = dataRow.Field <int>("FourStarCount"),
FiveStarCount = dataRow.Field <int>("FiveStarCount"),
SixStarCount = dataRow.Field <int>("SixStarCount"),
SevenStarCount = dataRow.Field <int>("SevenStarCount"),
}).AsEnumerable().OrderBy(x => x.Name);
gridModel.Total = ds.Tables[0].AsEnumerable().Count();
}
return(Json(gridModel));
}
