private void RefreshWagon(object param)
{
context.Dispose();
context = new ShFluContext();
AllWag = new ObservableCollection <Wagon>(context.WagonDbSet);
NotifyPropertyChanged("AllWag");
}
public allSmgsViewModel()
{
context = new ShFluContext();
AllSmgsNakl = new ObservableCollection <SmgsNakl>(context.SmgsNaklDbSet);
EditCommand = new ViewModelCommand(Edit, true);
DeleteCommand = new ViewModelCommand(Delete, true);
}
public FindMatrixViewModel(WagInSmgs wagInSmgs, ShFluContext context)
{
this.context = context;
WagInSmgs = wagInSmgs;
AddCommand = new ViewModelCommand(Add, true);
SaveCommand = new ViewModelCommand(Save, true);
MatrixWagonList = new List <MatrixWagon>(context.MatrixWagonDbSet.Where(p => p.WagonNumberMatrix == wagInSmgs.Wagon.Nwag));
}
public FindMatrixView(WagInSmgs paramWagInSmgs, ShFluContext context)
{
DataContext = new FindMatrixViewModel(paramWagInSmgs, context);
InitializeComponent();
}
public SmgsSeriallXML(string filePatch)
{
ShFluContext context = new ShFluContext();
string[] stringFromFile = File.ReadAllLines(filePatch);
StringBuilder strResult = new StringBuilder();
foreach (var itemStringFromFile in stringFromFile)
{
strResult.Append(itemStringFromFile);
strResult.Append('\n');
}
string commentPattern3 = @"\<\?xml(\w|\W)*</doc>";
var reg = Regex.Match(strResult.ToString(), commentPattern3).ToString();
XmlDocument doc = new XmlDocument();
doc.LoadXml(reg);
XDocument xdoc = XDocument.Parse(doc.OuterXml);
SmgsNakl smgsNak = null;
foreach (XElement smgsXElement in xdoc.Root.Elements("table"))
{
if (smgsXElement.FirstAttribute.Value == "nakl")
{
//smgsNak.Smgs = Convert.ToInt32(smgsXElement.Element("data").Element("smgs").Value);
var smgs = Convert.ToInt32(smgsXElement.Element("data").Element("smgs").Value);
smgsNak = context.SmgsNaklDbSet.FirstOrDefault(p => p.Smgs == smgs);
if (smgsNak == null)
{
smgsNak = new SmgsNakl();
smgsNak.Smgs = Convert.ToInt32(smgsXElement.Element("data").Element("smgs").Value);
smgsNak.Smgsdat = Convert.ToDateTime(smgsXElement.Element("data").Element("smgsdat").Value);
smgsNak.mnet = smgsXElement.Element("data").Element("mnet").Value;
smgsNak.mbrt = smgsXElement.Element("data").Element("mbrt").Value;
}
}
if (smgsXElement.FirstAttribute.Value == "nakl_gruz")
{
smgsNak.Etsngn = smgsXElement.Element("data").Element("etsngn").Value;
smgsNak.gngc = smgsXElement.Element("data").Element("gngc").Value;
smgsNak.gngn = smgsXElement.Element("data").Element("gngn").Value;
smgsNak.etsngc = smgsXElement.Element("data").Element("etsngc").Value;
}
if (smgsXElement.FirstAttribute.Value == "nakl_vag")
{
foreach (var vagonItem in smgsXElement.Elements("data"))
{
int vagnum = Convert.ToInt32(vagonItem.Element("nwag").Value);
var insertWag = context.WagonDbSet.FirstOrDefault(p => p.Nwag == vagnum);
if (insertWag == null)
{
Wagon wag = new Wagon
{
Nwag = Convert.ToInt32(vagonItem.Element("nwag").Value),
Ownerc = vagonItem.Element("ownerc").Value,
Gp = vagonItem.Element("gp").Value,
Tara = vagonItem.Element("tara").Value
};
context.WagonDbSet.Add(wag);
}
else
{
insertWag.Nwag = Convert.ToInt32(vagonItem.Element("nwag").Value);
insertWag.Ownerc = vagonItem.Element("ownerc").Value;
insertWag.Gp = vagonItem.Element("gp").Value;
insertWag.Tara = vagonItem.Element("tara").Value;
}
if (smgsNak.SmgsId == 0)
{
WagInSmgs wgs = new WagInSmgs();
wgs.Wagon = context.WagonDbSet.Local.FirstOrDefault(p => p.Nwag == vagnum);
wgs.Tarapr = vagonItem.Element("tarapr").Value;
wgs.Weightb = vagonItem.Element("weightb").Value;
wgs.Weight = vagonItem.Element("weight").Value;
smgsNak.WagInSmgses.Add(wgs);
}
else
{
WagInSmgs wgs = smgsNak.WagInSmgses.First(p => p.Wagon.Nwag == vagnum);
wgs.Wagon = context.WagonDbSet.Local.FirstOrDefault(p => p.Nwag == vagnum);
wgs.Tarapr = vagonItem.Element("tarapr").Value;
wgs.Weightb = vagonItem.Element("weightb").Value;
wgs.Weight = vagonItem.Element("weight").Value;
}
}
}
}
if (smgsNak.SmgsId == 0)
{
context.SmgsNaklDbSet.Add(smgsNak);
}
context.SaveChanges();
}
public AllWagViewModel()
{
context = new ShFluContext();
RefreshWagonCommand = new ViewModelCommand(RefreshWagon, true);
AllWag = new ObservableCollection <Wagon>(context.WagonDbSet);
}
public OpenFromDbViewModel()
{
context = new ShFluContext();
MatrixList = new List <Matrixx>(context.MatrixxDbSet);
}
