public DataTable GetPaymentList(string yvok, string passwordbld) { if (passwordbld == "=Bld2016dlB+") { Class2 conn = new Class2(); yvok = seo.temizle(yvok); DataRow dr = conn.GetDataRow(@"Select * from taxpayer where YVOK = '" + yvok + "'"); if (dr != null) { string taxpayerID = dr["TaxpayerID"].ToString(); MethotAll municipal = new MethotAll(); // DataTable dt = new DataTable(); // dt = municipal.GetTaxesObjects(taxpayerID); if (municipal.GetTaxesObjects(taxpayerID) != null) { return(municipal.GetTaxesObjects(taxpayerID)); } else { return(null); } } else { return(null); } } else { return(null); } }
public bool SendPayForInsert(string OdeyiciID, string VergiTipi, string Mebleg, string passwordbld) { MethotAll municipal = new MethotAll(); try { if (passwordbld == "=Bld2016dlB+") { municipal.InserTaxes(OdeyiciID, VergiTipi, Mebleg); return(true); } else { return(false); } } catch { return(false); } }
public DataTable GetPaymentListPincode(string Pincode, string passwordbld) { if (passwordbld == "=Bld2016dlB+") { Class2 conn = new Class2(); Pincode = seo.temizle(Pincode); DataTable dt = conn.getdatatable(@"Select * from taxpayer where Pincode = '" + Pincode + "' order by MunicipalName desc"); DataTable dt2 = new DataTable(); int i = 0; if (dt != null) { foreach (DataRow dr in dt.Rows) { string taxpayerID = dr["TaxpayerID"].ToString(); MethotAll municipal = new MethotAll(); DataTable dt1 = new DataTable(); // dt = municipal.GetTaxesObjects(taxpayerID); if (municipal.GetTaxesObjects(taxpayerID) != null) { dt1 = municipal.GetTaxesObjects(taxpayerID); i++; if (i == 1) { dt2 = dt1; } } else { dt1 = null; } if (i > 1) { if (dt1 != null) { for (int j = 0; j < dt1.Rows.Count; j++) { DataRow dr1 = dt2.NewRow(); dr1["RayonID"] = dt1.Rows[j]["RayonID"].ToString(); dr1["BelediyyeID"] = dt1.Rows[j]["BelediyyeID"].ToString(); dr1["RayonSheher"] = dt1.Rows[j]["RayonSheher"].ToString(); dr1["Belediyye"] = dt1.Rows[j]["Belediyye"].ToString(); dr1["OdeyiciID"] = dt1.Rows[j]["OdeyiciID"].ToString(); dr1["OdeyiciAdi"] = dt1.Rows[j]["OdeyiciAdi"].ToString(); dr1["VergiTipi"] = dt1.Rows[j]["VergiTipi"].ToString(); dr1["VergiAdi"] = dt1.Rows[j]["VergiAdi"].ToString(); dr1["Mebleg"] = dt1.Rows[j]["Mebleg"].ToString(); dr1["HesabNomresi"] = dt1.Rows[j]["HesabNomresi"].ToString(); dr1["BankAdi"] = dt1.Rows[j]["BankAdi"].ToString(); dt2.Rows.Add(dr1); } } } } return(dt2); } else { return(null); } } else { return(null); } }