public AllNotamsViewModel(NotamService notamService, ObservableCollection<WorkspaceViewModel> parent, NotamFilter filter)
{
bDisplayByList = false;
ParentWorkspaces = parent;
_notamFilter = filter;
Setup(notamService, filter.notamStatus, filter);
}
private void dispatcherTimer_Tick(object sender, EventArgs e)
{
if (DateTime.Now.Hour == 5 && DateTime.Now.Minute == 30 )
{
var notamFilter = new NotamFilter();
notamFilter.notamStatus = "D" ;
notamFilter.PermEstFilter = "EST" ;
_notamService.Archive();
_notamService.Reload();
_snowtamService.Archive();
_snowtamService.Reload();
List<Notam> ExpiredNotams = _notamService.GetFilterNotams(notamFilter);
if (ExpiredNotams.Count == 0)
return;
string subPath = "c:\\AISAdmin\\"; // your code goes here
try
{
bool exists = System.IO.Directory.Exists((subPath));
if (!exists)
System.IO.Directory.CreateDirectory((subPath));
subPath += "EXPIRED\\";
exists = System.IO.Directory.Exists((subPath));
if (!exists)
System.IO.Directory.CreateDirectory((subPath));
string strNotams = "THESE FOLLOWING NOTAMS:\n";
int i = 1;
foreach (Notam nt in ExpiredNotams)
{
strNotams += (nt.Type + nt.Number + "/" + nt.Year + ",");
if ((i % 10) == 0)
strNotams += "\n";
i++;
}
strNotams += "\nSHALL BE CANCELED OR REPLACED";
var FileName = subPath + DateTime.Now.ToString("yyMMdd") + ".txt";
System.IO.File.WriteAllText(FileName, strNotams);
MessageBox.Show(strNotams, "**Caution**");
}
catch (System.Exception ex)
{
}
}
}
public void Setup(NotamService notamService, string notamStatus, NotamFilter filter)
{
if (notamService == null)
throw new ArgumentNullException("notamService");
switch(notamStatus)
{
case "A":
base.DisplayName = Entity.ArchiveNotamsViewModel_DisplayName;
break;
case "H":
base.DisplayName = Entity.HoldNotamsViewModel_DisplayName;
break;
case "AD":
base.DisplayName = Entity.AllArchAndValidNotamsViewModel_DisplayName;
break;
default:
base.DisplayName = Entity.AllNotamsViewModel_DisplayName;
break;
}
_notamService = notamService;
// Subscribe for notifications of when a new customer is saved.
_notamService.NotamAdded += this.OnNotamAddedToRepository;
_notamService.NotamDeleted += this.OnNotamDeletedFromRepository;
// Reload += this.OnReload;
// Populate the AllCustomers collection with CustomerViewModels.
_notamStatus = notamStatus;
if (filter != null)
this.GetFilterNotams(filter);
else
this.CreateAllNotams(notamStatus);
}
public List<Notam> GetFilterNotams(NotamFilter notamFilter)
{
List<Notam> result = new List<Notam>();
Reload();
List<Notam> sourceNotams = _Notams;
if (notamFilter.notamStatus == "A")
sourceNotams = _ArchNotams;
else if (notamFilter.notamStatus == "H")
sourceNotams = _HoldNotams;
else if (notamFilter.notamStatus == "AD")
sourceNotams = GetAllNotams();
if (_dataContext != null)
{
try
{
result = sourceNotams.Where(
n => (String.IsNullOrEmpty(notamFilter.TypeFilter) || n.Type.Equals(notamFilter.TypeFilter))).Where(
n =>
(String.IsNullOrEmpty(notamFilter.NumberFilter) || (!String.IsNullOrEmpty(n.Number) && n.Number.Equals(notamFilter.NumberFilter)))).Where(
n => (String.IsNullOrEmpty(notamFilter.YearFilter) || n.Year.Equals(notamFilter.YearFilter))).Where(
n =>
(String.IsNullOrEmpty(notamFilter.NotamCodeFilter) || (n.NotamCode != null && (n.NotamCode.ToString() == (notamFilter.NotamCodeFilter))))).
Where(
n =>
(String.IsNullOrEmpty(notamFilter.NotamAeroFilter) || (!String.IsNullOrEmpty(n.FirAero) && (n.FirAero).Equals(notamFilter.NotamAeroFilter))))
.Where(n => (String.IsNullOrEmpty(notamFilter.FromDateFilter) || long.Parse(n.FromDate) >= long.Parse(notamFilter.FromDateFilter)))
.Where(n => (String.IsNullOrEmpty(notamFilter.ToDateFilter) || (!String.IsNullOrEmpty(n.ToDate) && long.Parse(n.ToDate) <= long.Parse(notamFilter.ToDateFilter))))
.Where(n => (String.IsNullOrEmpty(notamFilter.ItemEFilter) || (!String.IsNullOrEmpty(n.EFreeText)) && n.EFreeText.Contains(notamFilter.ItemEFilter)))
.Where(n => (String.IsNullOrEmpty(notamFilter.NotamFirFilter) || (n.FIR != null) && n.FIR.Code.Equals(notamFilter.NotamFirFilter)))
.Where(n => (String.IsNullOrEmpty(notamFilter.TrafficFilter) || (n.NotamCode != null && !String.IsNullOrEmpty(n.NotamCode.Traffic)) && n.NotamCode.Traffic.Equals(notamFilter.TrafficFilter)))
.Where(n => (String.IsNullOrEmpty(notamFilter.PurposeFilter) || (n.NotamCode != null && !String.IsNullOrEmpty(n.NotamCode.Purpose)) && n.NotamCode.Purpose.Equals(notamFilter.PurposeFilter)))
.Where(n => (String.IsNullOrEmpty(notamFilter.ScopeFilter) || (n.NotamCode != null && !String.IsNullOrEmpty(n.NotamCode.Scope)) && n.NotamCode.Scope.Equals(notamFilter.ScopeFilter)))
.Where(n => (String.IsNullOrEmpty(notamFilter.SendTimeFilter) || (!String.IsNullOrEmpty(n.SendTime) && long.Parse(n.SendTime) >= long.Parse(notamFilter.SendTimeFilter))))
.Where(n => (String.IsNullOrEmpty(notamFilter.SendTimeEndFilter) || (!String.IsNullOrEmpty(n.SendTime) && long.Parse(n.SendTime) <= long.Parse(notamFilter.SendTimeEndFilter))))
.Where(n => (String.IsNullOrEmpty(notamFilter.PermEstFilter) || (!String.IsNullOrEmpty(n.PermEst)) && n.PermEst.Equals(notamFilter.PermEstFilter)))
.Where(n => (String.IsNullOrEmpty(notamFilter.PermEstFilter) || notamFilter.PermEstFilter.Equals("PERM") || (notamFilter.PermEstFilter.Equals("EST") && !(string.IsNullOrEmpty(n.ToDate))
&& n.PermEst.Equals(notamFilter.PermEstFilter) && long.Parse(n.ToDate) <= long.Parse(DateTime.Now.ToString("yyMMddHHmm")))))
.ToList();
if (!string.IsNullOrEmpty( notamFilter.UserFilter))
{
NotamDetailService notamDetailService = new NotamDetailService(_dataContext);
result= notamDetailService.FilterByUser(result, notamFilter.UserFilter);
}
}
catch (System.Exception ex)
{
string s = ex.Message;
}
}
return result;
}
void CheckListSummary()
{
NotamFilter filter = new NotamFilter();
filter.NotamFirFilter = (FIR == null) ? "" : FIR.Code;
filter.NotamAeroFilter = (Aerodom == null) ? "" : Aerodom.Code;
filter.TypeFilter = Type;
filter.YearFilter = Year;
filter.FromDateFilter = From;
filter.ToDateFilter = To;
List<IntlNotam> notamList = _notamService.GetFilterNotams(filter);
if (notamList == null)
return;
if (notamList.Count == 0)
{
MessageBox.Show("No Result");
return;
}
try
{
var queryYear = notamList.GroupBy(item => item.Year).Select(group =>
new
{
Year = group.Key,
nums = group.OrderBy(x => x.Number)
}).OrderBy(group => group.Year);
// newTable.Rows.Add(newTable.Rows[1]);
int icol = 1;
string strItemE = "CHECKLIST:";
foreach (var yearItem in queryYear)
{
strItemE += "\r\nYEAR 20" + yearItem.Year + ": ";
foreach (var nt in yearItem.nums)
{
strItemE += nt.Number + " ";
icol++;
if (icol > 11)
{
icol = 1;
strItemE += "\r\n ";
}
}
icol = 1;
}
strItemE += "\r\nLATEST PUBLICATIONS: ";
NOTAM.SERVICE.Model.Notam newNotam = NOTAM.SERVICE.Model.Notam.CreateNewRNotam();
newNotam.NotamCode = _notamcodeService.GetNotamCodes().Where(o => (o.Subject + o.Condition).Equals("KKKK")).FirstOrDefault();
List<Notam> AllNotams = _notamServiceLocal.GetAllNotams();
Notam ntm = AllNotams.Where(m => (m.NotamCode == newNotam.NotamCode)).OrderByDescending(x => x.Number).FirstOrDefault();
newNotam.Type = "A";
if (ntm != null)
{
newNotam.RefId = ntm.Id;
newNotam.RefNum = ntm.Number;
newNotam.RefYear = ntm.Year;
newNotam.RefType = ntm.Type;
newNotam.Type = ntm.Type;
newNotam.FirAero = ntm.FirAero;
}
newNotam.EFreeText = strItemE;
NotamViewModel workspace = new NotamViewModel(newNotam, _notamServiceLocal, parentWorkSpaces);
parentWorkSpaces.Add(workspace);
this.SetActiveWorkspace(workspace);
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message);
}
}
void GenerateBlancReport()
{
var rptBuilder = new StringBuilder();
NotamFilter filter = new NotamFilter();
filter.NotamFirFilter = FIR.Code;
filter.TypeFilter = Type;
filter.YearFilter = Year;
filter.FromDateFilter = FromDate;
filter.ToDateFilter = ToDate;
filter.FromNumberFilter = From;
filter.ToNumberFilter = To;
filter.notamStatus = "AD";
List<IntlNotam> ListResult = _notamService.GetFilterNotams(filter).OrderBy(t => t.Number).ToList();
if (ListResult.Count == 0)
{
MessageBox.Show("No Result");
return;
}
string str = "Result For FIR=" + FIR.Code + Environment.NewLine;
rptBuilder.Append(str);
// str = "Valid Notams:" + Environment.NewLine;
// rptBuilder.Append(str);
// str = AddValidNotamStr(ListResult);
// rptBuilder.Append(str);
str = "Blanc Notams:" + Environment.NewLine;
rptBuilder.Append(str);
str = AddBlancNotamStr(ListResult);
rptBuilder.Append(str);
_ReportResult = rptBuilder.ToString();
base.OnPropertyChanged("ReportResult");
}
void DisplayInGrid(NotamFilter filter)
{
AllIntlNotamsViewModel workspace =
parentWorkSpaces.FirstOrDefault(vm => vm is AllIntlNotamsViewModel)
as AllIntlNotamsViewModel;
//if (workspace == null)
//{
workspace = new AllIntlNotamsViewModel(_notamService, parentWorkSpaces,filter);
parentWorkSpaces.Add(workspace);
// }
this.SetActiveWorkspace(workspace);
}
void DisplayArchiveNotams()
{
NotamFilter filter = new NotamFilter();
filter.NotamFirFilter = (FIR == null) ? "" : FIR.Code;
filter.NotamAeroFilter = (Aerodom == null) ? "" : Aerodom.Code;
filter.TypeFilter = Type;
filter.YearFilter = Year;
filter.FromDateFilter = From;
filter.ToDateFilter = To;
filter.notamStatus = "A";
List<IntlNotam> ListResult = _notamService.GetFilterNotams(filter);
if (ListResult == null)
return;
if (ListResult.Count == 0)
{
MessageBox.Show("No Result");
return;
}
DisplayInGrid(filter);
}
void RunReport()
{
NotamFilter filter = new NotamFilter();
filter.NotamFirFilter = (FIR==null) ? "":FIR.Code;
filter.NotamAeroFilter = (Aerodom==null) ? "":Aerodom.Code;
filter.TypeFilter = Type;
filter.YearFilter = Year;
filter.FromDateFilter = From;
filter.ToDateFilter = To;
List<IntlNotam> ListResult = _notamService.GetFilterNotams(filter);
if (ListResult == null)
return;
if (ListResult.Count == 0)
{
MessageBox.Show("No Result");
return;
}
var ntmBuilder = new StringBuilder();
string str = "";
#region Header
str = "Date : " + System.DateTime.Now.ToLongDateString() + Environment.NewLine;
ntmBuilder.Append(str);
str = "Time : " + System.DateTime.Now.ToLongTimeString() + Environment.NewLine;
ntmBuilder.Append(str);
ntmBuilder.Append("Base on following query" + Environment.NewLine);
ntmBuilder.Append("ORIGIN : " +OriginItem+ Environment.NewLine);
ntmBuilder.Append("FIR : " + (FIR==null ? "": FIR.Code) +Environment.NewLine);
ntmBuilder.Append("Aerodome :" + (Aerodom==null? "":Aerodom.Code )+ Environment.NewLine);
ntmBuilder.Append("Type : " +Type+ Environment.NewLine);
ntmBuilder.Append("Year : " + Year + Environment.NewLine);
ntmBuilder.Append("==============================================================" + Environment.NewLine);
#endregion
foreach (IntlNotam notam in ListResult)
{
ntmBuilder.Append("__________________________________________________________________" + Environment.NewLine);
str = GenerateNotamText(notam);
ntmBuilder.Append(str + Environment.NewLine);
}
_ReportResult = ntmBuilder.ToString();
base.OnPropertyChanged("ReportResult");
}
/// <summary>
/// Saves the customer to the repository. This method is invoked by the SaveCommand.
/// </summary>
public void Search()
{
if (!ValidateType())
return;
var notamFilter = new NotamFilter();
if(Type!=null )
notamFilter.TypeFilter = (Type.Equals("A") ||Type.Equals("B"))? Type: string.Empty ;
notamFilter.NumberFilter = NotamNum ;
notamFilter.YearFilter = NotamYear;
notamFilter.NotamCodeFilter =(IsQCode && QCode != null) ? QCode.ToString() : string.Empty;
notamFilter.NotamAeroFilter =(IsAD && Aerodom!=null)?Aerodom.Code: string.Empty ;
notamFilter.notamStatus = IsValid ? "D" : "A";
notamFilter.notamStatus = IsHold ? "H" : notamFilter.notamStatus;
notamFilter.notamStatus = IsAllNotams ? "AD" : notamFilter.notamStatus;
notamFilter.ItemEFilter = EFreeText;
notamFilter.NotamFirFilter = FIR!=null?FIR.Code:string.Empty ;
notamFilter.ScopeFilter = IsQualifier? Scope: string.Empty ;
notamFilter.PurposeFilter =IsQualifier ? Purpose: string.Empty ;
notamFilter.TrafficFilter =IsQualifier ? Traffic: string.Empty ;
notamFilter.PermEstFilter = IsPerm ? "PERM" : IsEst ? "EST" : string.Empty;
notamFilter.FromDateFilter = FromDate;
notamFilter.ToDateFilter = ToDate;
notamFilter.UserFilter = UserText;
notamFilter.SendTimeFilter = FromIssueDate;
notamFilter.SendTimeEndFilter = ToIssueDate;
_notamService.Archive();
_notamService.Reload();
AllNotamsViewModel workspace =
parentWorkSpaces.FirstOrDefault(vm => vm is AllNotamsViewModel)
as AllNotamsViewModel;
//if (workspace == null)
//{
workspace = new AllNotamsViewModel(_notamService, parentWorkSpaces, notamFilter );
string strTitle = Entity.AllNotamsViewModel_DisplayName;
if (notamFilter.notamStatus == "A")
strTitle = Entity.MainWindowViewModel_Command_ViewAllArchiveNotams;
if (notamFilter.notamStatus == "H")
strTitle = Entity.MainWindowViewModel_Command_ViewAllHoldNotams;
if (notamFilter.notamStatus == "AD")
strTitle = Entity.AllArchAndValidNotamsViewModel_DisplayName;
foreach (var obj in this.parentWorkSpaces)
{
if (obj.DisplayName == strTitle)
{
parentWorkSpaces.Remove(obj);
break;
}
}
this.parentWorkSpaces.Add(workspace);
// }
this.SetActiveWorkspace(workspace);
}
void GetFilterNotams(NotamFilter notamfilter)
{
strUser = notamfilter.UserFilter;
if (AllNotams != null)
this.AllNotams.Clear();
else
AllNotams = new ObservableCollection<NotamViewModel>();
List<NotamViewModel> all =
(from cust in _notamService.GetFilterNotams(notamfilter)
select new NotamViewModel(cust, _notamService, ParentWorkspaces)).ToList();
foreach (NotamViewModel cvm in all)
{
cvm.PropertyChanged += this.OnNotamViewModelPropertyChanged;
this.AllNotams.Add(cvm);
}
//this.AllNotams = new ObservableCollection<NotamViewModel>(all);
this.AllNotams.CollectionChanged += this.OnCollectionChanged;
}
void GetFilterNotams()
{
var notamfilter = new NotamFilter();
notamfilter.TypeFilter = TypeFilter;
notamfilter.NumberFilter = NumberFilter;
notamfilter.YearFilter = YearFilter;
notamfilter.NotamCodeFilter = NotamCodeFilter;
notamfilter.NotamAeroFilter = NotamAeroFilter;
notamfilter.notamStatus = _notamStatus;
notamfilter.ItemEFilter = _itemEFilter;
if (_notamFilter != null)
{
notamfilter.TypeFilter = TypeFilter ?? _notamFilter.TypeFilter;
notamfilter.NumberFilter = NumberFilter ?? _notamFilter.NumberFilter;
notamfilter.YearFilter = YearFilter ?? _notamFilter.YearFilter;
notamfilter.NotamCodeFilter = NotamCodeFilter ?? _notamFilter.NotamCodeFilter;
notamfilter.NotamAeroFilter = NotamAeroFilter ?? _notamFilter.NotamAeroFilter;
notamfilter.notamStatus = _notamStatus ?? _notamFilter.notamStatus;
notamfilter.ItemEFilter = _itemEFilter ?? _notamFilter.ItemEFilter;
}
GetFilterNotams(notamfilter);
}
private void OnReload(object sender, IList<Notam> e)
{
var notamfilter = new NotamFilter();
notamfilter.TypeFilter = TypeFilter;
notamfilter.NumberFilter = NumberFilter;
notamfilter.YearFilter = YearFilter;
notamfilter.NotamCodeFilter = NotamCodeFilter;
List<NotamViewModel> all =
(from cust in _notamService.GetFilterNotams(notamfilter)
select new NotamViewModel(cust, _notamService)).ToList();
foreach (NotamViewModel cvm in all)
cvm.PropertyChanged += this.OnNotamViewModelPropertyChanged;
this.AllNotams.Clear();
// this.AllNotams = new ObservableCollection<NotamViewModel>(all);
}
void RunSummary()
{
NotamFilter filter = new NotamFilter();
filter.TypeFilter = NType;
filter.FromDateFilter = FromDate;
filter.ToDateFilter = ToDate;
_notamService.Archive();
List<Notam> notamList = _notamService.GetFilterNotams(filter);
List<string> aeroList = notamList.Select(x => x.FirAero).ToList<string>();
Dictionary<string, string> aeroDic = _aerodomService.GetAddressList(aeroList);
object fileName = System.Configuration.ConfigurationManager.AppSettings.Get("DocTemplatePath").ToString();
Word.Application word = new Word.Application();
Word.Document doc = new Word.Document();
object missing = System.Type.Missing;
try
{
doc = word.Documents.Open(ref fileName, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
doc.Activate();
string newFileName = fileName.ToString();
newFileName = newFileName.Replace(".docx", "1.docx");
doc.SaveAs(newFileName);
Process.Start(newFileName.ToString());
int icol = 2, irow = 1;
var queryYear = notamList.GroupBy(item => item.Year).Select(group =>
new
{
Year = group.Key,
nums = group.OrderBy(x => x.Number)
}).OrderBy(group => group.nums.First().Number);
Word.Table newTable = doc.Application.ActiveDocument.Tables[1];
// newTable.Rows.Add(newTable.Rows[1]);
foreach (var yearItem in queryYear)
{
newTable.Cell(irow, 1).Range.Text = "20" + yearItem.Year + ":";
foreach (var nt in yearItem.nums)
{
if (icol > 14)
{
icol = 2;
irow++;
newTable.Rows.Add(ref missing);
}
if (nt.Number!=null)
newTable.Cell(irow, icol).Range.Text = nt.Number.ToString();
doc.Save();
icol++;
}
irow++;
icol = 2;
newTable.Rows.Add(ref missing);
doc.Save();
}
//add0519
var queryAero = notamList.Where(x => x.FirAero!=null).GroupBy(item => item.FirAero).Select(group =>
new
{
Aero = group.Key,
Addr = aeroDic.ContainsKey(group.Key) ? aeroDic[group.Key]:"",
nums = group.OrderBy(x => x.Number)
}).OrderBy(group => group.Addr);
Word.Table secTable = doc.Application.ActiveDocument.Tables[2];
irow = 1;
// newTable.Rows.Add(newTable.Rows[1]);
foreach (var aeroItem in queryAero)
{
secTable.Rows.Add(ref missing);
irow++;
secTable.Cell(irow, 3).Range.Font.Size = 11;
secTable.Cell(irow, 3).Range.Font.Bold = 1;
secTable.Cell(irow, 3).Range.Font.Italic = 1;
string strAeroCity = aeroItem.Addr;
secTable.Cell(irow, 3).Range.Text = strAeroCity + "." + aeroItem.Aero;
doc.Save();
foreach (var nt in aeroItem.nums)
{
secTable.Rows.Add(ref missing);
irow++;
secTable.Cell(irow, 1).Range.Font.Bold = 0;
secTable.Cell(irow, 1).Range.Font.Italic = 0;
secTable.Cell(irow, 1).Range.Font.Size = 10;
if (nt.Number!=null)
secTable.Cell(irow, 1).Range.Text = nt.Type+ nt.Number.ToString();
secTable.Cell(irow, 2).Range.Font.Bold = 0;
secTable.Cell(irow, 2).Range.Font.Italic = 0;
secTable.Cell(irow, 2).Range.Font.Size = 10;
if (nt.FromDate!=null)
secTable.Cell(irow, 2).Range.Text = nt.FromDate.Substring(0, 6);
string str = nt.FromDate + "/" + nt.ToDate + "/" + nt.PermEst + "\n";
string iteme = nt.EFreeText;
secTable.Cell(irow, 3).Range.Font.Bold = 0;
secTable.Cell(irow, 3).Range.Font.Italic = 0;
secTable.Cell(irow, 3).Range.Font.Size = 9;
secTable.Cell(irow, 3).Range.Text = str + iteme;
doc.Save();
}
}
doc.Save();
MessageBox.Show("Summary created successfully.");
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message);
}
}
public List<Snowtam> GetFilterSnowtams(NotamFilter notamFilter)
{
List<Snowtam> result = null;
if (this._dataContext != null)
{
}
return result;
}
