private void GRD_LISTE_DoubleClick(object sender, EventArgs e)
{
DataRow dr = GRD_VIEW_LISTE.GetFocusedDataRow();
_SLCT_MUSTERI_KODU = dr["MUSTERI_KODU"].ToString();
Close();
}
private void GRD_LISTE_DoubleClick(object sender, EventArgs e)
{
DataRow dr = GRD_VIEW_LISTE.GetFocusedDataRow();
_DIGER_SECENEKLER = dr["DIGER_SECENEKLER"].ToString();
_TAKVIM_SOR = (bool)dr["TAKVIM_SOR"];
Close();
}
private void GRD_LISTE_Click(object sender, EventArgs e)
{
DataRow dr = GRD_VIEW_LISTE.GetFocusedDataRow();
if (dr != null)
{
_SELECT_KODU = dr["DEFAULT_ACIKLAMA"].ToString();
}
}
private void GRD_LISTE_Click(object sender, EventArgs e)
{
hi = GRD_VIEW_LISTE.CalcHitInfo((sender as Control).PointToClient(Control.MousePosition));
dr = GRD_VIEW_LISTE.GetDataRow(hi.RowHandle);
if (dr != null)
{
_MECRA_KODU = dr["MECRA_KODU"].ToString();
}
}
private void GRD_LISTE_DoubleClick(object sender, EventArgs e)
{
DataRow dr = GRD_VIEW_LISTE.GetFocusedDataRow();
if (dr != null)
{
_SLCT_PAZARLAMA_SIRKETII_KODU = dr["KODU"].ToString();
Close();
}
}
private void GRD_VIEW_LISTE_Click(object sender, EventArgs e)
{
DataRow dr = GRD_VIEW_LISTE.GetFocusedDataRow();
if (dr == null)
{
return;
}
DOKUMANLARI_LISTELE(dr);
}
private void BR_YENI_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DataRow dr = GRD_VIEW_LISTE.GetFocusedDataRow();
if (dr != null)
{
MUSTERI_DOKUMANLARI_EKLE frm = new MUSTERI_DOKUMANLARI_EKLE(dr["MUSTERI_KODU"].ToString());
frm.ShowDialog();
DOKUMANLARI_LISTELE(dr);
}
}
private void gridCntrl_LIST_DoubleClick(object sender, EventArgs e)
{
DevExpress.XtraGrid.Views.Grid.ViewInfo.GridHitInfo hi =
GRD_VIEW_LISTE.CalcHitInfo((sender as Control).PointToClient(Control.MousePosition));
dr = GRD_VIEW_LISTE.GetDataRow(hi.RowHandle);
if (dr != null)
{
_KULLANICI_KODU = (string)dr["MAIL_ADRESI"];
_KULLANICI_ID = (int)dr["ID"];
}
Close();
}
private void GRD_LISTE_DoubleClick(object sender, EventArgs e)
{
hi = GRD_VIEW_LISTE.CalcHitInfo((sender as Control).PointToClient(Control.MousePosition));
dr = GRD_VIEW_LISTE.GetDataRow(hi.RowHandle);
if (dr != null)
{
_MUTABAKAT_FORM_TURU = dr["FORM_TURU"].ToString();
_MUTABAKAT_KODU = dr["MUTABAKAT_KODU"].ToString();
_MUTABAKAT_BAS_TARIHI = dr["BAS_TARIHI"].ToString();
_MUTABAKAT_BITIS_TARIHI = dr["BIT_TARIHI"].ToString();
_MUTABAKAT_ACIKLAMASI = dr["ACIKLAMASI"].ToString();
_MUTABAKAT_DONEMI = dr["DONEMI"].ToString();
}
Close();
}
public GENEL_LISTE_GIRIS(string TIPI)
{
InitializeComponent();
ControlBox = false;
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
_ERISIM_TURU = TIPI;
DATA_LOAD();
for (int i = 0; i <= 5; i++)
{
DW_LIST.AddNew();
DataRow dr = DW_LIST[GRD_VIEW_LISTE.RowCount - 1].Row;
dr["SIRA_INDEX"] = GRD_VIEW_LISTE.RowCount;
}
GRD_VIEW_LISTE.RefreshData();
}
private void BR_KAYDET_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
SqlConnection SQLCON = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString());
SQLCON.Open();
//// Satır Sil
DW_LIST.RowStateFilter = DataViewRowState.Deleted;
if (DW_LIST.Count != 0)
{
// SetWaitDialogCaption("Spotlar siliniyor...");
for (int i = 0; i <= DW_LIST.Count - 1; i++)
{
if (DW_LIST[i]["ID"] != DBNull.Value)
{
string myInsertQuery = " DELETE dbo.ADM_GENEL_LISTELER WHERE (ERISIM_TURU=@ERISIM_TURU) and (DEFAULT_ACIKLAMA=@DEFAULT_ACIKLAMA) and (ID=@ID)";
SqlCommand myCmd = new SqlCommand(myInsertQuery);
myCmd.Parameters.AddWithValue("@ERISIM_TURU", _ERISIM_TURU);
myCmd.Parameters.AddWithValue("@DEFAULT_ACIKLAMA", DW_LIST[i]["DEFAULT_ACIKLAMA"].ToString());
myCmd.Parameters.AddWithValue("@ID", DW_LIST[i]["ID"].ToString());
myCmd.Connection = SQLCON;
myCmd.ExecuteNonQuery();
}
}
}
// Yeni eklenmiş Satırları kaydet
DW_LIST.RowStateFilter = DataViewRowState.Added;
if (DW_LIST.Count != 0)
{
for (int i = 0; i <= DW_LIST.Count - 1; i++)
{
if (DW_LIST[i]["ID"] == DBNull.Value)
{
if (DW_LIST[i]["DEFAULT_ACIKLAMA"].ToString() != "")
{
string InsertQuery = "INSERT INTO dbo.ADM_GENEL_LISTELER(ERISIM_TURU, DEFAULT_ACIKLAMA, SIRA_INDEX) Values (@ERISIM_TURU,@DEFAULT_ACIKLAMA,@SIRA_INDEX)";
SqlCommand myCommand = new SqlCommand(InsertQuery);
myCommand.Parameters.AddWithValue("@ERISIM_TURU", _ERISIM_TURU);
myCommand.Parameters.AddWithValue("@DEFAULT_ACIKLAMA", DW_LIST[i]["DEFAULT_ACIKLAMA"].ToString());
myCommand.Parameters.AddWithValue("@SIRA_INDEX", DW_LIST[i]["SIRA_INDEX"].ToString());
myCommand.Connection = SQLCON;
myCommand.ExecuteNonQuery();
}
}
}
}
// Satır Değiştir
DW_LIST.RowStateFilter = DataViewRowState.ModifiedCurrent;
if (DW_LIST.Count != 0)
{
for (int i = 0; i <= DW_LIST.Count - 1; i++)
{
if (DW_LIST[i]["DEFAULT_ACIKLAMA"].ToString() != "")
{
if (DW_LIST[i]["ID"] == DBNull.Value)
{
string InsertQuery = "INSERT INTO dbo.ADM_GENEL_LISTELER(ERISIM_TURU, DEFAULT_ACIKLAMA, SIRA_INDEX) Values(@ERISIM_TURU,@DEFAULT_ACIKLAMA,@SIRA_INDEX)";
SqlCommand myCommand = new SqlCommand(InsertQuery);
myCommand.Parameters.AddWithValue("@ERISIM_TURU", _ERISIM_TURU);
myCommand.Parameters.AddWithValue("@DEFAULT_ACIKLAMA", DW_LIST[i]["DEFAULT_ACIKLAMA"].ToString());
myCommand.Parameters.AddWithValue("@SIRA_INDEX", DW_LIST[i]["SIRA_INDEX"].ToString());
myCommand.Connection = SQLCON;
myCommand.ExecuteNonQuery();
}
if (DW_LIST[i]["ID"] != DBNull.Value)
{
string InsertQuery = "UPDATE dbo.ADM_GENEL_LISTELER SET DEFAULT_ACIKLAMA=@DEFAULT_ACIKLAMA, SIRA_INDEX=@SIRA_INDEX WHERE ERISIM_TURU=@ERISIM_TURU AND ID=@ID";
SqlCommand myCommand = new SqlCommand(InsertQuery);
myCommand.Parameters.AddWithValue("@ERISIM_TURU", _ERISIM_TURU);
myCommand.Parameters.AddWithValue("@DEFAULT_ACIKLAMA", DW_LIST[i]["DEFAULT_ACIKLAMA"].ToString());
myCommand.Parameters.AddWithValue("@SIRA_INDEX", DW_LIST[i]["SIRA_INDEX"].ToString());
myCommand.Parameters.AddWithValue("@ID", DW_LIST[i]["ID"].ToString());
myCommand.Connection = SQLCON;
myCommand.ExecuteNonQuery();
}
}
}
}
DW_LIST.RowStateFilter = DataViewRowState.CurrentRows;
//for (int i = -1; i < 6; i++)
//{
// DW_LIST.AddNew();
//}
GRD_VIEW_LISTE.RefreshData();
DW_LIST.Table.AcceptChanges();
SQLCON.Close();
}
private void GRD_LISTE_Click(object sender, EventArgs e)
{
DevExpress.XtraGrid.Views.Grid.ViewInfo.GridHitInfo hi = GRD_VIEW_LISTE.CalcHitInfo((sender as Control).PointToClient(Control.MousePosition));
SlctDr = GRD_VIEW_LISTE.GetDataRow(hi.RowHandle);
}
private void BTN_GUNCELLE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString());
myConnection.Open();
for (int XS = 0; XS <= GRD_VIEW_LISTE.RowCount - 1; XS++)
{
string UPDATE_NAME = "";
DataRow DR = GRD_VIEW_LISTE.GetDataRow(XS);
if ((string)DR["MAIL_ADRESI"] != string.Empty)
{
string[] Ones = DR["MAIL_ADRESI"].ToString().Split('@');
string NEWSADI = ""; string NEWSOYADI = "";
for (int X = 0; X <= Ones.Length - 1; X++)
{
string[] METIN = Ones[0].ToString().Split('.');
char[] ADI = METIN[0].Trim().ToString().ToCharArray();
NEWSADI = "";
for (int i = 0; i <= ADI.Length - 1; i++)
{
if (i == 0)
{
NEWSADI += ADI[i].ToString().ToUpper();
}
else
{
NEWSADI += ADI[i].ToString();
}
}
char[] SOYADI = METIN[1].Trim().ToString().ToCharArray();
NEWSOYADI = "";
for (int i = 0; i <= SOYADI.Length - 1; i++)
{
if (i == 0)
{
NEWSOYADI += SOYADI[i].ToString().ToUpper();
}
else
{
NEWSOYADI += SOYADI[i].ToString();
}
}
}
UPDATE_NAME = NEWSADI + "." + NEWSOYADI + "@" + Ones[1].ToString();
}
SqlCommand myCmd = new SqlCommand();
myCmd.CommandText = "UPDATE dbo.ADM_KULLANICI SET MAIL_ADRESI=@MAIL_ADRESI where ID=@ID ";
myCmd.Parameters.AddWithValue("@ID", DR["ID"]);
myCmd.Parameters.AddWithValue("@MAIL_ADRESI", UPDATE_NAME);
myCmd.Connection = myConnection;
myCmd.ExecuteNonQuery();
SqlCommand mCmd = new SqlCommand();
mCmd.CommandText = "UPDATE dbo.TODO_TIME_SHEET SET MAIL_ADRESI=@MAIL_ADRESI,Location=@MAIL_ADRESI where MAIL_ADRESI=@MAIL_ADRESI ";
mCmd.Parameters.AddWithValue("@MAIL_ADRESI", UPDATE_NAME);
mCmd.Connection = myConnection;
mCmd.ExecuteNonQuery();
}
}
