public Boolean login(Entity.EntLogin e)
{
query = "Select id_user, password From tb_admin " +
"Where id_user = '******' AND password = '******'";
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if ((reader.GetString(0).ToString() == e.User) &&
(reader.GetString(1).ToString() == e.Password))
{
status = true;
}
else
{
status = false;
}
}
connection.Close();
return(status);
}
public Boolean Login(Entity.EntLogin e)
{
query = "SELECT id_staff, password FROM tb_staff " +
"WHERE id_staff = '" + e.getKode() + "' AND password = '******'";
koneksi.Open();
MySqlCommand command = koneksi.CreateCommand();
command.CommandText = query;
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if ((reader.GetString(0).ToString() == e.getKode()) &&
(reader.GetString(1).ToString() == e.getPassword()))
{
status = true;
}
else
{
status = false;
}
}
koneksi.Close();
return(status);
}
public FrmDashboard()
{
loading = new View.FrmLoading();
login = new Entity.EntLogin();
InitializeComponent();
rtBox.ReadOnly = true;
}
public Boolean Login(Entity.EntLogin e)
{
query = "SELECT NIP, Pwd FROM Guru WHERE NIP = '" + e.getNIP() + "'AND Pwd = '" + e.getPwd() + "'";
koneksi.Open();
SqlCommand command = koneksi.CreateCommand();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if ((reader.GetString(0).ToString() == e.getNIP()) &&
(reader.GetString(1).ToString() == e.getPwd()))
{
status = true;
}
else
{
status = false;
}
}
koneksi.Close();
return(status);
}
public FrmInputCalon()
{
cln = new Entity.EntCalon();
login = new Entity.EntLogin();
clnDao = Factory.FactLogin.GetInterfaceCalon();
InitializeComponent();
AturText(false);
AturButton(true);
}
public void InputQuery(Entity.EntLogin e) //fungsi memasukan data login ke tabel presensi
{
Fungsi.CodeGenerate objcode = new Fungsi.CodeGenerate(); //objek pembuatan kode baru
string newcode = objcode.NewCode("Presensi");
koneksi.Open();
// catat pada presensi kode pegawai yang login dan waktu login (sekarang)
query = "insert into Presensi values('" + newcode + "', '" + e.Kode + "', '" + DateTime.Now.ToString(@"MM/dd/yyyy HH") + ':' + DateTime.Now.ToString(@"mm") + ':' + DateTime.Now.ToString(@"ss") + "', '')";
SqlCommand command = koneksi.CreateCommand();
command.CommandText = query;
command.ExecuteNonQuery();
koneksi.Close();
}
public Boolean Login(Entity.EntLogin e) //fungsi login berdasarkan data di database. Kode = No Pegawai. Password = Nama Pegawai
{
query = "SELECT No_Pegawai, Nama FROM Pegawai WHERE No_Pegawai = '" + e.Kode + "' AND Nama = '" + e.Password + "'";
koneksi.Open();
SqlCommand command = koneksi.CreateCommand();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if ((reader.GetString(0).ToString() == e.Kode) && (reader.GetString(1).ToString() == e.Password)) //pengecekan apakah kode & password ada di database
{
status = true;
}
else
{
status = false;
}
}
koneksi.Close();
return(status);
}
