public enAdmin AdminGetir(int adminId)
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT * FROM Admin WHERE adm_id = @id ");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@adi", adminId);
DataTable dt = new DataTable();
adp.Fill(dt);
enAdmin admin = new enAdmin();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
admin.KullaniciAdi = rw["adm_kullAdi"].ToString();
admin.Sifre = rw["adm_sifre"].ToString();
admin.Id = rw["adm_id"].xToIntDefault();
admin.Finex = rw["adm_finex"].xToBooleanDefault();
admin.Statu = rw["adm_statu"].xToBooleanDefault();
}
return(admin);
}
public List <enAdmin> AdminleriGetir()
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT * FROM Admin");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
DataTable dt = new DataTable();
adp.Fill(dt);
List <enAdmin> adminler = new List <enAdmin>();
foreach (DataRow rw in dt.Rows)
{
enAdmin admin = new enAdmin();
admin.KullaniciAdi = rw["adm_kullAdi"].ToString();
admin.Sifre = rw["adm_sifre"].ToString();
admin.Id = rw["adm_id"].xToIntDefault();
admin.Finex = rw["adm_finex"].xToBooleanDefault();
admin.Statu = rw["adm_statu"].xToBooleanDefault();
adminler.Add(admin);
}
return(adminler);
}
public void StatuGuncelle(enAdmin admin)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("adm_statu", admin.Statu);
FxMySqlHelper.Update("Admin", dict, "adm_id", admin.Id);
}
public void Guncelle(enAdmin admin)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("adm_kullAdi", admin.KullaniciAdi);
dict.Add("adm_sifre", admin.Sifre);
FxMySqlHelper.Update("Admin", dict, "adm_id", admin.Id);
}
public void YeniAdminEkle(enAdmin admin)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("adm_kullAdi", admin.KullaniciAdi);
dict.Add("adm_sifre", admin.Sifre);
dict.Add("adm_finex", admin.Finex);
dict.Add("adm_statu", admin.Statu);
FxMySqlHelper.Insert("Admin", dict);
}
protected void lnkDuzenle_OnClick(object sender, EventArgs e)
{
LinkButton lnk = sender as LinkButton;
int adminId = lnk.CommandArgument.xToIntDefault();
enAdmin admin = bllAdmin.AdminGetir(adminId);
txtKullaniciAdi.Text = admin.KullaniciAdi;
txtSifre.Text = admin.Sifre;
VwID = adminId;
}
protected void btnGiris_Click(object sender, EventArgs e)
{
string kullaniciAdi = txtKullaniciAdi.Text.Trim();
string sifre = txtSifre.Text.Trim();
enAdmin adm = bllAdmin.AdminGetir(kullaniciAdi, sifre);
if (adm.Id != 0 && adm.Statu)
{
SessionManager.Admin = adm;
Response.Redirect("~/admin/");
}
else
{
lbluyari.Text = "Kullanıcı adı veya şifre yanlış.";
}
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
enAdmin admin = new enAdmin();
admin.KullaniciAdi = txtKullaniciAdi.Text;
admin.Sifre = txtSifre.Text;
if (VwID != null) //düzenleme
{
bllAdmin.Guncelle(admin);
}
else //yeni kayıt
{
enAdmin admKontrol = bllAdmin.AdminGetir(admin.KullaniciAdi);
if (admKontrol.Id != 0)
{
uscUyari1.UyariGoster("Kullanıcı adı daha önce alınmış !", "Kullanıcı adı kullanımda", false);
return;
}
try
{
admin.Statu = false;
admin.Finex = false;
bllAdmin.YeniAdminEkle(admin);
uscUyari1.UyariGoster("Kullanıcı başarıyla eklendi.", "Yeni Kullanıcı", true);
}
catch
{
uscUyari1.UyariGoster("Kullanıcı eklenirken hata oluştu !", "Yeni Kullanıcı", true);
}
}
txtKullaniciAdi.Text = "";
txtSifre.Text = "";
VwID = null;
AdminleriGetir();
}
protected void lnkStatuDegistir_Click(object sender, EventArgs e)
{
LinkButton lnk = sender as LinkButton;
int adminId = lnk.CommandArgument.xToIntDefault();
enAdmin admin = bllAdmin.AdminGetir(adminId);
if (admin.Statu)
{
admin.Statu = false;
}
else
{
admin.Statu = true;
}
bllAdmin.StatuGuncelle(admin);
AdminleriGetir();
}
public static void StatuGuncelle(enAdmin admin)
{
new dalAdmin().StatuGuncelle(admin);
}
public static void YeniAdminEkle(enAdmin admin)
{
new dalAdmin().YeniAdminEkle(admin);
}
