void FillData()
{
db.AddParameterValue("@ref", this._Ref);
DataTable dtPlug = db.GetDataTable("select * from StSellOrder where Ref=@ref");
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 StSellOrderDetails 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();
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int maxCode = int.Parse(db.GetScalarValue("select MAX(code) from StStockCard").ToString());
for (int i = 0; i < grdGrid.RowCount; i++)
{
if (i == 0)
{
grdGrid.SetRowCellValue(i, "Seçim", true);
grdGrid.SetRowCellValue(i, "Code", maxCode + 1);
if (string.IsNullOrEmpty(grdGrid.GetRowCellValue(i, "Name").ToString()))
{
grdGrid.SetRowCellValue(i, "Name", "BOŞ");
}
}
else
{
grdGrid.SetRowCellValue(i, "Seçim", true);
grdGrid.SetRowCellValue(i, "Code", int.Parse(grdGrid.GetRowCellValue(i - 1, "Code").ToString()) + 1);
if (string.IsNullOrEmpty(grdGrid.GetRowCellValue(i, "Name").ToString()))
{
grdGrid.SetRowCellValue(i, "Name", "BOŞ");
}
}
}
for (int a = 0; a < grdGrid.RowCount; a++)
{
if ((grdGrid.GetRowCellValue(a, "Name").ToString()) == "BOŞ")
{
state = false;
break;
}
else
{
state = true;
}
}
if (state == false)
{
XtraMessageBox.Show("Kart adı boş geçilen satırların Ad kısmı BOŞ olarak değiştirilmiştir.\n\rBu kayıtlar düzeltilmeden aktarım yapılmayacaktır.", "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Error);
grdGrid.Columns[3].OptionsColumn.AllowEdit = true;
}
grdGrid.RefreshData();
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 btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (Control())
{
db.AddParameterValue("@ref", this._Ref);
db.AddParameterValue("@code", code);
db.AddParameterValue("@name", name);
db.RunCommand("sp_StockCardSize", CommandType.StoredProcedure);
db.parameterDelete();
if (this._FormMod == Enums.enmFormMod.Yeni)
{
MaxRef += int.Parse(db.GetScalarValue("select Max(Ref) from StStockCardSize").ToString());
}
else
{
MaxRef = this._Ref;
}
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());
}
name = grdGrid.GetRowCellValue(i, "propName").ToString();
db.AddParameterValue("@ref", REf);
db.AddParameterValue("@sizeRef", MaxRef);
db.AddParameterValue("@propName", name);
db.RunCommand("sp_StockCardSizeDetails", CommandType.StoredProcedure);
}
XtraMessageBox.Show("İşlem başarıyla tamamlandı.", "Başarılı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillData();
RowCount = grdGrid.RowCount;
this.DialogResult = DialogResult.OK;
c.StateStabil(this);
this.Close();
}
}
catch (Exception ex)
{
helper.WriteLog(ex);
db.parameterDelete();
}
}
private void fillGrid(object sender, EventArgs e)
{
if (ledCard.GetValue() != 0)
{
dtList.Rows.Clear();
db.AddParameterValue("@ref", ledCard.GetValue());
DataTable dt = db.GetDataTable("select * from StStockCardBarcodes where cardRef=@ref");
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dtList.NewRow();
row["Beden"] = dt.Rows[i]["size"].ToString();
row["Renk"] = dt.Rows[i]["color"].ToString();
row["Barkod"] = dt.Rows[i]["barcode"].ToString();
dtList.Rows.Add(row);
db.AddParameterValue("@ref", ledCard.GetValue());
flashTextBox1.SetString(db.GetScalarValue("select name from StStockCard where Ref=@ref").ToString());
}
grdGrid.RefreshData();
grdGrid.BestFitColumns();
}
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (Control())
{
db.AddParameterValue("@ref", this._Ref);
db.AddParameterValue("@active", chkActive.GetBoolValue());
db.AddParameterValue("@code", txtCode.GetString());
db.AddParameterValue("@name", txtName.GetString());
db.AddParameterValue("@currencyRef", ledCurr.GetValue());
db.AddParameterValue("@start", dtpStart.GetDate(), SqlDbType.Date);
db.AddParameterValue("@finish", dtpFinish.GetDate(), SqlDbType.Date);
db.RunCommand("sp_SellPriceList", CommandType.StoredProcedure);
db.parameterDelete();
if (this._FormMod == Enums.enmFormMod.Yeni)
{
this._Ref = int.Parse(db.GetScalarValue("select MAX(ref) from StSellPriceList").ToString());
}
for (int a = 0; a < grdGrid.RowCount - 1; a++)
{
if (string.IsNullOrEmpty(grdGrid.GetRowCellValue(a, "Ref").ToString()))
{
REf = 0;
}
else
{
REf = int.Parse(grdGrid.GetRowCellValue(a, "Ref").ToString());
}
decimal price = decimal.Parse(grdGrid.GetRowCellValue(a, "Fiyat").ToString());
db.AddParameterValue("@ref", REf);
db.AddParameterValue("@listRef", this._Ref);
db.AddParameterValue("@cardRef", grdGrid.GetRowCellValue(a, "Kart Ref"));
db.AddParameterValue("@unitRef", grdGrid.GetRowCellValue(a, "Birim Ref"));
db.AddParameterValue("@barcode", grdGrid.GetRowCellValue(a, "Barkod"));
db.AddParameterValue("@price", price, SqlDbType.Decimal);
db.RunCommand("sp_SellPriceListDetails", CommandType.StoredProcedure);
db.parameterDelete();
}
for (int i = 0; i < grdBranch.RowCount - 1; i++)
{
if (string.IsNullOrEmpty(grdBranch.GetRowCellValue(i, "Ref").ToString()))
{
REf = 0;
}
else
{
REf = int.Parse(grdBranch.GetRowCellValue(i, "Ref").ToString());
}
db.AddParameterValue("@ref", REf);
db.AddParameterValue("@listRef", this._Ref);
db.AddParameterValue("@branchRef", grdBranch.GetRowCellValue(i, "branchRef"));
db.RunCommand("sp_SellPriceListBranch", CommandType.StoredProcedure);
db.parameterDelete();
}
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();
}
else
{
FrmErrorForm form = new FrmErrorForm();
form.flashMemoEdit1.SetString(stb.ToString());
form.ShowDialog();
}
}
catch (Exception ex)
{
helper.WriteLog(ex);
}
}
void Save()
{
if (Control())
{
db.AddParameterValue("@ref", this._Ref);
db.AddParameterValue("@code", txtCode.GetString());
db.AddParameterValue("@name", txtName.GetString());
db.AddParameterValue("@customerRef", ledCustomer.GetValue());
db.AddParameterValue("@date", dtpPlugDate.GetDate().ToShortDateString(), SqlDbType.Date);
db.AddParameterValue("@branch", branch);
db.AddParameterValue("@desc", txtDesc.GetString());
db.AddParameterValue("@state", true);
db.AddParameterValue("@totalPrice", allTotal, SqlDbType.Decimal);
db.RunCommand("sp_BuyServiceOrder", CommandType.StoredProcedure);
db.parameterDelete();
if (this._FormMod == Enums.enmFormMod.Yeni)
{
this._Ref = int.Parse(db.GetScalarValue("select MAX(Ref) from StBuyServiceOrder").ToString());
}
grdGrid.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
grdGrid.OptionsView.ShowAutoFilterRow = false;
for (int i = 0; i < grdGrid.RowCount; i++)
{
if (string.IsNullOrEmpty(grdGrid.GetRowCellValue(i, "Ref").ToString()))
{
REf = 0;
}
else
{
REf = int.Parse(grdGrid.GetRowCellValue(i, "Ref").ToString());
}
int serviceRef = int.Parse(grdGrid.GetRowCellValue(i, "Hizmet Ref").ToString());
string serviceCode = grdGrid.GetRowCellValue(i, "Hizmet Kodu").ToString();
int quantity = int.Parse(grdGrid.GetRowCellValue(i, "Miktar").ToString());
string lineDesc = grdGrid.GetRowCellValue(i, "Satır Açıklaması").ToString();
decimal unitPrice = decimal.Parse(grdGrid.GetRowCellValue(i, "Birim Fiyat").ToString());
decimal linePrice = decimal.Parse(grdGrid.GetRowCellValue(i, "Toplam Tutar").ToString());
db.AddParameterValue("@ref", REf);
db.AddParameterValue("@orderRef", this._Ref);
db.AddParameterValue("@serviceRef", serviceRef);
db.AddParameterValue("@serviceCode", serviceCode);
db.AddParameterValue("@quantity", quantity);
db.AddParameterValue("@unitPrice", unitPrice, SqlDbType.Decimal);
db.AddParameterValue("@linePrice", linePrice, SqlDbType.Decimal);
db.AddParameterValue("@direc", direc);
db.AddParameterValue("@desc", lineDesc);
db.RunCommand("sp_BuyServiceOrderDetails", CommandType.StoredProcedure);
}
XtraMessageBox.Show("İşlem başarılı bir şekilde kaydedildi.", "Başarılı işlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
ok = true;
}
else
{
FrmErrorForm form = new FrmErrorForm();
form.flashMemoEdit1.SetString(stb.ToString());
form.ShowDialog();
}
}
private void gridView1_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Space)
{
if (gridView1.GetFocusedRowCellValue("Seçim").ToString() == "True")
{
gridView1.SetFocusedRowCellValue("Seçim", false);
}
else
{
gridView1.SetFocusedRowCellValue("Seçim", true);
}
}
else if (e.KeyCode == Keys.Enter)
{
string barcode = "";
string oldBarcode, state = "";
int miktar;
int LastListRef;
DataRow row;
gridView1.Columns[2].UnGroup();
#region Plug
if (gelen == "Plug")
{
FrmOperation form = (FrmOperation)Application.OpenForms["FrmOperation"];
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
{
if (form.grdGrid.RowCount - 1 > 0)
{
for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
{
barcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
if (barcode == oldBarcode)
{
miktar = int.Parse(form.grdGrid.GetRowCellValue(a, "Miktar").ToString());
miktar++;
form.grdGrid.SetRowCellValue(a, "Miktar", miktar);
state = "true";
break;
}
else
{
state = "false";
}
}
if (state == "false")
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Miktar"] = 1;
form.dtBox.Rows.Add(row);
}
}
else
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Miktar"] = 1;
form.dtBox.Rows.Add(row);
}
}
}
}
#endregion
#region Sell List
else if (gelen == "List")
{
Sell.FrmSellPrices form = (Sell.FrmSellPrices)Application.OpenForms["FrmSellPrices"];
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
{
if (form.grdGrid.RowCount - 1 > 0)
{
for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
{
barcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
if (barcode == oldBarcode)
{
state = "true";
break;
}
else
{
state = "false";
}
}
if (state == "false")
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Fiyat"] = 1;
form.dtBox.Rows.Add(row);
}
}
else
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Fiyat"] = 1;
form.dtBox.Rows.Add(row);
}
}
}
}
#endregion
#region Kampanya
else if (gelen == "Campaing")
{
Sell.FrmCampaings form = (Sell.FrmCampaings)Application.OpenForms["FrmCampaings"];
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
{
if (form.grdGrid.RowCount - 1 > 0)
{
for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
{
barcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
if (barcode == oldBarcode)
{
state = "true";
break;
}
else
{
state = "false";
}
}
if (state == "false")
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
form.dtBox.Rows.Add(row);
}
}
else
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
form.dtBox.Rows.Add(row);
}
}
}
}
#endregion
#region İndirim
else if (gelen == "Discount")
{
Sell.FrmDiscount form = (Sell.FrmDiscount)Application.OpenForms["FrmDiscount"];
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
{
if (form.grdGrid.RowCount - 1 > 0)
{
for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
{
barcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
if (barcode == oldBarcode)
{
state = "true";
break;
}
else
{
state = "false";
}
}
if (state == "false")
{
row = form.dtBox.NewRow();
row["İndirim Tipi"] = 400;
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
string paramBarcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
db.AddParameterValue("@branchRef", branchRef);
db.AddParameterValue("@barcode", paramBarcode);
row["Eski Fiyat"] = decimal.Parse(db.GetScalarValue("select dbo.Tools_GetLastActiveSellPrice(@barcode,@branchRef)").ToString());
form.dtBox.Rows.Add(row);
}
}
else
{
row = form.dtBox.NewRow();
row["İndirim Tipi"] = 400;
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
string paramBarcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
db.AddParameterValue("@branchRef", branchRef);
db.AddParameterValue("@barcode", paramBarcode);
row["Eski Fiyat"] = decimal.Parse(db.GetScalarValue("select dbo.Tools_GetLastActiveSellPrice(@barcode,@branchRef)").ToString());
form.dtBox.Rows.Add(row);
}
}
}
}
#endregion
#region Buy List
else if (gelen == "Buy")
{
Buy.FrmBuyList form = (Buy.FrmBuyList)Application.OpenForms["FrmBuyList"];
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
{
if (form.grdGrid.RowCount - 1 > 0)
{
for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
{
barcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
if (barcode == oldBarcode)
{
state = "true";
break;
}
else
{
state = "false";
}
}
if (state == "false")
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Fiyat"] = 1;
form.dtBox.Rows.Add(row);
}
}
else
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Fiyat"] = 1;
form.dtBox.Rows.Add(row);
}
}
}
}
#endregion
#region Buy Order
if (gelen == "Buy Order")
{
Buy.FrmBuyOrder form = (Buy.FrmBuyOrder)Application.OpenForms["FrmBuyOrder"];
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
{
if (form.grdGrid.RowCount - 1 > 0)
{
for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
{
barcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
if (barcode == oldBarcode)
{
miktar = int.Parse(form.grdGrid.GetRowCellValue(a, "Miktar").ToString());
miktar++;
form.grdGrid.SetRowCellValue(a, "Miktar", miktar);
state = "true";
break;
}
else
{
state = "false";
}
}
if (state == "false")
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Miktar"] = 1;
db.AddParameterValue("@barcode", gridView1.GetRowCellValue(i, "Barkod").ToString());
db.AddParameterValue("@branchRef", form.ledBranch.GetValue());
string price = db.GetScalarValue("select dbo.Tools_GetLastActiveBuyPrice(@barcode,@branchRef)").ToString();
row["Birim Fiyat"] = price;
decimal total = 1 * decimal.Parse(price);
row["Toplam Tutar"] = total;
form.dtBox.Rows.Add(row);
}
}
else
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Miktar"] = 1;
db.AddParameterValue("@barcode", gridView1.GetRowCellValue(i, "Barkod").ToString());
db.AddParameterValue("@branchRef", form.ledBranch.GetValue());
string price = db.GetScalarValue("select dbo.Tools_GetLastActiveBuyPrice(@barcode,@branchRef)").ToString();
row["Birim Fiyat"] = price;
decimal total = 1 * decimal.Parse(price);
row["Toplam Tutar"] = total;
form.dtBox.Rows.Add(row);
}
}
}
form.Calculate();
}
#endregion
#region Sell Order
if (gelen == "Sell Order")
{
Sell.FrmSellOrder form = (Sell.FrmSellOrder)Application.OpenForms["FrmSellOrder"];
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, "Seçim").ToString() == "True")
{
if (form.grdGrid.RowCount - 1 > 0)
{
for (int a = 0; a < form.grdGrid.RowCount - 1; a++)
{
barcode = gridView1.GetRowCellValue(i, "Barkod").ToString();
oldBarcode = form.grdGrid.GetRowCellValue(a, "Barkod").ToString();
if (barcode == oldBarcode)
{
miktar = int.Parse(form.grdGrid.GetRowCellValue(a, "Miktar").ToString());
miktar++;
form.grdGrid.SetRowCellValue(a, "Miktar", miktar);
state = "true";
break;
}
else
{
state = "false";
}
}
if (state == "false")
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Miktar"] = 1;
db.AddParameterValue("@barcode", gridView1.GetRowCellValue(i, "Barkod").ToString());
db.AddParameterValue("@branchRef", form.ledBranch.GetValue());
string price = db.GetScalarValue("select dbo.Tools_GetLastActiveSellPrice(@barcode,@branchRef)").ToString();
row["Birim Fiyat"] = price;
decimal total = 1 * decimal.Parse(price);
row["Toplam Tutar"] = total;
form.dtBox.Rows.Add(row);
}
}
else
{
row = form.dtBox.NewRow();
row["Kart Ref"] = int.Parse(gridView1.GetRowCellValue(i, "Ref").ToString());
row["Kart Kodu"] = gridView1.GetRowCellValue(i, "Kart Kodu").ToString();
row["Kart Adı"] = gridView1.GetRowCellValue(i, "Kart Adı").ToString();
row["Renk"] = gridView1.GetRowCellValue(i, "Renk").ToString();
row["Beden"] = gridView1.GetRowCellValue(i, "Beden").ToString();
row["Barkod"] = gridView1.GetRowCellValue(i, "Barkod").ToString();
row["Birim Ref"] = gridView1.GetRowCellValue(i, "Birim Ref").ToString();
row["Birim Kodu"] = gridView1.GetRowCellValue(i, "Birim Kodu").ToString();
row["Miktar"] = 1;
db.AddParameterValue("@barcode", gridView1.GetRowCellValue(i, "Barkod").ToString());
db.AddParameterValue("@branchRef", form.ledBranch.GetValue());
string price = db.GetScalarValue("select dbo.Tools_GetLastActiveSellPrice(@barcode,@branchRef)").ToString();
row["Birim Fiyat"] = price;
decimal total = 1 * decimal.Parse(price);
row["Toplam Tutar"] = total;
form.dtBox.Rows.Add(row);
}
}
}
form.Calculate();
}
#endregion
this.DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
helper.WriteLog(ex);
}
}
private void BtnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int maxSiraNo = 0, count = 0;
try
{
for (int i = 0; i < grdClassValue.RowCount - 1; i++)
{
if (string.IsNullOrEmpty(grdClassValue.GetRowCellValue(i, "Ref").ToString()))
{
REf = 0;
}
else
{
REf = int.Parse(grdClassValue.GetRowCellValue(i, "Ref").ToString());
}
db.AddParameterValue("@ref", REf);
db.AddParameterValue("@no", int.Parse(grdClassValue.GetRowCellValue(i, "Sıra No").ToString()));
db.AddParameterValue("@name", grdClassValue.GetRowCellValue(i, "Sınıf Adı").ToString().ToUpper());
db.RunCommand("sp_StockCardClass", CommandType.StoredProcedure);
}
int eksikKalan = 11 - grdClassValue.RowCount;
for (int i = 0; i < eksikKalan; i++)
{
count = int.Parse(db.GetScalarValue("Select COUNT(*) from StStockCardClass").ToString());
if (count > 0)
{
maxSiraNo = int.Parse(db.GetScalarValue("select MAX(no) from StStockCardClass").ToString());
}
maxSiraNo++;
db.AddParameterValue("@ref", 0);
db.AddParameterValue("@no", maxSiraNo);
db.AddParameterValue("@name", "BOŞ");
db.RunCommand("sp_StockCardClass", CommandType.StoredProcedure);
}
for (int i = 0; i < grdValue.RowCount - 1; i++)
{
if (string.IsNullOrEmpty(grdValue.GetRowCellValue(i, "Ref").ToString()))
{
REf = 0;
}
else
{
REf = int.Parse(grdValue.GetRowCellValue(i, "Ref").ToString());
}
db.AddParameterValue("@ref", REf);
db.AddParameterValue("@classRef", selectedClassRef);
db.AddParameterValue("@code", grdValue.GetRowCellValue(i, "Özellik Kodu").ToString());
db.AddParameterValue("@name", grdValue.GetRowCellValue(i, "Özellik Adı").ToString().ToUpper());
db.AddParameterValue("@status", bool.Parse(grdValue.GetRowCellValue(i, "Özellik Durumu").ToString()), SqlDbType.Bit);
db.RunCommand("sp_StockCardClassDetail", CommandType.StoredProcedure);
}
XtraMessageBox.Show("İşlem başarılı bir şekilde kaydedildi.", "Başarılı işlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
helper.ClearForm(this);
c.StateStabil(this);
FillData();
}
catch (Exception ex)
{
helper.WriteLog(ex);
}
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (Control() == true)
{
calculateGain();
if (!File.Exists(goal) && !string.IsNullOrEmpty(goal))
{
Directory.CreateDirectory(goal);
File.Copy(MainPath, goal + newName);
}
db.AddParameterValue("@ref", _Ref);
db.AddParameterValue("@name", txtAd.GetString());
db.AddParameterValue("@surname", txtSoyad.GetString());
db.AddParameterValue("@tc", txtTC.GetString());
db.AddParameterValue("@bdate", dtpDTarihi.GetDate(), SqlDbType.Date);
db.AddParameterValue("@bPlace", txtDogumYeri.GetString());
db.AddParameterValue("@mName", txtAnneAdi.GetString());
db.AddParameterValue("@dName", txtBabaAdi.GetString());
db.AddParameterValue("@sex", cmbCinsiyet.GetString());
db.AddParameterValue("@bgroup", cmbKanGrubu.GetString());
db.AddParameterValue("@mStatus", cmbMedeni.GetString());
db.AddParameterValue("@register", txtSicil.GetString());
db.AddParameterValue("@mission", txtGorev.GetString());
db.AddParameterValue("@unit", ledBirim.GetValue());
db.AddParameterValue("@sDate", dtpIseGiris.GetDate(), SqlDbType.Date);
db.AddParameterValue("@gsm", txtGSM.GetString());
db.AddParameterValue("@mail", txtMail.GetString());
db.AddParameterValue("@address", txtAdres.GetString(), SqlDbType.NVarChar);
db.AddParameterValue("@cname", txtYAd.GetString());
db.AddParameterValue("@cSurname", txtYSoyad.GetString());
db.AddParameterValue("@cRank", cmbDerece.GetString());
db.AddParameterValue("@cGsm", txtYgsm.GetString());
db.AddParameterValue("@dLicence", cmbEhliyet.GetString());
db.AddParameterValue("@solider", cmbAskerlik.GetString());
db.AddParameterValue("@education", cmbOgrenim.GetString());
db.AddParameterValue("@children", cmbCocuk.GetString());
db.AddParameterValue("@imagePath", nowppPath);
db.AddParameterValue("@gain", gain);
db.AddParameterValue("@firm", cmbFirma.GetString());
db.AddParameterValue("@insurance", sigorta);
db.AddParameterValue("@IBAN", txtIBAN.GetString());
db.AddParameterValue("@campus", txtYerleske.GetString());
db.AddParameterValue("@blood", cmbKanGrubu.GetString());
db.RunCommand("sp_Person", CommandType.StoredProcedure);
#region File
this._Ref = int.Parse(db.GetScalarValue("select MAX(Ref) from tbPerson").ToString());
string foldername = "", sysName = "", path = "", type = "", desc = "";
for (int k = 0; k < grdFolder.RowCount - 1; k++)
{
if (string.IsNullOrEmpty(grdFolder.GetRowCellValue(k, "Ref").ToString()))
{
REf = 0;
}
else
{
REf = int.Parse(grdFolder.GetRowCellValue(k, "Ref").ToString());
}
foldername = grdFolder.GetRowCellValue(k, "Dosya Adı").ToString();
sysName = grdFolder.GetRowCellValue(k, "Sistem Dosya Adı").ToString();
path = grdFolder.GetRowCellValue(k, "Dosya Yolu").ToString();
desc = grdFolder.GetRowCellValue(k, "Açıklama").ToString();
type = grdFolder.GetRowCellValue(k, "Dosya Tipi").ToString();
db.AddParameterValue("@ref", REf);
db.AddParameterValue("@cardRef", this._Ref);
db.AddParameterValue("@desc", desc, SqlDbType.NVarChar);
db.AddParameterValue("@name", foldername, SqlDbType.NVarChar);
db.AddParameterValue("@sysName", sysName, SqlDbType.NVarChar);
db.AddParameterValue("@path", path, SqlDbType.NVarChar);
db.AddParameterValue("@type", type, SqlDbType.NVarChar);
db.RunCommand("sp_CardFile", CommandType.StoredProcedure);
if (!string.IsNullOrEmpty(path))
{
string goal = Application.StartupPath + @"\Images\Person\" + txtAd.GetString() + txtSoyad.GetString() + "\\";
if (!File.Exists(goal))
{
Directory.CreateDirectory(goal);
}
if (this._FormMod == Enums.enmFormMod.Yeni)
{
File.Copy(path, goal + sysName);
}
else if (this._FormMod == Enums.enmFormMod.Guncelle)
{
string newPath = path + sysName;
if (!File.Exists(newPath))
{
File.Copy(newPath, goal + sysName);
}
}
db.AddParameterValue("@ref", this._Ref);
db.AddParameterValue("@path", goal, SqlDbType.NVarChar);
db.RunCommand("update tbCardFiles set folderPath=@path where cardRef=@ref");
}
db.parameterDelete();
}
#endregion
if (nowppPath != oldPath && !string.IsNullOrEmpty(oldPath))
{
File.Open(oldPath, FileMode.Open).Close();
File.Delete(oldPath);
}
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();
}
}
