protected void btnKaydet_Click(object sender, EventArgs e)
{
try
{
KASA mn = new KASA();
mn.A_ID = Convert.ToInt32(ddlAdmin.SelectedValue);
mn.TUR = ddlTur.SelectedValue;
mn.TAR = tbTarih.Text;
mn.MIKTAR = Convert.ToInt32(tbMiktar.Text);
mn.ACIKLA = tbAcikla.Text;
string sonuc = String.Empty;
if (AddEdit == 0)
{
KASACRUD.Kaydet(mn);
sonuc = "Kaydetme";
Temizle();
}
else
{
mn.ID = AddEdit;
KASACRUD.Guncelle(mn);
sonuc = "Güncelleme";
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "bilgi", "$.jGrowl('" + sonuc + " Başarılı" + "', { header: 'Sonuç' });", true);
KASAGetir();
}
catch
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "bilgi", "$.jGrowl('" + "İşleminizde Hata Oluştu Lütfen Kontrol Ediniz!" + "', { header: 'Sonuç' });", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["id"]))
{
AddEdit = Convert.ToInt32(Request.QueryString["id"]);
}
else
{
AddEdit = 0;
}
if (!Page.IsPostBack)
{
G_Gider.InnerText = KASACRUD.KasaSay("SELECT MIKTAR FROM KASA WHERE TUR == 'Gider' AND TAR == '" + DateTime.Now.ToString("dd'/'MM'/'yyyy") + "'").ToString();
G_Gelir.InnerText = KASACRUD.KasaSay("SELECT MIKTAR FROM KASA WHERE TUR == 'Gelir' AND TAR == '" + DateTime.Now.ToString("dd'/'MM'/'yyyy") + "'").ToString();
T_Gelir.InnerText = KASACRUD.KasaSay("SELECT MIKTAR FROM KASA WHERE TUR == 'Gelir'").ToString();
T_Gider.InnerText = KASACRUD.KasaSay("SELECT MIKTAR FROM KASA WHERE TUR == 'Gider'").ToString();
string qs = Request.QueryString["tb"];
if (!String.IsNullOrEmpty(qs))
{
if (qs == "G_Gelir")
{
Tools.rptDoldur("Select * from KASA where TUR == 'Gelir' AND TAR == '" + DateTime.Now.ToString("dd'/'MM'/'yyyy") + "'", rptKasa);
}
else if (qs == "G_Gider")
{
Tools.rptDoldur("Select * from KASA where TUR == 'Gider' AND TAR == '" + DateTime.Now.ToString("dd'/'MM'/'yyyy") + "'", rptKasa);
}
else if (qs == "T_Gelir")
{
Tools.rptDoldur("Select * from KASA where TUR == 'Gelir'", rptKasa);
}
else if (qs == "T_Gider")
{
Tools.rptDoldur("Select * from KASA where TUR == 'Gider'", rptKasa);
}
Tools.ddlDoldur("SELECT * FROM ADMIN", ddlAdmin, "K_AD", "ID");
ddlAdmin.Items.Insert(0, new ListItem("Lütfen Sorumlu Kişi Seçiniz", "0"));
}
else
{
KASAGetir();
}
if (AddEdit != 0)
{
btnKaydet.Text = "Düzenle";
KASA mst = KASACRUD.IdyeGoreKASAGetir(AddEdit);
ddlTur.SelectedValue = mst.TUR;
ddlAdmin.SelectedValue = mst.A_ID.ToString();
tbAcikla.Text = mst.ACIKLA.ToString();
tbTarih.Text = mst.TAR;
tbMiktar.Text = mst.MIKTAR.ToString();
}
}
}
public static void Guncelle(KASA p)
{
SQLiteCommand cm = DBCon.KomutOlustur("update KASA set TUR=@TUR,MIKTAR=@MIKTAR,ACIKLA=@ACIKLA,TAR=@TAR,A_ID=@A_ID where ID=@ID");
cm.Parameters.AddWithValue("@TUR", p.TUR);
cm.Parameters.AddWithValue("@MIKTAR", p.MIKTAR);
cm.Parameters.AddWithValue("@ACIKLA", p.ACIKLA);
cm.Parameters.AddWithValue("@TAR", p.TAR);
cm.Parameters.AddWithValue("@A_ID", p.A_ID);
cm.Parameters.AddWithValue("@ID", p.ID);
cm.Connection.Open();
cm.ExecuteNonQuery();
cm.Connection.Close();
}
public static void Kaydet(KASA p)
{
SQLiteCommand cm = DBCon.KomutOlustur("insert into KASA(ID,TUR,MIKTAR,ACIKLA,TAR,A_ID)values (@ID,@TUR,@MIKTAR,@ACIKLA,@TAR,@A_ID)");
cm.Parameters.AddWithValue("@ID", null);
cm.Parameters.AddWithValue("@TUR", p.TUR);
cm.Parameters.AddWithValue("@MIKTAR", p.MIKTAR);
cm.Parameters.AddWithValue("@ACIKLA", p.ACIKLA);
cm.Parameters.AddWithValue("@TAR", p.TAR);
cm.Parameters.AddWithValue("@A_ID", p.A_ID);
cm.Connection.Open();
cm.ExecuteNonQuery();
cm.Connection.Close();
}
public static KASA IdyeGoreKASAGetir(int ID)
{
SQLiteDataAdapter da = new SQLiteDataAdapter("select * from KASA where ID=@ID", DBCon.BaglantiYap());
da.SelectCommand.Parameters.AddWithValue("@ID", ID);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count != 0)
{
KASA k = new KASA();
k.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
k.TUR = Convert.ToString(dt.Rows[0]["TUR"]);
k.MIKTAR = Convert.ToInt32(dt.Rows[0]["MIKTAR"]);
k.ACIKLA = Convert.ToString(dt.Rows[0]["ACIKLA"]);
k.TAR = Convert.ToString(dt.Rows[0]["TAR"]);
k.A_ID = Convert.ToInt32(dt.Rows[0]["A_ID"]);
return(k);
}
else
{
return(null);
}
}
