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