public bool EditOne(CandidateClearance p, ref string msg) { MySqlCommand command = new MySqlCommand(); command.CommandText = "EditCandidateClearance"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("intId", p.Id).Direction = ParameterDirection.Input; command.Parameters.AddWithValue("intGradeId", p.GradeId).Direction = ParameterDirection.Input; command.Parameters.AddWithValue("intPositionId", p.PositionId).Direction = ParameterDirection.Input; command.Parameters.AddWithValue("boolActive", p.Active).Direction = ParameterDirection.Input; command.Parameters.AddWithValue("itExists", MySqlDbType.Bit).Direction = ParameterDirection.Output; try { MyHelper.ExecuteNonQuery(command, ref msg); if ((int)command.Parameters["itExists"].Value == 0) { return(true); } msg = msg + "\nThis item is already in the database"; return(false); } catch (Exception ex) { msg = ef.GetExceptionMessage(ex, msg); return(false); } }
private CandidateClearance MapProperties(CandidateClearanceVm p) { CandidateClearance baseObj = new CandidateClearance(); baseObj.Id = p.Id.GetInt(); baseObj.PositionId = p.PositionId.GetInt(); baseObj.GradeId = p.GradeId.GetInt(); baseObj.Active = p.Active.GetBool(); return(baseObj); }
public bool DeleteOne(CandidateClearance p, ref string msg) { MySqlCommand command = new MySqlCommand(); command.CommandText = "DeleteCandidateClearance"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("intId", p.Id).Direction = ParameterDirection.Input; try { return(MyHelper.ExecuteNonQuery(command, ref msg)); } catch (Exception ex) { msg = ef.GetExceptionMessage(ex, msg); return(false); } }