public void Add(User_Token entity)
{
try
{
string strToken = (entity.Token_No == String.Empty ? GenerateToken() : entity.Token_No);
var vToken = adbContext.user_token.Where(w => w.User_Id == entity.User_Id).FirstOrDefault();
if (vToken != null)
{
vToken.Token_No = strToken;
vToken.Token_ExpiryDate = DateTime.Now.AddMinutes(30);
vToken.isActive = 1;
vToken.UpdatedOn = DateTime.Now;
vToken.UpdatedBy = entity.User_Id;
adbContext.user_token.Update(vToken);
}
else
{
adbContext.Add <User_Token>(new User_Token
{
Token_ExpiryDate = DateTime.Now.AddMinutes(30),
isActive = 1,
User_Id = entity.User_Id,
Token_No = strToken,
AddedBy = entity.User_Id,
AddedOn = DateTime.Now
});
}
adbContext.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void Remove(User_Token entity)
{
try
{
var vToken = adbContext.user_token.Where(w => w.User_Id == entity.User_Id).FirstOrDefault();
if (vToken != null)
{
vToken.Token_No = String.Empty;
vToken.Token_ExpiryDate = DateTime.Now.AddMinutes(-30);
vToken.isActive = 1;
vToken.UpdatedOn = DateTime.Now;
vToken.UpdatedBy = entity.User_Id;
adbContext.user_token.Update(vToken);
adbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(User_Token entity)
{
//adbContext.BeginTransaction();
try
{
string strToken = (entity.Token_No == String.Empty ? GenerateToken() : entity.Token_No);
var vToken = adbContext.user_token.Where(w => w.User_Id == entity.User_Id).ToList();
if (vToken.Count() > 0)
{
entity.Token_No = strToken;
entity.Token_ExpiryDate = DateTime.Now.AddMinutes(30);
entity.isActive = 1;
entity.UpdatedOn = DateTime.Now;
entity.UpdatedBy = entity.UpdatedBy;
adbContext.user_token.Update(entity);
}
else
{
adbContext.Add <User_Token>(new User_Token
{
Token_ExpiryDate = DateTime.Now.AddMinutes(30),
isActive = 1,
User_Id = entity.User_Id,
Token_No = strToken,
AddedBy = entity.User_Id,
AddedOn = DateTime.Now
});
}
adbContext.SaveChanges();
//adbContext.CommitTransaction();
}
catch (Exception ex)
{
//adbContext.RollBackTransaction();
throw ex;
}
}
public void Remove(User_Token entity)
{
//adbContext.BeginTransaction();
try
{
adbContext.Update <User_Token>(new User_Token
{
Token_ExpiryDate = DateTime.Now.AddMinutes(-30),
isActive = 0,
User_Id = entity.User_Id,
Token_No = String.Empty,
UpdatedBy = entity.User_Id,
UpdatedOn = DateTime.Now
});
adbContext.SaveChanges();
//adbContext.CommitTransaction();
}
catch (Exception ex)
{
//adbContext.RollBackTransaction();
throw ex;
}
}
