protected void rBTNSaveChanges_Click(object sender, EventArgs e) { SeasonPlayerDomainModel _SeasonPlayer = new SeasonPlayerDomainModel(); _SeasonPlayer.SeasonID = (Convert.ToInt32(rDDSeason.SelectedValue)); PositionDomainModel _Position = new PositionDomainModel(); _Position.PositionID = (Convert.ToInt16(rDDPosition.SelectedValue)); SPBLL.DeleteSeasonPlayerAll(_SeasonPlayer, _Position); int iStOrder = 1; foreach (RadListBoxItem item in rLBPlayerSelected.Items) { SeasonPlayerDomainModel _SPNew = new SeasonPlayerDomainModel(); _SPNew.SeasonID = Convert.ToInt32(rDDSeason.SelectedValue); _SPNew.PlayerGUID = new Guid(item.Value.ToString()); iStOrder += 1; SPBLL.InsertSeasonPlayer(_SPNew); } SetupListBoxes(); }
public void DeleteSeasonPlayerAll(SeasonPlayerDomainModel _SeasonPlayer, PositionDomainModel _Position) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { context.Database.ExecuteSqlCommand("sp_SeasonPlayer_deleteAll {0}, {1}", _SeasonPlayer.SeasonID, _Position.PositionID); } }
protected void rGridPosition_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { try { PositionDomainModel PosDM = new PositionDomainModel(); GridEditableItem eeditedItem = e.Item as GridEditableItem; PosDM.PositionID = Convert.ToInt32((eeditedItem.FindControl("lblPositionID") as Label).Text.ToString()); PosDM.PositionTypeID = Convert.ToInt32((eeditedItem.FindControl("lblPositionTypeID") as Label).Text.ToString()); PosDM.PositionName = (eeditedItem.FindControl("lblPositionName") as Label).Text.ToString().Trim(); PosDM.PositionNameLong = (eeditedItem.FindControl("rTXTPositionNameLong") as RadTextBox).Text.ToString().Trim(); PosDM.MaxCount = Convert.ToInt32((eeditedItem.FindControl("rNTBMaxCount") as RadNumericTextBox).Value); PosBLL.UpdatePosition(PosDM); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL Response.Redirect(url); // Go to the error page. } }
public void DeletePosition(PositionDomainModel position) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { var cPosition = (from n in context.Positions where n.PositionID == position.PositionID select n).FirstOrDefault(); context.Positions.Remove(cPosition); context.SaveChanges(); } }
public void UpdatePosition(PositionDomainModel position) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { var cPosition = context.Positions.Find(position.PositionID); if (cPosition != null) { cPosition.PositionName = position.PositionName; cPosition.MaxCount = position.MaxCount; cPosition.PositionNameLong = position.PositionNameLong; context.SaveChanges(); } } }
public PositionDomainModel InsertPosition(PositionDomainModel position) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { var _cPosition = new Position { MaxCount = position.MaxCount, PositionName = position.PositionName, PositionNameLong = position.PositionNameLong, PositionTypeID = position.PositionTypeID }; context.Positions.Add(_cPosition); context.SaveChanges(); // pass TeamID back to BLL position.PositionID = _cPosition.PositionID; return(position); } }
public void DeleteSeasonPlayerAll(SeasonPlayerDomainModel _SeasonPlayer, PositionDomainModel _Position) { SPDAL.DeleteSeasonPlayerAll(_SeasonPlayer, _Position); }
public void DeletePosition(PositionDomainModel position) { DAL.DeletePosition(position); }
public void UpdatePosition(PositionDomainModel position) { DAL.UpdatePosition(position); }
public PositionDomainModel InsertPosition(PositionDomainModel position) { return(DAL.InsertPosition(position)); }