public static string GetProductJson()
{
Grafikjson grafikjson = new Grafikjson();
string sql;
Grafiksql g = new Grafiksql();
sql = g.run_product_query("15", "2");
string json = grafikjson.JsonAl(sql);
return(json);
/*GetBarchartData Sonu*/
}
public static string GetGroupJson()
{
Grafikjson grafikjson = new Grafikjson();
string sql;
Grafiksql g = new Grafiksql();
sql = g.run_group_guery("15");
string json = grafikjson.JsonAl(sql);
return(json);
/*GetBarchartData Sonu*/
}
public string RunNpgsqlTransaction(string json, string k_id, string adres_id, string odeme_id, string account_id, string adsnot)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (NpgsqlConnection pgConnection = new NpgsqlConnection(constr))
{
pgConnection.Open();
// Start a local transaction
NpgsqlTransaction myTrans = pgConnection.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
NpgsqlCommand pgCommand = pgConnection.CreateCommand();
try
{
JavaScriptSerializer ser = new JavaScriptSerializer();
cartList cart = ser.Deserialize <cartList>(json); //attributeleri dolduracagımız liste tanımını yaparız
Grafikjson gj = new Grafikjson();
DataTable dt = new DataTable();
dt = gj.JsonDataAl("SELECT adsnoartir(1,1)");
string adsno = dt.Rows[0]["adsnoartir"].ToString();
float ttoplam = 0;
for (int i = 0; i <= cart.cart.Count - 1; i++) //veri doldurması yapılılır
{
string id = cart.cart[i].id;
string adi = cart.cart[i].adi;
string adet = cart.cart[i].adet;
string fiyat = cart.cart[i].fiyat;
float tutarx = Convert.ToSingle(adet, CultureInfo.InvariantCulture) * Convert.ToSingle(fiyat, CultureInfo.InvariantCulture);
ttoplam += tutarx;
string tutar = tutarx.ToString().Replace(",", ".");
string dmenu = cart.cart[i].dynamic;
string seviye = cart.cart[i].seviye;
string sqlx = "insert into ads_acik(masano,pluid,miktar,bfiyat,tutar,sipno,garsonno,vergi,hbasildi, " +
" sip_ekleyen,ack1,ack2,ack3,ack4,adsno,actar,acsaat, " +
" adtur,orgno,sturu,mustid,hsahid,country,dontar,donsaat, " +
" adsfisno,daily_number,fiyatno,sip_tutar,voran,mustcnt,myazici,mars_var,d_menu,seviye,k_id,adres_id,odeme_id,account_id)values (" +
" 9999," + id + ", " +
" " + adet + "," + fiyat + "," + tutar + ", '1',1,1,false," +
" 1, 'ack1', 'ack2', " +
" 'ack3', '4'," + adsno + ", NOW(), NOW(), '1', '-1', '0', '0', '-1'," +
" 1, NOW(),NOW(), '0', '0', '0', '0',8,1,-1,0," + dmenu + "," + seviye + "," + k_id + "," + adres_id + "," + odeme_id + "," + account_id + ")";
pgCommand.CommandText = sqlx;
pgCommand.ExecuteNonQuery();
cartAL.Add(cart.cart[i]);
}
if (ControlCartTrans(cart, account_id))
{
myTrans.Commit(); //burada veri tabanına yazılır //burada fonksıyon cagırmalı if lemeli
}
else
{
islem = "1";
Debug.WriteLine("HATA VAR");
return(islem);
}
string ttoplamx = ttoplam.ToString().Replace(",", ".");
islem = "0";
pgCommand.CommandText = "insert into ads_order_state (adsno,customer_id,account_id,order_state,address_id,pay_type_id,total) values (" +
" " + adsno + " , " + k_id + "," + account_id + ",0," + adres_id + "," + odeme_id + "," + ttoplamx + ") ";
pgCommand.ExecuteNonQuery();
Console.WriteLine("işlem tamam");
if (adsnot != "undefined")
{
dt = gj.JsonDataAl("insert into ads_notlar (adsno,adsnot) values (" + adsno + ",'" + adsnot + "')");
}
else
{
Debug.WriteLine("Not boş geldi");
}
}
catch (Exception e)
{
myTrans.Rollback();
Console.WriteLine(e.ToString());
Console.WriteLine("Hata oluştu işlem geri alındı");
islem = e.ToString();
}
finally
{
pgCommand.Dispose();
myTrans.Dispose();
}
}
return(islem);
}
