private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Panel.Controls.Add(StokListesi);
StokListesi.Dock = System.Windows.Forms.DockStyle.Fill;//DevExpress.Utils.
StokListesi.Show();
StokListesi.BringToFront();
StokListesi.VisibleChanged += UcstokListesi_VisibleChanged;
}
public ActionResult GetStok()
{
string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
string FirmaID = Session["FirmaID"].ToString();
List <StokListesi> yonetim = new List <StokListesi>();
string sorg = @"Select Birimi,Barkod,Brkd2,StokKodu,SatishFiyat,UrunAdi,Grubu,ID from Stok Where FirmaID= " + FirmaID;
try
{
using (SqlConnection con = new SqlConnection(strcon))
{
con.Open();
using (SqlCommand carigetir = new SqlCommand(sorg, con))
{
using (SqlDataReader dr = carigetir.ExecuteReader())
{
while (dr.Read())
{
StokListesi yt = new StokListesi();
yt.StokKodu = dr["StokKodu"].ToString();
yt.UrunAdi = dr["UrunAdi"].ToString();
yt.Birimi = dr["Birimi"].ToString();
yt.Barkod = dr["Barkod"].ToString();
yt.Barkod2 = dr["Brkd2"].ToString();
yt.Fiyat = dr["SatishFiyat"].ToString();
yt.ID = Convert.ToInt32(dr["ID"]);
yonetim.Add(yt);
}
}
}
}
}
catch (Exception e1)
{ System.IO.File.WriteAllText(Path.Combine(@"C:\Users\ilhan\AppData\Local\Sayazilim", "sonuç.xml"), e1.ToString()); }
return(Json(new { data = yonetim.Distinct() }, JsonRequestBehavior.AllowGet));
}
