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); } }