public bool loginUser(EntAdministrator et, string dt)
{
query = "SpLoginAdministrator";
dbParams = new SqlParameter[]
{
new SqlParameter("@user", et.Namapengguna),
new SqlParameter("@pass", et.Passwordpengguna)
};
table = "Administrator";
dtb = new DataTable();
condition = connect.eksekusiQuery(query, dbParams, false);
if (condition)
{
connect.viewTable(table).Fill(dtb);
if (dtb.Rows.Count > 0)
{
status = true;
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
}
else
{
status = false;
}
}
return(status);
}
public bool delete(EntUnitKerja et, string dt)
{
query = "SpDeleteUnitKerja";
dbParams = new SqlParameter[]
{
new SqlParameter("@idunit", et.Idunit)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool delete(EntPegawai et, string dt)
{
query = "SpDeletePegawai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool delete(EntDetailKegiatan ed, string dt)
{
query = "SpDeleteDetailKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@iddetailkegiatan", ed.Iddetailkegiatan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool delete(EntAtasanPejabatPenilai et, string dt)
{
query = "SpDeleteAtasanPejabatPenilai";
dbParams = new SqlParameter[]
{
new SqlParameter("@idatasanpejabatpenilai", et.Idatasanpenilai)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool save(EntAtasanPejabatPenilai et, string dt)
{
query = "SpInsertAtasanPejabatPenilai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Idpegawai),
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool delete(EntJenisKegiatan et, string dt)
{
query = "SpDeleteJenisKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@idjenis", et.Idjenis)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool save(EntUnitKerja et, string dt)
{
query = "SpInsertUnitKerja";
dbParams = new SqlParameter[]
{
new SqlParameter("@unit", et.Unitkerja),
new SqlParameter("@alamatunit", et.Alamatunit)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool save(EntLoginPegawai et, string dt)
{
query = "SpInsertLogin";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip),
new SqlParameter("@user", et.Namapengguna),
new SqlParameter("@pass", et.Katasandi)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool edit(EntAdministrator et, string dt)
{
query = "SpEditAdministrator";
dbParams = new SqlParameter[]
{
new SqlParameter("@idadmin", et.Idadmin),
new SqlParameter("@nama", et.Nama),
new SqlParameter("@jekel", et.Jekel),
new SqlParameter("@namapengguna", et.Namapengguna),
new SqlParameter("@pass", et.Passwordpengguna)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool edit(EntPegawai et, string dt)
{
query = "SpEditPegawai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip),
new SqlParameter("@nama", et.Nama),
new SqlParameter("@pagolru", et.Pagolru),
new SqlParameter("@jabatan", et.Jabatan),
new SqlParameter("@idunit", et.Idunit),
new SqlParameter("@keterangan", et.Keterangan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool edit(EntKegiatan et, string dt)
{
query = "SpEditKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@idkegiatan", et.Idkegiatan),
new SqlParameter("@outputkegiatan", et.Outputkegiatan),
new SqlParameter("@satuan", et.Satuan),
new SqlParameter("@idjenis", et.Idjenis),
new SqlParameter("@statuskegiatan", et.Status),
new SqlParameter("@keterangan", et.Keterangan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
