private void XtraForm1_Load(object sender, EventArgs e)
{
try
{
hemene = new csHemenAlGetSet();
gridControl1.DataSource = hemene.csHemenAlStringToDatatablesds(hemene.Get_Set_Fonksiyonlari.GetStokTip());
//= hemene.GetUrun();
//gridControl1.DataSource = hemene.btnHemenAlUrunleriGetir_ItemClick(null, null);
}
catch (Exception)
{
throw;
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
string Cevap = "";
using (hemeaq = new csHemenAlGetSet())
{
for (int i = 0; i < gridView1.RowCount; i++)
{
trgenel = SqlConnections.GetBaglanti().BeginTransaction();
Cevap += hemeaq.HememAl_SetUrun(SqlConnections.GetBaglanti(), trgenel, Convert.ToInt32(gridView1.GetRowCellValue(i, "StokID")));
// yukarıdan hemenal daki ürün ün Id si dönüyor;
Cevap += " ID li" + "\n" + gridView1.GetRowCellValue(i, "StokKodu") + " " + gridView1.GetRowCellValue(i, "StokAdi");
memoEdit1.Lines = Cevap.Split('\n');
trgenel.Commit();
}
}
}
private void HemenAlUrunFoto_Load(object sender, EventArgs e)
{
csHemenAlGetSet hemenAlma = new csHemenAlGetSet();
//HemenAlServis.GetUrunResimResponse x = await HemenAlServis.
//gridControl1.DataSource = hemenAlma.csHemenAlStringToDatatablesds(hemenAlma.Get_Set_Fonksiyonlari.GetUrunResim(""));
dt_UrunFotolari = new DataTable();
dt_UrunFotolari = hemenAlma.csHemenAlStringToDatatablesds(hemenAlma.Get_Set_Fonksiyonlari.GetUrunResim("1")).Copy();
dt_Urunler = new DataTable();
dt_Urunler = hemenAlma.csHemenAlStringToDatatablesds(hemenAlma.Get_Set_Fonksiyonlari.GetUrun()).Copy();
//dt_Urunler.Load(hemenAlma.csHemenAlStringToDatatablesds(hemenAlma.Get_Set_Fonksiyonlari.GetUrun()).CreateDataReader());
var fototo = from Urunler in dt_Urunler.AsEnumerable()
join Fotolaar in dt_UrunFotolari.AsEnumerable()
on Urunler.Field <string>("product_id") equals Fotolaar.Field <string>("id")
//into data
//from Fotolaar in data.DefaultIfEmpty()
select new
{
adi = Urunler[6],
stokkodu = Urunler[4],
id = Urunler[0],
url = Fotolaar["url"]
};
gridControl1.DataSource = fototo;
MessageBox.Show(gridView1.RowCount.ToString());
//gridControl2.DataSource
}
private void frmHemenAlStokFiyat_Load(object sender, EventArgs e)
{
csHemenAlGetSet HemelAl = new csHemenAlGetSet();
gridControl1.DataSource = HemelAl.csHemenAlStringToDatatablesds(HemelAl.Get_Set_Fonksiyonlari.GetUrunStokFiyat());
}
private void frmHemenAlTeesst_Load(object sender, EventArgs e)
{
heee = new csHemenAlGetSet();
heee.csHemenAlStringToDatatablesds(heee.Get_Set_Fonksiyonlari.GetUrun());
gridControl1.DataSource = heee.dt_Gelen;
}
private void simpleButton4_Click(object sender, EventArgs e)
{
csHemenAlGetSet hemenAlma = new csHemenAlGetSet();
hemenAlma.Get_Set_Fonksiyonlari.SetUrun("Ares", "", gv.GetFocusedRowCellValue("stokkodu").ToString(), gv.GetFocusedRowCellValue("stokkodu").ToString(), "", "", "", "", "", gv.GetFocusedRowCellValue("url").ToString(), "", "", "", "", "", "", "", "", "", "", "", "", "");
}