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(); }