public static string FaturaSil(int FaturaNo)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
Data.DonenDeger aa = new Data.DonenDeger();
if (FaturaNo == 0)
{
aa.Id = 0;
aa.Durum = "";
string str = serializer.Serialize(aa);
return(str);
}
SqlConnection conn = DB.Connect();
string query = " delete FaturaDetay where MasterId= @MasterId " +
" delete FaturaMaster where Id= @Id select * from FaturaMaster where Id= @Id2";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@MasterId", SqlDbType.Int, 20).Value = FaturaNo;
cmd.Parameters.Add("@Id", SqlDbType.Int, 20).Value = FaturaNo;
cmd.Parameters.Add("@Id2", SqlDbType.Int, 20).Value = FaturaNo;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
aa.Id = 0;
aa.Durum = "";
string str = serializer.Serialize(aa);
return(str);
}
aa.Id = FaturaNo;
aa.Durum = "Başarılı";
string ss = serializer.Serialize(aa);
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
return(ss);
}
public static string UrunKaydet(Data.Urunxx Gelen)
{
int Id; string Tanim; string Birim; double BirimFiyat;
JavaScriptSerializer serializer = new JavaScriptSerializer();
//Data.Urunxx Gelenxx= (Data.Urunxx)serializer.DeserializeObject(Gelen);
Id = Gelen.Id;
Tanim = Gelen.Tanim;
Birim = Gelen.Birim;
BirimFiyat = Gelen.BirimFiyat;
Data.DonenDeger aa = new Data.DonenDeger();
SqlConnection conn = DB.Connect();
SqlCommand cmd;
string query;
SqlDataReader dr;
if (Id == 0)
{
query = " insert into Urunler(Tanim,Birim,BirimFiyat) select @Tanim, @Birim, @BirimFiyat select scope_identity() Id ";
cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@Tanim", SqlDbType.VarChar, 20).Value = Tanim;
cmd.Parameters.Add("@Birim", SqlDbType.VarChar, 20).Value = Birim;
cmd.Parameters.Add("@BirimFiyat", SqlDbType.Float).Value = BirimFiyat;
dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
aa.Id = 0;
aa.Durum = "";
string str = serializer.Serialize(aa);
return(str);
}
}
else
{
query = " update Urunler set Tanim= @Tanim, Birim= @Birim,BirimFiyat= @BirimFiyat where Id= @Id select @Id Id ";
cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@Tanim", SqlDbType.VarChar, 20).Value = Tanim;
cmd.Parameters.Add("@Birim", SqlDbType.VarChar, 20).Value = Birim;
cmd.Parameters.Add("@BirimFiyat", SqlDbType.Float).Value = BirimFiyat;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = Id;
dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
aa.Id = 0;
aa.Durum = "";
string str = serializer.Serialize(aa);
return(str);
}
}
aa.Id = Id;
aa.Durum = "Başarılı";
string ss = serializer.Serialize(aa);
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
return(ss);
}
public static string SiparisEkle(Data.UrunSiparis Gelen)
{
int Id; double Miktar; string Birim; double BirimFiyat; int UrunId; int BayiId;
JavaScriptSerializer serializer = new JavaScriptSerializer();
//Data.Urunxx Gelenxx= (Data.Urunxx)serializer.DeserializeObject(Gelen);
Id = Gelen.Id;
BayiId = Gelen.BayiId;
UrunId = Gelen.UrunId;
Miktar = Gelen.Miktar;
Birim = Gelen.Birim;
BirimFiyat = Gelen.BirimFiyat;
Data.DonenDeger aa = new Data.DonenDeger();
SqlConnection conn = DB.Connect();
SqlCommand cmd;
string query;
SqlDataReader dr;
if (Id == 0)
{
query =// " insert into SiparisDetay(Tanim,Birim,BirimFiyat) select @Tanim, @Birim, @BirimFiyat select scope_identity() Id ";
" insert into SiparisMaster(Tarih,BayiId) select @Tarih, @BayiId" +
" Declare @newid int set @newid= scope_identity() " +
" insert into SiparisDetay( MasterId, UrunId, Birim, Miktar, BirimFiyat)" +
" select @newid, @UrunId,@Birim,@Miktar, @BirimFiyat select @newid Id ";
cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@Tarih", SqlDbType.DateTime).Value = System.DateTime.Today;
cmd.Parameters.Add("@BayiId", SqlDbType.Int).Value = BayiId;
cmd.Parameters.Add("@UrunId", SqlDbType.Int).Value = UrunId;
cmd.Parameters.Add("@Birim", SqlDbType.VarChar, 20).Value = Birim;
cmd.Parameters.Add("@Miktar", SqlDbType.Float).Value = Miktar;
cmd.Parameters.Add("@BirimFiyat", SqlDbType.Float).Value = BirimFiyat;
dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
aa.Id = 0;
aa.Durum = "";
string str = serializer.Serialize(aa);
return(str);
}
}
else
{
query = " update SiparisDetay set UrunId= @UrunId, Birim= @Birim,BirimFiyat= @BirimFiyat Miktar= @Miktar where Id= @Id select @Id Id ";
cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@UrunId", SqlDbType.Int).Value = UrunId;
cmd.Parameters.Add("@Birim", SqlDbType.VarChar, 20).Value = Birim;
cmd.Parameters.Add("@Miktar", SqlDbType.Float).Value = Miktar;
cmd.Parameters.Add("@BirimFiyat", SqlDbType.Float).Value = BirimFiyat;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = Id;
dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
aa.Id = 0;
aa.Durum = "";
string str = serializer.Serialize(aa);
return(str);
}
}
aa.Id = Id;
aa.Durum = "Başarılı";
string ss = serializer.Serialize(aa);
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
return(ss);
}
public static string FaturaKayit(int SiparisNo)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
Data.DonenDeger aa = new Data.DonenDeger();
if (SiparisNo == 0)
{
aa.Id = 0;
aa.Durum = "";
string str = serializer.Serialize(aa);
return(str);
}
/* var deserializedResult = serializer.Deserialize<Data.GelenDeger>(PSiparis);*/
//int SiparisNo = 2;
SqlConnection conn = DB.Connect();
string query = " select d.Id " +
" from SiparisMaster m inner join SiparisDetay d on m.Id=d.MasterId " +
" where m.Id= @Id and not exists(select Id from FaturaDetay where SiparisDetayId=d.Id )";// and m.Tarih between isnull( @Tarih1 , m.Tarih) and isnull( @Tarih2 , m.Tarih)";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@Id", SqlDbType.Int, 20).Value = SiparisNo;
SqlDataReader dr = cmd.ExecuteReader();
//Data.Siparisler Ana = new Data.Siparisler();
Data.Siparisler Ana = new Data.Siparisler();
Ana.Liste = new List <Data.Siparis>();
if (!dr.Read())
{
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
aa.Id = 0;
aa.Durum = "";
string str = serializer.Serialize(aa);
return(str);
}
dr.Close();
DB.Close(conn);
cmd.Dispose();
conn = DB.Connect();
query = " insert into FaturaMaster(Tarih,BayiId,Adres) select m.Tarih,m.BayiId,isnull((select Tanim from Bayiler where Id=m.BayiId ),'')" +
" from SiparisMaster m where m.Id= @Id " +
" Declare @newid int set @newid= scope_identity() " +
" insert into FaturaDetay( MasterId, UrunId, Birim, Miktar, BirimFiyat, SiparisDetayId)" +
" select @newid, d.UrunId,d.Birim,d.Miktar, d.BirimFiyat, d.Id " +
" from SiparisDetay d where d.MasterId= @MasterId and not exists(select Id from FaturaDetay where SiparisDetayId=d.Id ) select @newid FaturaId";
cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@Id", SqlDbType.Int, 20).Value = SiparisNo;
cmd.Parameters.Add("@MasterId", SqlDbType.Int, 20).Value = SiparisNo;
// cmd.Parameters.Add("@Tarih2", SqlDbType.VarChar, 30).Value = TxtSifre.Text; //Sifre.TripleDesc(TbxSifre.Text);
dr = cmd.ExecuteReader();
if (dr.Read())
{
aa.Id = Convert.ToInt16(dr["FaturaId"].ToString());
aa.Durum = "Başarılı";
}
else
{
aa.Id = 0;
aa.Durum = "";
}
string ss = serializer.Serialize(aa);
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
return(ss);
}
