public string[] getDate_PURE(string[] idDoc, string sumber)
{
List <string> List_dateDoc = new List <string>();
connectionClass con = new connectionClass();
string queryTerm;
if (!sumber.Equals("null"))
{
queryTerm = "SELECT \"dateDoc\" FROM public.\"Dokumen\" where \"idDokumen\" in (" + string.Join(", ", idDoc) + ") " +
" and site_name='" + sumber + "' order by \"dateDoc\" desc;";
}
else
{
queryTerm = "SELECT \"dateDoc\" FROM public.\"Dokumen\" where \"idDokumen\" in (" + string.Join(", ", idDoc) + ") order by \"dateDoc\" desc;";
}
con.openConnection();
DataTable result = con.getResult(queryTerm);
string[] arrayDate = new string[result.Rows.Count];
for (int i = 0; i < result.Rows.Count; i++)
{
string temp = result.Rows[i]["dateDoc"].ToString();
if (temp.Length > 10)
{
temp = temp.Substring(0, temp.Length - 1);
}
if (!List_dateDoc.Contains(temp))
{
List_dateDoc.Add(temp);
}
}
arrayHasilDatePure = List_dateDoc.ToArray();
return(arrayHasilDatePure);
}
public void get_nDoc()
{
this.con = new connectionClass();
DataTable pengguna = this.con.getResult("SELECT count (*) as get FROM public.\"Dokumen\";");
totalDoc.Text = pengguna.Rows[0]["get"].ToString();
}
public void getDoc_MengandungQuery(string[] query)
{
double[] hasilPembilang_Perkata;
double[] hasilPenyebut_Perkata;
for (int i = 0; i < query.Length; i++)
{
string queryPakek = cariID_Term(query[i]);
if (queryPakek.Equals("0"))
{
Console.WriteLine("Tidak ada dokument yang memakai kata '" + query + "'");
Console.WriteLine("======================================================================");
}
else
{
connectionClass con = new connectionClass();
con.openConnection();
string queryDF = "SELECT \"idDokumen\", \"id_Term\", \"TF-IDF\" FROM public.\"bobotTerm\" where" +
" \"id_Term\"='" + queryPakek + "'";
DataTable result = con.getResult(queryDF);
string[] dataID_Term = new string[result.Rows.Count];
hasilTF_IDF_Perkata_Pembagi = new double[dataID_Term.Length];
hasilTF_IDF_Perkata_Pembilang = new double[dataID_Term.Length];
string[] dataTF_IDF_Term = new string[result.Rows.Count];
}
}
}
public void get_n_DimensiTerm()
{
this.con = new connectionClass();
DataTable pengguna = this.con.getResult("SELECT count(*) as dimensiTerm FROM public.\"Term\";");
total_nTerm.Text = pengguna.Rows[0]["dimensiTerm"].ToString();
}
private void getDataUser(string email, string password)
{
this.con = new connectionClass();
string query = "SELECT * FROM public.\"userFix\"" +
"WHERE email = '" + email + "' " +
"AND password = '******';";
DataTable result = this.con.getResult(query);
if (result.Rows.Count == 0)
{
message_error.Attributes["class"] = "";
}
else
{
if (result.Rows[0]["level"].ToString().Equals("1"))
{
Session.Remove("Member");
Session["Admin"] = email;
Response.Redirect("Welcome[Here_AdminPanel].aspx");
}
else
{
Session.Remove("Admin");
Session["Member"] = email;
Response.Redirect("Welcome[Here_MemberPanel].aspx");
}
}
}
public string[] getID_Doc_Sumber(int status, string[] idTerm)
{
connectionClass con = new connectionClass();
con.openConnection();
DataTable result;
string[] arrayDoc;
List <string> List_idDoc = new List <string>();
if (status == 1)
{
string queryTerm = "SELECT dk.\"idDokumen\",count(*) FROM" +
" public.\"bobotTerm\" bt join \"Dokumen\" dk on (bt.\"idDokumen\"=dk.\"idDokumen\")" +
" where dk.site_name='Tribunnews.com' and bt.\"id_Term\" in (" + string.Join(", ", idTerm) + ") group by dk.\"idDokumen\";";
result = con.getResult(queryTerm);
for (int i = 0; i < result.Rows.Count; i++)
{
if (!List_idDoc.Contains(result.Rows[i]["idDokumen"]))
{
List_idDoc.Add("'" + result.Rows[i]["idDokumen"] + "'".ToString());
}
}
arrayDoc = List_idDoc.ToArray();
}
else if (status == 2)
{
string queryTerm = "SELECT dk.\"idDokumen\",count(*) FROM" +
" public.\"bobotTerm\" bt join \"Dokumen\" dk on (bt.\"idDokumen\"=dk.\"idDokumen\")" +
" where dk.site_name='Detik.com' and bt.\"id_Term\" in (" + string.Join(", ", idTerm) + ") group by dk.\"idDokumen\";";
result = con.getResult(queryTerm);
for (int i = 0; i < result.Rows.Count; i++)
{
if (!List_idDoc.Contains(result.Rows[i]["idDokumen"]))
{
List_idDoc.Add("'" + result.Rows[i]["idDokumen"] + "'".ToString());
}
}
arrayDoc = List_idDoc.ToArray();
}
else
{
string queryTerm = "SELECT dk.\"idDokumen\",count(*) FROM" +
" public.\"bobotTerm\" bt join \"Dokumen\" dk on (bt.\"idDokumen\"=dk.\"idDokumen\")" +
" where dk.site_name='Liputan6.com' and bt.\"id_Term\" in (" + string.Join(", ", idTerm) + ") group by dk.\"idDokumen\";";
result = con.getResult(queryTerm);
for (int i = 0; i < result.Rows.Count; i++)
{
if (!List_idDoc.Contains(result.Rows[i]["idDokumen"]))
{
List_idDoc.Add("'" + result.Rows[i]["idDokumen"] + "'".ToString());
}
}
arrayDoc = List_idDoc.ToArray();
}
return(arrayDoc);
}
public string getName()
{
string name = null;
this.con = new connectionClass();
string query = "select \"namaPengguna\" from public.\"user\" where email='" + Session["Admin"] + "'";
DataTable data = this.con.getResult(query);
name = data.Rows[0]["namaPengguna"].ToString();
return(name);
}
public string getPathIMage()
{
string path = null;
this.con = new connectionClass();
string query = "select path_photo from public.\"user\" where email='" + Session["Admin"] + "'";
DataTable data = this.con.getResult(query);
path = "admin-lte/img/" + data.Rows[0]["path_photo"].ToString();
return(path);
}
protected void Page_Load(object sender, EventArgs e)
{
labelEmail.Text = Session["EmailPendaftar"].ToString();
this.con = new connectionClass();
this.con.openConnection();
DataTable pengguna = this.con.getResult("SELECT * FROM public.user_register where email='" + Session["EmailPendaftar"] + "';");
kodeVerifikasi = pengguna.Rows[0]["kodeReg"].ToString();
password = pengguna.Rows[0]["password"].ToString();
pathPhoto = pengguna.Rows[0]["pathPhoto"].ToString();
nama = pengguna.Rows[0]["nama"].ToString();
}
public string getIDF_Term(string term)
{
connectionClass con = new connectionClass();
con.openConnection();
double getIDF_Term = 0;
string QgetDF_Term = "SELECT \"IDF\" FROM public.\"Term\" where \"Term\"='" + term + "';";
DataTable result = con.getResult(QgetDF_Term);
getIDF_Term = Convert.ToDouble(result.Rows[0]["IDF"]);
return(getIDF_Term.ToString());
}
// all studennndts
public DataTable getAllStd()
{
connectionClass obj = new connectionClass();
obj.openConn();
DataTable dt = new DataTable();
dt = obj.readData("GET_ALL_STD", null);
obj.CloseConn();
return(dt);
}
private Boolean cekEmail_db(string email)
{
this.con = new connectionClass();
DataTable result = this.con.getResult("SELECT * FROM public.user_register WHERE email = '" + email + "';");
if (result.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
profileImage_dropdown.Attributes["src"] = getPathIMage();
profileSideBar.Attributes["src"] = getPathIMage();
labelNama2.Text = getName();
labelNama3.Text = getName();
this.con = new connectionClass();
this.con.openConnection();
DataTable pengguna = this.con.getResult("SELECT count(*) as get FROM public.\"userFix\" where level='2';");
this.con = new connectionClass();
DataTable MemberBaru = this.con.getResult("SELECT * FROM public.user_register order by \"tanggalDaftar\" desc limit 3;");
profileImage1.Attributes["src"] = "admin-lte/img/" + MemberBaru.Rows[0]["pathPhoto"].ToString();
profileImage2.Attributes["src"] = "admin-lte/img/" + MemberBaru.Rows[1]["pathPhoto"].ToString();
profileImage3.Attributes["src"] = "admin-lte/img/" + MemberBaru.Rows[2]["pathPhoto"].ToString();
if (MemberBaru.Rows[0]["nama"].ToString().Length > 15)
{
Nama1.Text = MemberBaru.Rows[0]["nama"].ToString().Remove(15);
}
else
{
Nama1.Text = MemberBaru.Rows[0]["nama"].ToString();
}
if (MemberBaru.Rows[1]["nama"].ToString().Length > 15)
{
Nama2.Text = MemberBaru.Rows[1]["nama"].ToString().Remove(15);
}
else
{
Nama2.Text = MemberBaru.Rows[1]["nama"].ToString();
}
if (MemberBaru.Rows[2]["nama"].ToString().Length > 15)
{
Nama3.Text = MemberBaru.Rows[2]["nama"].ToString().Remove(15);
}
else
{
Nama3.Text = MemberBaru.Rows[2]["nama"].ToString();
}
pekerjaan1.Text = MemberBaru.Rows[0]["pekerjaan"].ToString();
pekerjaan2.Text = MemberBaru.Rows[1]["pekerjaan"].ToString();
pekerjaan3.Text = MemberBaru.Rows[2]["pekerjaan"].ToString();
tanggalDaftar1.Text = getTimeAgo(MemberBaru.Rows[0]["tanggalDaftar"].ToString());
tanggalDaftar2.Text = getTimeAgo(MemberBaru.Rows[1]["tanggalDaftar"].ToString());
tanggalDaftar3.Text = getTimeAgo(MemberBaru.Rows[2]["tanggalDaftar"].ToString());
}
public string[] getId_Doc(string idTerm)
{
connectionClass con = new connectionClass();
con.openConnection();
string query = "SELECT \"idDokumen\" FROM public.\"bobotTerm\" where \"id_Term\" = '" + idTerm + "'";
DataTable result = con.getResult(query);
string[] arrayDoc = new string[result.Rows.Count];
for (int i = 0; i < result.Rows.Count; i++)
{
arrayDoc[i] = result.Rows[i]["idDokumen"].ToString();
}
return(arrayDoc);
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Header.Controls.Add(new LiteralControl("<link rel=\"stylesheet\" type=\"text/css\" href=\"" + ResolveUrl("~/Content/MyStyleGrid.css") + "\" />"));
Page.Header.Controls.Add(new LiteralControl("<link rel=\"stylesheet\" type=\"text/css\" href=\"" + ResolveUrl("~/admin-lte/css/adminLTE.min.css") + "\" />"));
this.con = new connectionClass();
this.con.openConnection();
DataTable pengguna = this.con.getResult("SELECT uf.\"namaPengguna\", uf.email, ur.pekerjaan, uf.path_photo, " +
"ur.jenis_kelamin, ur.alamat, ur.\"tanggalDaftar\", ur.\"alasanBergabung\" FROM public.\"userFix\" uf join public.\"user_register\" ur on (uf.email=ur.email);");
for (int i = 0; i < pengguna.Rows.Count; i++)
{
pengguna.Rows[i]["path_photo"] = "~/admin-lte/img/" + pengguna.Rows[i]["path_photo"].ToString();
this.tabelPendaftar.DataSource = pengguna;
this.tabelPendaftar.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Header.Controls.Add(new LiteralControl("<link rel=\"stylesheet\" type=\"text/css\" href=\"" + ResolveUrl("~/Content/MyStyleGrid.css") + "\" />"));
Page.Header.Controls.Add(new LiteralControl("<link rel=\"stylesheet\" type=\"text/css\" href=\"" + ResolveUrl("~/admin-lte/css/adminLTE.min.css") + "\" />"));
this.con = new connectionClass();
this.con.openConnection();
if (query.Text.Equals(""))
{
show_all_klik(sender, e);
btnShowALL.Visible = false;
}
else
{
search_klik(sender, e);
btnShowALL.Visible = true;
}
}
protected void verifikasi_click(object sender, EventArgs e)
{
if (Convert.ToInt32(kode.Value) == Convert.ToInt32(kodeVerifikasi))
{
this.con = new connectionClass();
string queryInsert = "INSERT INTO public.\"userFix\"(email, password, level, path_photo, \"namaPengguna\")" +
" VALUES ('" + Session["EmailPendaftar"] + "', '" + password + "', '2', '" + pathPhoto + "', '" + nama + "');";
this.con.excequteQuery(queryInsert);
Response.Redirect("Welcome[Here_MemberPanel].aspx");
}
else
{
labelNotifikasi.Attributes["CssClas"] = "";
labelNotifikasi.Text = "Kode Yang anda Masukkan Salah";
}
}
protected void show_all_klik(object sender, EventArgs e)
{
this.con = new connectionClass();
this.con.openConnection();
DataTable activity = this.con.getResult("SELECT log.email,uf.path_photo, " +
"uf.\"namaPengguna\", ur.pekerjaan, ur.\"tanggalDaftar\", id_berita, " +
"\"timeAccess\", judul FROM public.\"logActivity_Member\" log " +
"join public.\"userFix\" uf on (log.email=uf.email) join" +
" user_register ur on (uf.email=ur.email) order by \"timeAccess\" desc limit 30;");
for (int i = 0; i < activity.Rows.Count; i++)
{
activity.Rows[i]["path_photo"] = "~/admin-lte/img/" + activity.Rows[i]["path_photo"].ToString();
this.tabelActivity.DataSource = activity;
this.tabelActivity.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.con = new connectionClass();
DataTable pengguna = this.con.getResult("SELECT count(*) as get FROM public.\"userFix\" where level='2';");
get_nUser = pengguna.Rows[0]["get"].ToString();
jml_userActive.Text = get_nUser.ToString();
get_nTribun = getcountTribun().ToString();
get_nDetik = getcounDetik().ToString();
get_nLiputan6 = getcountLiputan6().ToString();
totalTribun.Text = get_nTribun;
TotalDetik.Text = get_nDetik;
TotalLiputan6.Text = get_nLiputan6;
setBar_dashBoard();
loadChartBeranda();
setBoardButton();
}
// get all matched std
public DataTable getAllMatchedStd(string fname)
{
SqlParameter[] paraFname = new SqlParameter[1];
connectionClass obj = new connectionClass();
obj.openConn();
paraFname[0] = new SqlParameter("@std_fname", SqlDbType.NVarChar, 30);
paraFname[0].Value = fname;
DataTable dt = new DataTable();
dt = obj.readData("GET_ALL_MATCHED_STD", paraFname);
obj.CloseConn();
return(dt);
}
public void Page_Load(object sender, EventArgs e, string email)
{
Page.Header.Controls.Add(new LiteralControl("<link rel=\"stylesheet\" type=\"text/css\" href=\"" + ResolveUrl("~/Content/MyStyleGrid.css") + "\" />"));
Page.Header.Controls.Add(new LiteralControl("<link rel=\"stylesheet\" type=\"text/css\" href=\"" + ResolveUrl("~/admin-lte/css/adminLTE.min.css") + "\" />"));
this.email = email;
this.con = new connectionClass();
this.con.openConnection();
DataTable pengguna = this.con.getResult("SELECT ur.\"pathPhoto\", lg.judul, ur.nama, lg.email , lg.id_berita, lg.\"timeAccess\" " +
"FROM public.\"logActivity_Member\" lg join user_register ur on(lg.email=ur.email) where lg.email='" + this.email + "'" +
" order by \"timeAccess\" desc limit 10");
for (int i = 0; i < pengguna.Rows.Count; i++)
{
pengguna.Rows[i]["pathPhoto"] = "~/admin-lte/img/" + pengguna.Rows[i]["pathPhoto"].ToString();
}
this.tabelLog.DataSource = pengguna;
this.tabelLog.DataBind();
memberLog_Name.Text = this.email;
}
// delete std
public void DELETE_STD(int ID)
{
SqlParameter[] paraStdId = new SqlParameter[1];
connectionClass obj = new connectionClass();
obj.openConn();
paraStdId[0] = new SqlParameter("@STD_ID", SqlDbType.Int);
paraStdId[0].Value = ID;
obj.excuteCmd("DELETE_STD", paraStdId);
obj.CloseConn();
}
public double cariTF_IDF(string id_doc, string idTerm)
{
connectionClass con = new connectionClass();
con.openConnection();
double termCari;
string termMasuk = "SELECT \"TF-IDF\" FROM public.\"bobotTerm\" where" +
" \"idDokumen\"=" + id_doc + " and \"id_Term\"=" + idTerm + ";";
DataTable result2 = con.getResult(termMasuk);
if (result2.Rows.Count >= 1)
{
termCari = Convert.ToDouble(result2.Rows[0]["TF-IDF"]);
return(termCari);
}
else
{
return(0);
}
}
public string cariID_Term(string data)
{
connectionClass con = new connectionClass();
con.openConnection();
string termCari = null;
string termMasuk = "SELECT * FROM public.\"Term\" where \"Term\"='" + data + "';";
DataTable result2 = con.getResult(termMasuk);
idDoc = new string[result2.Rows.Count];
if (result2.Rows.Count >= 1)
{
termCari = result2.Rows[0]["id_Term"].ToString();
return(termCari);
}
else
{
return("null");
}
}
protected void search_klik(object sender, EventArgs e)
{
this.con = new connectionClass();
this.con.openConnection();
DataTable activitySearch = this.con.getResult("SELECT log.email,uf.path_photo, " +
"uf.\"namaPengguna\", ur.pekerjaan, ur.\"tanggalDaftar\", id_berita," +
" \"timeAccess\", judul FROM public.\"logActivity_Member\" " +
" log join public.\"userFix\" uf on (log.email=uf.email) " +
"join user_register ur on (uf.email=ur.email) where log.email " +
" like '%" + query.Text + "%' or uf.\"namaPengguna\" like '%" + query.Text + "%'" +
" order by \"timeAccess\" desc");
for (int i = 0; i < activitySearch.Rows.Count; i++)
{
activitySearch.Rows[i]["path_photo"] = "~/admin-lte/img/" + activitySearch.Rows[i]["path_photo"].ToString();
this.tabelActivity.DataSource = activitySearch;
this.tabelActivity.DataBind();
}
btnShowALL.Visible = true;
}
// add std
public void inserting_std(string fname, string lname, string gname, string gender, string phone = "", string email = "")
{
SqlParameter[] paraStd = new SqlParameter[6];
connectionClass obj = new connectionClass();
obj.openConn();
paraStd[0] = new SqlParameter("@std_fname ", SqlDbType.NVarChar, 30);
paraStd[0].Value = fname;
paraStd[1] = new SqlParameter("@std_lname ", SqlDbType.NVarChar, 30);
paraStd[1].Value = lname;
paraStd[2] = new SqlParameter("@std_gname ", SqlDbType.NVarChar, 30);
paraStd[2].Value = gname;
paraStd[3] = new SqlParameter("@std_gender", SqlDbType.NVarChar, 5);
paraStd[3].Value = gender;
paraStd[4] = new SqlParameter("@std_phone", SqlDbType.NVarChar, 15);
paraStd[4].Value = phone;
paraStd[5] = new SqlParameter("@std_email", SqlDbType.NVarChar, 50);
paraStd[5].Value = email;
obj.excuteCmd("ADD_STD", paraStd);
obj.CloseConn();
MessageBox.Show("تمت اضافة الطالب " + fname + " " + lname + " بنجاح");
}
public string[] getID_Doc(string[] idTerm)
{
connectionClass con = new connectionClass();
con.openConnection();
string queryTerm = "SELECT \"idDokumen\" ,count(*) FROM public.\"bobotTerm\" where \"id_Term\" in " +
"(" + string.Join(", ", idTerm) + ") group by \"idDokumen\";";
DataTable result = con.getResult(queryTerm);
string[] arrayDoc = new string[result.Rows.Count];
List <string> List_idDoc = new List <string>();
for (int i = 0; i < result.Rows.Count; i++)
{
if (!List_idDoc.Contains(result.Rows[i]["idDokumen"]))
{
List_idDoc.Add("'" + result.Rows[i]["idDokumen"] + "'".ToString());
}
}
arrayDoc = List_idDoc.ToArray();
return(arrayDoc);
}
public double cekKetersediaan_Term(string kata)
{
connectionClass con = new connectionClass();
con.openConnection();
string query = "SELECT \"Term\" FROM public.\"Term\" where \"Term\"='" + kata + "';";
DataTable result = con.getResult(query);
if (result.Rows.Count >= 1)
{
con.openConnection();
double getIDF_Term = 0;
string QgetDF_Term = "SELECT \"IDF\" FROM public.\"Term\" where \"Term\"='" + kata + "';";
DataTable result2 = con.getResult(QgetDF_Term);
getIDF_Term = Convert.ToDouble(result2.Rows[0]["IDF"]);
return(getIDF_Term);
}
else
{
return(0);
}
}
public string[] getID_Term(string[] query)
{
connectionClass con = new connectionClass();
con.openConnection();
string queryTerm = "SELECT \"id_Term\" FROM public.\"Term\" where \"Term\" in ( " + string.Join(", ", query) + ");";
DataTable result = con.getResult(queryTerm);
string[] arrayTerm = new string[result.Rows.Count];
for (int i = 0; i < result.Rows.Count; i++)
{
if (result.Rows.Count > 0)
{
arrayTerm[i] = "'" + result.Rows[i]["id_Term"] + "'".ToString();
}
else
{
arrayTerm[i] = "null".ToString();
}
}
return(arrayTerm);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Admin"] != null)
{
if (ViewState["userControl"] == null)
{
ViewState["userControl"] = "~/UDC/Admin/Dashboard.ascx";
this.loadControl(ViewState["userControl"].ToString(), false);
}
else
{
this.loadControl(ViewState["userControl"].ToString(), true);
}
sidebarProfile.Attributes["src"] = getPathIMage();
profileImage_dropdown.Attributes["src"] = getPathIMage();
profileSideBar.Attributes["src"] = getPathIMage();
labelNama.Text = getName();
labelNama2.Text = getName();
labelNama3.Text = getName();
this.con = new connectionClass();
this.con.openConnection();
DataTable pengguna = this.con.getResult("SELECT count(*) as get FROM public.\"userFix\" where level='2';");
this.con = new connectionClass();
DataTable MemberBaru = this.con.getResult("SELECT * FROM public.user_register order by \"tanggalDaftar\" desc limit 3;");
profileImage1.Attributes["src"] = "admin-lte/img/" + MemberBaru.Rows[0]["pathPhoto"].ToString();
profileImage2.Attributes["src"] = "admin-lte/img/" + MemberBaru.Rows[1]["pathPhoto"].ToString();
profileImage3.Attributes["src"] = "admin-lte/img/" + MemberBaru.Rows[2]["pathPhoto"].ToString();
if (MemberBaru.Rows[0]["nama"].ToString().Length > 15)
{
Nama1.Text = MemberBaru.Rows[0]["nama"].ToString().Remove(15);
}
else
{
Nama1.Text = MemberBaru.Rows[0]["nama"].ToString();
}
if (MemberBaru.Rows[1]["nama"].ToString().Length > 15)
{
Nama2.Text = MemberBaru.Rows[1]["nama"].ToString().Remove(15);
}
else
{
Nama2.Text = MemberBaru.Rows[1]["nama"].ToString();
}
if (MemberBaru.Rows[2]["nama"].ToString().Length > 15)
{
Nama3.Text = MemberBaru.Rows[2]["nama"].ToString().Remove(15);
}
else
{
Nama3.Text = MemberBaru.Rows[2]["nama"].ToString();
}
pekerjaan1.Text = MemberBaru.Rows[0]["pekerjaan"].ToString();
pekerjaan2.Text = MemberBaru.Rows[1]["pekerjaan"].ToString();
pekerjaan3.Text = MemberBaru.Rows[2]["pekerjaan"].ToString();
tanggalDaftar1.Text = getTimeAgo(MemberBaru.Rows[0]["tanggalDaftar"].ToString());
tanggalDaftar2.Text = getTimeAgo(MemberBaru.Rows[1]["tanggalDaftar"].ToString());
tanggalDaftar3.Text = getTimeAgo(MemberBaru.Rows[2]["tanggalDaftar"].ToString());
}
else
{
Response.Redirect("Site[Please_Login].aspx");
}
}
