private static jpCV ReaderDatajpCV(MySqlDataReader reader) { jpCV objjpCV = new jpCV(); objjpCV.cvID = Utility.IsValidInt(reader["cvID"]); objjpCV.name = Utility.IsValidString(reader["name"]); objjpCV.address = Utility.IsValidString(reader["address"]); objjpCV.age = Utility.IsValidInt(reader["age"]); objjpCV.gender = Utility.IsValidString(reader["gender"]); objjpCV.email = Utility.IsValidString(reader["email"]); objjpCV.contact = Utility.IsValidString(reader["contact"]); objjpCV.extraCurricularActivites = Utility.IsValidString(reader["extraCurricularActivites"]); objjpCV.userID = Utility.IsValidInt(reader["userID"]); objjpCV.currentSalary = Utility.IsValidString(reader["currentSalary"]); return(objjpCV); }
public static List <jpCV> GetjpCV(string whereclause, MySqlConnection conn = null) { jpCV objjpCV = null; List <jpCV> lstjpCV = new List <jpCV>(); 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()) { objjpCV = ReaderDatajpCV(reader); lstjpCV.Add(objjpCV); } } else { } } } if (isConnArgNull == true) { connection.Dispose(); } } catch (Exception ex) { } return(lstjpCV); }
public static string SavejpCV(jpCV objjpCV, MySqlConnection conn = null) { string returnMessage = ""; string scvID = ""; scvID = objjpCV.cvID.ToString(); var templstjpCV = GetjpCV("cvID = '" + scvID + "'", 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 (templstjpCV.Count <= 0) { isEdit = false; sql = @"INSERT INTO jpCV( name, address, age, gender, email, contact, extraCurricularActivites, userID, currentSalary ) VALUES( @name, @address, @age, @gender, @email, @contact, @extraCurricularActivites, @userID, @currentSalary )"; } else { sql = @"Update jpCV set cvID=@cvID, name=@name, address=@address, age=@age, gender=@gender, email=@email, contact=@contact, extraCurricularActivites=@extraCurricularActivites, userID=@userID, currentSalary=@currentSalary Where cvID=@cvID"; } command.Connection = connection; command.CommandType = CommandType.Text; command.CommandText = sql; if (isEdit) { command.Parameters.AddWithValue("@cvID", objjpCV.cvID); } command.Parameters.AddWithValue("@name", objjpCV.name); command.Parameters.AddWithValue("@address", objjpCV.address); command.Parameters.AddWithValue("@age", objjpCV.age); command.Parameters.AddWithValue("@gender", objjpCV.gender); command.Parameters.AddWithValue("@email", objjpCV.email); command.Parameters.AddWithValue("@contact", objjpCV.contact); command.Parameters.AddWithValue("@extraCurricularActivites", objjpCV.extraCurricularActivites); command.Parameters.AddWithValue("@userID", objjpCV.userID); command.Parameters.AddWithValue("@currentSalary", objjpCV.currentSalary); 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); }