public Form1()
{
InitializeComponent();
dbContext = new VkladDb();
loadData();
}
public VkladWin(int ind)
{
index = ind;
InitializeComponent();
db = new VkladDb();
db.Vklads.Load();
FillDataGrid(ind);
}
public List <SPResult> ExecuteSP(DateTime date)
{
System.Data.SqlClient.SqlParameter param = new System.Data.SqlClient.SqlParameter("@data", date.Date);
db = new VkladDb();
var result = db.Database.SqlQuery <SPResult>("pr_report @data", new object[] { param }).ToList();
return(result);
}
public MainMenu1(int Index)
{
ind = Index;
db = new VkladDb();
db.Clients.Load();
FindFIO();
// FindBal();
InitializeComponent();
}
public ProgWin(int ind)
{
InitializeComponent();
db = new VkladDb();
db.Progs.Load();
// FillDataGrid(ind);
Progs.ItemsSource = db.Progs.ToList();
Progs.Items.Refresh();
}
public VkladAdding(int index)
{
InitializeComponent();
db = new VkladDb();
db.Vklads.Load();
db.Progs.Load();
db.Clients.Load();
k = db.Clients.ToList();
ind = index;
fill_addPage();
}
public Window121(int ind)
{
index = ind;
InitializeComponent();
db = new VkladDb();
db.Vklads.Load();
db.Progs.Load();
n = db.Vklads.Find(ind);
m = db.Progs.Find(n.Prog_FK);
n8.Text = n.DateOpen.ToString();
n9.Text = n.Balance.ToString();
n10.Text = m.name;
n11.Text = m.percent.ToString();
n12.Text = "";
m12.Text = "";
}
public WindMen(int Index)
{
ind = Index;
db = new VkladDb();
db.Clients.Load();
n = db.Clients.Find(ind);
//FindFIO();
// FindBal();
InitializeComponent();
n = db.Clients.Find(ind);
Balance.Text = n.MainBalance.ToString();
this.jojo.Text = n.FIO;
}
public ProgRepository(VkladDb dbcontext)
{
this.db = dbcontext;
}
public VkladRepository(VkladDb dbcontext)
{
this.db = dbcontext;
db.Vklads.Include("Client").Load();
}
public ClientRepository(VkladDb dbcontext)
{
this.db = dbcontext;
db.Clients.Load();
}
public VkladRepository(VkladDb dbcontext)
{
this.db = dbcontext;
db.Vklads.Load();
}
public DbDataOperation()
{
db = new VkladDb();
db.Vklads.Load();
}
public DbReposSQL()
{
db = new VkladDb();
}
