public static PregeneratedCard GetCardSerialNumber(string loggedInUser)
{
try
{
var user = UserDL.RetrieveUserByUsername(loggedInUser);
if (user == null)
{
throw new Exception("Invalid username");
}
else if (user.ID == 0)
{
throw new Exception("Invalid username");
}
else
{
var existingCard = new PregeneratedCard();
using (var context = new LicenseDBEntities())
{
existingCard = context.PregeneratedCards
.Include("Branch1")
.Where(t => t.Status == false && t.Branch == user.UserBranch)
.Take(1)
.FirstOrDefault();
}
return(existingCard);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static User RetrieveUserByUsername(string username)
{
try
{
return(UserDL.RetrieveUserByUsername(username));
}
catch (Exception ex)
{
throw ex;
}
}