public HttpResponseMessage tester()
{
using (CouponsEntities dbContext = new CouponsEntities())
{
var dataSet = (from c in dbContext.Coupons
where c.CompanyId == 1
join co in dbContext.Companies
on c.CompanyId equals co.Id
select new
{
co.Name,
c.CompanyId
}).ToList();
return(CreateResponseMessage(dataSet));
// var user = dbContext.Users.FirstOrDefault(u => u.Id == 1);
/*
* var data = dbContext.Coupons
* .Join(
* dbContext.Users.Where(u => u.Id == 1),
* uu => uu.Id,
* c => c.CompanyId,
* (uu, c) => uu
* ).ToList();
*
* var a = 1;*/
}
return(null);
}
public HttpResponseMessage Login(LoginRequest loginRequest)
{
string apiName = "Login(LoginRequest loginRequest)";
var guid = Guid.NewGuid();
logger.Info("Guid: \"{0}\" api/{1}/{2} was invoked", guid, controllerName, apiName);
using (CouponsEntities db = new CouponsEntities())
{
try
{
var user = db.Users.FirstOrDefault(u => u.Email.Equals(loginRequest.UserName));
if (user == null)
{
return(CreateGeneralResultMessage("Wrong Password or User Name", false, ApiStatusCodes.BadRequest));
}
var userEncryptedPassword = db.AuthUsers.FirstOrDefault(a => a.UserId.Equals(user.Id)).EncryptedPassword;
//if (loginRequest.Password.Equals(PasswordEncryptor.Decrypt(userEncryptedPassword)))
if (PasswordEncryptor.Encrypt(loginRequest.Password).Equals(userEncryptedPassword))
{
AuthenticationResponse response = new AuthenticationResponse();
response.TokenId = user.Token.ToString();
return(CreateResponseMessage(response));
}
else
{
logger.Error("Guid: \"{0}\" Wrong Password or User Name:", guid);
return(CreateGeneralResultMessage("Wrong Password or User Name", false, ApiStatusCodes.BadRequest));
}
}
catch (Exception ex)
{
logger.Error("Guid: \"{0}\" General Error: {1}", guid, ex);
return(CreateGeneralResultMessage(ex.Message, false, ApiStatusCodes.InternalServerError));
}
}
}
public BaseRepository()
{
dbContext = new CouponsEntities();
}
