public ReturnBaseMessageModel SaveCustomerUser(CustomerUserViewModel user)
{
try
{
var singleUser = uow.Repository <CustomerUserTable>().FindBy(x => x.UserId == user.UserId).SingleOrDefault();
if (singleUser == null)
{
singleUser = new CustomerUserTable();
singleUser.PasswordHash = user.PasswordHash;
singleUser.CustomerId = user.CustomerId;
singleUser.EffDate = user.EffDate;
singleUser.TillDate = user.TillDate;
singleUser.UserName = user.UserName;
singleUser.MTId = Convert.ToInt32(user.MTId);
singleUser.Email = user.Email;
singleUser.IsActive = user.IsActive;
singleUser.IsUnlimited = user.IsUnlimited;
uow.Repository <CustomerUserTable>().Add(singleUser);
uow.Commit();
returnBaseMessageModel.Msg = "Customer User Added Sucessfully";
returnBaseMessageModel.Success = true;
}
else
{
singleUser.CustomerId = user.CustomerId;
singleUser.EffDate = user.EffDate;
singleUser.TillDate = user.TillDate;
singleUser.UserName = user.UserName;
singleUser.MTId = Convert.ToInt32(user.MTId);
singleUser.Email = user.Email;
singleUser.IsActive = user.IsActive;
singleUser.IsUnlimited = user.IsUnlimited;
uow.Repository <CustomerUserTable>().Edit(singleUser);
uow.Commit();
returnBaseMessageModel.Msg = "Customer User Edited Sucessfully";
returnBaseMessageModel.Success = true;
}
return(returnBaseMessageModel);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> PostLogin([FromBody] OAuthGrantResourceOwnerCredentialsContext context)
{
//var isCustomer= HttpContext.Current.Request.Params["IsCustomer"];
if (context.ClientId == "User")
{
PasswordHasher pass = new PasswordHasher();
//var hashedPassword = EncodePassword(context.Password, MembershipPasswordFormat.Hashed, "MAKV2SPBNI99212");
var user = db.Users.Where(x => x.UserName == context.UserName.Trim()).FirstOrDefault();
// password is correct
//var userManager = context.OwinContext.GetUserManager<Loader.UserManager>();
// var user = await userManager.FindAsync(context.UserName, context.Password);
//Loader.Models.ApplicationUser user = await userManager.FindAsync(context.UserName, context.Password);
if (user != null && user.IsActive == true && pass.VerifyHashedPassword(user.PasswordHash, context.Password) != PasswordVerificationResult.Failed)
{
if (user.UserDesignationId == 11)
{
var locations = String.Format("select locationid from fgetlocationlistbycollector('" + user.UserId + "')");
List <int> returnData = db.Database.SqlQuery <int>(locations).ToList();
int[] myintlist = returnData.ToArray();
var sul = new LocationUser
{
EmployeeId = user.EmployeeId,
Email = user.Email,
UserId = user.UserId,
UserName = user.UserName,
EffDate = user.EffDate,
TillDate = user.TillDate,
MTId = user.MTId,
IsUnlimited = user.IsUnlimited,
UserDesignationId = user.UserDesignationId,
Location = myintlist
};
return(Ok(new { results = sul }));
}
else
{
var sul = new User
{
EmployeeId = user.EmployeeId,
Email = user.Email,
UserId = user.UserId,
UserName = user.UserName,
EffDate = user.EffDate,
TillDate = user.TillDate,
MTId = user.MTId,
IsUnlimited = user.IsUnlimited,
UserDesignationId = user.UserDesignationId,
};
return(Ok(new { results = sul }));
}
}
//Logger.writeLog(Request, Logger.JsonDataResult(sul), Logger.JsonDataResult(context));
else if (user != null && user.IsActive == false)
{
return(BadRequest("User Not Active"));
}
else
{
return(NotFound());
}
}
else if (context.ClientId == "Customer")
{
PasswordHasher pass = new PasswordHasher();
//var hashedPassword = EncodePassword(context.Password, MembershipPasswordFormat.Hashed, "MAKV2SPBNI99212");
var user = db.CustomerUserTables.Where(x => x.UserName == context.UserName).FirstOrDefault();
//CustomerUser user = db.CustomerUsers.Where(x => x.UserName == context.UserName).FirstOrDefault();
if (user != null && user.IsActive == true && pass.VerifyHashedPassword(user.PasswordHash, context.Password) != PasswordVerificationResult.Failed)
{
var sul = new CustomerUserTable
{
CustomerId = user.CustomerId,
Email = user.Email,
UserId = user.UserId,
UserName = user.UserName,
EffDate = user.EffDate,
TillDate = user.TillDate,
MTId = user.MTId,
IsUnlimited = user.IsUnlimited,
};
//Logger.writeLog(Request, Logger.JsonDataResult(sul), Logger.JsonDataResult(context));
return(Ok(new { results = sul }));
}
else if (user != null && user.IsActive == false)
{
return(BadRequest("Customer Not Active"));
}
else
{
return(NotFound());
}
}
else
{
return(NotFound());
}
}
public HttpResponseMessage LoginDemo([FromBody] ApiControlViewModel.LoginViewModel context)
{
//var isCustomer= HttpContext.Current.Request.Params["IsCustomer"];
if (context.ClientId == "User")
{
PasswordHasher pass = new PasswordHasher();
//var hashedPassword = EncodePassword(context.Password, MembershipPasswordFormat.Hashed, "MAKV2SPBNI99212");
User user = new User();
if (context.Email != null)
{
user = db.Users.Where(x => x.Email == context.Email).FirstOrDefault();
}
if (context.UserName != null)
{
user = db.Users.Where(x => x.UserName == context.UserName.Trim()).FirstOrDefault();
}
// password is correct
//var userManager = context.OwinContext.GetUserManager<Loader.UserManager>();
// var user = await userManager.FindAsync(context.UserName, context.Password);
//Loader.Models.ApplicationUser user = await userManager.FindAsync(context.UserName, context.Password);
if (user != null && user.IsActive == true && pass.VerifyHashedPassword(user.PasswordHash, context.Password) != PasswordVerificationResult.Failed)
{
if (user.UserDesignationId == 11)
{
var locations = String.Format("select locationid from fgetlocationlistbycollector('" + user.UserId + "')");
List <int> returnData = db.Database.SqlQuery <int>(locations).ToList();
int[] myintlist = returnData.ToArray();
AuthenticationModule authentication = new AuthenticationModule();
string tokens = authentication.GenerateTokenForUser(user.UserName, user.UserId);
//var sul = new LocationUser
//{
//EmployeeId = user.EmployeeId,
//Email = user.Email,
//UserId = user.UserId,
//UserName = user.UserName,
//EffDate = user.EffDate,
//TillDate = user.TillDate,
//MTId = user.MTId,
//IsUnlimited = user.IsUnlimited,
//UserDesignationId = user.UserDesignationId,
//Location = myintlist,
var token = tokens;
//};
return(Request.CreateResponse(HttpStatusCode.OK, token, Configuration.Formatters.JsonFormatter));
//return Ok(new { results = sul });
}
//else
//{
// AuthenticationModule authentication = new AuthenticationModule();
// string tokens = authentication.GenerateTokenForUser(user.UserName, user.UserId);
// //var sul = new LocationUser
// //{
// //EmployeeId = user.EmployeeId,
// //Email = user.Email,
// //UserId = user.UserId,
// //UserName = user.UserName,
// //EffDate = user.EffDate,
// //TillDate = user.TillDate,
// //MTId = user.MTId,
// //IsUnlimited = user.IsUnlimited,
// //UserDesignationId = user.UserDesignationId,
// var token = tokens;
// //};
// //return Ok(new { results = sul });
// return Request.CreateResponse(HttpStatusCode.OK, token, Configuration.Formatters.JsonFormatter);
//}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "User is not collector ", Configuration.Formatters.JsonFormatter));
}
}
//Logger.writeLog(Request, Logger.JsonDataResult(sul), Logger.JsonDataResult(context));
else if (user != null && user.IsActive == false)
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "Invalid User", Configuration.Formatters.JsonFormatter));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "User Not Found ", Configuration.Formatters.JsonFormatter));
}
}
else if (context.ClientId == "Customer")
{
PasswordHasher pass = new PasswordHasher();
CustomerUserTable user = new CustomerUserTable();
if (context.UserName != null)
{
user = db.CustomerUserTables.Where(x => x.UserName == context.UserName).FirstOrDefault();
}
if (context.Email != null)
{
user = db.CustomerUserTables.Where(x => x.Email == context.Email).FirstOrDefault();
}
//var hashedPassword = EncodePassword(context.Password, MembershipPasswordFormat.Hashed, "MAKV2SPBNI99212");
// var user = db.CustomerUserTables.Where(x => x.UserName == context.UserName).FirstOrDefault();
//CustomerUser user = db.CustomerUsers.Where(x => x.UserName == context.UserName).FirstOrDefault();
if (user != null && user.IsActive == true && pass.VerifyHashedPassword(user.PasswordHash, context.Password) != PasswordVerificationResult.Failed)
{
AuthenticationModule authentication = new AuthenticationModule();
string tokens = authentication.GenerateTokenForUser(user.UserName, user.UserId);
//var sul = new customerUser
//{
//CustomerId = user.CustomerId,
//Email = user.Email,
//UserId = user.UserId,
//UserName = user.UserName,
//EffDate = user.EffDate,
//TillDate = user.TillDate,
//MTId = user.MTId,
//IsUnlimited = user.IsUnlimited,
var token = tokens;
//};
//Logger.writeLog(Request, Logger.JsonDataResult(sul), Logger.JsonDataResult(context));
//return Ok(new { results = sul });
return(Request.CreateResponse(HttpStatusCode.OK, token, Configuration.Formatters.JsonFormatter));
}
else if (user != null && user.IsActive == false)
{
//return BadRequest("Customer Not Active");
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "User Not Active", Configuration.Formatters.JsonFormatter));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "User Not Found", Configuration.Formatters.JsonFormatter));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "User Not Found", Configuration.Formatters.JsonFormatter));
}
}
