public void UpdateTeam(TeamDomainModel payload)
{
var currentTeam = _teamRepository.GetById(payload.Id);
if (currentTeam != null)
{
using (var scope = new TransactionScope())
{
currentTeam.Name = payload.Name;
currentTeam.IsActive = payload.IsActive;
currentTeam.GameId = payload.GameId;
if (payload.ImageData != null)
{
if (currentTeam.TeamLogoId != null)
{
_imageRepository.DeleteImageById(currentTeam.TeamLogoId.GetValueOrDefault());
}
var newImage = new Core.Entities.Image()
{
Guid = Guid.NewGuid(),
ImageData = payload.ImageData,
CreatedDate = new DateTime()
};
_imageRepository.Insert(newImage);
_imageRepository.Save();
currentTeam.TeamLogoId = newImage.Guid;
}
_teamRepository.Save();
scope.Complete();
}
}
}
public Guid CreateNewTeam(TeamDomainModel payload)
{
var newTeam = AutoMapper.Mapper.Map <Team>(payload);
var teamImage = Guid.NewGuid();
using (var scope = new TransactionScope())
{
if (payload.ImageData != null)
{
var newImage = new Core.Entities.Image()
{
Guid = Guid.NewGuid(),
ImageData = payload.ImageData,
CreatedDate = new DateTime()
};
_imageRepository.Insert(newImage);
_imageRepository.Save();
newTeam.TeamLogoId = teamImage;
}
_teamRepository.Insert(newTeam);
_teamRepository.Save();
scope.Complete();
}
return(newTeam.Id);
}
protected void rGridTeam_UpdIns(object sender, GridCommandEventArgs e, string Action)
{
try
{
GridEditableItem eeditedItem = e.Item as GridEditableItem;
TeamDomainModel TeamDM = new TeamDomainModel();
if (Action == "Update")
{
TeamDM.TeamID = Convert.ToInt32((eeditedItem.FindControl("lblTeamID") as Label).Text.ToString());
}
TeamDM.TeamName = (eeditedItem.FindControl("rTBTeamName") as RadTextBox).Text.Trim();
TeamDM.OwnerName = (eeditedItem.FindControl("rTBOwnerName") as RadTextBox).Text.Trim();
TeamDM.OwnerUserID = new Guid((eeditedItem.FindControl("rDDUserName") as RadDropDownList).SelectedValue.ToString());
TeamDM.OwnerEmail = (eeditedItem.FindControl("rTBOwnerEmail") as RadTextBox).Text.Trim();
var aUpload = (eeditedItem.FindControl("AsyncUpload1") as RadAsyncUpload);
if (aUpload.UploadedFiles.Count > 0)
{
EditableImage img = new EditableImage((MemoryStream)Context.Cache.Get(Session.SessionID + "UploadedFile"));
MemoryStream s = new MemoryStream();
img.Image.Save(s, img.RawFormat);
byte[] imgData = s.ToArray();
TeamDM.TeamImage = imgData;
}
else
{
TeamDM.TeamImage = null;
}
if (Action == "Update")
{
TeamBLL.UpdateTeam(TeamDM);
}
else if (Action == "Insert")
{
TeamBLL.InsertTeam(TeamDM);
}
//rGridPlayer.Rebind();
}
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 ActionResult GetTeam(int teamId)
{
TeamDomainModel dm = teamBusiness.getTeam(teamId);
TeamViewModel vm = new TeamViewModel();
AutoMapper.Mapper.Map(dm, vm);
ViewBag.teamId = teamId;
return(PartialView("EditTeamPartial", vm));
}
public string AddEditTeam(TeamViewModel vm)
{
string result = "";
TeamDomainModel dm = new TeamDomainModel();
AutoMapper.Mapper.Map(vm, dm);
result = result + " " + teamBusiness.AddUpdateTeam(dm);
return(result);
}
private void LoadMyTeam()
{
TeamBusinessLogicLayer TeamBLL = new TeamBusinessLogicLayer();
TeamDomainModel Team = new TeamDomainModel();
Guid OwnerUserID = new Guid(Session["UserID_GUID"].ToString());
Team = TeamBLL.ListTeam(OwnerUserID);
int SeasonID = Convert.ToInt32(rDDSeason.SelectedValue);
getTeamRoster(rDLMyTeam, rDZMyTeam, SeasonID, Team.TeamID, rDDMyPositionType);
}
public void UpdateTeam(TeamDomainModel team)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var cTeam = context.Teams.Find(team.TeamID);
if (cTeam != null)
{
cTeam.OwnerEmail = team.OwnerEmail;
cTeam.OwnerName = team.OwnerName;
cTeam.OwnerUserID = team.OwnerUserID;
cTeam.TeamName = team.TeamName;
cTeam.TeamImage = team.TeamImage;
context.SaveChanges();
}
}
}
public TeamDomainModel getTeam(int teamId)
{
Teams team = teamRepository.SingleOrDefault(m => m.teamId == teamId);
TeamDomainModel result = new TeamDomainModel();
result.teamId = team.teamId;
result.teamName = team.teamName;
result.gamePlayed = team.gamePlayed;
result.win = team.win;
result.lose = team.lose;
result.draw = team.draw;
result.goalAgainst = team.goalAgainst;
result.goalDifference = team.goalDifference;
result.point = team.point;
return(result);
}
public string AddUpdateTeam(int teamId)
{
TeamDomainModel teamDM = getTeam(teamId);
string result = "";
//if (teamDM.teamId > 0) // Edit Player
//{
// Teams team = teamRepository.SingleOrDefault(x => x.teamId == teamId);
// if (team != null)
// {
// team.teamName = dm.teamName;
// team.gamePlayed = dm.gamePlayed;
// team.win = dm.win;
// team.lose = dm.lose;
// team.draw = dm.draw;
// team.goalAgainst = dm.goalAgainst;
// team.goalDifference = dm.goalDifference;
// team.point = dm.point;
// teamRepository.Update(team);
// result = "Updated";
// }
//}
//else // Add Player
//{
// Teams team = new Teams();
// team.teamName = dm.teamName;
// team.gamePlayed = dm.gamePlayed;
// team.win = dm.win;
// team.lose = dm.lose;
// team.draw = dm.draw;
// team.goalAgainst = dm.goalAgainst;
// team.goalDifference = dm.goalDifference;
// team.point = dm.point;
// teamRepository.Insert(team);
// result = "Added";
//}
return(result);
}
public string AddUpdateTeam(TeamDomainModel dm)
{
string result = "";
if (dm.teamId > 0) // Edit Player
{
Teams team = teamRepository.SingleOrDefault(x => x.teamId == dm.teamId);
if (team != null)
{
team.teamName = dm.teamName;
team.gamePlayed = dm.gamePlayed;
team.win = dm.win;
team.lose = dm.lose;
team.draw = dm.draw;
team.goalAgainst = dm.goalAgainst;
team.goalDifference = dm.goalDifference;
team.point = dm.point;
teamRepository.Update(team);
result = "Updated";
}
}
else // Add Player
{
Teams team = new Teams();
team.teamName = dm.teamName;
team.gamePlayed = dm.gamePlayed;
team.win = dm.win;
team.lose = dm.lose;
team.draw = dm.draw;
team.goalAgainst = dm.goalAgainst;
team.goalDifference = dm.goalDifference;
team.point = dm.point;
teamRepository.Insert(team);
result = "Added";
}
return(result);
}
protected void rGridTeam_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
TeamDomainModel Team = new TeamDomainModel();
rGridTeam.DataSource = TeamBLL.ListTeams();
}
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.
}
}
private void getTeamRoster(RadDockLayout rDL, RadDockZone rDZ, int SeasonID, int TeamID, RadDropDownList rDDPosition)
{
TeamBusinessLogicLayer TeamBLL = new TeamBusinessLogicLayer();
TeamDomainModel Team = new TeamDomainModel();
List <v_Team_Draft_RosterDomainModel> lstTeamDeal = TeamBLL.ListTeamRoster(SeasonID, TeamID);
foreach (v_Team_Draft_RosterDomainModel item in lstTeamDeal)
{
if (rDDPosition.SelectedValue != string.Empty)
{
if (item.PositionTypeID == Convert.ToInt32(rDDPosition.SelectedValue))
{
RadDock dock = CreateRadDock(item);
dock.DockHandle = DockHandle.TitleBar;
RadAjaxManager1.AjaxSettings.AddAjaxSetting(rDZ, dock, RadAjaxLoadingPanel1);
rDL.Controls.Add(dock);
dock.Dock(rDZ);
}
}
}
}
public TeamDomainModel InsertTeam(TeamDomainModel team)
{
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
var _cTeam = new Team
{
TeamName = team.TeamName,
OwnerEmail = team.OwnerEmail,
OwnerUserID = team.OwnerUserID,
OwnerName = team.OwnerName,
TeamImage = team.TeamImage
};
context.Teams.Add(_cTeam);
context.SaveChanges();
// pass TeamID back to BLL
team.TeamID = _cTeam.TeamID;
return(team);
}
}
public List <SeasonTeamPlayerPositionDomainModel> STPP_Detail(SeasonDomainModel season, TeamDomainModel team)
{
return(DAL.STPP_Detail(season, team));
}
public static string CreateSpreadsheet(int iSeasonID)
{
SeasonDomainModel season = new SeasonDomainModel();
season.SeasonID = iSeasonID;
SeasonTeamBusinessLogic stBLL = new SeasonTeamBusinessLogic();
SeasonTeamPlayerPositionBLL stppBLL = new SeasonTeamPlayerPositionBLL();
List <SeasonTeamDomainModel> listSeasonTeam = stBLL.ListSelectedTeams(season.SeasonID);
List <SeasonTeamPlayerDomainModel> listSeasonTeamPlayer = new List <SeasonTeamPlayerDomainModel>();
TeamDomainModel team = new TeamDomainModel();
Excel.Application xlApp = new Excel.Application();
Workbook wb = xlApp.Workbooks.Add();
for (int i = 0; i < listSeasonTeam.Count; i++)
{
Worksheet sh = wb.Worksheets.Add();
xlApp.ActiveWindow.Zoom = 140;
SeasonTeamDomainModel st = listSeasonTeam[i];
team.TeamID = st.TeamID;
List <SeasonTeamPlayerPositionDomainModel> stpList = stppBLL.STPP_Detail(season, team);
sh.Name = st.TeamName.Trim();
int rowNbr = 1;
sh.Cells[rowNbr, "A"].Value2 = "Player Name";
sh.Cells[rowNbr, "A"].ColumnWidth = 30;
sh.Cells[rowNbr, "B"].Value2 = "Position";
sh.Cells[rowNbr, "A"].ColumnWidth = 20;
sh.Cells[rowNbr, "C"].Value2 = "Points";
sh.Cells[rowNbr, "A"].ColumnWidth = 20;
sh.Cells[rowNbr, "A"].Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
sh.Cells[rowNbr, "B"].Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignRight;
sh.Cells[rowNbr, "C"].Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignRight;
var columnHeadingsRange = sh.Range[sh.Cells[rowNbr, "A"], sh.Cells[rowNbr, "C"]];
columnHeadingsRange.Interior.Color = XlRgbColor.rgbSkyBlue;
columnHeadingsRange.Font.Color = XlRgbColor.rgbWhite;
rowNbr++;
foreach (SeasonTeamPlayerPositionDomainModel stp in stpList)
{
sh.Cells[rowNbr, "A"].Value2 = stp.PlayerName.Trim();
sh.Cells[rowNbr, "B"].Value2 = stp.PositionName.Trim();
sh.Cells[rowNbr, "C"].Value2 = stp.Points;
rowNbr++;
}
}
xlApp.DisplayAlerts = false;
for (int i = xlApp.ActiveWorkbook.Worksheets.Count; i > 0; i--)
{
Worksheet wkSheet = (Worksheet)xlApp.ActiveWorkbook.Worksheets[i];
if (wkSheet.Name == "Sheet1")
{
wkSheet.Delete();
}
}
xlApp.DisplayAlerts = true;
Random random = new Random();
int randomNumber = random.Next(0, 10000);
string path = AppDomain.CurrentDomain.BaseDirectory;
string CWorkbook = path + randomNumber + ".xlsx ";
wb.Application.ActiveWorkbook.CheckCompatibility = false;
wb.Application.ActiveWorkbook.SaveAs(CWorkbook, Excel.XlFileFormat.xlOpenXMLWorkbook);
wb.Close(true);
xlApp.Quit();
return(CWorkbook);
}
public TeamDomainModel InsertTeam(TeamDomainModel team)
{
return(dal.InsertTeam(team));
}
public List <SeasonTeamPlayerPositionDomainModel> STPP_Detail(SeasonDomainModel season, TeamDomainModel team)
{
List <SeasonTeamPlayerPositionDomainModel> STPP = new List <SeasonTeamPlayerPositionDomainModel>();
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
STPP = (from result in context.v_SeasonTeamPlayerPosition
orderby result.PositionSortOrder, result.Points
where result.SeasonID == season.SeasonID
where result.TeamID == team.TeamID
select new SeasonTeamPlayerPositionDomainModel
{
PlayerGUID = result.PlayerGUID,
PlayerName = result.PlayerName,
Points = result.Points,
PositionName = result.PositionName,
PositionNameLong = result.PositionNameLong,
SeasonID = result.SeasonID,
TeamID = result.TeamID,
TeamName = result.TeamName
}).ToList();
} // Guaranteed to close the Connection
return(STPP);
}
public void UpdateTeam(TeamDomainModel team)
{
dal.UpdateTeam(team);
}