private static jpUSER ReaderDatajpUSER(MySqlDataReader reader)
{
jpUSER objjpUSER = new jpUSER();
objjpUSER.userID = Utility.IsValidInt(reader["userID"]);
objjpUSER.email = Utility.IsValidString(reader["email"]);
objjpUSER.password = Utility.IsValidString(reader["password"]);
objjpUSER.username = Utility.IsValidString(reader["username"]);
return(objjpUSER);
}
public static List <jpUSER> GetjpUSER(string whereclause, MySqlConnection conn = null)
{
jpUSER objjpUSER = null;
List <jpUSER> lstjpUSER = new List <jpUSER>();
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
string sql = "";
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = sql;
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
objjpUSER = ReaderDatajpUSER(reader);
lstjpUSER.Add(objjpUSER);
}
}
else
{
}
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(lstjpUSER);
}
public static string SavejpUSER(jpUSER objjpUSER, MySqlConnection conn = null)
{
string returnMessage = "";
string suserID = "";
suserID = objjpUSER.userID.ToString();
var templstjpUSER = GetjpUSER("userID = '" + suserID + "'", conn);
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
using (MySqlCommand command = new MySqlCommand())
{
string sql;
bool isEdit = true;
if (templstjpUSER.Count <= 0)
{
isEdit = false;
sql = @"INSERT INTO jpUSER(
email,
password,
username
)
VALUES(
@email,
@password,
@username
)";
}
else
{
sql = @"Update jpUSER set
userID=@userID,
email=@email,
password=@password,
username=@username
Where userID=@userID";
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
if (isEdit)
{
command.Parameters.AddWithValue("@userID", objjpUSER.userID);
}
command.Parameters.AddWithValue("@email", objjpUSER.email);
command.Parameters.AddWithValue("@password", objjpUSER.password);
command.Parameters.AddWithValue("@username", objjpUSER.username);
int affectedRows = command.ExecuteNonQuery();
if (affectedRows > 0)
{
returnMessage = "OK";
}
else
{
returnMessage = "Unable to save, Please contact ISD";
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(returnMessage);
}
