public static bool updateDivision(Model.Division _u)
{
try {
// Tao ket noi
conn = new SqlConnection(strConnect);
// Mo ket noi
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
// Them don vi
string strCmd = string.Format("UPDATE BO_PHAN set TENBP = N'{0}', LUONG = '{1}' where MABP = '{2}'", _u.Name, _u.Salary, _u.IdString);
SqlCommand myCmd = new SqlCommand(strCmd, conn);
SqlDataReader myReader = myCmd.ExecuteReader();
conn.Close();
conn.Dispose();
return(true);
}
catch (Exception ex) {
System.Windows.Forms.MessageBox.Show(ex.Message);
conn.Close();
conn.Dispose();
return(false);
}
}
public static bool insertDivision(Model.Division _u)
{
try {
// Tao ket noi
conn = new SqlConnection(strConnect);
// Mo ket noi
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
// Them don vi
string strCmd = string.Format("INSERT INTO BO_PHAN VALUES('{0}', N'{1}', '{2}')", _u.IdString, _u.Name, _u.Salary);
SqlCommand myCmd = new SqlCommand(strCmd, conn);
SqlDataReader myReader = myCmd.ExecuteReader();
conn.Close();
conn.Dispose();
return(true);
}
catch (Exception ex) {
System.Windows.Forms.MessageBox.Show(ex.Message);
conn.Close();
conn.Dispose();
return(false);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
int salary = int.Parse(txtSalary.Text);
Model.Division u = new Model.Division(txtID.Text, txtName.Text, salary);
Controller.Connector.updateDivision(u);
MessageBox.Show("Sửa thành công đơn vị " + txtID.Text, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
public void DivisionAdd()
{
if (SystemClass.CheckConnection())
{
try
{
using (var db = new ImusCityHallEntities())
{
if (!String.IsNullOrEmpty(txtCode.Text) && !String.IsNullOrEmpty(txtName.Text) && departmentcb.SelectedValue != null)
{
if (db.Divisions.Any(m => m.DivisionCode == txtCode.Text))
{
MessageBox.Show("Division code is already used");
}
else
{
Model.Division d = new Model.Division();
d.DivisionCode = txtCode.Text;
d.DivisionName = txtName.Text;
d.DepartmentID = (int)departmentcb.SelectedValue;
d.IsActive = true;
db.Divisions.Add(d);
db.SaveChanges();
var audit = new AuditTrailModel
{
Activity = "Added new division in the database. DEPT CODE: " + txtCode.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Division added successfully", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information);
TextClear();
}
}
else
{
MessageBox.Show("Fill up necessary fields.", "System Information!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Something went wrong." + Environment.NewLine + ex.Message, "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
public Model.Organization Get(Model.Organization org)
{
using (var client = new HttpClient())
{
client.BaseAddress = BaseAddress;
var byteArray = Encoding.ASCII.GetBytes($"{ApiKey}:x");
client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Basic", Convert.ToBase64String(byteArray));
var result = client.GetAsync($"/organizations/{org.Id}.xml").Result;
using (var stream = result.Content.ReadAsStreamAsync().Result)
{
XmlSerializer serializer;
Model.Organization returnVal;
switch (org.Type)
{
case Model.OrganizationType.Division:
serializer = new XmlSerializer(typeof(Division));
returnVal = new Model.Division((Division)serializer.Deserialize(stream));
break;
case Model.OrganizationType.Franchise:
serializer = new XmlSerializer(typeof(Franchise));
returnVal = new Model.Franchise((Franchise)serializer.Deserialize(stream));
break;
case Model.OrganizationType.Franchisor:
serializer = new XmlSerializer(typeof(Franchisor));
returnVal = new Model.Franchisor((Franchisor)serializer.Deserialize(stream));
break;
default:
throw new NotImplementedException($"The Entity {org.Type} is not supported");
}
// resultContent = result.Content.ReadAsStringAsync().Result;
return(returnVal);
}
}
}
public void Run(Model.MlbStatsContext context)
{
Console.WriteLine($"TeamsProcessor - {this.Season}");
var url = Feeds.TeamsFeed.GetFeedUrl(this.Season);
var rawJson = JsonUtility.GetRawJsonFromUrl(url);
var feed = Feeds.TeamsFeed.FromJson(rawJson);
var dbAssociations = context.Associations.ToDictionary(x => x.AssociationID);
var dbLeagues = context.Leagues.ToDictionary(x => x.LeagueID);
var dbDivisions = context.Divisions.ToDictionary(x => x.DivisionID);
var dbVenues = context.Venues.ToDictionary(x => x.VenueID);
var dbTeams = context.Teams.ToDictionary(x => x.TeamID);
var dbVenueSeasons = context.VenueSeasons.Where(x => x.Season == this.Season).ToDictionary(x => x.VenueID);
var dbAssociationSeasons = context.AssociationSeasons.Where(x => x.Season == this.Season).ToDictionary(y => y.AssociationID);
var dbLeagueSeasons = context.LeagueSeasons.Where(x => x.Season == this.Season).ToDictionary(y => y.LeagueID);
var dbDivisionSeasons = context.DivisionSeasons.Where(x => x.Season == this.Season).ToDictionary(y => y.DivisionID);
var dbTeamSeasons = context.TeamSeasons.Where(x => x.Season == this.Season).ToDictionary(y => y.TeamID);
var feedTeams = feed.Teams.OrderBy(x => x.ParentOrgId.HasValue ? 1 : 0).ThenBy(y => y.Sport.Id).ToList();
foreach (var feedTeam in feedTeams)
{
if (!dbAssociations.TryGetValue(feedTeam.Sport.Id.Value, out Model.Association dbAssociation))
{
dbAssociation = new Model.Association
{
AssociationID = feedTeam.Sport.Id.Value,
AssociationName = feedTeam.Sport.Name,
AssociationLink = feedTeam.Sport.Link
};
dbAssociations.Add(dbAssociation.AssociationID, dbAssociation);
context.Associations.Add(dbAssociation);
}
Model.League dbLeague = null;
if (feedTeam.League?.Id != null && !dbLeagues.TryGetValue(feedTeam.League.Id.Value, out dbLeague))
{
dbLeague = new Model.League
{
LeagueID = feedTeam.League.Id.Value,
LeagueName = feedTeam.League.Name,
LeagueLink = feedTeam.League.Link
};
dbLeagues.Add(dbLeague.LeagueID, dbLeague);
context.Leagues.Add(dbLeague);
}
Model.Division dbDivision = null;
if (feedTeam.Division?.Id != null && !dbDivisions.TryGetValue(feedTeam.Division.Id.Value, out dbDivision))
{
dbDivision = new Model.Division
{
DivisionID = feedTeam.Division.Id.Value,
DivisionName = feedTeam.Division.Name,
DivisionLink = feedTeam.Division.Link
};
dbDivisions.Add(dbDivision.DivisionID, dbDivision);
context.Divisions.Add(dbDivision);
}
Model.Venue dbVenue = null;
if (feedTeam.Venue?.Id != null && !dbVenues.TryGetValue(feedTeam.Venue.Id.Value, out dbVenue))
{
dbVenue = new Model.Venue
{
VenueID = feedTeam.Venue.Id.Value,
VenueName = feedTeam.Venue.Name,
VenueLink = feedTeam.Venue.Link
};
dbVenues.Add(dbVenue.VenueID, dbVenue);
context.Venues.Add(dbVenue);
}
Model.League dbSpringLeague = null;
if (feedTeam.SpringLeague?.Id != null && !dbLeagues.TryGetValue(feedTeam.SpringLeague.Id.Value, out dbSpringLeague))
{
dbSpringLeague = new Model.League
{
LeagueID = feedTeam.SpringLeague.Id.Value,
LeagueName = feedTeam.SpringLeague.Name,
LeagueLink = feedTeam.SpringLeague.Link
};
dbLeagues.Add(dbSpringLeague.LeagueID, dbSpringLeague);
context.Leagues.Add(dbSpringLeague);
}
Model.Team dbParentOrg = null;
if (feedTeam.ParentOrgId.HasValue && !dbTeams.TryGetValue(feedTeam.ParentOrgId.Value, out dbParentOrg))
{
dbParentOrg = new Model.Team
{
TeamID = feedTeam.ParentOrgId.Value,
TeamFullName = feedTeam.ParentOrgName
};
dbTeams.Add(dbParentOrg.TeamID, dbParentOrg);
context.Teams.Add(dbParentOrg);
}
if (!dbTeams.TryGetValue(feedTeam.Id, out Model.Team dbTeam))
{
dbTeam = new Model.Team
{
TeamID = feedTeam.Id,
FileCode = feedTeam.FileCode,
FirstSeason = feedTeam.FirstYearOfPlay,
IsActive = feedTeam.Active,
IsAllStar = feedTeam.IsAllStarTeam,
TeamAbbr = feedTeam.Abbreviation,
TeamCode = feedTeam.TeamCode,
TeamFullName = feedTeam.Name,
TeamLocation = feedTeam.LocationName,
TeamName = feedTeam.Name,
};
dbTeams.Add(dbTeam.TeamID, dbTeam);
context.Teams.Add(dbTeam);
}
else if (this.IsCurrentSeason) // ONLY UPDATE TEAM ENTRY IF IT IS THE CURRENT SEASON
{
if (dbTeam.FileCode != feedTeam.FileCode ||
dbTeam.FirstSeason != feedTeam.FirstYearOfPlay ||
dbTeam.IsActive != feedTeam.Active ||
dbTeam.IsAllStar != feedTeam.IsAllStarTeam ||
dbTeam.TeamAbbr != feedTeam.Abbreviation ||
dbTeam.TeamCode != feedTeam.TeamCode ||
dbTeam.TeamFullName != feedTeam.Name ||
dbTeam.TeamLocation != feedTeam.LocationName ||
dbTeam.TeamName != feedTeam.Name)
{
dbTeam.FileCode = feedTeam.FileCode;
dbTeam.FirstSeason = feedTeam.FirstYearOfPlay;
dbTeam.IsActive = feedTeam.Active;
dbTeam.IsAllStar = feedTeam.IsAllStarTeam;
dbTeam.TeamAbbr = feedTeam.Abbreviation;
dbTeam.TeamCode = feedTeam.TeamCode;
dbTeam.TeamFullName = feedTeam.Name;
dbTeam.TeamLocation = feedTeam.LocationName;
dbTeam.TeamName = feedTeam.Name;
}
}
// ENTER SEASON BASED PROCESSING. CURRENT DATA CAN BE UPDATED ABOVE. SEASON BASED DATA SHOULD NEVER NEED TO BE UPDATED (FOR LEAGUE STRUCTURE)
Model.VenueSeason dbVenueSeason = null;
if (feedTeam.Venue?.Id != null && !dbVenueSeasons.TryGetValue(feedTeam.Venue.Id.Value, out dbVenueSeason))
{
dbVenueSeason = new Model.VenueSeason
{
VenueID = feedTeam.Venue.Id.Value,
Season = this.Season,
VenueName = feedTeam.Venue.Name
};
dbVenueSeasons.Add(feedTeam.Venue.Id.Value, dbVenueSeason);
context.VenueSeasons.Add(dbVenueSeason);
}
if (!dbAssociationSeasons.TryGetValue(feedTeam.Sport.Id.Value, out Model.AssociationSeason dbAssociationSeason))
{
dbAssociationSeason = new Model.AssociationSeason
{
Association = dbAssociation,
Season = this.Season,
AssociationName = feedTeam.Sport.Name
};
dbAssociationSeasons.Add(dbAssociation.AssociationID, dbAssociationSeason);
context.AssociationSeasons.Add(dbAssociationSeason);
}
Model.LeagueSeason dbLeagueSeason = null;
if (feedTeam.League?.Id != null && !dbLeagueSeasons.TryGetValue(feedTeam.League.Id.Value, out dbLeagueSeason))
{
dbLeagueSeason = new Model.LeagueSeason
{
League = dbLeague,
Season = this.Season,
LeagueName = feedTeam.League.Name,
AssociationSeason = dbAssociationSeason
};
dbLeagueSeasons.Add(dbLeague.LeagueID, dbLeagueSeason);
context.LeagueSeasons.Add(dbLeagueSeason);
}
Model.LeagueSeason dbSpringLeagueSeason = null;
if (feedTeam.SpringLeague?.Id != null && !dbLeagueSeasons.TryGetValue(feedTeam.SpringLeague.Id.Value, out dbSpringLeagueSeason))
{
dbSpringLeagueSeason = new Model.LeagueSeason
{
League = dbSpringLeague,
Season = this.Season,
LeagueName = feedTeam.SpringLeague.Name,
AssociationSeason = dbAssociationSeason
};
dbLeagueSeasons.Add(dbSpringLeague.LeagueID, dbSpringLeagueSeason);
context.LeagueSeasons.Add(dbSpringLeagueSeason);
}
Model.DivisionSeason dbDivisionSeason = null;
if (feedTeam.Division?.Id != null && !dbDivisionSeasons.TryGetValue(feedTeam.Division.Id.Value, out dbDivisionSeason))
{
dbDivisionSeason = new Model.DivisionSeason
{
Division = dbDivision,
Season = this.Season,
DivisionName = feedTeam.Division.Name,
LeagueSeason = dbLeagueSeason
};
dbDivisionSeasons.Add(dbDivision.DivisionID, dbDivisionSeason);
context.DivisionSeasons.Add(dbDivisionSeason);
}
Model.TeamSeason dbTeamSeason = null;
if (!dbTeamSeasons.TryGetValue(feedTeam.Id, out dbTeamSeason))
{
dbTeamSeason = new Model.TeamSeason
{
Team = dbTeam,
Season = this.Season,
AssociationSeason = dbAssociationSeason,
LeagueSeason = dbLeagueSeason,
DivisionSeason = dbDivisionSeason,
VenueSeason = dbVenueSeason,
FileCode = feedTeam.FileCode,
FullName = feedTeam.Name,
SpringLeagueSeason = dbSpringLeagueSeason,
TeamAbbr = feedTeam.Abbreviation,
TeamCode = feedTeam.TeamCode,
TeamLocation = feedTeam.LocationName,
TeamName = feedTeam.TeamName
};
dbTeamSeasons.Add(dbTeam.TeamID, dbTeamSeason);
context.TeamSeasons.Add(dbTeamSeason);
}
}
var feedChildTeams = feed.Teams.Where(x => x.ParentOrgId.HasValue);
foreach (var feedChildTeam in feedChildTeams)
{
var dbChildTeamSeason = dbTeamSeasons[feedChildTeam.Id];
if (!dbTeamSeasons.TryGetValue(feedChildTeam.ParentOrgId.Value, out Model.TeamSeason dbParentTeamSeason))
{
dbParentTeamSeason = new Model.TeamSeason
{
TeamID = feedChildTeam.ParentOrgId.Value,
Season = this.Season,
TeamName = feedChildTeam.ParentOrgName
};
dbTeamSeasons.Add(feedChildTeam.ParentOrgId.Value, dbParentTeamSeason);
context.TeamSeasons.Add(dbParentTeamSeason);
}
dbChildTeamSeason.ParentOrgSeason = dbParentTeamSeason;
}
context.SaveChanges();
}
private bool CheckIsExist(Model.Division division)
{
return(this.divisionService.CheckIsExist(division));
}
