void Add()
{
Person.FrmAddPerson newForm = new Person.FrmAddPerson();
newForm._Ref = 0;
newForm._FormMod = Enums.enmFormMod.Yeni;
//yeniForm.MdiParent = frmAnaMenu.ActiveForm;
newForm.MdiParent = FrmIKMain.ActiveForm;
newForm.Show();
if (newForm.DialogResult == DialogResult.OK)
{
FillData();
}
}
void Show()
{
if (grdList.RowCount > 0)
{
if (grdList.FocusedRowHandle != -1)
{
Person.FrmAddPerson newForm = new Person.FrmAddPerson();
newForm._Ref = int.Parse(grdList.GetFocusedRowCellValue("Ref").ToString());
newForm._MenuNo = this._MenuNo;
newForm._FormMod = Enums.enmFormMod.Goruntule;
newForm.MdiParent = FrmIKMain.ActiveForm;
newForm.Show();
}
}
}
private void barButtonItem5_ItemClick(object sender, ItemClickEventArgs e)
{
Person.FrmAddPerson addPerson = new Person.FrmAddPerson();
DataTable dt = db.GetDataTable(@"SELECT * from tbPerson");
int totalHak = 0;
try
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(dt.Rows[i]["sDate"].ToString()))
{
DateTime sonTarih = DateTime.Now;
DateTime ilkTarih = DateTime.Parse(dt.Rows[i]["sDate"].ToString());
int[] sonuc = addPerson.ikiTarihFarki(sonTarih, ilkTarih);
int yil = int.Parse(sonuc[0].ToString());
int hak = 0;
if (yil < 1)
{
hak = 0;
}
if (yil <= 5 && yil > 1)
{
hak = 14;
}
else if (yil < 15 && yil > 5)
{
hak = 20;
}
else if (yil > 15)
{
hak = 26;
}
int onbes = 0;
int on = 0;
int bes = 0;
int kalan = 0;
if (yil < 1)
{
totalHak += 0;
}
if (yil - 5 >= 0)
{
bes = 1;
totalHak += 5 * 14;
kalan = yil - 5;
}
else if (yil - 5 < 0)
{
totalHak = yil * 14;
}
if (kalan - 10 >= 0)
{
on = 1;
totalHak += 10 * 20;
kalan = kalan - 10;
}
else if (kalan - 10 < 0)
{
totalHak += kalan * 20;
kalan = 0;
}
if (kalan > 0)
{
onbes = 1;
totalHak += kalan * 26;
}
int Ref = int.Parse(dt.Rows[i]["Ref"].ToString());
db.AddParameterValue("@ref", Ref);
db.AddParameterValue("@gain", totalHak);
db.RunCommand("update tbPerson set gain=@gain where Ref=@ref");
}
}
}
}
catch (Exception ex)
{
throw;
}
}
private void barButtonItem1_ItemClick(object sender, ItemClickEventArgs e)
{
Person.FrmAddPerson addPerson = new Person.FrmAddPerson();
Viewchild(addPerson);
}
