public void DeleteStadium(StadiumDomainModel stadium) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { var cStadium = (from n in context.Stadia where n.StadiumID == stadium.StadiumID select n).FirstOrDefault(); context.Stadia.Remove(cStadium); context.SaveChanges(); } }
public void UpdateStadium(StadiumDomainModel stadium) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { var cstadium = context.Stadia.Find(stadium.StadiumID); if (cstadium != null) { cstadium.StadiumName = stadium.StadiumName; cstadium.Active_Flg = stadium.Active_Flg; cstadium.StadiumImage = stadium.StadiumImage; context.SaveChanges(); } } }
public StadiumDomainModel InsertStadium(StadiumDomainModel stadium) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { var _cStadium = new Stadium { StadiumName = stadium.StadiumName, Active_Flg = stadium.Active_Flg, StadiumImage = stadium.StadiumImage }; context.Stadia.Add(_cStadium); context.SaveChanges(); // pass StadiumID back to BLL stadium.StadiumID = _cStadium.StadiumID; return(stadium); } }
public StadiumDomainModel InsertStadium(StadiumDomainModel stadium) { return(dal.InsertStadium(stadium)); }
public void ClearStadium(StadiumDomainModel StadiumID) { }