void KisiGridGetir()
{
SiteDBEntities2 db = new SiteDBEntities2();
var list = db.S_Kisiler(-1).Where(c => c.IsDeleted == false).ToList();
gridControl1.DataSource = list;
}
private void Form1_Load(object sender, EventArgs e)
{
RibbonMenuGridAyarlari uc_gridAyarlari = new RibbonMenuGridAyarlari(ribbonPage.Text);
if (navigationFrame.SelectedPageIndex == 0)
{
uc_gridAyarlari.GrdView = gridView1;
}
ribbonControl.MergeRibbon(uc_gridAyarlari.ribbonControl1);
SiteDBEntities2 db = new SiteDBEntities2();
var bloklar = db.S_Bloklar().ToList();
repositoryItemLookUpEdit1.DataSource = bloklar;
var daireler = db.S_Daireler().ToList();
repositoryItemLookUpEdit2.DataSource = daireler;
var odemeTipi = db.S_OdemeTipi().ToList();
repositoryItemLookUpEdit3.DataSource = odemeTipi;
KisiGridGetir();
CariGridGetir();
}
private void btnBorclandir_ItemClick(object sender, ItemClickEventArgs e)
{
SiteDBEntities2 db = new SiteDBEntities2();
gridControl1.DataSource = null;
dsAktivite_OdemePlaniSenet.Tables.Clear();
dsAktivite_OdemePlaniSenet.Tables.Add(DataControls.ListToDt(db.S_Odemeler(-1).ToList()));
if (dsAktivite_OdemePlaniSenet.Tables[0].Rows.Count != 0)
{
dsAktivite_OdemePlaniSenet.Tables[0].Rows.Clear();
}
int vadeSayisi = Convert.ToInt32(textEdit1.EditValue);
if (vadeSayisi > 0)
{
for (int i = 0; i < vadeSayisi; i++)
{
TaksitEkle(VadeGridMaxTarihBul(), (decimal)(txtTutar.EditValue));
}
}
else
{
TaksitEkle(dateEdit1.DateTime.Date, (decimal)(txtTutar.EditValue));
}
gridControl1.DataSource = dsAktivite_OdemePlaniSenet.Tables[0];
}
private void btnKaydetYeni_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
db.UDI_Kisi(1, kisiid,
txtAdSoyad.EditValue.ToString(),
(int)cmbBlokAdi.EditValue,
(int)cmbDaireNo.EditValue,
rbKiraci.Checked,
DateTime.Now.Date,
(DateTime)dtGirisTarihi.EditValue,
((dtCikisTarihi.EditValue == null) ? (DateTime)System.Data.SqlTypes.SqlDateTime.Null : (DateTime)dtCikisTarihi.EditValue),
rbOturuyor.Checked,
((txtNotlar.EditValue == null) ? "" : txtNotlar.EditValue.ToString()));
Mesaj.MesajVer("Kayıt eklenmiştir.", Mesaj.MesajTipi.Onay, this);
txtAdSoyad.EditValue = "";
cmbBlokAdi.ResetText();
cmbDaireNo.ResetText();
rbKiraci.Checked = false;
rbEvSahibi.Checked = false;
dtGirisTarihi.ResetText();
dtCikisTarihi.ResetText();
rbOturuyor.Checked = false;
rbAyrildi.Checked = false;
txtNotlar.EditValue = "";
txtAdSoyad.Focus();
}
catch (Exception hata)
{
throw;
}
}
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
if (!(gridView1.PostEditor() && gridView1.UpdateCurrentRow()))
{
return;
}
GridView view = sender as GridView;
Object obj = view.GetRow(view.FocusedRowHandle);
if (obj == null)
{
return;
}
int kayitid = (gridView1.GetFocusedRowCellValue("ID") == DBNull.Value) ? -1 : (int)gridView1.GetFocusedRowCellValue("ID");
db.UDI_OdemeTipiTanimlari(1, kayitid, gridView1.GetFocusedRowCellValue("OdemeAdi").ToString());
var list = db.S_OdemeTipi().Where(c => c.IsDeleted == false).ToList();
dt = DataControls.ListToDt(list);
gridControl1.DataSource = dt;
}
catch (Exception hata)
{
throw;
}
}
private void OdemeTipiTanimlari_Load(object sender, EventArgs e)
{
SiteDBEntities2 db = new SiteDBEntities2();
var list = db.S_OdemeTipi().Where(c => c.IsDeleted == false).ToList();
dt = DataControls.ListToDt(list);
gridControl1.DataSource = dt;
}
void CariGridGetir()
{
SiteDBEntities2 db = new SiteDBEntities2();
var cari = db.S_CariIslemler().ToList();
pivotGridControl1.DataSource = cari;
//pivotGridControl1.ActiveFilter.
}
private void Borclandir_Load(object sender, EventArgs e)
{
lblAdiSoyadi.Text = ad;
SiteDBEntities2 db = new SiteDBEntities2();
var odemeTipi = db.S_OdemeTipi().Where(c => c.IsDeleted == false).ToList();
lookUpEdit1.Properties.DataSource = odemeTipi;
}
private void btnKaydetVeKapat_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
int vadeSayisi = Convert.ToInt32(textEdit1.EditValue);
if (vadeSayisi > 0)
{
DateTime OncekiTarih = new DateTime();
for (int i = 0; i < vadeSayisi; i++)
{
DateTime dtmMaxTarih = new DateTime();
dtmMaxTarih = dateEdit1.DateTime.Date;
if (i == 0)
{
db.UDI_Borclandir(kisiid, (int)lookUpEdit1.EditValue, (decimal)txtTutar.EditValue, dtmMaxTarih,
1, null, -1, null);
OncekiTarih = dtmMaxTarih;
}
else
{
int iYear = OncekiTarih.AddMonths(1).Year; //ParseDateTime(OncekiTarih.Month).AddMonths(1).Year;
int iMonth = OncekiTarih.AddMonths(1).Month; //ParseDateTime(OncekiTarih.Month +1).Month;
int iDay = dateEdit1.DateTime.Day;
DateTime dtmTemp = DateTime.Now;
try
{
dtmTemp = new DateTime(iYear, iMonth, iDay);
}
catch (Exception exc)
{
int lastDayOfMonth = DateTime.DaysInMonth(iYear, iMonth);
dtmTemp = new DateTime(iYear, iMonth, lastDayOfMonth);
}
db.UDI_Borclandir(kisiid, (int)lookUpEdit1.EditValue, (decimal)txtTutar.EditValue,
dtmTemp, 1, null, -1, null);
OncekiTarih = dtmTemp;
}
}
}
else
{
db.UDI_Borclandir(kisiid, (int)lookUpEdit1.EditValue, (decimal)txtTutar.EditValue, dateEdit1.DateTime.Date,
1, null, -1, null);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception hata)
{
throw;
}
}
private void navBarOdemeEkle_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
int rowhandle = gridView1.FocusedRowHandle;
OdemeEkle frm = new OdemeEkle(kisiid, lblAdSoyad.Text, -1);
frm.ShowDialog();
if (frm.DialogResult == DialogResult.OK)
{
SiteDBEntities2 db = new SiteDBEntities2();
var odeme = db.S_Odemeler(kisiid).OrderByDescending(c => c.VadeTarihi).ThenByDescending(m => m.ID).Where(c => c.IsDeleted == false).ToList();
gridControl2.DataSource = odeme;
}
gridView1.FocusedRowHandle = rowhandle;
}
private void btnKaydet_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
db.UDI_OdemeEkle(1, _id, -1, (DateTime)dtTarih.EditValue, (int)lookUpEdit1.EditValue,
(decimal)textEdit1.EditValue, memoEdit1.EditValue.ToString());
Mesaj.MesajVer("Kayıt eklenmiştir.", Mesaj.MesajTipi.Onay, this);
}
catch (Exception hata)
{
throw;
}
}
private void BlokTanimlari_Load(object sender, EventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
//gridControl1.DataSource = db.S_Bloklar().ToList();
var list = db.S_Bloklar().Where(c => c.IsDeleted == false).ToList();
dt = DataControls.ListToDt(list);
gridControl1.DataSource = dt;
}
catch (Exception hata)
{
throw;
}
}
private void btnSil_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
db.UDI_OdemeEkle(2, _id, _kayitid, (DateTime)dtTarih.EditValue, (int)lookUpEdit1.EditValue,
(decimal)textEdit1.EditValue, memoEdit1.EditValue.ToString());
Mesaj.MesajVer("Kayıt silinmiştir.", Mesaj.MesajTipi.Onay, this);
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception hata)
{
throw;
}
}
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
if (!(gridView1.PostEditor() && gridView1.UpdateCurrentRow()))
{
return;
}
GridView view = sender as GridView;
Object obj = view.GetRow(view.FocusedRowHandle);
if (obj == null)
{
return;
}
//int product_id_grid = Convert.ToInt32(view.GetDataRow(view.FocusedRowHandle)["ID"].ToString());
int kayitid = (gridView1.GetFocusedRowCellValue("ID") == DBNull.Value) ? -1 : (int)gridView1.GetFocusedRowCellValue("ID");
db.UDI_BlokTanimlari(1, kayitid, gridView1.GetFocusedRowCellValue("BlokAdi").ToString());
//if (view.IsNewItemRow(e.RowHandle))
//{
// //INSERT TSQL
// db.UDI_BlokTanimlari(1, kayitid,
// gridView1.GetFocusedRowCellValue("BlokAdi").ToString());
//}
//else
//{
// //UPDATE TSQL
// db.UDI_BlokTanimlari(1, kayitid,
// gridView1.GetFocusedRowCellValue("BlokAdi").ToString());
//}
var list = db.S_Bloklar().Where(c => c.IsDeleted == false).ToList();
dt = DataControls.ListToDt(list);
gridControl1.DataSource = dt;
}
catch (Exception hata)
{
throw;
}
}
private void YeniKisiEkle_Load(object sender, EventArgs e)
{
SiteDBEntities2 db = new SiteDBEntities2();
var bloklar = db.S_Bloklar().Where(c => c.IsDeleted == false).ToList();
cmbBlokAdi.Properties.DataSource = bloklar;
var daireler = db.S_Daireler().Where(c => c.IsDeleted == false).ToList();
cmbDaireNo.Properties.DataSource = daireler;
if (kisiid > 0)
{
var list = db.S_Kisiler(kisiid).Where(c => c.IsDeleted == false).ToList();
listkisiler = list;
txtAdSoyad.EditValue = list.FirstOrDefault().AdiSoyadi;
cmbBlokAdi.EditValue = list.FirstOrDefault().BlokAdiID;
cmbDaireNo.EditValue = list.FirstOrDefault().DaireAdiID;
dtGirisTarihi.EditValue = list.FirstOrDefault().DaireGirisTarihi;
dtCikisTarihi.EditValue = list.FirstOrDefault().DaireCikisTarihi;
bool kiraciEvSahibi = (bool)list.FirstOrDefault().KiraciEvsahibi;
if (kiraciEvSahibi)
{
rbKiraci.Checked = true;
rbEvSahibi.Checked = false;
}
else
{
rbKiraci.Checked = false;
rbEvSahibi.Checked = true;
}
bool oturuyorAyrildi = (bool)list.FirstOrDefault().OturuyorAyrildi;
if (oturuyorAyrildi)
{
rbOturuyor.Checked = true;
rbAyrildi.Checked = false;
}
else
{
rbOturuyor.Checked = false;
rbAyrildi.Checked = true;
}
txtNotlar.EditValue = list.FirstOrDefault().Notlar;
}
}
private void gridView2_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
db.UDI_Borclandir(-1, -1, 0, (DateTime)System.Data.SqlTypes.SqlDateTime.Null, 2,
(gridView2.GetFocusedRowCellValue("OdemeTarihi") == null) ? (DateTime)System.Data.SqlTypes.SqlDateTime.Null : (DateTime)gridView2.GetFocusedRowCellValue("OdemeTarihi"),
(int)gridView2.GetFocusedRowCellValue("ID"),
(gridView2.GetFocusedRowCellValue("Aciklama") == null) ? "" : gridView2.GetFocusedRowCellValue("Aciklama").ToString());
Mesaj.MesajVer("Kayıt güncellenmiştir.", Mesaj.MesajTipi.Onay, this);
CariGridGetir();
}
catch (Exception hata)
{
throw;
}
}
private void navBarKisilerListesi_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
SiteDBEntities2 db = new SiteDBEntities2();
XtraReport1 rpt = new XtraReport1();
var list = db.S_KisilerListesi().ToList();
rpt.DataSource = list;
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
// Invoke the Print Preview form modally,
// and load the report document into it.
printTool.ShowPreviewDialog();
Cursor.Current = Cursors.Default;
// Invoke the Print Preview form
// with the specified look and feel setting.
//printTool.ShowPreviewDialog(UserLookAndFeel.Default);
}
}
private void btnSil_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (XtraMessageBox.Show("Kayıdı silmek istediğinizden eminmisiniz?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
SiteDBEntities2 db = new SiteDBEntities2();
int kayitid = (gridView1.GetFocusedRowCellValue("ID") == DBNull.Value) ? -1 : (int)gridView1.GetFocusedRowCellValue("ID");
db.UDI_BlokTanimlari(2, kayitid, "");
var list = db.S_Bloklar().Where(c => c.IsDeleted == false).ToList();
dt = DataControls.ListToDt(list);
gridControl1.DataSource = dt;
}
}
catch (Exception hata)
{
throw;
}
}
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
int i = e.FocusedRowHandle;
string id = gridView1.GetRowCellValue(i, "ID").ToString();
if (id != "" || id != null)
{
lblAdSoyad.Text = gridView1.GetRowCellValue(i, "AdiSoyadi").ToString();
lblBlok.Text = string.Format("{0} Blok, Daire {1}", repositoryItemLookUpEdit1.GetDisplayText(gridView1.GetRowCellValue(i, "BlokAdiID")).Trim(),
repositoryItemLookUpEdit2.GetDisplayText(gridView1.GetFocusedRowCellValue("DaireAdiID")).Trim());
string Kiraci, Oturuyor = "";
bool kiraciEvSahibi = Convert.ToBoolean(gridView1.GetRowCellValue(i, "KiraciEvsahibi"));
if (kiraciEvSahibi)
{
Kiraci = "Kiracı";
}
else
{
Kiraci = "Ev Sahibi";
}
bool oturuyorAyrildi = Convert.ToBoolean(gridView1.GetRowCellValue(i, "OturuyorAyrildi"));
if (oturuyorAyrildi)
{
Oturuyor = "Oturuyor";
}
else
{
Oturuyor = "Ayrıldı";
}
lblKiraci.Text = string.Format("{0}, {1}", Kiraci, Oturuyor);
SiteDBEntities2 db = new SiteDBEntities2();
var odeme = db.S_Odemeler(Convert.ToInt32(id)).Where(c => c.IsDeleted == false).OrderByDescending(c => c.VadeTarihi).ToList();
gridControl2.DataSource = odeme;
kisiid = Convert.ToInt32(id);
}
}
private void btnSil_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (kisiid > 0)
{
if (XtraMessageBox.Show("Kayıdı silmek istediğinizden eminmisiniz?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
SiteDBEntities2 db = new SiteDBEntities2();
db.UDI_Kisi(2, kisiid, "", -1, -1, false, null, null, null, false, "");
Mesaj.MesajVer("Kayıt silinmiştir.", Mesaj.MesajTipi.Onay, this);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
catch (Exception hata)
{
throw;
}
}
private void btnKaydetKapat_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
SiteDBEntities2 db = new SiteDBEntities2();
db.UDI_Kisi(1, kisiid,
txtAdSoyad.EditValue.ToString(),
(int)cmbBlokAdi.EditValue,
(int)cmbDaireNo.EditValue,
rbKiraci.Checked,
DateTime.Now.Date,
(DateTime)dtGirisTarihi.EditValue,
((dtCikisTarihi.EditValue == null) ? (DateTime)System.Data.SqlTypes.SqlDateTime.Null : (DateTime)dtCikisTarihi.EditValue),
rbOturuyor.Checked,
((txtNotlar.EditValue == null) ? "" : txtNotlar.EditValue.ToString()));
this.DialogResult = DialogResult.OK;
Mesaj.MesajVer("Kayıt eklenmiştir.", Mesaj.MesajTipi.Onay, this);
this.Close();
}
catch (Exception hata)
{
throw;
}
}