public bool EditOne(VoterClearance p, ref string msg)
{
MySqlCommand command = new MySqlCommand();
command.CommandText = "EditVoterClearance";
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 VoterClearance MapProperties(VoterClearanceVm p)
{
VoterClearance baseObj = new VoterClearance();
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(VoterClearance p, ref string msg)
{
MySqlCommand command = new MySqlCommand();
command.CommandText = "DeleteVoterClearance";
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);
}
}
