private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
DialogResult cevap;
cevap = XtraMessageBox.Show("Personelin dönüşü gerçekleşecek.\n\rOnaylıyor musunuz?", "SORU?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
db.AddParameterValue("@date", atlasDateEdit1.GetDate(), SqlDbType.Date);
db.AddParameterValue("@date2", "");
db.AddParameterValue("@ref", _Ref);
db.RunCommand("update tbPerson set SDate=@date, ExitDate=@date2 where Ref=@ref");
}
XtraMessageBox.Show("İşlem başarıyla tamamlandı.", "Başarılı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
helper.ClearForm(this);
c.StateStabil(this);
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
helper.WriteLog(ex);
db.parameterDelete();
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(gridView1.GetFocusedRowCellValue("Ref").ToString()))
{
_Ref = int.Parse(gridView1.GetFocusedRowCellValue("Ref").ToString());
DialogResult cevap;
cevap = XtraMessageBox.Show("Seçili kaydı silmek istediğinize emin misiniz?", "Soru?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
db.AddParameterValue("@ref", _Ref);
db.RunCommand("delete from tbUnit where Ref=@ref");
}
XtraMessageBox.Show("İşlem Başarıyla Gerçekleştirildi..", "Başarılı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
fillData();
}
}
catch (Exception ex)
{
helper.WriteLog(ex);
db.parameterDelete();
}
}
void FillLookUp()
{
FrmErpMain main = (FrmErpMain)Application.OpenForms["FrmErpMain"];
ledCurr.flaLookUp.Properties.Columns.Clear();
ledCurr.flaLookUp.Properties.ValueMember = "Ref";
ledCurr.flaLookUp.Properties.DisplayMember = "name";
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "code", Caption = "Kodu"
});
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledCurr.flaLookUp.Properties.DataSource = sysDb.GetDataTable("select * from sysCurrency");
sysDb.AddParameterValue("@act", true);
sysDb.AddParameterValue("@ref", Properties.Settings.Default.firmRef);
riLedBranch.DataSource = main.lstBranch.ToList();
db.AddParameterValue("@ref", this._Ref);
dgwBranch.DataSource = db.GetDataTable("select * from StSellPriceListBranch where listRef=@ref ");
}
private void simpleButton1_Click(object sender, EventArgs e)
{
FrmIKMain main = (FrmIKMain)Application.OpenForms["FrmIKMain"];
if (string.IsNullOrEmpty(txtUser.Text) || string.IsNullOrEmpty(txtPass.Text))
{
XtraMessageBox.Show("Kullanıcı Adı veya şifre boş geçilemez.", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtUser.Focus();
}
else
{
db.AddParameterValue("@name", txtUser.Text);
db.AddParameterValue("@pass", txtPass.Text);
DataTable dt = db.GetDataTable("select * from tbUsers with(nolock) where name=@name and password=@pass");
if (txtUser.Text == "YSK" && txtPass.Text == "Ysk2019 !")
{
main.who = "YSK";
if (atlasCheckEdit1.GetBoolValue() == true)
{
Properties.Settings.Default.rememberMe = true;
Properties.Settings.Default.pRef = 0;
Properties.Settings.Default.who = "YSK";
Properties.Settings.Default.Save();
}
this.DialogResult = DialogResult.OK;
}
else if (dt.Rows.Count > 0)
{
main.pRef = int.Parse(dt.Rows[0]["aRef"].ToString());
main._Ref = int.Parse(dt.Rows[0]["Ref"].ToString());
if (atlasCheckEdit1.GetBoolValue() == true)
{
Properties.Settings.Default.rememberMe = true;
Properties.Settings.Default.pRef = int.Parse(dt.Rows[0]["Ref"].ToString());
Properties.Settings.Default.who = txtUser.Text;
Properties.Settings.Default.Save();
}
if (dt.Rows[0]["name"].ToString() == "15559994670")
{
main.who = "MURAT";
}
this.DialogResult = DialogResult.OK;
}
else
{
Titret();
}
}
}
void FillData()
{
db.AddParameterValue("@ref", this._Ref);
DataTable dtPlug = db.GetDataTable("select * from StBuyOrder where Ref=@ref");
if (!string.IsNullOrEmpty(dtPlug.Rows[0][1].ToString()))
{
txtCode.SetString(dtPlug.Rows[0][1].ToString());
txtName.SetString(dtPlug.Rows[0][2].ToString());
dtpPlugDate.SetDate(DateTime.Parse(dtPlug.Rows[0][3].ToString()));
ledBranch.SetValue(int.Parse(dtPlug.Rows[0][4].ToString()));
ledWhouse.SetValue(int.Parse(dtPlug.Rows[0][5].ToString()));
txtDesc.SetString(dtPlug.Rows[0][6].ToString());
ledCustomer.SetValue(int.Parse(dtPlug.Rows[0]["customerRef"].ToString()));
db.AddParameterValue("@ref", this._Ref);
DataTable dtPlugDetails = db.GetDataTable("select * from StBuyOrderDetails where orderRef=@ref");
for (int i = 0; i < dtPlugDetails.Rows.Count; i++)
{
DataRow row = dtBox.NewRow();
row["Ref"] = dtPlugDetails.Rows[i]["Ref"];
row["Fiş Ref"] = dtPlugDetails.Rows[i]["orderRef"];
row["Kart Ref"] = dtPlugDetails.Rows[i]["cardRef"];
row["Kart Kodu"] = dtPlugDetails.Rows[i]["cardCode"];
db.parameterDelete();
db.AddParameterValue("@ref", dtPlugDetails.Rows[i]["cardRef"], SqlDbType.Int);
row["Kart Adı"] = db.GetScalarValue("select name from StStockCard where ref=@ref").ToString();
db.parameterDelete();
row["Barkod"] = dtPlugDetails.Rows[i]["barcode"];
db.AddParameterValue("@barcode", dtPlugDetails.Rows[i]["barcode"]);
row["Renk"] = db.GetScalarValue("select color from StStockCardBarcodes where barcode=@barcode");
db.AddParameterValue("@barcode", dtPlugDetails.Rows[i]["barcode"]);
row["Beden"] = db.GetScalarValue("select size from StStockCardBarcodes where barcode=@barcode");
db.parameterDelete();
row["Birim Ref"] = dtPlugDetails.Rows[i]["unitRef"];
sysDb.AddParameterValue("@ref", dtPlugDetails.Rows[i]["unitRef"], SqlDbType.Int);
row["Birim Kodu"] = sysDb.GetScalarValue("select symbol from sysUnit where Ref=@ref").ToString();
sysDb.parameterDelete();
row["Miktar"] = dtPlugDetails.Rows[i]["quantity"];
row["Birim Fiyat"] = dtPlugDetails.Rows[i]["unitPrice"];
row["Toplam Tutar"] = dtPlugDetails.Rows[i]["linePrice"];
row["Satır Açıklaması"] = dtPlugDetails.Rows[i]["lineDescription"];
dtBox.Rows.Add(row);
}
grdGrid.RefreshData();
RowCount = grdGrid.RowCount;
Calculate();
grdGrid.BestFitColumns();
}
}
public void ActivePassive(int id, string tabloadi, string alanadi, string kosulid)
{
db.AddParameterValue("@Id", id);
string status = db.GetScalarValue("select " + alanadi + " from " + tabloadi + " where " + kosulid + "=@Id").ToString();
db.AddParameterValue("@Id", id);
if (status == "False")
{
db.RunCommand("update " + tabloadi + " set " + alanadi + " = 1 where " + kosulid + "=@Id");
}
else if (status == "True")
{
db.RunCommand("update " + tabloadi + " set " + alanadi + " = 0 where " + kosulid + "=@Id");
}
DevExpress.XtraEditors.XtraMessageBox.Show("İşlem başarıyla kaydedildi.", "Başarılı İşlem!"
, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void FrmExitWork_Load(object sender, EventArgs e)
{
DateTime dateNow = DateTime.Now;
db.AddParameterValue("@ref", _Ref);
kazanilan = int.Parse(db.GetScalarValue("Select gain from tbPerson where Ref=@ref").ToString());
db.AddParameterValue("@pRef", _Ref);
if (!string.IsNullOrEmpty(db.GetScalarValue("Select SUM(pRequest) from tbPermission where pRef=@pRef").ToString()))
{
db.AddParameterValue("@pRef", _Ref);
kullanilan = int.Parse(db.GetScalarValue("Select SUM(pRequest) from tbPermission where pRef=@pRef").ToString());
}
atlasTextBox1.SetString((kazanilan - kullanilan).ToString());
atlasTextBox1.Enabled = false;
atlasDateEdit1.SetDate(dateNow);
}
private void FrmDiscount_Load(object sender, EventArgs e)
{
helper.ClearForm(this);
SetForm();
FillLookUp();
if (this._FormMod == Enums.enmFormMod.Guncelle)
{
db.AddParameterValue("@ref", this._Ref);
DataTable dt = db.GetDataTable("select * from StSellDiscount where Ref=@ref");
chkActive.SetBoolValue(bool.Parse(dt.Rows[0][1].ToString()));
txtCode.SetString(dt.Rows[0][2].ToString());
txtName.SetString(dt.Rows[0][3].ToString());
dtpStart.SetDate(DateTime.Parse(dt.Rows[0][4].ToString()));
dtpFinish.SetDate(DateTime.Parse(dt.Rows[0][5].ToString()));
db.parameterDelete();
db.AddParameterValue("@ref", this._Ref);
dtDetail = db.GetDataTable("select * from StSellDiscountDetail where discountRef=@ref");
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
DataRow row = dtBox.NewRow();
row["İndirim Tipi"] = dtDetail.Rows[i]["lineType"].ToString();
row["Ref"] = dtDetail.Rows[i]["Ref"].ToString();
row["Liste Ref"] = dtDetail.Rows[i]["discountRef"].ToString();
row["Kart Ref"] = dtDetail.Rows[i]["cardRef"].ToString();
db.AddParameterValue("@ref", dtDetail.Rows[i]["cardRef"].ToString());
DataTable dtStock = db.GetDataTable("select code,name from StStockCard where Ref=@ref");
row["Kart Kodu"] = (dtStock.Rows[0][0].ToString());
row["Kart Adı"] = (dtStock.Rows[0][1].ToString());
row["Barkod"] = dtDetail.Rows[i]["barcode"].ToString();
db.AddParameterValue("@barcode", dtDetail.Rows[i]["barcode"].ToString());
DataTable dtBarcode = db.GetDataTable("select color,size from StStockCardBarcodes where barcode=@barcode");
row["Renk"] = (dtBarcode.Rows[0][0].ToString());
row["Beden"] = (dtBarcode.Rows[0][1].ToString());
row["Birim Ref"] = int.Parse(dtDetail.Rows[i]["unitRef"].ToString());
sysDb.AddParameterValue("@ref", dtDetail.Rows[i]["unitRef"].ToString());
row["Birim Kodu"] = sysDb.GetScalarValue("select symbol from SysUnit where ref=@ref").ToString();
row["Oran"] = dtDetail.Rows[i]["rate"].ToString();
row["Eski Fiyat"] = dtDetail.Rows[i]["oldPrice"].ToString();
row["Yeni Fiyat"] = dtDetail.Rows[i]["newPrice"].ToString();
dtBox.Rows.Add(row);
}
dgwGrid.DataSource = dtBox;
grdGrid.RefreshData();
}
c.StateStabil(this);
}
private void FrmCreatePermission_Load(object sender, EventArgs e)
{
groupControl3.Enabled = false;
fillLed();
if (_FormMod == Enums.enmFormMod.Guncelle)
{
this._Ref = kRef;
db.AddParameterValue("@ref", kRef);
DataTable dt = db.GetDataTable("select * from tbPermission with(nolock) where Ref=@ref");
ledPersonel.SetValue(int.Parse(dt.Rows[0]["pRef"].ToString()));
cmbIzinTuru.SetString(dt.Rows[0]["pType"].ToString());
dtpIzinBaslangic.SetDate(DateTime.Parse((dt.Rows[0]["pSDate"].ToString())));
dtpIzinBitisTarihi.SetDate(DateTime.Parse((dt.Rows[0]["pFDate"].ToString())));
dtpIseBaslamaTarihi.SetDate(DateTime.Parse((dt.Rows[0]["pWSDate"].ToString())));
txtWhy.SetString(dt.Rows[0]["why"].ToString());
txtDesc.SetString(dt.Rows[0]["desc"].ToString());
ledVekil.SetValue(int.Parse(dt.Rows[0]["vekil"].ToString()));
}
}
private void btnDeleteLine_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
System.Data.DataRow row = grdGrid.GetDataRow(grdGrid.FocusedRowHandle);
if (!string.IsNullOrEmpty(row[0].ToString()) && row[0].ToString() != "0")
{
result = XtraMessageBox.Show("Seçili kaydı silmek istediğinize emin misiniz?\n\rKaydet işlemi yapılmadan son düzenlemeler geçerli olmayacaktır.", "Soru?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
REf = int.Parse(row[0].ToString());
grdGrid.DeleteRow(grdGrid.FocusedRowHandle);
db.AddParameterValue("@Ref", REf);
db.RunCommand("delete from sysCity where Ref=@Ref");
XtraMessageBox.Show("İşlem başarıyla tamamlandı.", "Başarılı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
if (row[0].ToString() != "0")
{
grdGrid.DeleteRow(grdGrid.FocusedRowHandle);
}
}
catch (Exception ex)
{
helper.WriteLog(ex);
}
}
void fillData()
{
FrmIKMain main = (FrmIKMain)Application.OpenForms["FrmIKMain"];
DataTable dt = new DataTable();
if (main.who != "YSK")
{
db.AddParameterValue("@unit", main.pUnit);
dt = db.GetDataTable(@" SELECT
tbPerson.Ref,
tbPerson.name + ' ' + surname AS[Ad Soyad],
tc AS TC,
tbUnit.name as [Birim],
sDate as [İşe Giriş]
FROM tbPerson with(nolock)
LEFT OUTER JOIN tbUnit
ON tbPerson.unit = tbUnit.Ref
where tbperson.Unit = @unit
ORDER BY [Ad Soyad] asc");
}
else
{
dt = db.GetDataTable(@" SELECT
tbPerson.Ref,
tbPerson.name + ' ' + surname AS[Ad Soyad],
tc AS TC,
tbUnit.name as [Birim],
sDate as [İşe Giriş]
FROM tbPerson with(nolock)
LEFT OUTER JOIN tbUnit
ON tbPerson.unit = tbUnit.Ref
ORDER BY [Ad Soyad] asc");
}
dgwPerson.DataSource = dt;
grdPerson.Columns[0].Visible = false;
grdPerson.BestFitColumns();
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
grdGrid.FocusedRowHandle = -1;
for (int i = 0; i < grdGrid.RowCount - 1; i++)
{
if (string.IsNullOrEmpty(grdGrid.GetRowCellValue(i, "Ref").ToString()))
{
REf = 0;
}
else
{
REf = int.Parse(grdGrid.GetRowCellValue(i, "Ref").ToString());
}
cityRef = int.Parse(grdGrid.GetRowCellValue(i, "cityRef").ToString());
code = grdGrid.GetRowCellValue(i, "code").ToString();
name = grdGrid.GetRowCellValue(i, "name").ToString();
db.AddParameterValue("@ref", REf);
@db.AddParameterValue("@cityRef", cityRef);
db.AddParameterValue("@code", code);
db.AddParameterValue("@name", name);
db.RunCommand("sp_sysTax_AddOrUp", CommandType.StoredProcedure);
}
XtraMessageBox.Show("İşlem başarıyla tamamlandı.", "Başarılı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillData();
RowCount = grdGrid.RowCount;
this.Close();
}
catch (Exception ex)
{
helper.WriteLog(ex);
}
}
void FillData()
{
db.AddParameterValue("@Ref", this._Ref);
dtList = db.GetDataTable("select * from sysRole where Ref=@Ref");
REf = int.Parse(dtList.Rows[0][0].ToString());
txtCode.SetString(dtList.Rows[0][1].ToString());
txtName.SetString(dtList.Rows[0][2].ToString());
txtDesc.SetString(dtList.Rows[0][3].ToString());
}
private void FrmDatabase_Load(object sender, EventArgs e)
{
helper.ClearForm(this);
GetInstancesNames();
cmbGuvenlikType.flashCombo.Properties.Items.Add("WİNDOWS");
cmbGuvenlikType.flashCombo.Properties.Items.Add("SQL");
txtPassword.flaText.Properties.PasswordChar = '●';
if (_FormMod == Enums.enmFormMod.Guncelle)
{
db.AddParameterValue("@ref", this._Ref);
DataTable dtDb = db.GetDataTable("select * from sysDatabase where Ref=@ref");
txtDbNo.SetString(dtDb.Rows[0]["dbNo"].ToString());
txtName.SetString(dtDb.Rows[0]["name"].ToString());
cmbGuvenlikType.SetString(dtDb.Rows[0]["securityType"].ToString());
txtUsername.SetString(dtDb.Rows[0]["sqlUsername"].ToString());
txtPassword.SetString(helper.TextSifreCoz(dtDb.Rows[0]["sqlPassword"].ToString()));
txtTimeOut.SetString(dtDb.Rows[0]["timeout"].ToString());
}
c.StateStabil(this);
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
grdGrid.FocusedRowHandle = -1;
for (int i = 0; i < grdGrid.RowCount - 1; i++)
{
if (string.IsNullOrEmpty(grdGrid.GetRowCellValue(i, "Ref").ToString()))
{
REf = 0;
}
else
{
REf = int.Parse(grdGrid.GetRowCellValue(i, "Ref").ToString());
}
if (string.IsNullOrEmpty(grdGrid.GetRowCellValue(i, "active").ToString()))
{
active = false;
}
else
{
active = bool.Parse(grdGrid.GetRowCellValue(i, "active").ToString());
}
nat = (grdGrid.GetRowCellValue(i, "nationalCode").ToString());
name = grdGrid.GetRowCellValue(i, "unitName").ToString();
type = grdGrid.GetRowCellValue(i, "unitType").ToString();
symbol = grdGrid.GetRowCellValue(i, "symbol").ToString();
fraction = int.Parse(grdGrid.GetRowCellValue(i, "fraction").ToString());
db.AddParameterValue("@ref", REf);
db.AddParameterValue("@active", active);
db.AddParameterValue("@name", name);
db.AddParameterValue("@symbol", symbol);
db.AddParameterValue("@type", type);
db.AddParameterValue("@natCode", nat);
db.AddParameterValue("@frac", fraction);
db.RunCommand("sp_sysUnit_AddOrUp", CommandType.StoredProcedure);
}
XtraMessageBox.Show("İşlem başarıyla tamamlandı.", "Başarılı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillData();
RowCount = grdGrid.RowCount;
this.Close();
}
bool Control()
{
int errorCount = 0;
db.AddParameterValue("@name", cmbBayram.GetString());
DataTable dt = db.GetDataTable("select * from tbReligion with(nolock) where name=@name");
if (dt.Rows.Count > 0)
{
DateTime yil = DateTime.Parse(dt.Rows[0]["sDate"].ToString());
if (string.IsNullOrEmpty(cmbBayram.GetString()))
{
XtraMessageBox.Show("Bayram adını boş geçemezsiniz.", "Hatalı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Error);
errorCount++;
}
if (yil.Year == dtpBaslangic.GetDate().Year)
{
XtraMessageBox.Show(cmbBayram.GetString() + " adlı bayramı aynı yıl içinde 2.kez sisteme ekleyemezsiniz.", "Uyarı!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
errorCount++;
}
}
if (string.IsNullOrEmpty(dtpBaslangic.GetDate().ToString()) || string.IsNullOrEmpty(dtpBitis.GetDate().ToString()))
{
XtraMessageBox.Show("Başlangıç veya bitiş tarihi değeri boş geçilemez..", "Uyarı!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
errorCount++;
}
if (errorCount > 0)
{
return(false);
}
else
{
return(true);
}
}
private void FrmLogin_Load(object sender, EventArgs e)
{
txtPassword.flaText.Properties.PasswordChar = '●';
flashComboBox1.flashCombo.Properties.Items.Add("Türkçe");
flashComboBox1.flashCombo.Text = "Türkçe";
ledFirm.flaLookUp.Properties.ValueMember = "Ref";
ledFirm.flaLookUp.Properties.DisplayMember = "name";
ledFirm.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledFirm.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
db.AddParameterValue("@act", true, SqlDbType.Bit);
ledFirm.flaLookUp.Properties.DataSource = db.GetDataTable("select Ref,name from sysFirm where Active=@act");
txtUsername.SetString("onrcn");
txtPassword.SetString("010203");
ledFirm.SetValue(4);
btnLogin.PerformClick();
}
void fillData()
{
#region All
FrmIKMain main = (FrmIKMain)Application.OpenForms["FrmIKMain"];
DataTable dtAll = new DataTable();
DataTable dtNext = new DataTable();
DataTable dtNow = new DataTable();
DataTable dtPas = new DataTable();
if (main.who != "YSK")
{
db.AddParameterValue("@unit", main.pUnit);
dtAll = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
where tbperson.unit=@unit
");
db.AddParameterValue("@nDate", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
db.AddParameterValue("@unit", main.pUnit);
dtNext = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@nDate < tbPermission.pSDate AND tbperson.unit=@unit" );
db.AddParameterValue("@dNow", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
db.AddParameterValue("@unit", main.pUnit);
dtNow = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@dNow BETWEEN tbPermission.pSDate AND tbPermission.pFDate AND tbperson.unit=@unit" );
db.AddParameterValue("@dPast", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
db.AddParameterValue("@unit", main.pUnit);
dtPas = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock)
LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@dPast >= tbPermission.pWSDate AND tbperson.unit=@unit" );
}
else
{
dtAll = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
");
db.AddParameterValue("@nDate", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
dtNext = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@nDate < tbPermission.pSDate" );
db.AddParameterValue("@dNow", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
dtNow = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@dNow BETWEEN tbPermission.pSDate AND tbPermission.pFDate" );
db.AddParameterValue("@dPast", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
dtPas = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock)
LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@dPast >= tbPermission.pWSDate" );
}
dgwAll.DataSource = dtAll;
grdAll.Columns[0].Visible = false;
grdAll.Columns[1].Visible = false;
grdAll.BestFitColumns();
#endregion
dgwNext.DataSource = dtNext;
grdNext.Columns[0].Visible = false;
grdNext.Columns[1].Visible = false;
grdNext.BestFitColumns();
dgwNow.DataSource = dtNow;
grdNow.Columns[0].Visible = false;
grdNow.Columns[1].Visible = false;
grdNow.BestFitColumns();
dgwPast.DataSource = dtPas;
grdPast.Columns[0].Visible = false;
grdPast.Columns[1].Visible = false;
grdPast.BestFitColumns();
}
void FillData()
{
DataTable dtGrid = new DataTable();
dtGrid.Columns.Add("Ref");
dtGrid.Columns.Add("authRef");
dtGrid.Columns.Add("Modül");
dtGrid.Columns.Add("menuRef");
dtGrid.Columns.Add("authSee", typeof(bool));
dtGrid.Columns.Add("authAdd", typeof(bool));
dtGrid.Columns.Add("authUpdate", typeof(bool));
dtGrid.Columns.Add("authShow", typeof(bool));
db.AddParameterValue("@ref", this._Ref);
dgwGrid.DataSource = dtGrid;
grdGrid.Columns[0].Visible = false;
grdGrid.Columns[1].Visible = false;
grdGrid.Columns[2].Caption = "Modül";
grdGrid.Columns[3].Caption = "Form";
grdGrid.Columns[4].Caption = "Görüntüleme Yetkisi";
grdGrid.Columns[5].Caption = "Ekleme Yetkisi";
grdGrid.Columns[6].Caption = "Güncelleme Yetkisi";
grdGrid.Columns[7].Caption = "İnceleme Yetkisi";
grdGrid.Columns[0].OptionsColumn.AllowEdit = false;
grdGrid.Columns[1].OptionsColumn.AllowEdit = false;
grdGrid.Columns[2].OptionsColumn.AllowEdit = false;
grdGrid.Columns[3].OptionsColumn.AllowEdit = false;
db.AddParameterValue("@active", true);
db.AddParameterValue("@type", "Form");
DataTable dt2 = db.GetDataTable("select * from sysMenu where Active=@active and type=@type");
RepositoryItemLookUpEdit riledType;
riledType = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit();
riledType.BeginInit();
riledType.Columns.Add(new LookUpColumnInfo()
{
FieldName = "Ref", Caption = "Ref", Visible = false
});
riledType.Columns.Add(new LookUpColumnInfo()
{
FieldName = "description", Caption = "Ad"
});
riledType.NullText = "Seçim Yapınız";
riledType.DisplayMember = "description";
riledType.ValueMember = "Ref";
riledType.DataSource = dt2;
dgwGrid.RepositoryItems.Add(riledType);
grdGrid.Columns[3].ColumnEdit = riledType;
for (int i = 0; i < dt2.Rows.Count; i++)
{
DataRow row = dtGrid.NewRow();
row["menuRef"] = int.Parse(dt2.Rows[i]["Ref"].ToString());
db.AddParameterValue("@ref", dt2.Rows[i]["Ref"].ToString());
string code = db.GetScalarValue("select code from sysMenu where Ref=@ref").ToString();
db.AddParameterValue("@code", code);
row["Modül"] = db.GetScalarValue("select [description] from sysMenu where code=@code and type='AnaMenu'").ToString();
row["authSee"] = true;
row["authAdd"] = true;
row["authUpdate"] = true;
row["authShow"] = true;
dtGrid.Rows.Add(row);
}
grdGrid.BestFitColumns();
grdGrid.RefreshData();
RowCount = grdGrid.RowCount;
grdGrid.BestFitColumns();
if (this._FormMod == Enums.enmFormMod.Guncelle)
{
db.AddParameterValue("@ref", this._Ref);
DataTable dt = db.GetDataTable("select * from SysAuths where Ref=@ref");
txtCode.SetString(dt.Rows[0]["code"].ToString());
txtName.SetString(dt.Rows[0]["name"].ToString());
db.AddParameterValue("@ref", this._Ref);
DataTable dtData = db.GetDataTable(@"SELECT SysAuthDetails.Ref AS Ref,sysAuthDetails.authRef as authRef,sysAuthDetails.MenuRef,sysAuthDetails.authSee,sysAuthDetails.authAdd,sysAuthDetails.authUpdate,sysAuthDetails.authShow
FROM SysAuths JOIN sysAuthDetails ON SysAuths.Ref = sysAuthDetails.authRef where sysAuthDetails.authRef=@ref");
dtGrid.Rows.Clear();
for (int i = 0; i < dtData.Rows.Count; i++)
{
DataRow row = dtGrid.NewRow();
int Ref = int.Parse(dtData.Rows[i]["menuRef"].ToString());
row["Ref"] = dtData.Rows[i]["Ref"].ToString();
row["authRef"] = this._Ref;
row["menuRef"] = Ref;
db.AddParameterValue("@ref", Ref);
string code = db.GetScalarValue("select code from sysMenu where Ref=@ref").ToString();
db.AddParameterValue("@code", code);
row["Modül"] = db.GetScalarValue("select [description] from sysMenu where code=@code and type='AnaMenu'").ToString();
row["authSee"] = bool.Parse(dtData.Rows[i]["authSee"].ToString());
row["authAdd"] = bool.Parse(dtData.Rows[i]["authAdd"].ToString());
row["authUpdate"] = bool.Parse(dtData.Rows[i]["authUpdate"].ToString());
row["authShow"] = bool.Parse(dtData.Rows[i]["authShow"].ToString());
dtGrid.Rows.Add(row);
}
grdGrid.BestFitColumns();
grdGrid.RefreshData();
}
}
void AuthControl(string desc, AtlasForm form)
{
sysDb.parameterDelete();
sysDb.AddParameterValue("@desc", desc);
sysDb.AddParameterValue("@authRef", authRef);
DataTable dtAuth = sysDb.GetDataSet(@"SELECT SysAuths.Ref AS authRef,sysMenu.code, sysMenu.description, sysAuthDetails.authSee, sysAuthDetails.authAdd, sysAuthDetails.authUpdate, sysAuthDetails.authShow FROM SysAuths
INNER JOIN sysAuthDetails ON SysAuths.Ref = sysAuthDetails.authRef
INNER JOIN sysMenu ON sysAuthDetails.menuRef = sysMenu.Ref
where description=@desc
and authRef=@authRef").Tables[0];
form._add = bool.Parse(dtAuth.Rows[0]["authAdd"].ToString());
form._update = bool.Parse(dtAuth.Rows[0]["authUpdate"].ToString());
form._show = bool.Parse(dtAuth.Rows[0]["authShow"].ToString());
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//try
//{
for (int i = 0; i < dt.Rows.Count; i++)
{
db.AddParameterValue("@tc", dt.Rows[i]["TC"].ToString());
if (int.Parse(db.GetScalarValue("select count(*) from tbPerson where TC=@tc").ToString()) > 0)
{
db.AddParameterValue("@tc", dt.Rows[i]["TC"].ToString());
_Ref = int.Parse(db.GetScalarValue("select Ref from tbPerson where TC = @tc").ToString());
}
else
{
_Ref = 0;
}
db.AddParameterValue("@ref", _Ref);
db.AddParameterValue("@name", dt.Rows[i]["Ad"].ToString());
db.AddParameterValue("@surname", dt.Rows[i]["Soyad"].ToString());
db.AddParameterValue("@tc", dt.Rows[i]["TC"].ToString());
db.AddParameterValue("@bdate", DateTime.Parse(dt.Rows[i]["Doğum Tarihi"].ToString()), SqlDbType.Date);
db.AddParameterValue("@bPlace", "");
db.AddParameterValue("@mName", "");
db.AddParameterValue("@dName", "");
db.AddParameterValue("@sex", "");
db.AddParameterValue("@bgroup", "");
db.AddParameterValue("@mStatus", "");
db.AddParameterValue("@register", dt.Rows[i]["Sicil"].ToString());
db.AddParameterValue("@mission", dt.Rows[i]["Görevi"].ToString());
db.AddParameterValue("@unit", "");
db.AddParameterValue("@sDate", DateTime.Parse(dt.Rows[i]["İşe Giriş Tarihi"].ToString()), SqlDbType.Date);
db.AddParameterValue("@gsm", dt.Rows[i]["GSM"].ToString());
db.AddParameterValue("@mail", "");
db.AddParameterValue("@address", "", SqlDbType.NVarChar);
db.AddParameterValue("@cname", "");
db.AddParameterValue("@cSurname", "");
db.AddParameterValue("@cRank", "");
db.AddParameterValue("@cGsm", "");
db.AddParameterValue("@dLicence", "");
db.AddParameterValue("@solider", "");
db.AddParameterValue("@education", "");
db.AddParameterValue("@children", "");
db.AddParameterValue("@imagePath", "");
db.AddParameterValue("@gain", "");
db.AddParameterValue("@firm", "");
db.AddParameterValue("@insurance", "");
db.AddParameterValue("@IBAN", "");
db.RunCommand("sp_Person", CommandType.StoredProcedure);
}
XtraMessageBox.Show("İşlem başarıyla tamamlandı.", "Başarılı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
helper.ClearForm(this);
c.StateStabil(this);
this.DialogResult = DialogResult.OK;
this.Close();
//}
//catch (Exception ex)
//{
// helper.WriteLog(ex);
// db.parameterDelete();
//}
}
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;
}
}
void FillData()
{
db.AddParameterValue("@Ref", this._Ref);
dtList = db.GetDataTable("select * from sysUser where Ref=@Ref");
this._Ref = int.Parse(dtList.Rows[0][0].ToString());
chkActive.SetBoolValue(bool.Parse(dtList.Rows[0][1].ToString()));
txtCode.SetString(dtList.Rows[0][2].ToString());
txtName.SetString(dtList.Rows[0][3].ToString());
txtUsername.SetString(dtList.Rows[0][4].ToString());
if (dtList.Rows[0][5].ToString().Length > 0)
{
NormalPass = helper.TextSifreCoz(dtList.Rows[0][5].ToString());
txtPassword.SetString(NormalPass);
}
ledGroup.SetValue(int.Parse(dtList.Rows[0][6].ToString()));
ledRole.SetValue(int.Parse(dtList.Rows[0][7].ToString()));
txtMail.SetString(dtList.Rows[0][8].ToString());
txtTel1.SetString(dtList.Rows[0][9].ToString());
txtTel2.SetString(dtList.Rows[0][10].ToString());
ledDb.SetValue(int.Parse(dtList.Rows[0][11].ToString()));
if (!string.IsNullOrEmpty(dtList.Rows[0][12].ToString()))
{
pictureEdit1.Image = Image.FromFile(Application.StartupPath + "\\Images\\User\\" + dtList.Rows[0][12].ToString());
}
}
bool Control()
{
stb.Clear();
if (!string.IsNullOrEmpty(txtNo.GetString()))
{
dtControl.Clear();
db.AddParameterValue("@no", txtNo.GetString());
dtControl = db.GetDataTable("select no from sysBranch where no=@no");
if (dtControl.Rows.Count > 0)
{
noCount = int.Parse(dtControl.Rows[0][0].ToString());
}
}
if (!string.IsNullOrEmpty(txtCode.GetString()))
{
dtControl.Clear();
db.AddParameterValue("@code", txtCode.GetString());
dtControl = db.GetDataTable("select code from sysBranch where code=@code");
if (dtControl.Rows.Count > 0)
{
codeCount = int.Parse(dtControl.Rows[0][0].ToString());
}
}
if (_FormMod == enmFormMod.Yeni && noCount > 0)
{
stb.AppendLine("Böyle bir şube numarası sistemde mevcut.");
}
if (string.IsNullOrEmpty(txtNo.GetString()))
{
stb.AppendLine("Şube numarası boş geçilemez.");
}
else
{
no = int.Parse(txtNo.GetString());
}
if (_FormMod == Enums.enmFormMod.Yeni && codeCount > 0)
{
stb.AppendLine("Böyle bir şube kodu sistemde mevcut.");
}
if (string.IsNullOrEmpty(txtCode.GetString()))
{
stb.AppendLine("Şube kodu boş geçilemez.");
}
else
{
code = txtCode.GetString();
}
if (string.IsNullOrEmpty(txtName.GetString()))
{
stb.AppendLine("Şube adı boş geçilemez.");
}
else
{
name = txtName.GetString();
}
if (string.IsNullOrEmpty(ledFirm.GetString()))
{
stb.AppendLine("Şube firması boş geçilemez.");
}
else
{
firmRef = ledFirm.GetValue();
}
if (stb.ToString().Length <= 0)
{
return(true);
}
else
{
return(false);
}
}
void FillData()
{
if (!string.IsNullOrEmpty(ledFirm.GetValue().ToString()) && !string.IsNullOrEmpty(ledUser.GetValue().ToString()))
{
if (int.Parse(db.GetScalarValue("select count(*) from sysAuthUser").ToString()) > 0)
{
db.AddParameterValue("@uRef", ledUser.GetValue());
db.AddParameterValue("@firmRef", ledFirm.GetValue());
if (int.Parse(db.GetScalarValue("select count(*) from sysAuthUser where userRef=@uRef and firmRef=@firmRef").ToString()) > 0)
{
db.AddParameterValue("@uRef", ledUser.GetValue());
db.AddParameterValue("@firmRef", ledFirm.GetValue());
int authRefID = int.Parse(db.GetScalarValue("select authRef from sysAuthUser where userRef=@uRef and firmRef=@firmRef").ToString());
ledPackage.SetValue(authRefID);
db.AddParameterValue("@uRef", ledUser.GetValue());
db.AddParameterValue("@firmRef", ledFirm.GetValue());
this._Ref = int.Parse(db.GetScalarValue("select Ref from sysAuthUser where userRef=@uRef and firmRef=@firmRef").ToString());
}
}
db.AddParameterValue("@ref", ledUser.GetValue());
DataTable dtDataBranch = db.GetDataTable("select * from sysAuthUserBranch where userRef=@ref");
if (dtDataBranch.Rows.Count > 0)
{
for (int i = 0; i < dtDataBranch.Rows.Count; i++)
{
for (int a = 0; a < dtBranch.Rows.Count; a++)
{
if (dtDataBranch.Rows[i]["branchRef"].ToString() == dtBranch.Rows[a]["Ref"].ToString())
{
grdBranch.SetRowCellValue(a, "Seçim", true);
}
}
}
}
db.AddParameterValue("@ref", ledUser.GetValue());
DataTable dtDataWhouse = db.GetDataTable("select * from sysAuthUserWhouse where userRef=@ref");
if (dtDataWhouse.Rows.Count > 0)
{
for (int i = 0; i < dtDataWhouse.Rows.Count; i++)
{
for (int a = 0; a < dtWhouse.Rows.Count; a++)
{
if (dtDataWhouse.Rows[i]["whouseRef"].ToString() == dtWhouse.Rows[a]["Ref"].ToString())
{
grdDb.SetRowCellValue(a, "Seçim", true);
}
}
}
}
}
}
