private static mastercard ReaderDatamastercard(MySqlDataReader reader)
{
mastercard objmastercard = new mastercard();
objmastercard.CARDID = Utility.IsValidInt(reader["CARDID"]);
objmastercard.EXPIRYDATE = Utility.IsValidDateTime(reader["EXPIRYDATE"]);
objmastercard.CVV = Utility.IsValidInt(reader["CVV"]);
objmastercard.CUSTID = Utility.IsValidInt(reader["CUSTID"]);
objmastercard.PIN = Utility.IsValidInt(reader["PIN"]);
return(objmastercard);
}
public static List <mastercard> Getmastercard(string whereclause, MySqlConnection conn = null)
{
mastercard objmastercard = null;
List <mastercard> lstmastercard = new List <mastercard>();
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
//MySqlConnection connection = new MySqlConnection("server=132.148.68.125;user id = testusr; password=Testusr123!@#; database=testdatabase");
tryOpenConnection(connection);
string sql = "select * from mastercard ";
if (!string.IsNullOrEmpty(whereclause))
{
sql += " where " + whereclause;
}
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = sql;
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
objmastercard = ReaderDatamastercard(reader);
lstmastercard.Add(objmastercard);
}
}
else
{
}
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch
{
}
return(lstmastercard);
}
public static string Savemastercard(mastercard objmastercard, MySqlConnection conn = null, MySqlTransaction trans = null)
{
string returnMessage = "";
string sCARDID = "";
sCARDID = objmastercard.CARDID.ToString();
var templstmastercard = Getmastercard("CARDID='" + sCARDID + "'", conn);
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
// MySqlConnection connection = new MySqlConnection("server=132.148.68.125;user id = testusr; password=Testusr123!@#; database=testdatabase");
tryOpenConnection(connection);
using (MySqlCommand command = new MySqlCommand())
{
string sql;
bool isEdit = true;
if (templstmastercard.Count <= 0)
{
isEdit = false;
sql = @"INSERT INTO mastercard(CARDID,EXPIRYDATE,CVV,CUSTID,PIN ) VALUES (@CARDID,@EXPIRYDATE,@CVV,@CUSTID,@PIN)";
}
else
{
sql = @"Update mastercard set CARDID=@CARDID,EXPIRYDATE=@EXPIRYDATE, CVV=@CVV,CUSTID=@CUSTID,PIN=@PIN where CARDID=@CARDID";
}
if (trans != null)
{
command.Transaction = trans;
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
if (isEdit)
{
command.Parameters.AddWithValue("@CARDID", objmastercard.CARDID);
}
command.Parameters.AddWithValue("@EXPIRYDATE", objmastercard.EXPIRYDATE);
command.Parameters.AddWithValue("@CVV", objmastercard.CVV);
command.Parameters.AddWithValue("@CUSTID", objmastercard.CUSTID);
command.Parameters.AddWithValue("@PIN", objmastercard.PIN);
int affectedRows = command.ExecuteNonQuery();
if (affectedRows > 0)
{
returnMessage = "OK";
}
else
{
returnMessage = Constants.MSG_ERR_DBSAVE.Text;
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(returnMessage);
}
