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