public ClientsWindow(MainWindow mw)
{
InitializeComponent();
p = new List <byte[]>();
this.mw = mw;
try
{
using (ReseptionistContext db = new ReseptionistContext())
{
var users = db.Database.SqlQuery <CLIENT>("SELECT * FROM SelectFromUsers()").ToList();
List <Clent> list = new List <Clent>();
foreach (CLIENT u in users)
{
p.Add(u.PASWRD);
list.Add(new Clent(u.ID, u.FIRST_NAME, u.MAIL, BitConverter.ToString(u.PASWRD).Replace("-", string.Empty)));
}
ClientsGrid.ItemsSource = list;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public MainWindow()
{
InitializeComponent();
using (ReseptionistContext db = new ReseptionistContext())
{
Object[] param = { };
try
{
db.Database.ExecuteSqlCommand("SetClientServivesIrrelevant", param);
db.Database.ExecuteSqlCommand("SetClientsRoomsAvaliable", param);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void Income_Click(object sender, RoutedEventArgs e)
{
using (ReseptionistContext db = new ReseptionistContext())
{
var param1 = new SqlParameter
{
ParameterName = "@start",
SqlDbType = System.Data.SqlDbType.DateTime,
Direction = System.Data.ParameterDirection.Input,
Value = Start.SelectedDate
};
var param2 = new SqlParameter
{
ParameterName = "@end",
SqlDbType = System.Data.SqlDbType.DateTime,
Direction = System.Data.ParameterDirection.Input,
Value = Stop.SelectedDate
};
var param3 = new SqlParameter
{
ParameterName = "@income",
SqlDbType = System.Data.SqlDbType.Money,
Direction = System.Data.ParameterDirection.Output
};
try
{
db.Database.ExecuteSqlCommand("DeterminateIncome_sp @start, @end, @income out", param1, param2, param3);
Header.Text = $"Income \n\r from {Start.SelectedDate} to {Stop.SelectedDate} \n\r equals:";
Result.Text = param3.Value.ToString();
}
catch
{
MessageBox.Show("Procedure DeterminateIncome_sp @start, @end, @income out cannot be executed");
}
}
}
private void Bill_Click(object sender, RoutedEventArgs e)
{
ClientsWindow clientsWindow = new ClientsWindow(this);
clientsWindow.ShowDialog();
using (ReseptionistContext db = new ReseptionistContext())
{
var param1 = new SqlParameter
{
ParameterName = "@clientId",
SqlDbType = System.Data.SqlDbType.Int,
Direction = System.Data.ParameterDirection.Input,
Value = int.Parse(Id.Text)
};
var param2 = new SqlParameter
{
ParameterName = "@bill",
SqlDbType = System.Data.SqlDbType.Money,
Direction = System.Data.ParameterDirection.Output
};
try
{
db.Database.ExecuteSqlCommand("GetClientBill @clientId, @bill out", param1, param2);
}
catch
{
MessageBox.Show("Procedure GetClientBill @clientId, @bill out cannot be executed");
}
Result.Text = param2.Value.ToString();
}
}
