Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
        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);
        }