public ConsumerTokenEN GetLastConsumerSmsToken(int pConsumerID)
{
ConsumerTokenEN consumerToken = null;
try
{
consumerToken = connection.Cnn.GetList <ConsumerTokenEN>().Where(f => f.ConsumerID == pConsumerID).LastOrDefault();
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException);
EventViewerLoggerDAL.LogError("GetLastConsumerToken: " + ex.Message);
}
finally
{
connection.Cnn.Close();
}
return(consumerToken);
}
public int UpdateToken(ConsumerTokenEN pNewToken)
{
int resultUpdate = default(int);
try
{
resultUpdate = connection.Cnn.Update(pNewToken);
}
catch (Exception ex)
{
resultUpdate = 0;
Console.WriteLine(ex.InnerException);
EventViewerLoggerDAL.LogError("UpdateToken: " + ex.Message);
}
finally
{
connection.Cnn.Close();
}
return(resultUpdate);
}
public ConsumerTokenEN GetConsumerSmsToken(int pConsumerID, string pToken, DateTime pDate)
{
ConsumerTokenEN consumerToken = null;
try
{
consumerToken = connection.Cnn.GetList <ConsumerTokenEN>().Where(f => f.Token == pToken.ToUpper() &&
f.ConsumerID == pConsumerID &&
f.ExpirationDate >= pDate &&
f.Status == false).FirstOrDefault();
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException);
EventViewerLoggerDAL.LogError("VerifyConsumerToken: " + ex.Message);
}
finally
{
connection.Cnn.Close();
}
return(consumerToken);
}
