public void OK_Click(System.Object sender, System.EventArgs e)
{
if (UsernameTextBox.Text.Trim() == "" || PasswordTextBox.Text.Trim() == "")
{
Interaction.MsgBox("Por favor, llene ambos campos!", Constants.vbInformation, "Nota");
}
else
{
Modulo1.con.Open();
var sql = "SELECT * FROM tblUser WHERE username = \'" + Modulo1.SafeSqlLiteral(UsernameTextBox.Text, 2) + "\' AND password = \'" + Modulo1.SafeSqlLiteral(PasswordTextBox.Text, 2) + "\'";
var cmd = new OleDbCommand(sql, Modulo1.con);
OleDbDataReader dr = cmd.ExecuteReader();
try
{
if (dr.Read() == false)
{
Interaction.MsgBox("Inicio de sesión fallida ¬¬", Constants.vbCritical, "Nota");
}
else
{
Interaction.MsgBox("¡Bienvenido! ツ", Constants.vbInformation, "Nota");
frmMain.Default.status.Items[0].Text = "Logueado como : " + UsernameTextBox.Text.Trim();
DateTime datenow = DateTime.Now;
frmMain.Default.status.Items[2].Text = "Fecha y Hora : " + datenow.ToString("MMMM dd, yyyy") + " " + DateAndTime.TimeOfDay;
Modulo1.con.Close();
UsernameTextBox.Clear(); PasswordTextBox.Clear(); UsernameTextBox.Focus();
this.Hide();
frmMain.Default.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Modulo1.con.Close();
}
}
public void bttnSave_Click(System.Object sender, System.EventArgs e)
{
Modulo1.con.Open();
string num = txtID.Text.Trim();
string type = txtRoomType.Text.Trim();
string rate = txtRoomRate.Text.Trim();
string occupancy = txtNoOfOccupancy.Text.Trim();
string stat = "Disponible";
if (type == null || rate == null || occupancy == null)
{
Interaction.MsgBox("Por favor llene todos los campos", Constants.vbInformation, "Nota");
}
else
{
if (bttnSave.Text == "&Guardar")
{
var sql = "SELECT * FROM tblRoom WHERE RoomNumber = " + Modulo1.SafeSqlLiteral(num, 2) + "";
var cmd = new OleDbCommand(sql, Modulo1.con);
OleDbDataReader dr = cmd.ExecuteReader();
try
{
if (dr.Read() == false)
{
OleDbCommand add_room = new OleDbCommand("INSERT INTO tblRoom(RoomNumber,RoomType,RoomRate,NoOfOccupancy,Status) values (\'" +
Modulo1.SafeSqlLiteral(num, 2) + "\',\'" +
Modulo1.SafeSqlLiteral(type, 2) + "\',\'" +
Modulo1.SafeSqlLiteral(rate, 2) + "\',\'" +
Modulo1.SafeSqlLiteral(occupancy, 2) + "\',\'" +
stat + "\')", Modulo1.con);
add_room.ExecuteNonQuery();
add_room.Dispose();
Interaction.MsgBox("Habitación Agregada!", Constants.vbInformation, "Nota");
txtID.Clear();
txtRoomType.Clear();
txtRoomRate.Clear();
txtNoOfOccupancy.Clear();
}
else
{
Interaction.MsgBox("Número de Habitación Existente!", Constants.vbExclamation, "Nota");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
OleDbCommand update_room = new OleDbCommand("UPDATE tblRoom SET RoomNumber= \'" + Modulo1.SafeSqlLiteral(num, 2) + "\',RoomType = \'" + Modulo1.SafeSqlLiteral(type, 2) + "\',RoomRate = \'" + Modulo1.SafeSqlLiteral(rate, 2) + "\',NoOfOccupancy = \'" + Modulo1.SafeSqlLiteral(occupancy, 2) + "\' WHERE ID = " + id.ToString() + "", Modulo1.con);
update_room.ExecuteNonQuery();
update_room.Dispose();
Interaction.MsgBox("Habitación Guardada!", Constants.vbInformation, "Nota");
bttnSave.Text = "&Guardar";
txtID.Clear();
txtRoomType.Clear();
txtRoomRate.Clear();
txtNoOfOccupancy.Clear();
}
}
Modulo1.con.Close();
display_room();
}