public UserValidateDetail ValidateUser(string userName, string password, out string errorMessage)
{
UserValidateDetail userValidateDetail = null;
errorMessage = string.Empty;
try
{
HttpResponseMessage responseMessage = client.GetAsync("/api/UserManagement/ValidateUser?userName="******"&password="******"No Record Found!";
}
}
catch (Exception ex)
{
errorMessage = ex.Message;
}
return(userValidateDetail);
}
internal UserValidateDetail UserValidate(string userName, string password)
{
Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>();
cmdParameters["UserName"] = new SqlParameter("UserName", userName);
cmdParameters["Password"] = new SqlParameter("Password", CryptographyUtility.EncryptPassword(password, userName));
SqlParameter outPutParameter1 = new SqlParameter();
outPutParameter1.ParameterName = "@Name";
outPutParameter1.SqlDbType = System.Data.SqlDbType.VarChar;
outPutParameter1.Size = 255;
outPutParameter1.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@Name"] = outPutParameter1;
SqlParameter outPutParameter2 = new SqlParameter();
outPutParameter2.ParameterName = "@GroupID";
outPutParameter2.SqlDbType = System.Data.SqlDbType.Int;
outPutParameter2.Size = 255;
outPutParameter2.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@GroupID"] = outPutParameter2;
SqlParameter outPutParameter3 = new SqlParameter();
outPutParameter3.ParameterName = "@ERRNo";
outPutParameter3.SqlDbType = System.Data.SqlDbType.Int;
outPutParameter3.Size = 255;
outPutParameter3.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@ERRNo"] = outPutParameter3;
SqlParameter outPutParameter4 = new SqlParameter();
outPutParameter4.ParameterName = "@ERRORDESC";
outPutParameter4.SqlDbType = System.Data.SqlDbType.VarChar;
outPutParameter4.Size = 255;
outPutParameter4.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@ERRORDESC"] = outPutParameter4;
SqlParameter outPutParameter5 = new SqlParameter();
outPutParameter5.ParameterName = "@UserID";
outPutParameter5.SqlDbType = System.Data.SqlDbType.Int;
outPutParameter5.Size = 255;
outPutParameter5.Direction = System.Data.ParameterDirection.Output;
cmdParameters["@UserID"] = outPutParameter5;
UserValidateDetail userValidateDetail = new UserValidateDetail();
dbutility.ExecuteNonQuery("QuotationDb", "dbo.UserValidate", cmdParameters);
userValidateDetail.Name = outPutParameter1.Value == null ? null : outPutParameter1.Value.ToString();
userValidateDetail.GroupId = outPutParameter2.Value == null ? -1 : (outPutParameter2.Value.ToString() == string.Empty ? -1 : int.Parse(outPutParameter2.Value.ToString()));
userValidateDetail.Code = outPutParameter3.Value == null ? -1 : (outPutParameter3.Value.ToString() == string.Empty ? -1 : int.Parse(outPutParameter3.Value.ToString()));
userValidateDetail.Info = outPutParameter4.Value == null ? "ERROR" : outPutParameter4.Value.ToString();
userValidateDetail.UserId = outPutParameter5.Value == null ? -1 : (outPutParameter5.Value.ToString() == string.Empty ? -1 : int.Parse(outPutParameter5.Value.ToString()));
return(userValidateDetail);
}
public async Task <IHttpActionResult> UserValidate(string userName, string password)
{
try
{
UserValidateDetail userValidateDetail = await Task.Run(() => usermanagementDb.UserValidate(userName, password));
if (userValidateDetail == null)
{
return(NotFound());
}
return(Ok(userValidateDetail));
}
catch (Exception)
{
return(InternalServerError());
}
}
