private static jpOPENING ReaderDatajpOPENING(MySqlDataReader reader)
{
jpOPENING objjpOPENING = new jpOPENING();
objjpOPENING.openingID = Utility.IsValidInt(reader["openingID"]);
objjpOPENING.openingType = Utility.IsValidString(reader["openingType"]);
objjpOPENING.cvID = Utility.IsValidInt(reader["cvID"]);
return(objjpOPENING);
}
public static List <jpOPENING> GetjpOPENING(string whereclause, MySqlConnection conn = null)
{
jpOPENING objjpOPENING = null;
List <jpOPENING> lstjpOPENING = new List <jpOPENING>();
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())
{
objjpOPENING = ReaderDatajpOPENING(reader);
lstjpOPENING.Add(objjpOPENING);
}
}
else
{
}
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(lstjpOPENING);
}
public static string SavejpOPENING(jpOPENING objjpOPENING, MySqlConnection conn = null)
{
string returnMessage = "";
string sopeningID = "";
sopeningID = objjpOPENING.openingID.ToString();
var templstjpOPENING = GetjpOPENING("openingID = '" + sopeningID + "'", 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 (templstjpOPENING.Count <= 0)
{
isEdit = false;
sql = @"INSERT INTO jpOPENING(
openingType,
cvID
)
VALUES(
@openingType,
@cvID
)";
}
else
{
sql = @"Update jpOPENING set
openingID=@openingID,
openingType=@openingType,
cvID=@cvID
Where openingID=@openingID";
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
if (isEdit)
{
command.Parameters.AddWithValue("@openingID", objjpOPENING.openingID);
}
command.Parameters.AddWithValue("@openingType", objjpOPENING.openingType);
command.Parameters.AddWithValue("@cvID", objjpOPENING.cvID);
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);
}
