private void BTN_KAYDET_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string SELECT_COLUMS = "MEDYA";
if (RDBTN_MEDYA.Checked)
{
SELECT_COLUMS = "MEDYA";
}
if (RDBTN_ANAYAYIN.Checked)
{
SELECT_COLUMS = "ANA_YAYIN";
}
if (lbID.Caption != "")
{
GLOBALTARIFELER.GUNCELLE(lbFILE_NAME.Caption, lbID.Caption, "DERGI", SELECT_COLUMS);
}
if (lbID.Caption == "")
{
TARIFELER._TARIFE_KAYDET frm = new TARIFELER._TARIFE_KAYDET();
frm.ShowDialog();
lbFILE_NAME.Caption = frm._TXT_FILE_NAME.ToString();
if (lbFILE_NAME.Caption.ToString() != "")
{
lbID.Caption = GLOBALTARIFELER.KAYDET(lbFILE_NAME.Caption, "DERGI", "", false, SELECT_COLUMS).ToString();
}
else
{
MessageBox.Show("Tarife kodu giriniz.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (dv != null)
{
// SATIR SİL
dv.RowStateFilter = DataViewRowState.Deleted;
GLOBALTARIFELER.DERGI_ROW_DELETE(dv, lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
// SATIR EKLE
dv.RowStateFilter = DataViewRowState.Added;
GLOBALTARIFELER.DERGI_ROW_ADD(dv, lbFILE_NAME.Caption.ToString(), lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
// SATIR GUNCELLE
dv.RowStateFilter = DataViewRowState.ModifiedOriginal;
GLOBALTARIFELER.DERGI_ROW_UPDATE(dv, lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
DATA_READ(lbFILE_NAME.Caption.ToString());
}
}
private void BTN_KAYDET_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (lbID.Caption != "")
{
GLOBALTARIFELER.GUNCELLE(lbFILE_NAME.Caption, lbID.Caption, "TELEVIZYON", "");
}
if (lbID.Caption == "")
{
TARIFELER._TARIFE_KAYDET frm = new TARIFELER._TARIFE_KAYDET();
frm.ShowDialog();
lbFILE_NAME.Caption = frm._TXT_FILE_NAME.ToString();
if (lbFILE_NAME.Caption.ToString() != "")
{
string SELECT_COLUMS = "MECRA";
if (rdBtn_MECRA_BAZINDA.Checked)
{
SELECT_COLUMS = "MECRA";
}
if (rdBtn_MECRA_VE_SPOTTURU_DETYAY.Checked)
{
SELECT_COLUMS = "MECRA_VE_SPOTTURU_DETYAY";
}
lbID.Caption = GLOBALTARIFELER.KAYDET(lbFILE_NAME.Caption, "TELEVIZYON", SELECT_COLUMS, false, "").ToString();
}
else
{
MessageBox.Show("Tarife kodu giriniz.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (dv != null)
{
// SATIR SİL
dv.RowStateFilter = DataViewRowState.Deleted;
GLOBALTARIFELER.TELEVIZYON_ROW_DELETE(dv, lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
// SATIR EKLE
dv.RowStateFilter = DataViewRowState.Added;
GLOBALTARIFELER.TELEVIZYON_ROW_ADD(dv, lbFILE_NAME.Caption.ToString(), lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
// SATIR GUNCELLE
dv.RowStateFilter = DataViewRowState.ModifiedOriginal;
GLOBALTARIFELER.TELEVIZYON_ROW_UPDATE(dv, lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
DATA_READ(lbFILE_NAME.Caption.ToString());
//dv.RowStateFilter = DataViewRowState.CurrentRows ;
//dv.Table.AcceptChanges();
}
}
private void BTN_KAYDET_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string TARIFE_TURU = "MECRA", GUNLUK = "AYLIK";
if (rdBtn_MECRA_BAZINDA.Checked)
{
TARIFE_TURU = "MECRA";
}
if (rdBtn_MECRA_VE_SAYFA_BAZINDA.Checked)
{
TARIFE_TURU = "MECRA_SAYFA";
}
if (rdBtn_MECRA_VE_SAYFA_YAYINTURU.Checked)
{
TARIFE_TURU = "MECRA_SAYFA_YAYINTURU";
}
if (CHK_GUNLUK_TARIFE.Checked)
{
GUNLUK = "GUNLUK_TARIFE";
}
string SELECT_COLUMS = "MEDYA";
if (RDBTN_MEDYA.Checked)
{
SELECT_COLUMS = "MEDYA";
}
if (RDBTN_ANAYAYIN.Checked)
{
SELECT_COLUMS = "ANA_YAYIN";
}
if (lbID.Caption != "")
{
GLOBALTARIFELER.GUNCELLE(lbFILE_NAME.Caption, lbID.Caption, "GAZETE", SELECT_COLUMS);
}
if (lbID.Caption == "")
{
TARIFELER._TARIFE_KAYDET frm = new TARIFELER._TARIFE_KAYDET();
frm.ShowDialog();
lbFILE_NAME.Caption = frm._TXT_FILE_NAME.ToString();
if (lbFILE_NAME.Caption.ToString() != "")
{
lbID.Caption = GLOBALTARIFELER.KAYDET(lbFILE_NAME.Caption, "GAZETE", TARIFE_TURU, CHK_GUNLUK_TARIFE.Checked, SELECT_COLUMS).ToString();
}
else
{
MessageBox.Show("Tarife kodu giriniz.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (dv != null)
{
// SATIR SİL
dv.RowStateFilter = DataViewRowState.Deleted;
GLOBALTARIFELER.GAZETE_ROW_DELETE(dv, lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
// SATIR EKLE
dv.RowStateFilter = DataViewRowState.Added;
// DataView dv, string TARIFE_KODU,string GAZETE_TARIFE_TURU,string GAZETE_TARIFE_SECENEK
GLOBALTARIFELER.GAZETE_ROW_ADD(dv, lbFILE_NAME.Caption.ToString(), TARIFE_TURU, GUNLUK, lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
// SATIR GUNCELLE
dv.RowStateFilter = DataViewRowState.ModifiedOriginal;
GLOBALTARIFELER.GAZETE_ROW_UPDATE(dv, lbID.Caption, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._KULLANICI_MAIL);
DATA_READ(lbFILE_NAME.Caption.ToString());
}
}
