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