private static transactionWallet ReaderDatatransaction(MySqlDataReader reader) { transactionWallet objtransaction = new transactionWallet(); objtransaction.TRANSACTIONID = Utility.IsValidInt(reader["TRANSACTIONID"]); objtransaction.TRANSACTIONDATE = Utility.IsValidDateTime(reader["TRANSACTIONDATE"]); objtransaction.CUSTID = Utility.IsValidInt(reader["CUSTID"]); objtransaction.TRANSACTIONAMOUNT = Utility.IsValidInt(reader["TRANSACTIONAMOUNT"]); return(objtransaction); }
public static List <transactionWallet> Gettransaction(string whereclause, MySqlConnection conn = null) { transactionWallet objtransaction = null; List <transactionWallet> lsttransaction = new List <transactionWallet>(); 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 transaction "; 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()) { objtransaction = ReaderDatatransaction(reader); lsttransaction.Add(objtransaction); } } else { } } } if (isConnArgNull == true) { connection.Dispose(); } } catch { } return(lsttransaction); }
public static string Savetransaction(transactionWallet objtransaction, MySqlConnection conn = null, MySqlTransaction trans = null) { string returnMessage = ""; string stransactionID = ""; stransactionID = objtransaction.TRANSACTIONID.ToString(); var templsttransaction = Gettransaction("TRANSACTIONID='" + stransactionID + "'", 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 (templsttransaction.Count <= 0) { isEdit = false; sql = @"INSERT INTO transaction(TRANSACTIONDATE,CUSTID,TRANSACTIONAMOUNT) VALUES (@TRANSACTIONDATE, @CUSTID,@TRANSACTIONAMOUNT)"; } else { sql = @"Update transaction set TRANSACTIONID=@TRANSACTIONID,TRANSACTIONDATE=@TRANSACTIONDATE, CUSTID=@CUSTID, TRANSACTIONAMOUNT=@TRANSACTIONAMOUNT where TRANSACTIONID=@TRANSACTIONID"; } if (trans != null) { command.Transaction = trans; } command.Connection = connection; command.CommandType = CommandType.Text; command.CommandText = sql; if (isEdit) { command.Parameters.AddWithValue("@TRANSACTIONID", objtransaction.TRANSACTIONID); } command.Parameters.AddWithValue("@TRANSACTIONDATE", objtransaction.TRANSACTIONDATE); command.Parameters.AddWithValue("@CUSTID", objtransaction.CUSTID); command.Parameters.AddWithValue("@TRANSACTIONAMOUNT", objtransaction.TRANSACTIONAMOUNT); 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); }