private MeritalStatus Mapper(IDataReader reader)
{
try {
MeritalStatus _MeritalStatus = new MeritalStatus();
if (reader[ID] != null && reader[ID] != DBNull.Value)
{
_MeritalStatus.ID = Common.Conversion.ToShort(reader[ID]);
}
if (reader[MERITALSTATUSTITLE] != null && reader[MERITALSTATUSTITLE] != DBNull.Value)
{
_MeritalStatus.MeritalStatusTitle = Common.Conversion.ToString(reader[MERITALSTATUSTITLE]);
}
if (reader[ISACTIVE] != null && reader[ISACTIVE] != DBNull.Value)
{
_MeritalStatus.IsActive = Common.Conversion.ToBool(reader[ISACTIVE]);
}
return(_MeritalStatus);
}
catch (Exception exception) {
throw exception;
}
}
private string GetMaritalStatusAsString(MeritalStatus meritalStatus)
{
if (meritalStatus.Married)
{
return("Married");
}
if (meritalStatus.Single)
{
return("Single");
}
return("PartiallyMarried");
}
private MeritalStatus GetMeritalStatus(short Id)
{
try {
MeritalStatus MeritalStatus = null;
using (DbCommand dbcmdMeritalStatus = _Database.GetStoredProcCommand(PROC_MERITALSTATUS_GETBYID)) {
_Database.AddInParameter(dbcmdMeritalStatus, ID, DbType.Int16, Id);
using (IDataReader reader = _Database.ExecuteReader(dbcmdMeritalStatus)) {
MeritalStatus = Mapper(reader);
}
}
return(MeritalStatus);
}
catch (Exception ex) {
throw ex;
}
}
