//REGISTER NEW CLIENT
private void RegisterUser_Click(object sender, RoutedEventArgs e)
{
string firstName = userName.Text + " " + userLastname.Text;
CLIENT client = new CLIENT(firstName, newUserMail.Text, newUserPassword.Password);
XmlSerializer formatter = new XmlSerializer(typeof(CLIENT));
string xml = null;
try
{
using (FileStream fs = new FileStream("../../../../xml/CLIENT/newClient.xml", FileMode.Truncate))
{
formatter.Serialize(fs, client);
}
using (FileStream fs = new FileStream("../../../../xml/CLIENT/newClient.xml", FileMode.OpenOrCreate))
{
StreamReader reader = new StreamReader(fs);
xml = reader.ReadToEnd();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
using (ClientContext db = new ClientContext())
{
try
{
var param = new SqlParameter
{
ParameterName = "@request",
SqlDbType = System.Data.SqlDbType.Xml,
Direction = System.Data.ParameterDirection.Input,
Value = xml
};
var result = db.Database.ExecuteSqlCommand("RegisterUser @request", param);
if (result == 1)
{
ReservationWindow window = new ReservationWindow(client);
window.Show();
this.Close();
}
}
catch
{
MessageBox.Show("Procedure RegisterUser @request connot be executed");
}
}
}
private void Confirm_Click(object sender, RoutedEventArgs e)
{
int ClientId = 0;
try
{
using (HotelContext db = new HotelContext())
{
string sqlQuery = "SELECT dbo.GetUserId ( {0} )";
Object[] param = { mail };
try
{
ClientId = db.Database.SqlQuery <int>(sqlQuery, param).FirstOrDefault();
}
catch
{
MessageBox.Show("Function dbo.GetUserId cannot be executed");
}
}
using (ClientContext db = new ClientContext())
{
var param1 = new SqlParameter
{
ParameterName = "@room_number",
SqlDbType = System.Data.SqlDbType.SmallInt,
Direction = System.Data.ParameterDirection.Input,
Value = number
};
var param2 = new SqlParameter
{
ParameterName = "@client_id",
SqlDbType = System.Data.SqlDbType.Int,
Direction = System.Data.ParameterDirection.Input,
Value = ClientId
};
var param3 = new SqlParameter
{
ParameterName = "@come",
SqlDbType = System.Data.SqlDbType.DateTime,
Direction = System.Data.ParameterDirection.Input,
Value = CommingDate.SelectedDate
};
var param4 = new SqlParameter
{
ParameterName = "@leave",
SqlDbType = System.Data.SqlDbType.DateTime,
Direction = System.Data.ParameterDirection.Input,
Value = LeavingDate.SelectedDate
};
try
{
var result = db.Database.ExecuteSqlCommand("BookRoom_sp @room_number, @client_id, @come, @leave", param1, param2, param3, param4);
}
catch
{
MessageBox.Show("Procedure BookRoom_sp @room_number, @client_id, @come, @leave connot be executed");
}
ReservationWindow window = new ReservationWindow(client);
window.Show();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Login_Click(object sender, RoutedEventArgs e)
{
string firstName = "UserX";
string mail = userMail.Text;
string password = userPassword.Password;
CLIENT client = new CLIENT(firstName, mail, password);
XmlSerializer formatter = new XmlSerializer(typeof(CLIENT));
string xml;
try
{
using (FileStream fs = new FileStream("../../../../xml/CLIENT/Client.xml", FileMode.Truncate))
{
formatter.Serialize(fs, client);
}
using (FileStream fs = new FileStream("../../../../xml/CLIENT/Client.xml", FileMode.Open))
{
StreamReader reader = new StreamReader(fs);
xml = reader.ReadToEnd();
}
using (ClientContext db = new ClientContext())
{
var param = new SqlParameter
{
ParameterName = "@request",
SqlDbType = System.Data.SqlDbType.Xml,
Direction = System.Data.ParameterDirection.Input,
Value = xml
};
var result = new SqlParameter
{
ParameterName = "@r",
SqlDbType = System.Data.SqlDbType.Bit,
Direction = System.Data.ParameterDirection.Output,
};
try
{
db.Database.ExecuteSqlCommand("Login_sp @request, @r out", param, result);
if ((bool)result.Value == true)
{
ReservationWindow window = new ReservationWindow(client);
window.Show();
this.Close();
}
}
catch
{
MessageBox.Show("Procedure Login_sp @request, @r out connot be executed");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
