public int SatisKaydiEkle(int ULC, int UC, string ClientName, int Kamera, int nvr, int videoDuvar, int IsIstasyonu, int Keyboard, DateTime SatisTarihi, string LisansKodu, string DonanimId, string Notes, out string errorMes) { errorMes = ""; if (ULC != 0 && UC != 0 && !string.IsNullOrEmpty(LisansKodu)) { Entities.SalesTable satisNesne = new Entities.SalesTable() { ULC = ULC, UC = UC, ClientName = ClientName, Camera = Kamera, NVR = nvr, VideoDuvar = videoDuvar, IsIstasyonu = IsIstasyonu, Keyboard = Keyboard, SatisTarihi = SatisTarihi, LisansKodu = LisansKodu, DonanimID = DonanimId, Notes = Notes }; return(dll.SatisKaydiEkle(satisNesne, out errorMes)); } else { return(-1); } }
public int SatisKaydiDuzenle(int ULC, int UC, int Kamera, int nvr, int videoDuvar, int IsIstasyonu, int Keyboard, DateTime SatisTarihi, string LisansKodu, string DonanimId, string notes) { if (ULC != 0 && UC != 0) { Entities.SalesTable satisNesne = new Entities.SalesTable() { ULC = ULC, //UC = UC, //ClientName = ClientName, Camera = Kamera, NVR = nvr, VideoDuvar = videoDuvar, IsIstasyonu = IsIstasyonu, Keyboard = Keyboard, SatisTarihi = SatisTarihi, LisansKodu = LisansKodu, DonanimID = DonanimId, Notes = notes }; return(dll.SatisKaydiDuzenle(satisNesne)); } else { return(-1); } }
public int SatisKaydiDuzenle(Entities.SalesTable S) { try { cmd = new SqlCommand("update SalesTable set Camera=@Camera, NVR=@NVR, IsIstasyonu=@IsIstasyonu, Keyboard=@Keyboard, SatisTarihi=@SatisTarihi, LisansKodu=@LisansKodu, DonanimID=@DonanimID, Notes=@Notes where ULC=@ULC", con); cmd.Parameters.Add("@ULC", SqlDbType.Int).Value = S.ULC; //cmd.Parameters.Add("@UC", SqlDbType.Int).Value = S.UC; //cmd.Parameters.Add("@ClientName", SqlDbType.VarChar).Value = S.ClientName; cmd.Parameters.Add("@Camera", SqlDbType.Int).Value = S.Camera; cmd.Parameters.Add("@NVR", SqlDbType.Int).Value = S.NVR; cmd.Parameters.Add("@VideoDuvar", SqlDbType.Int).Value = S.VideoDuvar; cmd.Parameters.Add("@IsIstasyonu", SqlDbType.Int).Value = S.IsIstasyonu; cmd.Parameters.Add("@Keyboard", SqlDbType.Int).Value = S.Keyboard; cmd.Parameters.Add("@SatisTarihi", SqlDbType.Date).Value = S.SatisTarihi; cmd.Parameters.Add("@LisansKodu", SqlDbType.VarChar).Value = S.LisansKodu; cmd.Parameters.Add("@DonanimID", SqlDbType.VarChar).Value = S.DonanimID; cmd.Parameters.Add("@Notes", SqlDbType.VarChar).Value = S.Notes; BaglantiAyarla(); ReturnValues = cmd.ExecuteNonQuery(); } catch (Exception ex) { } finally { BaglantiAyarla(); } return(ReturnValues); }
public int SatisKaydiEkle(Entities.SalesTable S, out string errormessage) { errormessage = ""; try { cmd = new SqlCommand("insert into SalesTable (ULC,UC,ClientName,Camera,NVR,VideoDuvar,IsIstasyonu,Keyboard,SatisTarihi,LisansKodu,DonanimID,Notes) values (@ULC,@UC,@ClientName,@Camera,@NVR,@VideoDuvar,@IsIstasyonu,@Keyboard,@SatisTarihi,@LisansKodu,@DonanimID,@Notes)", con); cmd.Parameters.Add("@ULC", SqlDbType.Int).Value = S.ULC; cmd.Parameters.Add("@UC", SqlDbType.Int).Value = S.UC; cmd.Parameters.Add("@ClientName", SqlDbType.VarChar).Value = S.ClientName; cmd.Parameters.Add("@Camera", SqlDbType.Int).Value = S.Camera; cmd.Parameters.Add("@NVR", SqlDbType.Int).Value = S.NVR; cmd.Parameters.Add("@VideoDuvar", SqlDbType.Int).Value = S.VideoDuvar; cmd.Parameters.Add("@IsIstasyonu", SqlDbType.Int).Value = S.IsIstasyonu; cmd.Parameters.Add("@Keyboard", SqlDbType.Int).Value = S.Keyboard; cmd.Parameters.Add("@SatisTarihi", SqlDbType.Date).Value = S.SatisTarihi; cmd.Parameters.Add("@LisansKodu", SqlDbType.VarChar).Value = S.LisansKodu; cmd.Parameters.Add("@DonanimID", SqlDbType.VarChar).Value = S.DonanimID; cmd.Parameters.Add("@Notes", SqlDbType.VarChar).Value = S.Notes; BaglantiAyarla(); ReturnValues = cmd.ExecuteNonQuery(); } catch (Exception ex) { errormessage = ex.Message; } finally { BaglantiAyarla(); } return(ReturnValues); }
public int SatisKaydiSil(int ULC) { if (ULC != 0) { Entities.SalesTable satisNesne = new Entities.SalesTable() { ULC = ULC, }; return(dll.SatisKaydiSil(satisNesne)); } else { return(-1); } }
public int SatisKaydiSil(Entities.SalesTable S) { try { cmd = new SqlCommand("delete SalesTable where ULC=@ULC", con); cmd.Parameters.Add("@ULC", SqlDbType.Int).Value = S.ULC; BaglantiAyarla(); ReturnValues = cmd.ExecuteNonQuery(); } catch (Exception ex) { } finally { BaglantiAyarla(); } return(ReturnValues); }