public static List <DBPrepaidCableTransactions> GetDataByWallet(string wallet, DateTime past, DateTime present)
{
List <DBPrepaidCableTransactions> data = new List <DBPrepaidCableTransactions>();
MySqlConnection con = DBConnection.ConnectDatabase();
try
{ // AND
MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE (date BETWEEN '" + past.ToString("yyyy-MM-dd") + " 0:0:0" + "' AND '" + present.ToString("yyyy-MM-dd") + " 23:59:59" + "') AND wallet_id ='" + wallet + "' ORDER BY id DESC", con);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DBPrepaidCableTransactions rawData = new DBPrepaidCableTransactions();
rawData.Id = reader.GetInt32(0);
rawData.Wallet_id = reader.GetString(1);
rawData.Code = reader.GetString(2);
rawData.Box_number = reader.GetString(3);
rawData.Amount = reader.GetInt32(4);
rawData.Discount = reader.GetFloat(5);
rawData.Pin = reader.GetString(6);
rawData.Customer_number = reader.GetString(7);
rawData.Date = reader.GetDateTime(8);
rawData.Status = reader.GetString(9);
data.Add(rawData);
}
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(data);
}
public static List <DBPrepaidCableTransactions> GetData()
{
List <DBPrepaidCableTransactions> data = new List <DBPrepaidCableTransactions>();
MySqlConnection con = DBConnection.ConnectDatabase();
try
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " ORDER BY id DESC", con);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
DBPrepaidCableTransactions rawData = new DBPrepaidCableTransactions();
rawData.Id = reader.GetInt32(0);
rawData.Wallet_id = reader.GetString(1);
rawData.Code = reader.GetString(2);
rawData.Box_number = reader.GetString(3);
rawData.Amount = reader.GetInt32(4);
rawData.Discount = reader.GetFloat(5);
rawData.Pin = reader.GetString(6);
rawData.Customer_number = reader.GetString(7);
rawData.Date = reader.GetDateTime(8);
rawData.Status = reader.GetString(9);
data.Add(rawData);
}
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(data);
}
public static DBPrepaidCableTransactions GetDataSendingStatus(string s)
{
DBPrepaidCableTransactions data = null;
MySqlConnection con = DBConnection.ConnectDatabase();
try
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE status='" + s + "'", con);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
data = new DBPrepaidCableTransactions();
data.Id = reader.GetInt32(0);
data.Wallet_id = reader.GetString(1);
data.Code = reader.GetString(2);
data.Box_number = reader.GetString(3);
data.Amount = reader.GetInt32(4);
data.Discount = reader.GetFloat(5);
data.Pin = reader.GetString(6);
data.Customer_number = reader.GetString(7);
data.Date = reader.GetDateTime(8);
data.Status = reader.GetString(9);
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
return(data);
}
public static DBPrepaidCableTransactions GetDataById(int idx)
{
DBPrepaidCableTransactions data = null;
MySqlConnection con = DBConnection.ConnectLocalAddressDatabase();
try
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE id=" + idx, con);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
data = new DBPrepaidCableTransactions();
data.Id = reader.GetInt32(0);
data.Wallet_id = reader.GetString(1);
data.Code = reader.GetString(2);
data.Box_number = reader.GetString(3);
data.Amount = reader.GetInt32(4);
data.Discount = reader.GetFloat(5);
data.Pin = reader.GetString(6);
data.Customer_number = reader.GetString(7);
data.Date = reader.GetDateTime(8);
data.Status = reader.GetString(9);
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(data);
}