private void BeritaID()
{
AutoGeneratedID auto = new AutoGeneratedID();
string idk = auto.AutoGenerateIDBer();
txtidberita.Text = idk;
}
private void adminid()
{
AutoGeneratedID auto = new AutoGeneratedID();
string id = auto.AutoGenerateIDAdmin();
txtid.Text = id;
}
private void KatBeritaID()
{
AutoGeneratedID auto = new AutoGeneratedID();
string idk = auto.AutoGenerateIDCat();
txtid.Text = idk;
}
public string AutoGenerateIDBer()
{
AutoGeneratedID koneksi = new AutoGeneratedID();
conn = koneksi.sambung();
string id = null;
using (conn)
{
conn.Open();
string sql = "SELECT TOP 1 ID_Berita from Berita ORDER BY ID_Berita DESC";
SqlCommand sqlcom1 = new SqlCommand(sql, conn);
using (sqlcom1)
{
SqlDataReader dr1 = sqlcom1.ExecuteReader();
if (dr1.Read())
{
id = dr1.GetString(0);
string sub = id.Substring(3);
int a = Convert.ToInt32(sub) + 1;
if (a < 10)
{
id = "BER00" + a;
}
else if (a < 100)
{
id = "BER0" + a;
}
else if (a < 1000)
{
id = "BER" + a;
}
}
else
{
id = "BER001";
}
}
conn.Close();
}
return(id);
}
public string AutoGenerateIDCat()
{
AutoGeneratedID koneksi = new AutoGeneratedID();
conn = koneksi.sambung();
string id = null;
using (conn)
{
conn.Open();
string sql = "SELECT TOP 1 ID_Kategori from Kategori ORDER BY ID_Kategori DESC";
SqlCommand sqlcom = new SqlCommand(sql, conn);
using (sqlcom)
{
SqlDataReader dr = sqlcom.ExecuteReader();
if (dr.Read())
{
id = dr.GetString(0);
string sub = id.Substring(3);
int a = Convert.ToInt32(sub) + 1;
if (a < 10)
{
id = "CAT00" + a;
}
else if (a < 100)
{
id = "CAT0" + a;
}
else if (a < 1000)
{
id = "CAT" + a;
}
}
else
{
id = "CAT001";
}
}
conn.Close();
}
return(id);
}
