private void smsGönderToolStripMenuItem_Click(object sender, EventArgs e)
{
//if (gridView1.FocusedRowHandle < 0) return;
//DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
//string pkFirma = dr["pkFirma"].ToString();
int h = 0;
DataTable dt = DB.GetData("select pkFirma,Cep,Cep2 from Firmalar with(nolock) where sec=1 and (len(Cep)>9 or len(Cep2)>9)");//pkFirma=" + pkFirma);
for (int i = 0; i < dt.Rows.Count; i++)
{
string fkFirma = dt.Rows[i]["pkFirma"].ToString();
string cep = dt.Rows[i]["Cep"].ToString();
string cep2 = dt.Rows[i]["Cep2"].ToString();
if (cep.Length < 9)
{
cep = cep2;
}
if (cep.Length < 9)
{
h++;
continue;
}
ArrayList list = new ArrayList();
list.Add(new SqlParameter("@fkFirma", fkFirma));
list.Add(new SqlParameter("@CepTel", cep));
list.Add(new SqlParameter("@Mesaj", "Bakiye"));
if (DB.GetData("select fkFirma from Sms where Durumu=0 and fkFirma=" + fkFirma).Rows.Count == 0)
{
string sonuc = DB.ExecuteSQL("INSERT INTO Sms (fkFirma,CepTel,Durumu,Mesaj,Tarih) values(@fkFirma,@CepTel,0,@Mesaj,GetDate())", list);
if (sonuc == "0")
{
DB.ExecuteSQL("update Firmalar set sec=0 where pkFirma=" + fkFirma);
}
}
else
{
DB.ExecuteSQL("update Firmalar set sec=0 where pkFirma=" + fkFirma);
}
}
//if(h>0)
// MessageBox.Show( h.ToString() + " Hatalı Cep No Bilgisilerini Kontrol Ediniz!");
frmSmsGonder SmsGonder = new frmSmsGonder();
SmsGonder.Show();
gridyukle("");
}
private void simpleButton9_Click(object sender, EventArgs e)
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
string pkFirma = dr["PkFirma"].ToString();
DataTable dt = DB.GetData("select * from Firmalar with(nolock) where pkFirma=" + pkFirma);//len(Cep)>9 and
if (dt.Rows.Count > 0)
{
string ceptel = dt.Rows[0]["Cep"].ToString();
string ceptel2 = dt.Rows[0]["Cep2"].ToString();
if (ceptel.Length < 9)
{
ceptel = ceptel2;
}
if (ceptel.Length < 9)
{
formislemleri.Mesajform("Cep Telefon Numarası Hatalı.", "K", 200);
return;
}
ArrayList list = new ArrayList();
list.Add(new SqlParameter("@fkFirma", pkFirma));
list.Add(new SqlParameter("@CepTel", dt.Rows[0]["Cep"].ToString()));
list.Add(new SqlParameter("@Mesaj", "Taksit"));
if (DB.GetData("select * from Sms with(nolock) where Durumu=0 and fkFirma=" + pkFirma).Rows.Count == 0)
{
DB.ExecuteSQL("INSERT INTO Sms (fkFirma,CepTel,Durumu,Mesaj,Tarih) values(@fkFirma,@CepTel,0,@Mesaj,GetDate())", list);
}
}
frmSmsGonder SmsGonder = new frmSmsGonder();
SmsGonder.ShowDialog();
}
void item_Click_sms_gonder(object sender, EventArgs e)
{
//int h = 0;
//DataTable dt = DB.GetData("select pkFirma,Cep,Cep2 from Firmalar with(nolock) where sec=1 and (len(Cep)>9 or len(Cep2)>9)");//pkFirma=" + pkFirma);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// string fkFirma = dt.Rows[i]["pkFirma"].ToString();
// string cep = dt.Rows[i]["Cep"].ToString();
// string cep2 = dt.Rows[i]["Cep2"].ToString();
// if (cep.Length < 9) cep = cep2;
// if (cep.Length < 9)
// {
// h++;
// continue;
// }
// ArrayList list = new ArrayList();
// list.Add(new SqlParameter("@fkFirma", fkFirma));
// list.Add(new SqlParameter("@CepTel", cep));
// list.Add(new SqlParameter("@Mesaj", "Bakiye"));
// if (DB.GetData("select fkFirma from Sms where Durumu=0 and fkFirma=" + fkFirma).Rows.Count == 0)
// {
// string sonuc = DB.ExecuteSQL("INSERT INTO Sms (fkFirma,CepTel,Durumu,Mesaj,Tarih) values(@fkFirma,@CepTel,0,@Mesaj,GetDate())", list);
// if (sonuc == "0")
// DB.ExecuteSQL("update Firmalar set sec=0 where pkFirma=" + fkFirma);
// }
// else
// DB.ExecuteSQL("update Firmalar set sec=0 where pkFirma=" + fkFirma);
//}
frmSmsGonder SmsGonder = new frmSmsGonder();
SmsGonder.Show();
}
private void sMSGönderToolStripMenuItem_Click(object sender, EventArgs e)
{
frmSmsGonder SmsGonder = new frmSmsGonder();
SmsGonder.ShowDialog();
}