private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
RptYazdir Rp = new RptYazdir();
int pRef = 0, Ref = 0;
if (xtraTabControl1.SelectedTabPage.Text.ToString() == "Tüm İzinler")
{
if (!string.IsNullOrEmpty(grdAll.GetFocusedRowCellValue("Ref").ToString()))
{
Rp.Ref = int.Parse(grdAll.GetFocusedRowCellValue("Ref").ToString());
Rp.pRef = int.Parse(grdAll.GetFocusedRowCellValue("pRef").ToString());
db.AddParameterValue("@pRef", Rp.pRef);
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", Rp.pRef);
Rp.oncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
}
}
if (xtraTabControl1.SelectedTabPage.Text.ToString() == "Gelecek İzinler")
{
if (!string.IsNullOrEmpty(grdNext.GetFocusedRowCellValue("Ref").ToString()))
{
Rp.Ref = int.Parse(grdNext.GetFocusedRowCellValue("Ref").ToString());
Rp.pRef = int.Parse(grdNext.GetFocusedRowCellValue("pRef").ToString());
db.AddParameterValue("@pRef", Rp.pRef);
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", Rp.pRef);
Rp.oncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
}
}
if (xtraTabControl1.SelectedTabPage.Text.ToString() == "Aktif İzinler")
{
if (!string.IsNullOrEmpty(grdNow.GetFocusedRowCellValue("Ref").ToString()))
{
Rp.Ref = int.Parse(grdNow.GetFocusedRowCellValue("Ref").ToString());
Rp.pRef = int.Parse(grdNow.GetFocusedRowCellValue("pRef").ToString());
db.AddParameterValue("@pRef", Rp.pRef);
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", Rp.pRef);
Rp.oncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
}
}
if (xtraTabControl1.SelectedTabPage.Text.ToString() == "Geçmiş İzinler")
{
if (!string.IsNullOrEmpty(grdPast.GetFocusedRowCellValue("Ref").ToString()))
{
Rp.Ref = int.Parse(grdPast.GetFocusedRowCellValue("Ref").ToString());
Rp.pRef = int.Parse(grdPast.GetFocusedRowCellValue("pRef").ToString());
db.AddParameterValue("@pRef", Rp.pRef);
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", Rp.pRef);
Rp.oncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
}
}
Rp.CreateDocument();
ReportPrintTool printTool = new ReportPrintTool(Rp);
printTool.ShowRibbonPreviewDialog();
}
void save()
{
int OncekiRef = 0;
db.AddParameterValue("@pRef", ledPersonel.GetValue());
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", ledPersonel.GetValue());
OncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
db.AddParameterValue("@Ref", _Ref);
db.AddParameterValue("@pRef", ledPersonel.GetValue());
db.AddParameterValue("@pType", cmbIzinTuru.GetString());
db.AddParameterValue("@psDate", dtpIzinBaslangic.GetDate(), SqlDbType.Date);
db.AddParameterValue("@pfDate", dtpIzinBitisTarihi.GetDate(), SqlDbType.Date);
db.AddParameterValue("@pwsDate", dtpIseBaslamaTarihi.GetDate(), SqlDbType.Date);
db.AddParameterValue("@pRequest", txtVerilen.GetString());
db.AddParameterValue("@weekend", txtHaftaSonu.GetString());
db.AddParameterValue("@national", txtMilli.GetString());
db.AddParameterValue("@religion", txtDiniBayram.GetString());
db.AddParameterValue("@why", txtWhy.GetString());
db.AddParameterValue("@desc", txtDesc.GetString());
db.AddParameterValue("@vekil", ledVekil.GetValue());
if (int.Parse(txtKalanIzin.GetString()) < 0)
{
DialogResult soru;
soru = XtraMessageBox.Show("Bu izin formunun oluşturulması halinde personelin izin hakkı eksiye düşecektir..\n\rOnaylıyor musunuz?", "Soru?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (soru == DialogResult.Yes)
{
db.RunCommand("sp_Permission", CommandType.StoredProcedure);
}
}
else
{
db.RunCommand("sp_Permission", CommandType.StoredProcedure);
}
DialogResult cevap;
cevap = XtraMessageBox.Show("İşlem başarıyla tamamlandı.\n\rİzin belgesini yazdırmak ister misiniz?", "Başarılı İşlem!", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (cevap == DialogResult.Yes)
{
_Ref = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission").ToString());
RptYazdir Rp = new RptYazdir();
Rp.pRef = ledPersonel.GetValue();
Rp.Ref = _Ref;
Rp.oncekiRef = OncekiRef;
Rp.CreateDocument();
ReportPrintTool printTool = new ReportPrintTool(Rp);
printTool.ShowRibbonPreviewDialog();
}
if (dtpIzinBitisTarihi.GetDate() > DateTime.Now)
{
db.AddParameterValue("@ref", ledPersonel.GetValue());
int unitRef = int.Parse(db.GetScalarValue("select unit from tbPerson where Ref=@ref").ToString());
if (unitRef != 0 && !string.IsNullOrEmpty(unitRef.ToString()))
{
db.AddParameterValue("@uRef", unitRef);
string mailAddress = db.GetScalarValue(@"SELECT tbPerson.mail
FROM tbUnit INNER JOIN tbPerson ON tbUnit.aRef = tbPerson.Ref WHERE (tbUnit.Ref = @uRef)").ToString();
if (!string.IsNullOrEmpty(mailAddress))
{
string pAd = "", pSoyad = "";
db.AddParameterValue("@ref", ledPersonel.GetValue());
pAd = db.GetScalarValue("select name from tbPerson where Ref=@ref").ToString();
db.AddParameterValue("@ref", ledPersonel.GetValue());
pSoyad = db.GetScalarValue("select surname from tbPerson where Ref=@ref").ToString();
sendMail(mailAddress, pAd, pSoyad, cmbIzinTuru.GetString(), dtpIzinBaslangic.GetDate().ToShortDateString().ToString(), dtpIzinBitisTarihi.GetDate().ToShortDateString().ToString(), dtpIseBaslamaTarihi.GetDate().ToShortDateString().ToString());
}
else
{
XtraMessageBox.Show("Departman yöneticisinin mail adresi bulunamadı.", "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Personele ait mail adresi bulunamadı.", "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
helper.ClearForm(this);
c.StateStabil(this);
this.DialogResult = DialogResult.OK;
this.Close();
}
