private static jpQUALIFICATION ReaderDatajpQUALIFICATION(MySqlDataReader reader)
{
jpQUALIFICATION objjpQUALIFICATION = new jpQUALIFICATION();
objjpQUALIFICATION.qualificationID = Utility.IsValidInt(reader["qualificationID"]);
objjpQUALIFICATION.cvID = Utility.IsValidInt(reader["cvID"]);
objjpQUALIFICATION.degreeName = Utility.IsValidString(reader["degreeName"]);
objjpQUALIFICATION.passingYear = Utility.IsValidString(reader["passingYear"]);
objjpQUALIFICATION.grades = Utility.IsValidString(reader["grades"]);
objjpQUALIFICATION.institutionName = Utility.IsValidString(reader["institutionName"]);
return(objjpQUALIFICATION);
}
public static List <jpQUALIFICATION> GetjpQUALIFICATION(string whereclause, MySqlConnection conn = null)
{
jpQUALIFICATION objjpQUALIFICATION = null;
List <jpQUALIFICATION> lstjpQUALIFICATION = new List <jpQUALIFICATION>();
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())
{
objjpQUALIFICATION = ReaderDatajpQUALIFICATION(reader);
lstjpQUALIFICATION.Add(objjpQUALIFICATION);
}
}
else
{
}
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(lstjpQUALIFICATION);
}
public static string SavejpQUALIFICATION(jpQUALIFICATION objjpQUALIFICATION, MySqlConnection conn = null)
{
string returnMessage = "";
string squalificationID = "";
squalificationID = objjpQUALIFICATION.qualificationID.ToString();
var templstjpQUALIFICATION = GetjpQUALIFICATION("qualificationID = '" + squalificationID + "'", 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 (templstjpQUALIFICATION.Count <= 0)
{
isEdit = false;
sql = @"INSERT INTO jpQUALIFICATION(
cvID,
degreeName,
passingYear,
grades,
institutionName
)
VALUES(
@cvID,
@degreeName,
@passingYear,
@grades,
@institutionName
)";
}
else
{
sql = @"Update jpQUALIFICATION set
qualificationID=@qualificationID,
cvID=@cvID,
degreeName=@degreeName,
passingYear=@passingYear,
grades=@grades,
institutionName=@institutionName
Where qualificationID=@qualificationID";
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
if (isEdit)
{
command.Parameters.AddWithValue("@qualificationID", objjpQUALIFICATION.qualificationID);
}
command.Parameters.AddWithValue("@cvID", objjpQUALIFICATION.cvID);
command.Parameters.AddWithValue("@degreeName", objjpQUALIFICATION.degreeName);
command.Parameters.AddWithValue("@passingYear", objjpQUALIFICATION.passingYear);
command.Parameters.AddWithValue("@grades", objjpQUALIFICATION.grades);
command.Parameters.AddWithValue("@institutionName", objjpQUALIFICATION.institutionName);
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);
}