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