using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using MySql.Data.MySqlClient;



/// <summary>
/// Summary description for notificationtocp
/// </summary>
[WebService(Namespace = "http://SubscriptionEngine.ibm.com/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
 [System.Web.Script.Services.ScriptService]
public class notificationtocp : System.Web.Services.WebService
{
    private string server;
    private string database;
    private string uid;
    private string password;
    private string query;
   
    public notificationtocp()
    {

        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }

    [WebMethod]
    public void notificationToCP(int xactionId, int errorCode, String errorMsg, String temp1, String temp2, String temp3, double lowBalance, double amount, DateTime chargigTime, String msisdn, int productId)
    {

        query = "insert cpnotifications(xactionId,errorCode,errorMsg,temp1,temp2,temp3,lowBalance,amount,chargeTime,msisdn,productId,status) values ('" + xactionId + "','" + errorCode + "','" + errorMsg + "','" + temp1 + "','" + temp2 + "','" + temp3 + "','" + lowBalance + "','" + amount + "','" + chargigTime + "','" + msisdn + "','" + productId + "','0')";
        int reader2 = 0;
        server = "localhost";
        database = "smartsmsrouter";
        uid = "smsEngine";
        password = "guEnaR28T";
        string connectionString;
        connectionString = "SERVER=" + server + ";" + "DATABASE=" +
        database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

        MySqlConnection connection2 = new MySqlConnection(connectionString);

        using (connection2)
            try
            {
                MySqlCommand command2 = new MySqlCommand(query, connection2);
                connection2.Open();
                reader2 = command2.ExecuteNonQuery();

            }
            catch (Exception ex)
            {

                Console.WriteLine("Error: " + ex.Message);
            }




        connection2.Close();

        //return "nosa";

    }
}