// 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(); } }