public ApplicationViewModel(IDbRepository crud, NavigationService nav)
{
this.nav = nav;
this.crud = crud;
/* List<TimeSlotModel> tsm;
* TimeSlots = new List<TimeSlotViewModel>();
* scheduleTable = new DataTable();
* DataColumn column = new DataColumn();
* DataRow row;
* column.ColumnName = "Time";
* column.DataType = Type.GetType("System.String");
* scheduleTable.Columns.Add(column);
* for (TimeSpan t = new TimeSpan(9, 0, 0); t < new TimeSpan(13, 0, 0); t.Add(new TimeSpan(0, 30, 0)))
* {
* row = scheduleTable.NewRow();
* row["Time"] = t.ToString();
* }
* DateTime date1 = new DateTime(2019, 10, 30);
* DateTime date2 = new DateTime(2019, 10, 31);
* List<WorkDayModel> wdm = apSer.SelectWorkDay(3);
* foreach(WorkDayModel workDay in wdm)
* {
* column = new DataColumn();
* column.DataType = Type.GetType("System.Bool");
*
* tsm = schedule.GetTimeSlots(workDay.WorkDayId);
* }*/
}
public PlanForMonthsViewModel(DBDataOperation myBd, Window w2)
{
bd = myBd;
w = w2;
SelectedMonth = DateTime.Now;
}
public PlanForYearsViewModel(DBDataOperation myBd, Window w2)
{
bd = myBd;
w = w2;
SelectedYear = DateTime.Now;
}
public MainWindow()
{
InitializeComponent();
var kernel = new Ninject.StandardKernel(new NinjectRegistrations());
bd = new DBDataOperation();
DataContext = new ApplicationViewModel(bd, MainFrame.NavigationService);
}
public RegistrationView(DBDataOperation myBd, Window w2)
{
bd = myBd;
Name = "";
Surname = "";
Login = "";
Password = "";
Password2 = "";
thisW = w2;
}
public EditMyProfileViewModel(DBDataOperation myBd, Window w2, int past)
{
bd = myBd;
pastPage = past;
user = bd.GetUSER(App.id);
Name = user.name;
Surname = user.surname;
Login = user.login;
Password = user.password;
thisW = w2;
}
public ExpenseView(DBDataOperation myBd, System.Windows.Window w2)
{
bd = myBd;
ExpenseGuide = bd.GetEXPENSE_GUIDE();
EXPENSEDate = DateTime.Now;
EXPENSESize = "0";
EXPENSEDate2 = DateTime.Now;
EXPENSEDate1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
ExpenseDataGrid = bd.GetEXPENSESELECT(EXPENSEDate1, EXPENSEDate2, App.id);
w = w2;
double r = 0;
for (int i = 0; i < ExpenseDataGrid.Count; i++)
{
r += (double)ExpenseDataGrid[i].expense_size;
}
EXPENSESum = "Итого " + r.ToString();
}
public IncomeView(DBDataOperation myBd, System.Windows.Window w2)
{
bd = myBd;
IncomeGuide = bd.GetINCOME_GUIDE();
iNCOMEDate = DateTime.Now;
iNCOMESize = "0";
iNCOMEDate2 = DateTime.Now;
iNCOMEDate1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
IncomeDataGrid = bd.GetINCOMESELECT(iNCOMEDate1, iNCOMEDate2, App.id);
w = w2;
double r = 0;
for (int i = 0; i < IncomeDataGrid.Count; i++)
{
r += (double)IncomeDataGrid[i].income_size;
}
iNCOMESum = "Итого " + r.ToString();
}
public IncomeViewModel(DBDataOperation myBd, Window w2)
{
bd = myBd;
IncomeGuide = bd.GetALLINCOME_GUIDES(App.id);
iNCOMEDate = DateTime.Now;
iNCOMESize = "0";
iNCOMEDate2 = DateTime.Now;
iNCOMEDate1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, App.id);
IncomeDataGrid = bd.GetALLINCOMESSELECT(iNCOMEDate1, iNCOMEDate2, App.id);
w = w2;
double r = 0;
if (IncomeDataGrid != null)
{
for (int i = 0; i < IncomeDataGrid.Count; i++)
{
r += (double)IncomeDataGrid[i].income_size;
}
}
iNCOMESum = "Итог за выбранный период: " + r.ToString();
}
public EditMyProfileView(DBDataOperation myBd, Window w2)
{
bd = myBd;
user = bd.GetUSER(App.id)[0];
Name = user.name;
Surname = user.surname;
Login = user.login;
Password = user.password;
Limit = user.limit_size.ToString();
thisW = w2;
DateTime Date2 = DateTime.Now;
DateTime Date1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
List <Order> or = bd.GetEXPENSESELECT(Date1, Date2, App.id);
double r = 0;
for (int i = 0; i < or.Count; i++)
{
r += (double)or[i].expense_size;
}
Limit2 = Convert.ToDouble(Limit) - r;
}
public EditSourcesOfIncomeViewModel(DBDataOperation myBd, System.Windows.Window w2)
{
bd = myBd;
SourceOfIncomeDataGrid = bd.GetALLINCOME_GUIDES(App.id);
w = w2;
}
public MainWindowsViewModel(DBDataOperation myBd, Window w2)
{
bd = myBd;
w = w2;
}
public EditSourcesOfExpenseViewModel(DBDataOperation myBd, System.Windows.Window w2)
{
bd = myBd;
SourceOfExpenseDataGrid = bd.GetALLEXPENSE_GUIDES(App.id);
w = w2;
}
public DealService(DBDataOperation db)
{
this.db = db;
}
