protected void JqgridUser_RowEditing(object sender, JQGridRowEditEventArgs e)
{
var status = e.RowData["StatusLabel"];
var mainCompany = e.RowData["PropertyCode"];
var accessProperties = e.RowData["AccessProperties"];
var permissionId = e.RowData["PermissionName"];
var position = e.RowData["Position"];
var userId = e.RowKey;
var username = e.RowData["Username"];
if (!(string.IsNullOrEmpty(status) || string.IsNullOrEmpty(mainCompany) || string.IsNullOrEmpty(permissionId)))
{
var user = new HotelDataEntryLib.User()
{
UserId = Convert.ToInt32(userId),
PropertyId = Convert.ToInt32(mainCompany),
FirstName = e.RowData["FirstName"],
LastName = e.RowData["LastName"],
Email = e.RowData["Email"],
Status = Convert.ToInt32(status),
AccessProperties = accessProperties,
PermissionId = Convert.ToInt32(permissionId),
Username = username,
Position = position
};
UserHelper.UpdateUserProfile(user);
}
}
protected void JqgridMatch1_RowEditing(object sender, JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var match = dc.Matches.Single(item => item.MatchId == Convert.ToInt32(e.RowKey));
match.MatchDate = Convert.ToDateTime(e.RowData["MatchDate"]);
dc.SubmitChanges();
}
}
protected void JqgridHomePlayer_RowEditing(object sender, JQGridRowEditEventArgs e)
{
var playerMatchId = Convert.ToInt32(e.RowKey);
var playerNumber = Convert.ToInt32(e.RowData["PlayerNumber"]);
var playerName = e.RowData["PlayerName"];
var player = CalculatePlayerMatch(playerMatchId, playerNumber, playerName);
CalculatePlayerResult(player);
}
protected void JqgridMatch1_RowEditing(object sender, JQGridRowEditEventArgs e)
{
var teamWin = "<b style='color: red'>ยังไม่มีผลการแข่งขัน</b>";
var hasResult = 0;
var homeScore = String.IsNullOrEmpty(e.RowData["TeamHomeScore"])
? 0
: Convert.ToInt32(e.RowData["TeamHomeScore"]);
var awayScore = String.IsNullOrEmpty(e.RowData["TeamAwayScore"])
? 0
: Convert.ToInt32(e.RowData["TeamAwayScore"]);
var date = String.IsNullOrEmpty(e.RowData["FAMatchDate"])
? DateTime.Now
: Convert.ToDateTime(e.RowData["FAMatchDate"]);
if (homeScore > awayScore)
{
teamWin = "<b style='color: blue'>" + e.RowData["TeamHomeName"] + "</b>";
hasResult = 1;
}
else if (homeScore < awayScore)
{
teamWin = "<b style='color: blue'>" + e.RowData["TeamAwayName"] + "</b>";
hasResult = 1;
}
using (var dc = ThaitaeDataDataContext.Create())
{
var faMatch = dc.FAMatches.Single(item => item.FAMatchId == Convert.ToInt32(e.RowKey));
faMatch.FAMatchDate = date;
faMatch.TeamHomeName = e.RowData["TeamHomeName"];
faMatch.TeamHomeScore = homeScore;
faMatch.TeamAwayScore = awayScore;
faMatch.TeamAwayName = e.RowData["TeamAwayName"];
faMatch.TeamWin = teamWin;
faMatch.HasResult = hasResult;
dc.SubmitChanges();
}
}
protected void JqGridDataEntry_RowEditing(object sender, JQGridRowEditEventArgs e)
{
var revenueEntryId = e.RowKey;
var hotelEntryId = e.RowData["HotelEntryId"] == "" ? 0 : Convert.ToInt32(e.RowData["HotelEntryId"]);
var roomRevenue = string.IsNullOrEmpty(e.RowData["RoomRevenue"]) ? 0.00 : Convert.ToDouble(e.RowData["RoomRevenue"]);
var fbRevenue = string.IsNullOrEmpty(e.RowData["FBRevenue"]) ? 0.00 : Convert.ToDouble(e.RowData["FBRevenue"]);
var spa = string.IsNullOrEmpty(e.RowData["SpaRevenue"]) ? 0.00 : Convert.ToDouble(e.RowData["SpaRevenue"]);
var others = string.IsNullOrEmpty(e.RowData["Others"]) ? 0.00 : Convert.ToDouble(e.RowData["Others"]);
var occupancyRoom = 0.0;
if (string.IsNullOrEmpty(e.RowData["OccupancyRoom"]))
{
occupancyRoom = 0;
}
else
{
var strOccupancy = "";
strOccupancy = e.RowData["OccupancyRoom"].Contains("%") ? e.RowData["OccupancyRoom"].Remove(e.RowData["OccupancyRoom"].Length - 1, 1) : e.RowData["OccupancyRoom"];
occupancyRoom = Convert.ToDouble(strOccupancy);
}
var revenueEntry = new RevenueEntry()
{
RevenueId = Convert.ToInt32(revenueEntryId),
HotelRevenueId = hotelEntryId,
OccupancyRoom = occupancyRoom,
RoomRevenue = roomRevenue,
FBRevenue = fbRevenue,
SpaRevenue = spa,
Others = others,
UpdateUser = Session["UserSession"].ToString(),
Total = roomRevenue + fbRevenue + spa + others
};
RevenueHelper.UpdateRevenueEntry(revenueEntry);
}
protected void JqgridAwayTeam_RowEditing(object sender, JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var team = dc.TeamMatches.Single(item => item.TeamMatchId == Convert.ToInt32(e.RowKey));
team.TeamGoalFor = Convert.ToInt32(e.RowData["TeamGoalFor"]);
team.TeamRedCard = Convert.ToInt32(e.RowData["TeamRedCard"]);
team.TeamYellowCard = Convert.ToInt32(e.RowData["TeamYellowCard"]);
if (team.TeamGoalFor == -1 && team.TeamRedCard == -1 && team.TeamYellowCard == -1)
{
team.TeamEdited = 0;
team.TeamStatus = 0;
team.TeamGoalAgainst = 0;
team.TeamGoalFor = 0;
team.TeamRedCard = 0;
team.TeamYellowCard = 0;
}
else
{
team.TeamEdited = 1;
var teamAgainst = dc.TeamMatches.Single(item => item.MatchId == Convert.ToInt32(e.ParentRowKey) && item.TeamHome == 1);
teamAgainst.TeamGoalAgainst = Convert.ToInt32(e.RowData["TeamGoalFor"]);
if (teamAgainst.TeamEdited == 1)
{
if (team.TeamGoalFor < teamAgainst.TeamGoalFor)
{
team.TeamStatus = 3;
teamAgainst.TeamStatus = 1;
}
else if (team.TeamGoalFor > teamAgainst.TeamGoalFor)
{
team.TeamStatus = 1;
teamAgainst.TeamStatus = 3;
}
else
{
team.TeamStatus = 2;
teamAgainst.TeamStatus = 2;
}
dc.SubmitChanges();
CalculateTeamResult(team, teamAgainst, Convert.ToInt32(Session["seasonid"]));
}
}
dc.SubmitChanges();
var removePlayerList =
dc.PlayerMatches.Where(item => item.TeamId == team.TeamId && item.MatchId == team.MatchId && item.SeasonId == team.SeasonId);
dc.PlayerMatches.DeleteAllOnSubmit(removePlayerList);
dc.SubmitChanges();
for (int i = 0; i < team.TeamGoalFor; i++)
{
var player = new PlayerMatch {
PlayerGoal = 1, TeamId = team.TeamId, MatchId = team.MatchId, SeasonId = team.SeasonId
};
dc.PlayerMatches.InsertOnSubmit(player);
dc.SubmitChanges();
}
for (int i = 0; i < team.TeamRedCard; i++)
{
var player = new PlayerMatch {
PlayerRedCard = 1, TeamId = team.TeamId, MatchId = team.MatchId, SeasonId = team.SeasonId
};
dc.PlayerMatches.InsertOnSubmit(player);
dc.SubmitChanges();
}
for (int i = 0; i < team.TeamYellowCard; i++)
{
var player = new PlayerMatch {
PlayerYellowCard = 1, TeamId = team.TeamId, MatchId = team.MatchId, SeasonId = team.SeasonId
};
dc.PlayerMatches.InsertOnSubmit(player);
dc.SubmitChanges();
}
}
}
protected void JqgridMatch1_RowEditing(object sender, JQGridRowEditEventArgs e)
{
var homeScore = String.IsNullOrEmpty(e.RowData["TeamHomeScore"])
? 0
: Convert.ToInt32(e.RowData["TeamHomeScore"]);
var homePScore = String.IsNullOrEmpty(e.RowData["TeamHomePScore"])
? 0
: Convert.ToInt32(e.RowData["TeamHomePScore"]);
var awayScore = String.IsNullOrEmpty(e.RowData["TeamAwayScore"])
? 0
: Convert.ToInt32(e.RowData["TeamAwayScore"]);
var awayPScore = String.IsNullOrEmpty(e.RowData["TeamAwayPScore"])
? 0
: Convert.ToInt32(e.RowData["TeamAwayPScore"]);
var date = String.IsNullOrEmpty(e.RowData["MatchDate"])
? DateTime.Now
: Convert.ToDateTime(e.RowData["MatchDate"]);
using (var dc = ThaitaeDataDataContext.Create())
{
var match = dc.Matches.Single(item => item.MatchId == Convert.ToInt32(e.RowKey));
var teamHome =
dc.TeamMatches.Single(item => item.MatchId == Convert.ToInt32(e.RowKey) && item.TeamHome == 1);
var teamAway =
dc.TeamMatches.Single(item => item.MatchId == Convert.ToInt32(e.RowKey) && item.TeamHome == 0);
match.MatchDate = date;
teamHome.TeamGoalFor = homeScore;
teamHome.TeamGoalPenalty = homePScore;
teamAway.TeamGoalFor = awayScore;
teamAway.TeamGoalPenalty = awayPScore;
if (teamHome.TeamGoalFor == teamAway.TeamGoalFor)
{
//if (teamHome.TeamGoalFor + teamHome.TeamGoalPenalty >
// teamAway.TeamGoalFor + teamAway.TeamGoalPenalty)
//{
// teamHome.TeamEdited = 1;
// teamHome.TeamStatus = 1;
// teamAway.TeamEdited = 1;
// teamAway.TeamStatus = 3;
//}
//else if (teamHome.TeamGoalFor + teamHome.TeamGoalPenalty <
// teamAway.TeamGoalFor + teamAway.TeamGoalPenalty)
//{
// teamHome.TeamEdited = 1;
// teamHome.TeamStatus = 3;
// teamAway.TeamEdited = 1;
// teamAway.TeamStatus = 1;
//}
//else
//{
teamHome.TeamEdited = 1;
teamHome.TeamStatus = 2;
teamAway.TeamEdited = 1;
teamAway.TeamStatus = 2;
//}
}
else if (teamHome.TeamGoalFor > teamAway.TeamGoalFor)
{
teamHome.TeamEdited = 1;
teamHome.TeamStatus = 1;
teamAway.TeamEdited = 1;
teamAway.TeamStatus = 3;
}
else if (teamHome.TeamGoalFor < teamAway.TeamGoalFor)
{
teamHome.TeamEdited = 1;
teamHome.TeamStatus = 3;
teamAway.TeamEdited = 1;
teamAway.TeamStatus = 1;
}
if (teamHome.TeamGoalFor == -1 && teamHome.TeamGoalPenalty == -1 && teamAway.TeamGoalFor == -1 &&
teamAway.TeamGoalPenalty == -1)
{
teamHome.TeamGoalFor = 0;
teamHome.TeamGoalPenalty = 0;
teamAway.TeamGoalFor = 0;
teamAway.TeamGoalPenalty = 0;
teamHome.TeamEdited = 0;
teamHome.TeamStatus = 0;
teamAway.TeamEdited = 0;
teamAway.TeamStatus = 0;
}
dc.SubmitChanges();
var mirrorMatchId =
dc.Matches.Single(
item =>
item.TeamHomeId == match.TeamAwayId && item.TeamAwayId == match.TeamHomeId && item.SeasonId == match.SeasonId).MatchId;
var mirrorTeamHome =
dc.TeamMatches.Single(item => item.MatchId == mirrorMatchId && item.TeamHome == 1);
var mirrorTeamAway =
dc.TeamMatches.Single(item => item.MatchId == mirrorMatchId && item.TeamHome == 0);
if (mirrorMatchId < match.MatchId && mirrorTeamHome.TeamEdited == 1 && mirrorTeamAway.TeamEdited == 1 && teamHome.TeamEdited == 1 && teamAway.TeamEdited == 1)
{
var totalScoreHome = teamHome.TeamGoalFor + mirrorTeamAway.TeamGoalFor;
var totalScoreAway = teamAway.TeamGoalFor + mirrorTeamHome.TeamGoalFor;
if (totalScoreHome > totalScoreAway)
{
teamHome.TeamStatus = 1;
teamAway.TeamStatus = 3;
}
else if (totalScoreHome < totalScoreAway)
{
teamHome.TeamStatus = 3;
teamAway.TeamStatus = 1;
}
else
{
if (teamHome.TeamGoalPenalty > teamAway.TeamGoalPenalty)
{
teamHome.TeamStatus = 1;
teamAway.TeamStatus = 3;
}
else
{
teamHome.TeamStatus = 3;
teamAway.TeamStatus = 1;
}
}
dc.SubmitChanges();
}
}
}
