public static void silServisKayit(int servisid) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { List <int> query1 = (from sv in db.serviskalems where sv.servisID == servisid select sv.serviskalemID).ToList(); if (query1.Count == 0) { var x = db.servis.Find(servisid); db.servis.Remove(x); db.SaveChanges(); } else if (query1.Count != 0) { int count1 = query1.Count; for (int i = 0; i < count1; i++) { silServisKalem(query1[i]); } var x = db.servis.Find(servisid); db.servis.Remove(x); db.SaveChanges(); } } }
public static kullanici getKullaniciAsClass(string tc) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { kullanici k = new kullanici(); var query = (from c in db.kullanicis where c.tckn == tc select new { c.kullaniciID, c.kullaniciAdi, c.parola, c.tckn, c.adSoyad, c.iseGirisTarihi, c.bolumID, c.pozisyonID, c.telno }).Single(); k.kullaniciID = query.kullaniciID; k.kullaniciAdi = query.kullaniciAdi; k.parola = query.parola; k.tckn = query.tckn; k.adSoyad = query.adSoyad; k.iseGirisTarihi = query.iseGirisTarihi; k.bolumID = query.bolumID; k.pozisyonID = query.pozisyonID; k.telno = query.telno; return(k); } }
public static int ekleArac(string pl, int maid, int moid, int musid, int yil, string ruhsat, string sase, string motor) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { List <int> query1 = (from a in db.aracs where a.plaka.Contains(pl) select a.aracID).ToList(); if (query1.Count == 0) { arac aracekle = new arac(); aracekle.plaka = pl; aracekle.markaID = maid; aracekle.modelID = moid; aracekle.musteriID = musid; aracekle.modelYil = yil; aracekle.ruhsatNo = ruhsat; aracekle.saseNo = sase; aracekle.motorNo = motor; db.aracs.Add(aracekle); db.SaveChanges(); return(1); } else { return(2); } } }
public static int ekleMusteri(string tc, string isim) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { List <int> query1 = (from a in db.musteris where a.tckn.Contains(tc) select a.musteriID).ToList(); if (query1.Count == 0) { musteri musteriekle = new musteri(); musteriekle.tckn = tc; musteriekle.adSoyad = isim; db.musteris.Add(musteriekle); db.SaveChanges(); return(1); } else { return(2); } } }
public static object getAracVeBolumler() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var query = from a in db.aracs join m1 in db.aracmarkas on a.markaID equals m1.markaID join m2 in db.aracmodels on a.modelID equals m2.modelID join m3 in db.musteris on a.musteriID equals m3.musteriID select new { a.aracID, a.plaka, a.markaID, m1.marka, a.modelID, m2.model, a.musteriID, m3.adSoyad, a.modelYil, a.ruhsatNo, a.saseNo, a.motorNo }; return(query.ToList()); } }
public static void silMarka(int m1id) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { List <int> query1 = (from mo in db.aracmodels where mo.markaID == m1id select mo.modelID).ToList(); if (query1.Count == 0) { var x = db.aracmarkas.Find(m1id); db.aracmarkas.Remove(x); db.SaveChanges(); } else if (query1.Count != 0) { int count1 = query1.Count; for (int i = 0; i < count1; i++) { silModel(m1id, query1[i]); } var x = db.aracmarkas.Find(m1id); db.aracmarkas.Remove(x); db.SaveChanges(); } } }
//*************************sadece markadaki islemler***************************** public static int ekleMarka(string m1) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { List <int> query1 = (from ma in db.aracmarkas where ma.marka.Contains(m1) select ma.markaID).ToList(); if (query1.Count == 0) { aracmarka markaekle = new aracmarka(); markaekle.marka = m1; db.aracmarkas.Add(markaekle); db.SaveChanges(); return(1); } else { return(2); } } }
protected void GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e) { otoservisdbEntities db = new otoservisdbEntities(); Label marka = GridView1.Rows[e.RowIndex].FindControl("Label1") as Label; Label model = GridView1.Rows[e.RowIndex].FindControl("Label2") as Label; string m1 = marka.Text; string m2 = model.Text; List <int> query1 = db.aracmarkas.ToList() .Where(x => x.marka == m1) .Select(x => x.markaID).ToList(); int m1id = Convert.ToInt32(query1[0]); List <int> query2 = db.aracmodels.ToList() .Where(x => x.model == m2 && x.markaID == m1id) .Select(x => x.modelID).ToList(); int m2id = Convert.ToInt32(query2[0]); dbarac2.silModel(m1id, m2id); ObjectDataSource1.DataBind(); GridView1.DataSource = ObjectDataSource1; GridView1.DataBind(); }
public static int ekleModel(string m1, string m2) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { List <int> query1 = (from ma in db.aracmarkas where ma.marka.Contains(m1) select ma.markaID).ToList(); int m1id = Convert.ToInt32(query1[0]); List <string> query2 = (from mo in db.aracmodels where mo.model.Contains(m2) select mo.model).ToList(); if (query2.Count == 0) { aracmodel y = new aracmodel(); y.model = m2; y.markaID = m1id; //db.aracmarkas.Add(x); db.aracmodels.Add(y); db.SaveChanges(); return(1); } else { return(2); } } }
public static void silKullanici(int id) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var x = db.kullanicis.Find(id); db.kullanicis.Remove(x); db.SaveChanges(); } }
public static object GetKullanici() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var query = from c in db.kullanicis select c; return(query.ToList()); } }
public static void silModel(int m1id, int m2id) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var x = db.aracmodels.Find(m2id, m1id); db.aracmodels.Remove(x); db.SaveChanges(); } }
public static object getMusteriID() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var query = from musteri in db.musteris select new { musteri.musteriID, musteri.adSoyad }; return(query.ToList()); } }
public static void guncelleServisAktif(int servisid, bool aktif) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var x = db.servis.Find(servisid); x.servisAktif = aktif; db.SaveChanges(); } }
public static int getAracModelYili(int aracid) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = db.aracs.Where(x => x.aracID == aracid).Select(x => x.modelYil).Single(); return(Convert.ToInt32(sorgu)); } }
public static object getAracKayitAll() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var query = from a in db.aracs select a; return(query.ToList()); } }
public static void guncelleModel(int m1id, int m2id, string m2) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var y = db.aracmodels.Find(m2id, m1id); y.model = m2; db.SaveChanges(); } }
public static void silAracKayit(int aracid) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var x = db.aracs.Find(aracid); db.aracs.Remove(x); db.SaveChanges(); } }
public static object GetMarkas() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = from x in db.aracmarkas select new { x.marka }; return(sorgu.ToList()); } }
public static string getPozisyonAd(int pozid) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { string sorgu = (from pid in db.pozisyonlars where pid.pozisyonID == pozid select pid.pozisyon).Single(); return(sorgu); } }
public static object getParcaBilgiAll() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = from d1 in db.parcas select d1; return(sorgu.ToList()); } }
public static object getBolumIDList() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = from b1 in db.bolumlers select b1; return(sorgu.ToList()); } }
public static object getPozisyonIDList() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = from d1 in db.pozisyonlars select d1; return(sorgu.ToList()); } }
public static object getServisKayit() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = from s1 in db.servis select s1; return(sorgu.ToList()); } }
protected void GridViewKullanici_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { Label parcaID = GridViewParcaAll.Rows[e.RowIndex].FindControl("Label1") as Label; TextBox parcaKodu = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox2") as TextBox; TextBox parcaAdi = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox4") as TextBox; TextBox fiyatAlis = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox6") as TextBox; TextBox fiyatSatis = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox8") as TextBox; TextBox stok = GridViewParcaAll.Rows[e.RowIndex].FindControl("TextBox10") as TextBox; int s1 = Convert.ToInt32(parcaID.Text); string s2 = Convert.ToString(parcaKodu.Text); string s3 = Convert.ToString(parcaAdi.Text); decimal s4 = Convert.ToDecimal(fiyatAlis.Text); decimal s5 = Convert.ToDecimal(fiyatSatis.Text); int s6 = Convert.ToInt32(stok.Text); otoservisdbEntities db = new otoservisdbEntities(); List <string> ifparcaexists = db.parcas.ToList() .Where(x => x.parcaKodu == parcaKodu.Text) .Select(x => x.parcaKodu).ToList(); if (ifparcaexists.Count == 0) { if (s1 != 0 || s2 != "" || s3 != "" || s4 != 0 || s5 != 0) { parcaislem.guncelleParca(s1, s2, s3, s4, s5, s6); //Label11.Text = "Satır bilgisi başarıyla güncellendi"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentSuccess('Satır bilgisi başarıyla güncellendi', 'İşlem Başarılı');", true); GridViewParcaAll.EditIndex = -1; GridViewParcaAll.DataSource = parcaislem.getParcaBilgiAll(); GridViewParcaAll.DataBind(); } else { //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Eksik girişler mevcut')", true); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Eksik girişler mevcut', 'HATA');", true); } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentError('Parça Kodu listede mevcut', '');", true); } } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Güncelleme Başarısız')", true); } }
public static object getParcaBilgi() { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = from d1 in db.parcas select new { d1.parcaID, d1.parcaAdi, d1.parcaKodu }; return(sorgu.ToList()); } }
public static void guncelleMarka(int m1id, string m1) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var x = db.aracmarkas.Find(m1id); x.marka = m1; db.SaveChanges(); } }
protected void LinkButton5_Click(object sender, EventArgs e) { try { otoservisdbEntities db = new otoservisdbEntities(); TextBox musteriID = GridView1.FooterRow.FindControl("TextBox3") as TextBox; TextBox tckn = GridView1.FooterRow.FindControl("TextBox4") as TextBox; TextBox adSoyad = GridView1.FooterRow.FindControl("TextBox5") as TextBox; //int deneme1 = Convert.ToInt32(musteriID.Text); string tckimlik = Convert.ToString(tckn.Text); string isim = Convert.ToString(adSoyad.Text); if (tckimlik != "" && isim != "") { if (tckimlik.Length != 11) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('TC Kimlik No 11 haneli olmalı', '');", true); } else { List <string> ifmusteriexists = db.musteris.ToList() .Where(x => x.tckn == tckimlik) .Select(x => x.tckn).ToList(); if (ifmusteriexists.Count == 0) { dbmusteri2.AddMusteri(tckimlik, isim); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentSuccess('Müşteri eklendi', '');", true); } else { //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Müşteri mevcut, lütfen kontrol ediniz')", true); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Müşteri mevcut, lütfen kontrol ediniz', 'HATA');", true); } ObjectDataSource1.DataBind(); GridView1.DataSource = ObjectDataSource1; GridView1.DataBind(); } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Eksik girişler mevcut', 'HATA');", true); } } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentError('Ekleme başarısız', 'HATA');", true); } }
public static string getAracMarkaAdi(int aracid) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = db.aracs.Where(x => x.aracID == aracid).Select(x => x.markaID).Single(); int mrkid = Convert.ToInt32(sorgu); var sorgu2 = db.aracmarkas.Where(y => y.markaID == mrkid).Select(y => y.marka).Single(); return(sorgu2); } }
public static string getAracMusteri(int aracid) { otoservisdbEntities db = new otoservisdbEntities(); using (db) { var sorgu = db.aracs.Where(x => x.aracID == aracid).Select(x => x.musteriID).Single(); int mustid = Convert.ToInt32(sorgu); var sorgu2 = db.musteris.Where(y => y.musteriID == mustid).Select(y => y.adSoyad).Single(); return(sorgu2); } }