private void Sayac_Tick(object sender, EventArgs e)
{
HakYenile();
TimeSpan çıkan = TimeSpan.FromSeconds(MaxZaman);
DateTime dateTime = DateTime.Today.Add(çıkan);
dateTime = dateTime.AddMilliseconds(-(Zaman.ElapsedMilliseconds));
button9.Text = dateTime.ToString("mm:ss");
if (MaxZaman * 1000 < Zaman.ElapsedMilliseconds)
{
Zaman.Stop();
Sayac.Stop();
MessageBox.Show("Bilemediniz! Doğru Cevap:" + TutulanKelimem);
button3.Enabled = true;
button5.Enabled = false;
}
}
private void button3_Click(object sender, EventArgs e)
{
if (Sayıgüncelle() < 1)
{
durum("Oynamak için Kelime Yetersiz!", Sinyal.Hata);
return;
}
if (radioButton1.Checked)
{
TutulanKelimem = KelimeTut((int)numericUpDown1.Value);
}
else
{
TutulanKelimem = KelimeTut();
}
if (TutulanKelimem == "-1")
{
return;
}
flowLayoutPanel1.Controls.Clear();
flowLayoutPanel2.Controls.Clear();
button3.Enabled = false;
button5.Enabled = true;
boşluk = false;
MaxZaman = HarfBaşıSaniye * TutulanKelimem.Length;
Bilinen = 0;
HarfNesneEkle(TutulanKelimem);
Zaman = Stopwatch.StartNew();
Sayac.Start();
HakKalan = TutulanKelimem.Length * 2;
HakLimit = HakKalan;
}
public JsonResult Hesapla(int[] branches, int[] calculates, string[] dates, int[] companies)
{
Sayac say = Context.Sayacs.FirstOrDefault();
if (say != null)
{
if (DateTime.Now > say.AylikTarih.AddDays(29))
{
say.Aylik = 0;
say.AylikTarih = DateTime.Now;
}
if (DateTime.Now > say.GunlukTarih.AddDays(1))
{
say.Gunluk = 0;
say.GunlukTarih = DateTime.Now;
}
if (DateTime.Now > say.YillikTarih.AddDays(364))
{
say.Yillik = 0;
say.YillikTarih = DateTime.Now;
}
say.Aylik += 1;
say.Yillik += 1;
say.Gunluk += 1;
Context.SaveChanges();
}
if (dates[0].ToString().Length == 0 || branches[0].ToString().Length == 0 || calculates[0].ToString().Length == 0 || companies[0].ToString().Length == 0)
{
return(Json(-1, JsonRequestBehavior.AllowGet));
}
try
{
string strbran = "";
for (int i = 0; i < branches.Length; i++)
{
strbran += branches[i];
if (i != branches.Length - 1)
{
strbran += ",";
}
}
string strdate = "";
for (int i = 0; i < dates.Length; i++)
{
DateTime d = Convert.ToDateTime(dates[i]);
strdate += ((char)39).ToString() + d.Year + "-" + d.Month + "-01" + ((char)39).ToString();
if (i != dates.Length - 1)
{
strdate += ",";
}
}
string strComp = "";
string smallQuery = "";
bool add = false;
bool addc = false;
string sorgu = "";
for (int i = 0; i < companies.Length; i++)
{
if (companies[i] == 72 || companies[i] == 73 || companies[i] == 74 || companies[i] == 75)
{
smallQuery += companies[i];
add = true;
if (i != companies.Length - 1)
{
smallQuery += ",";
}
}
else
{
strComp += companies[i];
addc = true;
if (i != companies.Length - 1)
{
strComp += ",";
}
}
}
if (smallQuery != "")
{
if (smallQuery[smallQuery.Length - 1] == ',')
{
smallQuery = smallQuery.Substring(0, smallQuery.Length - 1);
}
}
if (strComp != "")
{
if (strComp[strComp.Length - 1] == ',')
{
strComp = strComp.Substring(0, strComp.Length - 1);
}
}
//Toplam İşlemleri
if (add)
{
for (int u = 0; u < calculates.Length; u++)
{
int ct = calculates[u];
Calc c = Context.Calcs.Where(s => s.id == ct).FirstOrDefault();
if (c.sumAll)
{
sorgu += " select 'Toplam '+ (select name from CompanyTypes where id=companyTypeId) as companyName ,date,(select name from Calcs where id = " + calculates[u] + " )as calcName,sum(amount) as amount from Data B where B.date in (" + strdate + ") and B.branchId in(" + strbran + ") and B.companyTypeId in(select companyTypeId from Companies C where C.companyTypeId in(select companyTypeId from Companies where id in(" + smallQuery + "))) and B.accountId in (select A.accountId from AccountCalcRelations A where A.calcId = " + calculates[u] + ") group by date,companyTypeId ";
}
//buraya sorgu yazılacak üstteki sorgunun farklı formul türevi
else
{
string[] parse = c.formul.Split('/')[0].Split(',').ToArray();
string ss = "";
string ss2 = "";
int k = 0;
foreach (string item in parse)
{
if (int.TryParse(item, out k))
{
ss += item + ",";
}
}
ss = ss.Substring(0, ss.Length - 1);
parse = c.formul.Split('/')[1].Split(',').ToArray();
foreach (string item in parse)
{
if (int.TryParse(item, out k))
{
ss2 += item + ",";
}
}
ss2 = ss2.Substring(0, ss2.Length - 1);
sorgu += " select x.companyName,x.date,x.calcName, ((x.amount*100) / y.amount ) as amount from(select 'Toplam '+ (select name from CompanyTypes where id=companyTypeId) as companyName ,date,(select name from Calcs where id = " + calculates[u] + " )as calcName,sum(amount) as amount from Data B where B.date in (" + strdate + ") and B.branchId in(" + strbran + ") and B.companyTypeId in(select companyTypeId from Companies C where C.companyTypeId in(select companyTypeId from Companies where id in(" + smallQuery + "))) and B.accountId in (" + ss + ") group by date,companyTypeId) x join ( select 'Toplam '+ (select name from CompanyTypes where id=companyTypeId) as companyName ,date,(select name from Calcs where id = " + calculates[u] + " )as calcName,sum(amount) as amount from Data B where B.date in (" + strdate + ") and B.branchId in(" + strbran + ") and B.companyTypeId in(select companyTypeId from Companies C where C.companyTypeId in(select companyTypeId from Companies where id in(" + smallQuery + "))) and B.accountId in (" + ss2 + ") group by date,companyTypeId) y on x.companyName = y.companyName and x.date = y.date ";
}
if (u != calculates.Length - 1)
{
sorgu += " union all ";
}
}
if (addc)
{
sorgu += " union all ";
}
}
if (addc)
{
for (int i = 0; i < calculates.Length; i++)
{
int ct = calculates[i];
Calc c = Context.Calcs.Where(s => s.id == ct).FirstOrDefault();
//stardart queryler
if (c.sumAll)
{
sorgu += " select ( select name from Companies where id = companyId) as companyName,date,(select name from Calcs where id = " + calculates[i] + " ) as calcName,sum(amount) as amount from Data B where B.companyId in(" + strComp + ") and B.date in (" + strdate + ") and B.branchId in(" + strbran + ") and B.accountId in (select A.accountId from AccountCalcRelations A where A.calcId = " + calculates[i] + ") group by date,companyId ";
}
//bölümlü queryler
else
{
string[] parse = c.formul.Split('/')[0].Split(',').ToArray();
string ss = "";
string ss2 = "";
int k = 0;
foreach (string item in parse)
{
if (int.TryParse(item, out k))
{
ss += item + ",";
}
}
ss = ss.Substring(0, ss.Length - 1);
parse = c.formul.Split('/')[1].Split(',').ToArray();
foreach (string item in parse)
{
if (int.TryParse(item, out k))
{
ss2 += item + ",";
}
}
ss2 = ss2.Substring(0, ss2.Length - 1);
sorgu += " select x.companyName,x.date,x.calcName, ((x.amount*100) / y.amount ) as amount from( select(select name from Companies where id = companyId) as companyName, date, (select name from Calcs where id = " + calculates[i] + ") as calcName,sum(amount) as amount from Data B where B.companyId in(" + strComp + ") and B.date in (" + strdate + ") and B.branchId in(" + strbran + ") and B.accountId in (" + ss + ") group by date,companyId) x join ( select(select name from Companies where id = companyId) as companyName, date, (select name from Calcs where id = " + calculates[i] + ") as calcName,sum(amount) as amount from Data B where B.companyId in(" + strComp + ") and B.date in (" + strdate + ") and B.branchId in(" + strbran + ") and B.accountId in (" + ss2 + ") group by date,companyId) y on x.companyName = y.companyName and x.date = y.date ";
}
if (i != calculates.Length - 1)
{
sorgu += " union all ";
}
}
}
List <companyDateHelper> adder = new List <companyDateHelper>();
for (int k = 0; k < calculates.Length; k++)
{
int dene2 = calculates[k];
string sc = Context.Calcs.Where(s => s.id == dene2).Select(a => a.name).FirstOrDefault();
for (int j = 0; j < companies.Length; j++)
{
int dene = companies[j];
string scom = "";
scom = Context.Companies.Where(s => s.id == dene).Select(a => a.name).FirstOrDefault();
for (int i = 0; i < dates.Length; i++)
{
adder.Add(new companyDateHelper()
{
calcType = sc,
indexer = k,
amount = "0",
companyName = scom,
date = Convert.ToDateTime(dates[i]),
});
}
}
}
using (SqlConnection con = new SqlConnection(@"Data Source = 94.102.13.102;Initial Catalog=NihaiVeri;User ID = Alperbasda;Password=Ab3142;"))
{
con.Open();
SqlCommand cmd = new SqlCommand(sorgu, con)
{
CommandTimeout = 3600
};
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
companyDateHelper data = adder.Where(s => s.date == (DateTime)dr["date"] && s.companyName.ToLower() == dr["companyName"].ToString().ToLower() && s.calcType == dr["calcName"].ToString()).FirstOrDefault();
data.amount = String.Format(CultureInfo.InvariantCulture, "{0:0,0.00}", dr["amount"]);
}
con.Close();
}
return(Json(adder, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.InnerException, JsonRequestBehavior.AllowGet));
}
}
public void KurSayac(Sayac sayac)
{
this._hataik.KurSayac(sayac);
}
public void KurSayac(Sayac sayac)
{
this._hataRapor.KurSayac(sayac);
}
private void button5_Click(object sender, EventArgs e)
{
string Tbox = textBox2.Text.ToLower();
bool Bildimi = false;
if (TutulanKelimem.Contains(Tbox))
{
for (int i = 0; i < TutulanKelimem.Length; i++)
{
harf a = (harf)flowLayoutPanel1.Controls[i];
string tutulan = TutulanKelimem.Substring(i, 1);
if (tutulan == Tbox)
{
a.HarfGöster();
if (a.renk != Color.GreenYellow)
{
a.renk = Color.GreenYellow;
Bilinen++;
}
Bildimi = true;
}
else if (!boşluk && tutulan == " ")
{
Bilinen++;
}
}
}
boşluk = true;
string harfler = String.Join("", DenenmişHarfler.ToArray());
if (!harfler.Contains(Tbox))
{
Label lbl = new Label();
lbl.Text = Tbox.ToUpper();
lbl.Font = new Font(textBox2.Font.FontFamily, textBox2.Font.Size, FontStyle.Strikeout);
lbl.AutoSize = true;
DenenmişHarfler.Add(Tbox);
if (!Bildimi)
{
HakKalan--;
}
else
{
lbl.Font = new Font(textBox2.Font.FontFamily, textBox2.Font.Size, FontStyle.Bold);
lbl.ForeColor = Color.ForestGreen;
}
flowLayoutPanel2.Controls.Add(lbl);
}
else if (flowLayoutPanel2.Controls.Count > 0 && !Bildimi)
{
foreach (Label lbl in flowLayoutPanel2.Controls)
{
if (lbl.Text.Equals(Tbox, StringComparison.OrdinalIgnoreCase))
{
Thread uyarı = new Thread(a => {
lbl.ForeColor = Color.Red;
Thread.Sleep(80);
lbl.ForeColor = Color.Black;
Thread.Sleep(80);
lbl.ForeColor = Color.Red;
Thread.Sleep(80);
lbl.ForeColor = Color.Black;
Thread.Sleep(80);
lbl.ForeColor = Color.Red;
Thread.Sleep(80);
lbl.ForeColor = Color.Black;
});
uyarı.Start();
}
}
}
if (HakKalan == 0)
{
MessageBox.Show("Bilemediniz! Doğru Cevap:" + TutulanKelimem);
button3.Enabled = true;
button5.Enabled = false;
Zaman.Stop();
Sayac.Stop();
}
else if (Bilinen == TutulanKelimem.Length)
{
SkorEkle msg = new SkorEkle();
string skor = SkorHesapla(TutulanKelimem).ToString();
msg.label1.Text = string.Format(msg.label1.Text, skor);
Zaman.Stop();
Sayac.Stop();
msg.ShowDialog();
if (msg.isim != null)
{
SkorEkle(msg.isim, skor);
}
button3.Enabled = true;
button5.Enabled = false;
}
}
