protected void SetrGridPlayerDS() { TradeDomainModel Trade = new TradeDomainModel(); Trade.SeasonID = Convert.ToInt32(rDDSeason.SelectedValue); rGridTrade.DataSource = TradeBLL.ListTrades(Trade); }
public List <TradeDataDomainModel> ListTrades(TradeDomainModel Trade) { //Create a return type Object List <TradeDataDomainModel> list = new List <TradeDataDomainModel>(); ////Create a Context object to Connect to the database //using (CSBAAzureEntities context = new CSBAAzureEntities()) //{ // list = (from result in context.sp_TradeData_Select(Trade.SeasonID, Trade.TradeGUID) // select new TradeDataDomainModel // { // ActionDate = result.ActionDate, // ProposedDate = result.ProposedDate, // SeasonID = result.SeasonID, // TeamID = result.TeamID, // TradeGUID = result.TradeGUID, // TradeStatusID = result.TradeStatusID, // TeamName = result.TeamName, // TradeStatusDesc = result.TradeStatusDesc // }).ToList(); //} // Guaranteed to close the Connection ////return the list return(list); }
public void UpdateTrade(TradeDomainModel Trade) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { var cTrade = context.Trades.Find(Trade.TradeGUID); if (cTrade != null) { cTrade.ActionDate = Trade.ActionDate; cTrade.ProposedDate = Trade.ProposedDate; cTrade.SeasonID = Trade.SeasonID; cTrade.TeamID = Trade.TeamID; cTrade.TradeGUID = Trade.TradeGUID; cTrade.TradeStatusID = Trade.TradeStatusID; context.SaveChanges(); } } #endregion }
public TradeDomainModel InsertTrade(TradeDomainModel Trade) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { var _cTrade = new Trade { ActionDate = Trade.ActionDate, ProposedDate = Trade.ProposedDate, SeasonID = Trade.SeasonID, TeamID = Trade.TeamID, TradeStatusID = Trade.TradeStatusID }; context.Trades.Add(_cTrade); context.SaveChanges(); // pass TeamID back to BLL Trade.TradeGUID = _cTrade.TradeGUID; return(Trade); } }
protected void rGridTrade_UpdIns(object sender, GridCommandEventArgs e, string Action) { try { GridEditableItem eeditedItem = e.Item as GridEditableItem; TradeDomainModel TradeDM = new TradeDomainModel(); if (Action == "Update") { TradeDM.TradeGUID = new Guid((eeditedItem.FindControl("lblTradeGUID") as Label).Text.ToString()); } TradeDM.SeasonID = Convert.ToInt32((eeditedItem.FindControl("rDDSeason") as RadDropDownList).SelectedValue.ToString()); RadCalendar rCal = (RadCalendar)eeditedItem.FindControl("rCALProposedDate"); TradeDM.ProposedDate = rCal.SelectedDate; TradeDM.TeamID = Convert.ToInt32((eeditedItem.FindControl("rDDTeam") as RadDropDownList).SelectedValue.ToString()); TradeDM.TradeStatusID = Convert.ToInt32((eeditedItem.FindControl("rDDTradeStatus") as RadDropDownList).SelectedValue.ToString()); if (Action == "Update") { TradeBLL.UpdateTrade(TradeDM); } else if (Action == "Insert") { TradeBLL.InsertTrade(TradeDM); } } 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 UpdateTrade(TradeDomainModel Trade) { DAL.UpdateTrade(Trade); }
public TradeDomainModel InsertTrade(TradeDomainModel Trade) { return(DAL.InsertTrade(Trade)); }
public List <TradeDataDomainModel> ListTrades(TradeDomainModel Trade) { return(DAL.ListTrades(Trade)); }