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