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)); }