public ContractsPage()
{
DataEntitiesContracts = new SportsEntities();
InitializeComponent();
ListContracts = new ObservableCollection <Contract>();
}
public wNewClient(ObservableCollection <Client> clilist)
{
db = new SportsEntities();
InitializeComponent();
spfac = new SPORTSFACTORY();
this.ClientList = clilist;
}
private void Save_Table_Click(object sender, RoutedEventArgs e)
{
SportsEntities db = new SportsEntities();
var clients = from c in db.Clients
select new
{
c.ClientId,
c.Family,
c.Name,
c.ThirdName,
c.Adress,
c.Phone,
};
XElement xlinq = new XElement("Client",
from c in db.Clients.AsEnumerable()
select new XElement("Client",
new XAttribute("ClientId", c.ClientId),
new XElement("Family", c.Family),
new XElement("Name", c.Name),
new XElement("ThirdName", c.ThirdName),
new XAttribute("Adress", c.Adress),
new XAttribute("Phone", c.Phone)));
xlinq.Save("NewXML.xml");
Console.WriteLine(xlinq);
Console.Read();
}
public wNewServices(ObservableCollection <Service> servicelist)
{
db = new SportsEntities();
InitializeComponent();
spfac = new SPORTSFACTORY();
this.ServiceList = servicelist;
}
public wNewTrainers(ObservableCollection <Trainer> tralist)
{
db = new SportsEntities();
InitializeComponent();
spfac = new SPORTSFACTORY();
this.TrainerList = tralist;
}
private void SaveDatabase(object sender, RoutedEventArgs e)
{
SportsEntities db = new SportsEntities();
XDocument xlinq = new XDocument(new XElement("Client",
from c in db.Clients.AsEnumerable()
select new XElement("Client",
new XAttribute("ClientId", c.ClientId),
new XElement("Family", c.Family),
new XElement("Name", c.Name),
new XElement("ThirdName", c.ThirdName),
new XElement("Adress", c.Adress),
new XElement("Phone", c.Phone))));
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "XML files (*.xml)|*.xml";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.FileName = null;
saveFileDialog.Title = "Save path of the file to be exported";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
xlinq.Save(saveFileDialog.FileName);
}
}
public JsonResult <Driver> Drivers(int id)
{
var context = new SportsEntities();
var driverRepos = new Repository <Driver>(context);
var driver = driverRepos.Find(id);
return(Json(driver));
}
public JsonResult <List <Driver> > Drivers()
{
var context = new SportsEntities();
var driverRepos = new Repository <Driver>(context);
var driverList = driverRepos.FindAll();
return(Json(driverList.ToList()));
}
public wNewContract(ObservableCollection <Contract> contractlist)
{
InitializeComponent();
Db = new SportsEntities();
spfac = new SPORTSFACTORY();
this.contractList = contractlist;
dpDateStart.DisplayDateStart = DateTime.Now;
dpDateEnd.DisplayDateStart = DateTime.Now;
}
public void MyPie_OnLoaded(object sender, RoutedEventArgs e)
{
using (var db = new SportsEntities())
{
MyCollection = new ObservableCollection <object>();
var query = from c in db.Contracts
from x in db.Trainers
where c.TrainerId == x.TrainerId
group c by x.Family
into g
select new { Name = g.Key, ClientCount = g.Count() };
foreach (var item in query)
{
MyCollection.Add(item);
}
((PieSeries)MyPie.Series[0]).ItemsSource = MyCollection;
}
}
public static void ClientValid()
{
SportsEntities db = new SportsEntities();
if (!Regex.IsMatch("Family", RagexMask.FioMask))
{
MessageBox.Show(ErrorList.Surname);
return;
}
if (!Regex.IsMatch("Name", RagexMask.FioMask))
{
MessageBox.Show(ErrorList.Name);
return;
}
if (!Regex.IsMatch("ThirdName", RagexMask.FioMask))
{
MessageBox.Show(ErrorList.PatronymicName);
return;
}
if (!Regex.IsMatch("Adress", RagexMask.AddressMask))
{
MessageBox.Show(ErrorList.Address);
return;
}
if (!Regex.IsMatch("Phone", RagexMask.PhoneMask))
{
MessageBox.Show(ErrorList.Phone);
return;
}
if (db.Clients.Where(i => i.Family == "Family").FirstOrDefault() != null &&
db.Clients.Where(i => i.Name == "Name").FirstOrDefault() != null &&
db.Clients.Where(i => i.ThirdName == "ThirdName").FirstOrDefault() != null)
{
MessageBox.Show("Такой клиент уже есть в базе!");
return;
}
}
public SPORTSDATALAYER()
{
db = new SportsEntities();
}
public Services()
{
DataEntitiesServices = new SportsEntities();
InitializeComponent();
ListServices = new ObservableCollection <Service>();
}
public Clients()
{
DataEntitiesClients = new SportsEntities();
InitializeComponent();
ListClients = new ObservableCollection <Client>();
}
public Trainers()
{
DataEntitiesTrainers = new SportsEntities();
InitializeComponent();
ListTrainers = new ObservableCollection <Trainer>();
}
public SelectedPage()
{
InitializeComponent();
ListClients = new ObservableCollection <Client>();
db = new SportsEntities();
}
