private void LoadSeasonTeamCombo()
{
var ds = SeasonTeamBLL.SeasonTeamOrder(Convert.ToInt32(rDDSeason.SelectedValue));
rDDSeasonTeam.Items.Clear();
rDDSeasonTeam.DataSource = ds;
rDDSeasonTeam.DataValueField = "TeamID";
rDDSeasonTeam.DataTextField = "TeamName";
rDDSeasonTeam.DataBind();
rDDMyPositionType.SelectedValue = ds.FirstOrDefault().TeamID.ToString();
}
protected void rGridTeam_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
//GridDataItem dataItem = e.Item as GridDataItem;
int fieldValue = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "Points").ToString());
totPointCount += fieldValue;
RadBinaryImage rPrimPos = (RadBinaryImage)e.Item.FindControl("imgPrimPositon");
RadBinaryImage rSecPos = (RadBinaryImage)e.Item.FindControl("imgSecPositon");
rPrimPos.ImageUrl = "~/Content/images/" + DataBinder.Eval(e.Item.DataItem, "PrimPos").ToString().Trim() + ".jpg";
if (DataBinder.Eval(e.Item.DataItem, "SecPos") != null)
{
rSecPos.ImageUrl = "~/Content/images/" + DataBinder.Eval(e.Item.DataItem, "SecPos").ToString().Trim() + ".jpg";
}
else
{
rSecPos.Visible = false;
}
}
if (e.Item is GridFooterItem)
{
GridFooterItem footerItem = e.Item as GridFooterItem;
footerItem["Points"].Text = "total: " + totPointCount.ToString();
}
else if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
GridEditableItem edtItem = (GridEditableItem)e.Item;
Label lblSeasonID = (Label)edtItem.FindControl("lblSeasonID");
Label lblTeamID = (Label)edtItem.FindControl("lblTeamID");
RadDropDownList rDDSeasonTeam = (RadDropDownList)edtItem.FindControl("rDDSeasonTeam");
rDDSeasonTeam.DataSource = SeasonTeamBLL.SeasonTeamOrder(Convert.ToInt32(lblSeasonID.Text));
rDDSeasonTeam.DataValueField = "TeamID";
rDDSeasonTeam.DataTextField = "TeamName";
rDDSeasonTeam.DataBind();
rDDSeasonTeam.SelectedValue = lblTeamID.Text.ToString();
}
}
protected void LoadrDDSeasonTeam()
{
// Manually load dropdown list
try
{
List <SeasonTeamDomainModel> ds = SeasonTeamBLL.SeasonTeamOrder(Convert.ToInt32(rDDSeason.SelectedValue)).OrderBy(o => o.TeamName).ToList();
rDDSeasonTeam.Items.Clear();
var itemRecycle = new DropDownListItem("Recycle Bin", "0");
rDDSeasonTeam.Items.Add(itemRecycle);
foreach (var element in ds)
{
var item = new DropDownListItem(element.TeamName.ToString(), element.TeamID.ToString());
if (CanTeamBid(element.SeasonID, element.TeamID, element.MaxBid))
{
item.Enabled = true;
}
else
{
item.Enabled = false;
item.BackColor = System.Drawing.Color.LightBlue;
}
rDDSeasonTeam.Items.Add(item);
}
}
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.
}
}
protected void rGridDraftPlayer_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "TestEmail")
{
try
{
string strFileName = CSBA.BusinessLogicLayer.Logic.cExcel.CreateSpreadsheet(1031);
Attachment att = new Attachment(strFileName);
cMail.SendMessage("*****@*****.**", "*****@*****.**", "CSBA Test Email", "Test Body", strFileName, att);
}
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.
}
}
if (e.CommandName == "CreateSpreadsheets")
{
List <SeasonDomainModel> Seasons = new List <SeasonDomainModel>();
TeamBusinessLogicLayer TeamBLL = new TeamBusinessLogicLayer();
SeasonTeamBusinessLogic SeasonTeamBLL = new SeasonTeamBusinessLogic();
Seasons = SeasonBLL.ListSeason();
int SeasonID = 0;
foreach (SeasonDomainModel season in Seasons)
{
if (season.CurrentSeason == true)
{
SeasonID = season.SeasonID;
break;
}
}
Excel.Application myApp = new Excel.Application();
myApp.Visible = true;
Excel.Workbook wb = myApp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
List <SeasonTeamDomainModel> listSeasonTeam = SeasonTeamBLL.SeasonTeamOrder(SeasonID);
foreach (SeasonTeamDomainModel st in listSeasonTeam)
{
Excel.Worksheet ws = (Excel.Worksheet)wb.Worksheets.Add();
ws.Name = st.TeamName.Trim();
List <v_Team_Draft_RosterDomainModel> ListTeam = TeamBLL.ListTeamRoster(SeasonID, st.TeamID);
int iRow = 1;
ws.Cells[iRow, 1] = "Primary Position";
ws.Cells[iRow, 2] = "Secondary Position";
ws.Cells[iRow, 3] = "Player Name";
ws.Cells[iRow, 4] = "Points";
iRow++;
foreach (v_Team_Draft_RosterDomainModel TDraft in ListTeam)
{
ws.Cells[iRow, 1] = TDraft.PrimPos.Trim();
if (TDraft.SecPos != null)
{
ws.Cells[iRow, 2] = TDraft.SecPos.Trim();
}
ws.Cells[iRow, 3] = TDraft.PlayerName.Trim();
ws.Cells[iRow, 4] = TDraft.Points;
iRow++;
}
}
}
if (e.CommandName == "EmailRosters")
{
string strFileName = CSBA.BusinessLogicLayer.Logic.cExcel.CreateSpreadsheet(Convert.ToInt32(rDDSeason.SelectedValue));
foreach (GridDataItem item in rGridDraftPlayer.Items)
{
try
{
StringBuilder sb = new StringBuilder();
TeamBusinessLogicLayer TeamBLL = new TeamBusinessLogicLayer();
RadButton rBTNTeamName = (RadButton)item.FindControl("rBTNTeamName");
Label lblOwnerEmail = (Label)item.FindControl("lblOwnerEmail");
Label lblTeamID = (Label)item.FindControl("lblTeamID");
List <v_Team_Draft_RosterDomainModel> TeamDraft = TeamBLL.ListTeamRoster(Convert.ToInt32(rDDSeason.SelectedValue), Convert.ToInt32(lblTeamID.Text));
sb.Append("<table><p class=border>");
sb.Append("<tr>");
sb.Append("<td><b><p class=border>");
sb.Append("Player Name");
sb.Append("</b></td>");
sb.Append("<td><b><p class=border>");
sb.Append("Primary Position ");
sb.Append("</b></td>");
sb.Append("<td><b><p class=border>");
sb.Append("Secondary Position ");
sb.Append("</b></td>");
sb.Append("<td><b><p class=border>");
sb.Append("Points ");
sb.Append("</b></td>");
foreach (v_Team_Draft_RosterDomainModel TeamPlayer in TeamDraft)
{
sb.Append("<tr>");
sb.Append("<td>");
sb.Append("<div align=left><p class=border>");
sb.Append(TeamPlayer.PlayerName.Trim());
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<div align=left><p class=border>");
sb.Append(TeamPlayer.PrimPos.Trim());
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<div align=left><p class=border>");
if (TeamPlayer.SecPos == null)
{
sb.Append("n/a");
}
else
{
sb.Append(TeamPlayer.SecPos.Trim());
}
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<div align=right><p class=border>");
sb.Append(TeamPlayer.Points.ToString().Trim());
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("</table>");
string[,] MergeValues = new string[, ] {
{ "{TeamName}", rBTNTeamName.Text.Trim() }, { "{TeamRoster}", sb.ToString() }
};
//Attachment att = null;// = new Attachment(strFileName);
if (strFileName != null)
{
Attachment att = new System.Net.Mail.Attachment(strFileName, System.Net.Mime.MediaTypeNames.Application.Octet);
ContentDisposition disposition = att.ContentDisposition;
disposition.CreationDate = File.GetCreationTime(strFileName);
disposition.ModificationDate = File.GetLastWriteTime(strFileName);
disposition.ReadDate = File.GetLastAccessTime(strFileName);
disposition.FileName = Path.GetFileName(strFileName.Trim());
disposition.Size = new FileInfo(strFileName).Length;
disposition.DispositionType = DispositionTypeNames.Attachment;
cMail.SendMessage("*****@*****.**", lblOwnerEmail.Text.ToString().Trim(), "CSBA Roster", cMail.PopulateBody("~/Content/EmailTemplates/DraftRoster.html", MergeValues), strFileName, att);
}
}
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.
}
}
}
}