public invoiceResponse GetInvoiceInfoByServiceCodeList(invoiceDefaultRequest InvoiceDefaultRequest, int[] ServiceCodeList)
{
// public invoiceResponse GetInvoiceInfoByServiceCodeList(int SCCode, string IdentificationSubtype, string AbonCode
// , int[] ServiceCodeList)
//{
// invoiceDefaultRequest InvoiceDefaultRequest = new invoiceDefaultRequest();
// InvoiceDefaultRequest.scCode = SCCode;
// InvoiceDefaultRequest.identificationSubtype = IdentificationSubtype;
// InvoiceDefaultRequest.abonCode = AbonCode;
invoiceResponse invResp = new invoiceResponse();
//var soapRequest = TraceExtension.XmlRequest.OuterXml;
//System.IO.File.AppendAllText(Settings.Default.LogFileDirectory + "log" + DateTime.Now.ToString() + ".txt", "Request : " + DateTime.Now + soapRequest + Environment.NewLine);
invResp.serviceAccountPartial = new serviceAccountPartial();
invResp.serviceAccountPartial.abonCode = InvoiceDefaultRequest.abonCode;
invResp.serviceAccountPartial.scCode = InvoiceDefaultRequest.scCode;
invResp.serviceAccountPartial.identificationSubtype = InvoiceDefaultRequest.identificationSubtype;
SqlConnection sqlcon = new SqlConnection();
try
{
sqlcon.ConnectionString = SQLConnectionstring;
sqlcon.Open();
}
catch (Exception ex)
{
System.IO.File.AppendAllText(Settings.Default.LogFileDirectory + "log" + DateTime.Now.ToString("yyyyMMdd") + ".txt",
DateTimeOffset.Now.ToString("yyyy-MM-ddTHH:mm:sszzz") + " - Error : " + ex.Message.ToString() + Environment.NewLine + SQLConnectionstring + Environment.NewLine);
errorType ert = new errorType();
ert.errorCode = errorCode.SYSTEM_ERROR;
ert.errorDateTime = DateTime.Now;
ert.errorData = new object[1];
ert.errorData[0] = InvoiceDefaultRequest.scCode;
ert.errorObjectType = objectType.SYSTEM;
CustomSOAPException myexp = new CustomSOAPException("GetInvoiceInfoByServiceCodeList", ert);
throw myexp;
}
SqlCommand ckcmd = new SqlCommand("select * from Taxpayer where YVOK=@YVOK and Fordelete=1", sqlcon);
ckcmd.Parameters.AddWithValue("@YVOK", InvoiceDefaultRequest.abonCode);
SqlDataReader reader1 = ckcmd.ExecuteReader();
if (!(reader1.HasRows) || !(reader1.Read()))
{
errorType ert = new errorType();
ert.errorCode = errorCode.NOT_FOUND;
ert.errorDateTime = DateTime.Now;
ert.errorData = new object[1];
ert.errorData[0] = InvoiceDefaultRequest.abonCode;
ert.errorObjectType = objectType.SERVICE_ACCOUNT;
CustomSOAPException myexp = new CustomSOAPException("GetInvoiceInfoByServiceCodeList", ert);
sqlcon.Close();
throw myexp;
}
reader1.Close();
string TaxpayerID = klas.getdatacell("select TaxpayerID from Taxpayer " +
"where YVOK=N'" + InvoiceDefaultRequest.abonCode + "' and Fordelete=1");
DataTable dt = new DataTable();
if (TaxpayerID != null && ServiceCodeList.Length > 0)
{
//if (municipal.GetTaxesObjects(TaxpayerID,ServiceCodeList) != null)
{
dt = municipal.GetTaxesObjects(TaxpayerID, ServiceCodeList);
}
}
DataTableReader reader;
reader = dt.CreateDataReader();
int cnt = 0;
List <invoice> invList = new List <invoice>();
while (reader.Read())
{
int colIndex;
invoice inv = new invoice();
colIndex = reader.GetOrdinal("InvoiceType");
//invoiceType invtype = new invoiceType();
//if (Enum.TryParse(reader[colIndex].ToString(), out invtype))
//{
inv.invoiceType = invoiceType.AVANS;
//}
//colIndex = reader.GetOrdinal("InvoiceDate");
//if (!reader.IsDBNull(colIndex))
//{
// inv.invoiceDate = reader.GetDateTime(colIndex);
// inv.invoiceDateSpecified = true;
//}
colIndex = reader.GetOrdinal("AmountDue");
inv.amountDue = reader.IsDBNull(colIndex) ?
0 : reader.GetDecimal(colIndex);
inv.amountDueSpecified = true;
colIndex = reader.GetOrdinal("CurrentDebt");
inv.currentDebt = reader.IsDBNull(colIndex) ?
0 : reader.GetDecimal(colIndex);
inv.currentDebtSpecified = true;
colIndex = reader.GetOrdinal("PaymentReceiver");
int paymentReceiver = 0;
if (Int32.TryParse(reader[colIndex].ToString(), out paymentReceiver))
{
inv.paymentReceiverCode = paymentReceiver;
inv.paymentReceiverCodeSpecified = true;
}
colIndex = reader.GetOrdinal("ServiceCode");
int serviceCode = 0;
if (Int32.TryParse(reader[colIndex].ToString(), out serviceCode))
{
inv.serviceCode = serviceCode;
inv.serviceCodeSpecified = true;
}
//System.IO.File.AppendAllText(Settings.Default.LogFileDirectory + "log.txt",
// "INFO:1:" + DateTime.Now + Environment.NewLine);
//System.IO.File.AppendAllText(Settings.Default.LogFileDirectory + "log" + DateTime.Now.ToString() + ".txt",
// "INFO:1:" + DateTime.Now + Environment.NewLine);
invList.Add(inv);
cnt++;
}
if (reader.HasRows)
{
invResp.invoiceList = invList.ToArray();
}
else if (invList.Count != ServiceCodeList.Length)
{
errorType ert = new errorType();
ert.errorCode = errorCode.NOT_ALLOWED;
ert.errorDateTime = DateTime.Now;
ert.errorData = new object[1];
ert.errorData[0] = InvoiceDefaultRequest.abonCode;
ert.errorObjectType = objectType.PRE_PAYMENT;
CustomSOAPException myexp = new CustomSOAPException("GetInvoiceInfoByServiceCodeList", ert);
throw myexp;
}
sqlcon.Close();
System.IO.File.AppendAllText(Settings.Default.LogFileDirectory + "log" + DateTimeOffset.Now.ToString("yyyyMMdd") + ".txt",
DateTimeOffset.Now.ToString("yyyy-MM-ddTHH:mm:sszzz") + " - codelistinfo INFO : " + DateTimeOffset.Now.ToString("yyyy-MM-ddTHH:mm:sszzz") + InvoiceDefaultRequest.abonCode.ToString() + Environment.NewLine);
//var soapResponse = TraceExtension.XmlResponse.OuterXml;
//System.IO.File.AppendAllText(Settings.Default.LogFileDirectory + "log" + DateTime.Now.ToString() + ".txt",
// "INFO : " + DateTime.Now + soapResponse + Environment.NewLine);
return(invResp);
}
public invoiceResponse GetInvoiceInfo(invoiceDefaultRequest InvoiceDefaultRequest)
{
//serhe alinan hisse evvel
// public invoiceResponse GetInvoiceInfo(int SCCode, string IdentificationSubtype, string AbonCode)
//{
// invoiceDefaultRequest InvoiceDefaultRequest = new invoiceDefaultRequest();
// InvoiceDefaultRequest.abonCode = AbonCode;
// InvoiceDefaultRequest.scCode = SCCode;
// InvoiceDefaultRequest.identificationSubtype = IdentificationSubtype;
//serhe alinan hisse son
invoiceResponse invResp = new invoiceResponse();
invResp.serviceAccountPartial = new serviceAccountPartial();
invResp.serviceAccountPartial.abonCode = InvoiceDefaultRequest.abonCode;
invResp.serviceAccountPartial.scCode = InvoiceDefaultRequest.scCode;
invResp.serviceAccountPartial.identificationSubtype = InvoiceDefaultRequest.identificationSubtype;
SqlConnection sqlcon = new SqlConnection();
try
{
sqlcon.ConnectionString = SQLConnectionstring;
sqlcon.Open();
}
catch (Exception ex)
{
System.IO.File.AppendAllText(Settings.Default.LogFileDirectory + "log" + DateTime.Now.ToString("yyyyMMdd") + ".txt",
DateTimeOffset.Now.ToString("yyyy-MM-ddTHH:mm:sszzz") + " - Error : " + ex.Message.ToString() + Environment.NewLine + SQLConnectionstring + Environment.NewLine);
errorType ert = new errorType();
ert.errorCode = errorCode.SYSTEM_ERROR;
ert.errorDateTime = DateTime.Now;
ert.errorData = new object[1];
ert.errorData[0] = messageHeaderValue.receiverID.ToString();
ert.errorObjectType = objectType.SYSTEM;
CustomSOAPException myexp = new CustomSOAPException("GetInvoiceInfo", ert);
throw myexp;
}
SqlCommand ckcmd = new SqlCommand(@"select TaxpayerID from Taxpayer
where YVOK=@YVOK and Fordelete=1", sqlcon);
ckcmd.Parameters.AddWithValue("@YVOK", InvoiceDefaultRequest.abonCode);
SqlDataReader reader1 = ckcmd.ExecuteReader();
if (!(reader1.HasRows) || !(reader1.Read()))
{
errorType ert = new errorType();
ert.errorCode = errorCode.NOT_FOUND;
ert.errorDateTime = DateTime.Now;
ert.errorData = new object[1];
ert.errorData[0] = InvoiceDefaultRequest.abonCode;
ert.errorObjectType = objectType.SERVICE_ACCOUNT;
CustomSOAPException myexp = new CustomSOAPException("GetInvoiceInfo", ert);
sqlcon.Close();
throw myexp;
}
reader1.Close();
int[] ServiceCodeList = { 20000200 /*emlak*/, 20000100 /*torpaq*/, 20000300 /*meden vergisi*/,
20001000 /*Bələdiyyə mülkiyyətinin icarə*/, 20000500 /*reklam*/, 20000800 /*neqliyyat vas day*/, 20000700 /*Mehmanxana*/, 20000600 /*Stasionar*/,
20000900 /*Bələdiyyə mülkiyyətinin özgə*/, 20000400 /*menfeet*/, 20001100 /*sanksiya*/, 20001200 /*iane*/ };
string TaxpayerID = klas.getdatacell(@"select TaxpayerID from Taxpayer
where YVOK=N'" + InvoiceDefaultRequest.abonCode + "' and Fordelete=1");
DataTable dt = new DataTable();
if (TaxpayerID != null && ServiceCodeList.Length > 0)
{
dt = municipal.GetTaxesObjects(TaxpayerID, ServiceCodeList);
}
DataTableReader reader;
reader = dt.CreateDataReader();
int cnt = 0;
List <invoice> invList = new List <invoice>();
while (reader.Read())
{
int colIndex;
invoice inv = new invoice();
colIndex = reader.GetOrdinal("InvoiceType");
//invoiceType invtype = new invoiceType();
//if (Enum.TryParse(reader[colIndex].ToString(), out invtype))
//{
inv.invoiceType = invoiceType.AVANS;
//}
colIndex = reader.GetOrdinal("AmountDue");
inv.amountDue = reader.IsDBNull(colIndex) ?
0 : reader.GetDecimal(colIndex);
inv.amountDueSpecified = true;
colIndex = reader.GetOrdinal("CurrentDebt");
inv.currentDebt = reader.IsDBNull(colIndex) ?
0 : reader.GetDecimal(colIndex);
inv.currentDebtSpecified = true;
colIndex = reader.GetOrdinal("PaymentReceiver");
int paymentReceiver = 0;
if (Int32.TryParse(reader[colIndex].ToString(), out paymentReceiver))
{
inv.paymentReceiverCode = paymentReceiver;
inv.paymentReceiverCodeSpecified = true;
}
colIndex = reader.GetOrdinal("ServiceCode");
int serviceCode = 0;
if (Int32.TryParse(reader[colIndex].ToString(), out serviceCode))
{
inv.serviceCode = serviceCode;
inv.serviceCodeSpecified = true;
}
//if (inv.currentDebt > 0)
//{
invList.Add(inv);
cnt++;
//}
}
sqlcon.Close();
if (cnt > 0)
{
invResp.invoiceList = invList.ToArray();
}
System.IO.File.AppendAllText(Settings.Default.LogFileDirectory + "log" + DateTimeOffset.Now.ToString("yyyyMMdd") + ".txt",
DateTimeOffset.Now.ToString("yyyy-MM-ddTHH:mm:sszzz") + " - INFO : " + DateTimeOffset.Now.ToString("yyyy-MM-ddTHH:mm:sszzz") + InvoiceDefaultRequest.abonCode.ToString() + Environment.NewLine);
return(invResp);
}
