private void AddItemToLog(CLogItem LogItem, CQueueItem Item)
{
GlobalDefines.CheckPublishingDirExists();
string Dir = GlobalDefines.STD_PUBLISHING_LOG_DIR + Item.CompId.ToString() + "\\";
if (!Directory.Exists(Dir))
{
Directory.CreateDirectory(Dir);
}
try
{
using (TextWriter tw = new StreamWriter(string.Format("{0}{1}\\{2}{3}",
GlobalDefines.STD_PUBLISHING_LOG_DIR,
Item.CompId,
Item.GroupId,
GlobalDefines.PUBLISHING_LOG_FILE_EXTENSION), true))
{
tw.WriteLine(LogItem.ToLogFileString());
}
}
catch (Exception ex)
{
ex.ToString(); // make compiler happy
}
}
private bool HandleFile(string FullFilePath)
{
CGroupItem GroupChanged = null;
CCompItem Comp = null;
long id = -1;
string FileDir = System.IO.Path.GetDirectoryName(FullFilePath);
int LastSlash = FileDir.LastIndexOf('\\');
if (long.TryParse(FileDir.Right(FileDir.Length - LastSlash - 1), out id))
{
Comp = Comps.FirstOrDefault(arg => arg.id == id);
if (Comp == null)
{ // Такого соревнования нет => его нужно добавить
Comp = new CCompItem(id)
{
FolderName = id.ToString() + "\\"
};
descriptions desc = DBManagerApp.m_Entities.descriptions.FirstOrDefault(arg => arg.id_desc == id);
if (desc == null)
{
return(false);
}
else
{
Comp.CompName = desc.name;
}
if (long.TryParse(System.IO.Path.GetFileNameWithoutExtension(FullFilePath), out id))
{
GroupChanged = AddNewGroup(Comp, id);
if (GroupChanged == null)
{
return(false);
}
}
else
{ // неверное название файла
return(false);
}
Comps.Add(Comp);
}
else
{
if (long.TryParse(System.IO.Path.GetFileNameWithoutExtension(FullFilePath), out id))
{
GroupChanged = Comp.Groups.FirstOrDefault(arg => arg.id == id);
if (GroupChanged == null)
{ // Группы нет => добавляем
GroupChanged = AddNewGroup(Comp, id);
if (GroupChanged == null)
{
return(false);
}
}
}
}
}
else
{ // неверное название файла
return(false);
}
GroupChanged.Items.Clear();
GlobalDefines.CheckPublishingDirExists();
List <CLogItem> lstItems = new List <CLogItem>();
try
{
using (TextReader tr = new StreamReader(string.Format("{0}{1}\\{2}{3}",
GlobalDefines.STD_PUBLISHING_LOG_DIR,
Comp.id,
GroupChanged.id,
GlobalDefines.PUBLISHING_LOG_FILE_EXTENSION)))
{
string line = null;
CLogItem CurLogItem = null;
DateTime ItemDateTime = DateTime.Now;
enOnlineResultsLogItemType ItemType = enOnlineResultsLogItemType.None;
do
{
line = tr.ReadLine();
if (line == null)
{ // Файл закончился
break;
}
else
{
string[] Fields = line.Split(GlobalDefines.PUBLISHING_LOG_FIELDS_SEPARATOR);
// Переносы строк не используем в логе для удобства, поэтому добавляем их там, где они нужны
for (int i = 0; i < Fields.Length; i++)
{
Fields[i] = Fields[i].Replace(GlobalDefines.PUBLISHING_LOG_LFCR_SYMBOL, '\n');
}
int Index = 0;
if (Enum.TryParse <enOnlineResultsLogItemType>(Fields[Index++], out ItemType) &&
DateTime.TryParse(Fields[Index++], out ItemDateTime))
{
CurLogItem = new CLogItem()
{
Type = ItemType,
CreationDate = ItemDateTime,
};
if (Fields.Length > Index)
{
CurLogItem.PCWbkName = Fields[Index].Trim();
}
Index++;
if (Fields.Length > Index)
{
CurLogItem.Text = Fields[Index].Trim();
}
Index++;
lstItems.Add(CurLogItem);
}
}
}while (line != null);
}
}
catch
{ }
lstItems.Sort((lhs, rhs) => - lhs.CreationDate.CompareTo(rhs.CreationDate));
GroupChanged.Items.AddRange(lstItems);
return(true);
}
/// <summary>
/// Обработка 1 элемента
/// </summary>
/// <param name="Item"></param>
public bool HandleItem(CQueueItem Item)
{
CLogItem LogItem = new CLogItem()
{
CreationDate = DateTime.Now,
PCWbkName = Item.PCWbkFullPath
};
// Проверка соединения с удалённой БД
if (!m_DBManager.IsConnectedToRemoteDB)
{
string msg = string.Format(DBManager.Properties.Resources.resrmtCantConnectToRemoteDB, m_DBManager.ConnectionString);
MessageBox.Show(msg, AppAttributes.Title, MessageBoxButton.OK, MessageBoxImage.Error);
LogItem.Type = enOnlineResultsLogItemType.Error;
LogItem.Text = msg;
AddItemToLog(LogItem, Item);
return(false);
}
if (Item.Round == enRounds.Total)
{ // TO DO: пока сайт не поддерживает вывод итоговых протоколов
return(true);
}
string GroupFullNameToPublish = Item.CompSettings.AgeGroup.FullGroupName;
string roundNameToPublish = GlobalDefines.ROUND_NAMES[(byte)Item.Round];
DBManagerApp.MainWnd.PublishingNow = true;
try
{
// Получаем список участников заданной группы и раунда в удалённой БД
var RemoteDBResults = (from result in m_DBManager.Entities.results_speed
where result.groups == GroupFullNameToPublish &&
result.round == roundNameToPublish
select result)
.ToList();
// Получаем список участников в локальной БД
var LocalDBResults = (from member in DBManagerApp.m_Entities.members
join part in DBManagerApp.m_Entities.participations on member.id_member equals part.member
join result in DBManagerApp.m_Entities.results_speed on part.id_participation equals result.participation
where result.round == (byte)Item.Round && part.Group == Item.GroupId
select new CMemberAndResults
{
MemberInfo = new CFullMemberInfo()
{
IDMember = member.id_member,
Surname = member.surname,
Name = member.name,
YearOfBirth = member.year_of_birth,
Coach = part.coach,
Team = part.team,
InitGrade = part.init_grade,
},
Results = new COneRoundResults()
{
m_Round = (enRounds)result.round,
Route1 = new CResult()
{
ResultInDB = result,
ResultColumnNumber = enResultColumnNumber.Route1,
Time = result.route1,
},
Route2 = new CResult()
{
ResultInDB = result,
ResultColumnNumber = enResultColumnNumber.Route2,
Time = result.route2,
},
Sum = new CResult()
{
ResultInDB = result,
ResultColumnNumber = enResultColumnNumber.Sum,
Time = result.sum,
},
},
StartNumber = result.number,
Place = result.place,
})
.ToList();
var LocalDBResultsWithSum = LocalDBResults.Where(arg => arg.Results?.Sum?.Time != null);
// В основном запросе заполнить эти поля почему-то не получилось
foreach (CMemberAndResults item in LocalDBResults)
{
if (Item.CompSettings.SecondColNameType == enSecondColNameType.Coach)
{
item.MemberInfo.SecondCol = DBManagerApp.m_Entities.coaches.First(arg => arg.id_coach == item.MemberInfo.Coach).name;
}
else
{
item.MemberInfo.SecondCol = DBManagerApp.m_Entities.teams.First(arg => arg.id_team == item.MemberInfo.Team).name;
}
}
// Сравниваем результаты и заносим их в удалённую БД
// Обновляем результаты или добавляем новые
foreach (var pair in (from localResult in LocalDBResults
join remoteResult in RemoteDBResults on localResult.MemberInfo.IDMember equals remoteResult.local_member_id into remoteResults
from remoteResult in remoteResults.DefaultIfEmpty()
select new
{
remoteResult,
localResult
}))
{
OnlineDB.Data.results_speed remoteResult = pair.remoteResult;
if (remoteResult == null)
{ // Нужно добавить новый результат в удалённую БД
remoteResult = new OnlineDB.Data.results_speed(pair.localResult, GroupFullNameToPublish, Item.Round);
m_DBManager.Entities.results_speed.Add(remoteResult);
}
else if (!remoteResult.IsEqualWithoutIdentificationProperties(pair.localResult))
{ // Нужно заменить результат в удалённой БД
remoteResult.UpdateFromLocalData(pair.localResult);
}
// Обновляем поле pass_to_next_round
switch (Item.Round)
{
case enRounds.Qualif:
remoteResult.pass_to_next_round = remoteResult.place.HasValue &&
Item.CompSettings.MembersFrom1stQualif > 0 &&
remoteResult.place <= Item.CompSettings.MembersFrom1stQualif;
break;
case enRounds.Qualif2:
remoteResult.pass_to_next_round = remoteResult.place.HasValue &&
Item.CompSettings.MembersFrom2ndQualif > 0 &&
remoteResult.place <= Item.CompSettings.MembersFrom2ndQualif;
break;
case enRounds.OneEighthFinal:
case enRounds.QuaterFinal:
case enRounds.SemiFinal:
case enRounds.Final:
if (remoteResult.sum.HasValue)
{
int pairNumber = (remoteResult.number - 1) / 2;
int firstMemberStartNumber = (pairNumber * 2) + 1;
int secondMemberStartNumber = firstMemberStartNumber + 1;
var firstMember = LocalDBResultsWithSum.FirstOrDefault(arg => arg.StartNumber == firstMemberStartNumber);
var secondMember = LocalDBResultsWithSum.FirstOrDefault(arg => arg.StartNumber == secondMemberStartNumber);
if (firstMember != null && secondMember != null)
{ // Оба участника из пары пробежали обе трассы
if (firstMember.Results.Sum.Time < secondMember.Results.Sum.Time)
{
remoteResult.pass_to_next_round = remoteResult.number == firstMember.StartNumber;
}
else
{
remoteResult.pass_to_next_round = remoteResult.number == secondMember.StartNumber;
}
}
else
{
remoteResult.pass_to_next_round = false;
}
}
else
{
remoteResult.pass_to_next_round = false;
}
break;
}
}
m_DBManager.Entities.SaveChanges();
// Удаляем из удалённой БД результаты, которых больше нет
foreach (var remoteResult in (from remoteResult in RemoteDBResults
join localResult in LocalDBResults on remoteResult.local_member_id equals localResult.MemberInfo.IDMember into localResults
from localResult in localResults.DefaultIfEmpty()
where localResult == null
select remoteResult))
{
m_DBManager.Entities.results_speed.Remove(remoteResult);
}
m_DBManager.Entities.SaveChanges();
}
catch (Exception ex)
{
LogItem.Type = enOnlineResultsLogItemType.Error;
LogItem.Text = string.Format("Error in HandleItem:\n{0}", ex.Message);
AddItemToLog(LogItem, Item);
DBManagerApp.MainWnd.PublishingNow = false;
return(false);
}
// Запись прошла успешно => добавляем запись в лог
LogItem.Type = enOnlineResultsLogItemType.OK;
LogItem.Text = string.Format("Group \"{0}\" round \"{1}\" has been published", GroupFullNameToPublish, roundNameToPublish);
AddItemToLog(LogItem, Item);
DBManagerApp.MainWnd.PublishingNow = false;
return(true);
}