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_DaireTanimlari(1, kayitid, gridView1.GetFocusedRowCellValue("DaireNo").ToString());
var list = db.S_Daireler().Where(c => c.IsDeleted == false).ToList();
dt = DataControls.ListToDt(list);
gridControl1.DataSource = dt;
}
catch (Exception hata)
{
throw;
}
}
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 DaireTanimlari_Load(object sender, EventArgs e)
{
SiteDBEntities2 db = new SiteDBEntities2();
var list = db.S_Daireler().Where(c => c.IsDeleted == false).ToList();
dt = DataControls.ListToDt(list);
gridControl1.DataSource = dt;
}
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 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_DaireTanimlari(2, kayitid, "");
var list = db.S_Daireler().Where(c => c.IsDeleted == false).ToList();
dt = DataControls.ListToDt(list);
gridControl1.DataSource = dt;
}
}
catch (Exception hata)
{
throw;
}
}