public static int GonderimSekliSil(int gonderimSekliId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@GonderimSekliId", gonderimSekliId));
return(Dal.executeProcedure("GonderimSekliSil", prms));
}
public static int DonanimTuruSil(int turId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@TurId", turId));
return(Dal.executeProcedure("DonanimTuruSil", prms));
}
public static int TeknikServisSil(int kayitId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@KayitId", kayitId));
return(Dal.executeProcedure("TeknikServisSil", prms));
}
public static int HurdaSil(int donanimId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@DonanimId", donanimId));
return(Dal.executeProcedure("HurdaSil", prms));
}
public static int FirmaSil(int firmaId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@FirmaId", firmaId));
return(Dal.executeProcedure("FirmaSil", prms));
}
public static int LisansSil(int lisansId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@LisansId", lisansId));
return(Dal.executeProcedure("LisansSil", prms));
}
public static int KullaniciSil(int kullaniciId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@KullaniciId", kullaniciId));
return(Dal.executeProcedure("KullaniciSil", prms));
}
public static int UyeSil(int uyeId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@UyeId", uyeId));
return(Dal.executeProcedure("UyeSil", prms));
}
public static int LisasnTipiSil(int tipId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@TipId", tipId));
return(Dal.executeProcedure("LisasnTipiSil", prms));
}
public static int ServisSekliSil(int servisSekliId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@ServisSekliId", servisSekliId));
return(Dal.executeProcedure("ServisSekliSil", prms));
}
public static int YazilimSil(int yazilimId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@YazilimId", yazilimId));
return(Dal.executeProcedure("YazilimSil", prms));
}
public static int YazilimKullaniciGuncelle(int kullaniciId, int yazilimId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@kullaniciId", kullaniciId));
prms.Add(new SqlParameter("@YazilimId", yazilimId));
return(Dal.executeProcedure("YazilimKullaniciGuncelle", prms));
}
public int LisansTipiEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@TipId", TipId));
prms.Add(new SqlParameter("@TipAdi", TipAdi));
return(Dal.executeProcedure("LisansTipiEkleGuncelle", prms));
}
public int DonanimTuruEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@TurId", TurId));
prms.Add(new SqlParameter("@Tur", Tur));
return(Dal.executeProcedure("DonanimTuruEkleGuncelle", prms));
}
public static int DonanimKullaniciGuncelle(int kullaniciId, int donanimId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@KullaniciId", kullaniciId));
prms.Add(new SqlParameter("@donanimId", donanimId));
return(Dal.executeProcedure("DonanimKullaniciGuncelle", prms));
}
public int GonderimSekliEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@GonderimSekliId", GonderimSekliId));
prms.Add(new SqlParameter("@GonderimSekli", GonderimSekli));
return(Dal.executeProcedure("GonderimSekliEkleGuncelle", prms));
}
public int ServisSekliEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@ServisSekliId", ServisSekliId));
prms.Add(new SqlParameter("@ServisSekli", ServisSekli));
return(Dal.executeProcedure("ServisSekliEkleGuncelle", prms));
}
public int KullaniciKontrolEt()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@KullaniciAdi", KullaniciAdi));
prms.Add(new SqlParameter("@Sifre", Sifre));
return(Dal.executeProcedure("KullaniciKontrolEt", prms));
}
public static int LisansKullaniciGuncelle(int kullaniciId, int lisansId)
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@KullaniciId", kullaniciId));
prms.Add(new SqlParameter("@LisansId", lisansId));
return(Dal.executeProcedure("LisansKullaniciGuncelle", prms));
}
public int HurdaEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@DonanimId", DonanimId));
prms.Add(new SqlParameter("@HurdaTarihi", HurdaTarihi));
prms.Add(new SqlParameter("@Notu", Notu));
return(Dal.executeProcedure("HurdaEkleGuncelle", prms));
}
public int YazilimEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@YazilimId", YazilimId));
prms.Add(new SqlParameter("@YazilimAdi", YazilimAdi));
prms.Add(new SqlParameter("@GuncellemeTarihi", GuncellemeTarihi));
prms.Add(new SqlParameter("@LisansSayisi", LisansSayisi));
return(Dal.executeProcedure("YazilimEkleGuncelle", prms));
}
public int FirmaEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@FirmaId", FirmaId));
prms.Add(new SqlParameter("@Firma", Firma));
prms.Add(new SqlParameter("@Adres", Adres));
prms.Add(new SqlParameter("@VergiDairesi", VergiDairesi));
prms.Add(new SqlParameter("@VergiNumarasi", VergiNumarasi));
return(Dal.executeProcedure("FirmaEkleGuncelle", prms));
}
public int UyeEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@UyeId", UyeId));
prms.Add(new SqlParameter("@Rol", Rol));
prms.Add(new SqlParameter("@Ad", Ad));
prms.Add(new SqlParameter("@Soyad", Soyad));
prms.Add(new SqlParameter("@KullaniciAdi", KullaniciAdi));
prms.Add(new SqlParameter("@Sifre", Sifre));
return(Dal.executeProcedure("UyeEkleGuncelle", prms));
}
public int KullaniciEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@KullaniciId", KullaniciId));
prms.Add(new SqlParameter("@FirmaId", FirmaId));
prms.Add(new SqlParameter("@Ad", Ad));
prms.Add(new SqlParameter("@Soyad", Soyad));
prms.Add(new SqlParameter("@Departman", Departman));
prms.Add(new SqlParameter("@DomainAdi", DomainAdi));
return(Dal.executeProcedure("KullaniciEkleGuncelle", prms));
}
public int LisansEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@LisansId", LisansId));
prms.Add(new SqlParameter("@YazilimId", YazilimId));
prms.Add(new SqlParameter("@TipId", TipId));
prms.Add(new SqlParameter("@LisansKey", LisansKey));
prms.Add(new SqlParameter("@LisansNumarasi", LisansNumarasi));
prms.Add(new SqlParameter("@LisansAdi", LisansAdi));
prms.Add(new SqlParameter("@LisansSayisi", LisansSayisi));
return(Dal.executeProcedure("LisansEkleGuncelle", prms));
}
public int ServisFirmasiEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@ServisFirmaId", ServisFirmaId));
prms.Add(new SqlParameter("@FirmaAdi", FirmaAdi));
prms.Add(new SqlParameter("@Adres", Adres));
prms.Add(new SqlParameter("@Tel", Tel));
prms.Add(new SqlParameter("@Fax", Fax));
prms.Add(new SqlParameter("@Gsm", Gsm));
prms.Add(new SqlParameter("@Email", Email));
return(Dal.executeProcedure("ServisFirmasiEkleGuncelle", prms));
}
public int TeknikServisEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@KayitId", KayitId));
prms.Add(new SqlParameter("@DonanimId", DonanimId));
prms.Add(new SqlParameter("@ServisSekliId", ServisSekliId));
prms.Add(new SqlParameter("@GonderimSekliId", GonderimSekliId));
prms.Add(new SqlParameter("@ServisFirmaId", ServisFirmaId));
prms.Add(new SqlParameter("@Aksesuar", Aksesuar));
prms.Add(new SqlParameter("@Sikayet", Sikayet));
prms.Add(new SqlParameter("@Tarih", Tarih));
prms.Add(new SqlParameter("@Karar", Karar));
prms.Add(new SqlParameter("@Durum", Durum));
prms.Add(new SqlParameter("@FaturaResmi", FaturaResmi));
return(Dal.executeProcedure("TeknikServisEkleGuncelle", prms));
}
public int DonanimEkleGuncelle()
{
List <SqlParameter> prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@DonanimId", DonanimId));
prms.Add(new SqlParameter("@FirmaId", FirmaId));
prms.Add(new SqlParameter("@TurId", TurId));
prms.Add(new SqlParameter("@Marka", Marka));
prms.Add(new SqlParameter("@Model", Model));
prms.Add(new SqlParameter("@SeriNo", SeriNo));
prms.Add(new SqlParameter("@UrunNo", UrunNo));
prms.Add(new SqlParameter("@LisansKey", LisansKey));
prms.Add(new SqlParameter("@IsletimSistemi", IsletimSistemi));
prms.Add(new SqlParameter("@Ram", Ram));
prms.Add(new SqlParameter("@GarantiDurumu", GarantiDurumu));
prms.Add(new SqlParameter("@BakimTarihi", BakimTarihi));
return(Dal.executeProcedure("DonanimEkleGuncelle", prms));
}