// GET: Baglantis/Details/5
        public async Task <ActionResult> Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Baglanti baglanti = await db.Baglantis.FindAsync(id);

            if (baglanti == null)
            {
                return(HttpNotFound());
            }
            return(View(baglanti));
        }
        public async Task <ActionResult> Create([Bind(Include = "BaglantiId,BaglanitipId,OdfId,BaglantiAdi")] Baglanti baglanti)
        {
            if (ModelState.IsValid)
            {
                db.Baglantis.Add(baglanti);
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }

            ViewBag.OdfId        = new SelectList(db.Odfs, "OdfId", "OdfAdi", baglanti.OdfId);
            ViewBag.BaglanitipId = new SelectList(db.BaglantiTips, "BaglantiTipId", "BaglantiTipAdi");
            return(View(baglanti));
        }
        public Makale Makaleler(int id)
        {
            using (var session = Baglanti.OpenSession())
            {
                //Aşağıdaki Sorguların Hepsi Denendi Çalışıyor..

                //var list2 = session.QueryOver<HavayoluFirmalari>().Where(x => x.AirlineName.IsLike(name, MatchMode.Anywhere)).List();
                //var list3 = session.QueryOver<HavayoluFirmalari>().Where(t => t.AirlineName.IsLike("SunExpress")).List();

                var list = session.QueryOver <Makale>().Where(x => x.illerID == id).SingleOrDefault();

                return(list);
            }
        }
        public IList <airport> ulkeKodu(string code)
        {
            using (var session = Baglanti.OpenSession())
            {
                //Aşağıdaki Sorguların Hepsi Denendi Çalışıyor..

                //var list3 = session.QueryOver<airport>().Where(t => t.AirportCode.Equals("SAW")).List();

                //equals Kullanılmıyor..!
                //var list = session.QueryOver<airport>().Where(t => t.AirportCode.Equals(code)).List();
                var list = session.QueryOver <airport>().Where(p => p.AirportCode == code || p.CityCode == code).List();

                return(list);
            }
        }
        // GET: Baglantis/Edit/5
        public async Task <ActionResult> Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Baglanti baglanti = await db.Baglantis.FindAsync(id);

            if (baglanti == null)
            {
                return(HttpNotFound());
            }
            ViewBag.OdfId        = new SelectList(db.Odfs, "OdfId", "OdfAdi", baglanti.OdfId);
            ViewBag.BaglanitipId = new SelectList(db.BaglantiTips, "BaglantiTipId", "BaglantiTipAdi");
            return(View(baglanti));
        }
 public bool Guncelle(Araclar obje)
 {
     try
     {
         string strSql = @"UPDATE Araclar SET AracMarka = '" + obje.AracMarka + "', AracModel = '" + obje.AracModel
                         + "', AracYil = '" + obje.AracYil + "', AracGerekenEhliyetYili = '" + obje.AracGerekenEhliyetYili + "', AracGerekenMinimumYas = '" + obje.AracGerekenMinimumYas
                         + "', AracKoltukSayisi = '" + obje.AracKoltukSayisi + "', AracGunlukFiyat = '" + obje.AracGunlukFiyat + "', AracAirbagDurumu = '" + obje.AracAirbagDurumu
                         + "', AracBagajHacmi = '" + obje.AracBagajHacmi + "', AracGunlukKmSiniri = '" + obje.AracGunlukKmSiniri + "', FirmaId = '" + obje.FirmaId
                         + "', KiralandiMi = '" + obje.KiralandiMi + "', AracPlakaNo = '" + obje.AracPlakaNo + "', MusteriId = '" + obje.MusteriId
                         + "' WHERE AracId = '" + obje.AracId + "'";
         Baglanti.VeriGuncelle(strSql);
     }
     catch (Exception ex)
     { }
     return(false);
 }
 public bool Ekle(Sehirler obje)
 {
     try
     {
         Baglanti.BaglantiKontrol();
         var        strSql     = @"    
                        INSERT INTO [dbo].[Sehirler]
                                         ([SehirAdi])
                          VALUES
                                ('" + obje.SehirAdi + "');";
         SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
         sqlCommand.ExecuteNonQuery();
         return(true);
     }
     catch (Exception ex) { }
     return(false);
 }
        public List <airport> customList(string sql)
        {
            using (var session = Baglanti.OpenSession())
            {
                //var query =
                //       session.CreateSQLQuery(sql)
                //           .AddEntity("airport", typeof(airport))
                //           .List<airport>();
                sql = "EXEC TR_AIRPORT_LIST '" + sql + "'";
                var query =
                    session.CreateSQLQuery(sql)
                    .AddEntity("airport", typeof(airport))
                    .List <airport>();

                return(query.ToList());
            }
        }
        public bool Update(Makale makale)
        {
            try
            {
                using (var session = Baglanti.OpenSession())
                {
                    session.Update(makale);
                    // sıradan commit
                    session.Flush();

                    return(true);
                }
            }
            catch (Exception exc)
            {
                return(false);
            }
        }
        public bool Sil(int makaleId)
        {
            try
            {
                using (var session = Baglanti.OpenSession())
                {
                    var makale = session.QueryOver <Makale>().Where(x => x.illerID == makaleId).List().FirstOrDefault();
                    session.Delete(makale);
                    // sıradan commit
                    session.Flush();

                    return(true);
                }
            }
            catch (Exception exc)
            {
                return(false);
            }
        }
        public List <airport> customList2(string sql)
        {
            //Procedur
            using (var session = Baglanti.OpenSession())
            {
                var sql2 = "EXEC TR_AIRPORT_LIST 'IST' ";
                //session.CreateSQLQuery("EXEC TR_AIRPORT_LIST @StrValue = N'" + sql + "'").executeUpdate();
                //.AddEntity("airport", typeof(airport))
                //.List<airport>();

                //return query.ToList();

                var query =
                    session.CreateSQLQuery(sql2)
                    .AddEntity("airport", typeof(airport))
                    .List <airport>();

                return(query.ToList());
            }
        }
 public bool Ekle(AracKmler obje)
 {
     try
     {
         Baglanti.BaglantiKontrol();
         var        strSql     = @"    
                         INSERT INTO [dbo].[AracKmler]
                         ([AracId]
                         ,[AracBaslangicKm]
                         ,[AracBitisKm]                 
                          VALUES
                                ('" + obje.AracId + "','" + obje.AracBaslangicKm + "', '" + obje.AracBitisKm + "',);";
         SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
         sqlCommand.ExecuteNonQuery();
         return(true);
     }
     catch (Exception ex)
     { }
     return(false);
 }
Exemple #13
0
                public static DataTable DataTableGetir(string SQL)
                {
                    DataTable DT = new DataTable();

                    try
                    {
                        using (MySqlConnection MySQLCon = Baglanti.BaglantiCumlesi())
                        {
                            using (MySqlCommand MySQLCom = new MySqlCommand(SQL, MySQLCon))
                            {
                                MySQLCon.Open();
                                DT.Load(MySQLCom.ExecuteReader());
                            }
                        }
                    }
                    catch
                    {
                    }

                    return(DT);
                }
Exemple #14
0
                public static string ExecuteScalar(string SQL)
                {
                    string sonuc = null;

                    try
                    {
                        using (MySqlConnection MySQLCon = Baglanti.BaglantiCumlesi())
                        {
                            using (MySqlCommand MySQLCom = new MySqlCommand(SQL, MySQLCon))
                            {
                                MySQLCon.Open();
                                sonuc = MySQLCom.ExecuteScalar().ToString();
                            }
                        }
                        return(sonuc);
                    }
                    catch
                    {
                    }
                    return(sonuc);
                }
Exemple #15
0
        private void dugme_baglan_Click(object sender, EventArgs e)
        {
            Baglanti.Open();
            durum.Text = "Bağlantı başarıyla kuruldu!";
            Kanal1     = new Thread(new ThreadStart(VeriAl));
            //Kanal2 = new Thread(new ParameterizedThreadStart(worker_ComX));
            //Kanal3 = new Thread(new ParameterizedThreadStart(worker_KalmanX));
            //Kanal4 = new Thread(new ParameterizedThreadStart(worker_AccX));
            //Kanal5 = new Thread(new ParameterizedThreadStart(worker_ComY));
            //Kanal6 = new Thread(new ParameterizedThreadStart(worker_KalmanY));
            //Kanal7 = new Thread(new ParameterizedThreadStart(worker_AccY));
            //Kanal8 = new Thread(new ParameterizedThreadStart(worker_GyroX));
            //Kanal9 = new Thread(new ParameterizedThreadStart(worker_GyroY));
            //Kanal10 = new Thread(new ParameterizedThreadStart(worker_PusulaZ));
            //Kanal11 = new Thread(new ParameterizedThreadStart(worker_GyroZ));
            //Kanal12 = new Thread(new ParameterizedThreadStart(worker_ComZ));
            //Kanal13 = new Thread(new ParameterizedThreadStart(worker_KalmanZ));
            //Kanal14 = new Thread(new ParameterizedThreadStart(worker_LowPassZ));
            Kanal15 = new Thread(new ParameterizedThreadStart(worker_Um7Roll));
            Kanal16 = new Thread(new ParameterizedThreadStart(worker_Um7Pitch));
            Kanal17 = new Thread(new ParameterizedThreadStart(worker_Um7Yaw));

            Kanal1.Start();
            //Kanal2.Start(new Action<myData>(this.AddDataPoint_ComX));
            //Kanal3.Start(new Action<myData>(this.AddDataPoint_KalmanX));
            //Kanal4.Start(new Action<myData>(this.AddDataPoint_AccX));
            //Kanal5.Start(new Action<myData>(this.AddDataPoint_ComY));
            //Kanal6.Start(new Action<myData>(this.AddDataPoint_KalmanY));
            //Kanal7.Start(new Action<myData>(this.AddDataPoint_AccY));
            //Kanal8.Start(new Action<myData>(this.AddDataPoint_GyroX));
            //Kanal9.Start(new Action<myData>(this.AddDataPoint_GyroY));
            //Kanal10.Start(new Action<myData>(this.AddDataPoint_PusulaZ));
            //Kanal11.Start(new Action<myData>(this.AddDataPoint_GyroZ));
            //Kanal12.Start(new Action<myData>(this.AddDataPoint_ComZ));
            //Kanal13.Start(new Action<myData>(this.AddDataPoint_KalmanZ));
            //Kanal14.Start(new Action<myData>(this.AddDataPoint_lowPassZ));
            Kanal15.Start(new Action <myData>(this.AddDataPoint_Um7Roll));
            Kanal16.Start(new Action <myData>(this.AddDataPoint_Um7Pitch));
            Kanal17.Start(new Action <myData>(this.AddDataPoint_Um7Yaw));
        }
Exemple #16
0
        public void SorguCalistir(string sorgu)
        {
            SorguCalistirici.CommandText = sorgu;

            try
            {
                Baglanti.Open();
                SorguCalistirici.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                //throw new Exception("Hata oluştu.");
                throw ex;
            }
            finally
            {
                if (Baglanti.State != ConnectionState.Closed || Baglanti.State != ConnectionState.Broken)
                {
                    Baglanti.Close();
                }
            }
        }
 public bool Ekle(Kullanicilar obje)
 {
     try
     {
         Baglanti.BaglantiKontrol();
         var strSql = @"    
                         INSERT INTO [dbo].[Kullanicilar]
                                ([KullaniciAd]
                                ,[KullaniciSoyad]
                                ,[FirmaId]
                                ,[KullaniciAdi]
                                ,[KullaniciParola]
                                ,[RolId])
                          VALUES
                                ('" + obje.KullaniciAd + "','" + obje.KullaniciSoyad + "', '" + obje.FirmaId
                      + "', '" + obje.KullaniciAdi + "', '" + obje.KullaniciParola + "','" + obje.RolId + "');";
         SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
         sqlCommand.ExecuteNonQuery();
         return(true);
     }
     catch (Exception ex) { }
     return(false);
 }
Exemple #18
0
        public bool Ekle(Musteriler obje)
        {
            try
            {
                Baglanti.BaglantiKontrol();
                var strSql = @"
                        INSERT INTO[dbo].[Musteriler]
                        ([MusteriAd]
                         ,[MusteriSoyad]
                        ,[MusteriEhliyetNo]
                        ,[MusteriTCKNo]
                        ,[MusteriTelNo]
                        ,[MusteriEmail])
                        VALUES
                        ('" + obje.MusteriAd + "','" + obje.MusteriSoyad + "', '" + obje.MusteriEhliyetNo
                             + "', '" + obje.MusteriTCKNo + "', '" + obje.MusteriTelNo + "','" + obje.MusteriEmail + "');";

                SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
                sqlCommand.ExecuteNonQuery();
            }
            catch (Exception ex)
            { }
            return(false);
        }
Exemple #19
0
                public static DataSet DataSetGetir(string SQL, string TabloAdi)
                {
                    DataSet DS = new DataSet();

                    try
                    {
                        using (MySqlConnection MySQLCon = Baglanti.BaglantiCumlesi())
                        {
                            using (MySqlCommand MySQLCom = new MySqlCommand(SQL, MySQLCon))
                            {
                                using (MySqlDataAdapter MDA = new MySqlDataAdapter(SQL, MySQLCon))
                                {
                                    MySQLCon.Open();
                                    MDA.Fill(DS, TabloAdi);
                                }
                            }
                        }
                    }
                    catch
                    {
                    }

                    return(DS);
                }
Exemple #20
0
        private void VeriAl()
        {
            yazi = Baglanti.ReadLine();
            Metin_Girisi2(yazi, richTextBox1);
            //if (yazi.IndexOf("Pol")==0)
            //{
            //    yazi = yazi.Replace('.', ',');
            //    indis_um7Roll = yazi.IndexOf("R:");
            //    indis_um7Pitch = yazi.IndexOf("P:");
            //    indis_um7Yaw = yazi.IndexOf("Y:");

            //    um7Roll = Convert.ToDouble(yazi.Substring(indis_um7Roll + 2, indis_um7Pitch - indis_um7Roll - 2).Trim());
            //    um7Pitch = Convert.ToDouble(yazi.Substring(indis_um7Pitch + 2, indis_um7Yaw - indis_um7Pitch - 2).Trim());
            //    um7Yaw = Convert.ToDouble(yazi.Substring(indis_um7Yaw + 2, yazi.Length - indis_um7Yaw - 2 - 1).Trim());

            //}

            //if (yazi[0] == 'R')
            //{

            //}
            //if (yazi[0] == 'X')
            //{
            //    Metin_Girisi("", gelenKutusu);
            //    Metin_Girisi(yazi.ToString(), gelenKutusu);

            //    yazi = yazi.Replace('.', ',');

            //    indis_accX = yazi.IndexOf("X0:");
            //    indis_accY = yazi.IndexOf("Y0:");
            //    indis_gyroX = yazi.IndexOf("X1:");
            //    indis_gyroY = yazi.IndexOf("Y1:");
            //    indis_comX = yazi.IndexOf("X2:");
            //    indis_comY = yazi.IndexOf("Y2:");
            //    indis_kalmanX = yazi.IndexOf("X3:");
            //    indis_kalmanY = yazi.IndexOf("Y3:");
            //    indis_pusulaZ = yazi.IndexOf("Z0:");
            //    indis_gyroZ = yazi.IndexOf("Z1:");
            //    indis_comZ = yazi.IndexOf("Z2:");
            //    indis_kalmanZ = yazi.IndexOf("Z3:");
            //    indis_LowPassZ = yazi.IndexOf("Z4:");

            //    //accX = Convert.ToDouble(yazi.Substring(indis_accX + 3, indis_accY - indis_accX - 3).Trim());
            //    //accY = Convert.ToDouble(yazi.Substring(indis_accY + 3, indis_gyroX - indis_accY - 3).Trim());
            //    //gyroX = Convert.ToDouble(yazi.Substring(indis_gyroX + 3, indis_gyroY - indis_gyroX - 3).Trim());
            //    //gyroY = Convert.ToDouble(yazi.Substring(indis_gyroY + 3, indis_comX - indis_gyroY - 3).Trim());
            //    //comX = Convert.ToDouble(yazi.Substring(indis_comX + 3, indis_comY - indis_comX - 3).Trim());
            //    //comY = Convert.ToDouble(yazi.Substring(indis_comY + 3, indis_kalmanX - indis_comY - 3).Trim());
            //    //kalmanX = Convert.ToDouble(yazi.Substring(indis_kalmanX + 3, indis_kalmanY - indis_kalmanX - 3).Trim());
            //    //kalmanY = Convert.ToDouble(yazi.Substring(indis_kalmanY + 3, indis_pusulaZ - indis_kalmanY - 3).Trim());
            //    //pusulaZ = Convert.ToDouble(yazi.Substring(indis_pusulaZ + 3, indis_gyroZ - indis_pusulaZ - 3).Trim());
            //    //gyroZ = Convert.ToDouble(yazi.Substring(indis_gyroZ + 3, indis_comZ - indis_gyroZ - 3).Trim());
            //    //comZ = Convert.ToDouble(yazi.Substring(indis_comZ + 3, indis_kalmanZ - indis_comZ - 3).Trim());
            //    //kalmanZ = Convert.ToDouble(yazi.Substring(indis_kalmanZ + 3, indis_LowPassZ - indis_kalmanZ - 3).Trim());
            //    //lowPassZ = Convert.ToDouble(yazi.Substring(indis_LowPassZ + 3, yazi.Length - indis_LowPassZ - 3 - 1).Trim());

            //    Metin_Girisi(accX.ToString(), metin_accX);
            //    Metin_Girisi(accY.ToString(), metin_accY);
            //    Metin_Girisi(pusulaZ.ToString(), metin_pusulaZ);
            //    Metin_Girisi(gyroX.ToString(), metin_gyroX);
            //    Metin_Girisi(gyroY.ToString(), metin_gyroY);
            //    Metin_Girisi(gyroZ.ToString(), metin_gyroZ);
            //    Metin_Girisi(comX.ToString(), metin_comX);
            //    Metin_Girisi(comY.ToString(), metin_comY);
            //    Metin_Girisi(comZ.ToString(), metin_comZ);
            //    Metin_Girisi(kalmanX.ToString(), metin_kalmanX);
            //    Metin_Girisi(kalmanY.ToString(), metin_kalmanY);
            //    Metin_Girisi(kalmanZ.ToString(), metin_kalmanZ);

            //    render();

            //}
        }
Exemple #21
0
    public static string UrunEkle(string Baslik, string Etiket, string Description)
    {
        Baglanti.ExecuteQuery("insert into Tbl_Genel_Kayitlar (Baslik,Etiket,Description) values ('" + Baslik + "','" + Etiket + "','" + Description + "')");

        return("success");
    }
Exemple #22
0
 public HtmlBelgesi(Baglanti baglanti)
 {
     _baglanti = baglanti;
 }
Exemple #23
0
    public static string UrunDuzenle(int id, string Baslik, string Etiket, string Description)
    {
        DataRow dr = Baglanti.GetDataRow("update Tbl_Genel_Kayitlar set Baslik='" + Baslik + "',etiket='" + Etiket + "',Description='" + Description + "' where id=" + id + "");

        return("success");
    }
 public void LoadData()
 {
     chartControl1.DataSource       = Baglanti.GetData(dateTimePicker1.Value.ToString("yyyyMMdd"));
     chartControl1.SeriesDataMember = "OrtalamaKm";
     chartControl1.SeriesDataMember = "OrtalamaGun";
 }
Exemple #25
0
        private void BaglantiKontroluYap()
        {
            Baglanti baglanti = new Baglanti();

            baglanti.InternetVarMi();
        }
Exemple #26
0
 public KitaplarDAL()
 {
     baglanti = new Baglanti();
 }
Exemple #27
0
    public static string UrunList()
    {
        DataTable dtUrunler = Baglanti.GetDataTable("select*from Tbl_Genel_Kayitlar order by id desc");

        return(JsonConvert.SerializeObject(dtUrunler));
    }