public string insertPegawai(PegawaiInfo data)
{
Koneksi kon = new Koneksi();
SqlConnection sqlcon = kon.getConnection();
string msg = string.Empty;
using (sqlcon)
{
sqlcon.Open();
string sql = "insert pegawai values(@id, @nama, @alamat, @jk, @telepon)";
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
using (sqlcom)
{
sqlcom.Parameters.AddWithValue("@id", data.IDPegawai);
sqlcom.Parameters.AddWithValue("@nama", data.NamaPegawai);
sqlcom.Parameters.AddWithValue("@alamat", data.alamatPegawai);
sqlcom.Parameters.AddWithValue("@jk", data.jeniskelaminPegawai);
sqlcom.Parameters.AddWithValue("@telepon", data.teleponPegawai);
int res = sqlcom.ExecuteNonQuery();
msg = (res != 0 ? "Data has been saved." : "Oops, something went wrong.");
}
sqlcon.Close();
}
return(msg);
}
public string updatePegawai(PegawaiInfo data)
{
Koneksi kon = new Koneksi();
SqlConnection sqlcon = kon.getConnection();
string msg = string.Empty;
using (sqlcon)
{
sqlcon.Open();
string sql = "update pegawai set nama = @nama, alamat = @alamat, jk = @jk, telepon = @telepon where idpegawai = @id";
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
using (sqlcom)
{
sqlcom.Parameters.AddWithValue("@id", data.IDPegawai);
sqlcom.Parameters.AddWithValue("@nama", data.NamaPegawai);
sqlcom.Parameters.AddWithValue("@alamat", data.alamatPegawai);
sqlcom.Parameters.AddWithValue("@jk", data.jeniskelaminPegawai);
sqlcom.Parameters.AddWithValue("@telepon", data.teleponPegawai);
int res = sqlcom.ExecuteNonQuery();
msg = (res != 0 ? "Data has been updated." : "Oops, something went wrong.");
}
sqlcon.Close();
}
return(msg);
}
public List <PegawaiInfo> getPegawaiInfo()
{
// kode get data from sql server..
Koneksi kon = new Koneksi();
SqlConnection sqlcon = kon.getConnection();
List <PegawaiInfo> objList = new List <PegawaiInfo>();
using (sqlcon)
{
sqlcon.Open();
string sql = "select * from pegawai";
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
using (sqlcom)
{
SqlDataReader dr = sqlcom.ExecuteReader();
while (dr.Read())
{
PegawaiInfo obj = new PegawaiInfo();
obj.IDPegawai = dr.GetString(0);
obj.NamaPegawai = dr.GetString(1);
obj.alamatPegawai = dr.GetString(2);
obj.jeniskelaminPegawai = dr.GetString(3);
obj.teleponPegawai = dr.GetString(4);
objList.Add(obj);
}
}
sqlcon.Close();
}
return(objList);
}
public string getPegawaiLastID()
{
try
{
Koneksi kon = new Koneksi();
SqlConnection sqlcon = kon.getConnection();
List <PegawaiInfo> objList = new List <PegawaiInfo>();
string result = string.Empty;
string nextid = string.Empty;
using (sqlcon)
{
String sql = "select top 1 idpegawai,nama from pegawai order by idpegawai desc";
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
using (sqlcom)
{
SqlDataReader dr = sqlcom.ExecuteReader();
if (dr.Read())
{
result = dr.GetString(0);
int cut = Convert.ToInt32(result.Substring(8, 3)) + 1;
if (cut < 10)
{
nextid = "PGW" + DateTime.Now.Year + "000" + cut;
}
else if (cut < 100)
{
nextid = "PGW" + DateTime.Now.Year + "00" + cut;
}
else if (cut < 1000)
{
nextid = "PGW" + DateTime.Now.Year + "0" + cut;
}
else
{
//
}
}
else
{
nextid = nextid = "PGW" + DateTime.Now.Year + "0001";
}
}
}
return(nextid);
}
catch (Exception e)
{
Console.Write(e);
return(null);
}
}
public string deletePegawai(string id)
{
Koneksi kon = new Koneksi();
SqlConnection sqlcon = kon.getConnection();
string msg = string.Empty;
using (sqlcon)
{
sqlcon.Open();
string sql = "delete from pegawai where idpegawai = @id";
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
using (sqlcom)
{
sqlcom.Parameters.AddWithValue("@id", id);
int res = sqlcom.ExecuteNonQuery();
msg = (res != 0 ? "Data has been deleted." : "Oops, something went wrong.");
}
sqlcon.Close();
}
return(msg);
}