// static string conString = "Data Source='10.1.5.137';Initial Catalog='TcDirectTopUp';User ID='tigocash';Password='******'";
#endregion '
/// <summary>
///
/// </summary>
/// <returns></returns>
public static IList <AirTimePrice> GetAllRequests()
{
con = new SqlConnection(conString);
string qry = "SELECT * FROM UssdPriceInput WHERE ProcessStatus=0";
IList <AirTimePrice> requests = new List <AirTimePrice>();
AirTimePrice ussdPrice; // = new AirTimePrice();
using (SqlCommand qryCmd = new SqlCommand(qry, con))
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
var temp_data = qryCmd.ExecuteReader(); //get all
// int i = 1;
while (temp_data.Read())
{
ussdPrice = new AirTimePrice();
//string qry = string.Empty;
//if (menu == 0)
// qry = string.Format("SELECT * FROM UssdPriceInput Where sessionID='{0}'", session);
//else
// qry = string.Format("SELECT * FROM UssdPriceInput Where sessionID='{0}' AND MenuId='{1}'", session, menu);
//SqlConnection con = new SqlConnection(conSession);
// string qry = string.Format("SELECT * FROM UssdPriceInput Where sessionID='{0}' AND MenuId='{1}'", session, menu);
ussdPrice.ctmin = temp_data[1].ToString();
ussdPrice.ctmax = temp_data[2].ToString();
ussdPrice.session = temp_data[3].ToString();
ussdPrice.type = temp_data[4].ToString();
ussdPrice.menuId = int.Parse(temp_data[5].ToString());
ussdPrice.ctminLong = temp_data[6].ToString();
ussdPrice.ctmaxLong = temp_data[7].ToString();
ussdPrice.network = temp_data[8].ToString();
ussdPrice.networkName = temp_data[9].ToString();
ussdPrice.RecordId = int.Parse(temp_data[0].ToString());
ussdPrice.inputPrice = temp_data[10].ToString();
ussdPrice.reciever = temp_data[11].ToString();
requests.Add(ussdPrice);
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
return(requests);
}
public static void UpdateTigoCashRequest(AirTimePrice request, int status)
{
SqlConnection con = new SqlConnection(conString);
// string qry = String.Format("Update Temp_Recon SET Status = {1} WHERE AutoID={0}", request.RequestID, status);
string qry = String.Format("Update UssdPriceInput SET ProcessStatus = {1} WHERE ID={0}", request.RecordId, status);
using (SqlCommand qryCmd = new SqlCommand(qry, con))
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
var tmp = qryCmd.ExecuteNonQuery();
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
