public static DataSet ExternalLogin([FromBody] externalLogin userlogin)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@name", userlogin.Name));
parameters.Add(new SqlParameter("@email", userlogin.Email));
parameters.Add(new SqlParameter("@loginProvider", userlogin.LoginProvider));
parameters.Add(new SqlParameter("@providerKey", userlogin.ProviderKey));
try
{
string ConnectionString = Common.GetConnectionString();
DataSet ds = new DataSet();
using (ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spAuthentication", parameters.ToArray()))
{
return(ds);
}
//int rowsAffected = SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "spAuthentication", parameters.ToArray());
//return rowsAffected;
}
catch (Exception e)
{
//loggerErr.Error(e.Message + " - " + e.StackTrace);
throw e;
}
}
public IActionResult Authentication(externalLogin userlogin)
{
try
{
List <UsersLogin> userList = new List <UsersLogin>();
DataSet ds = Data.Users.ExternalLogin(userlogin);
string row = ds.Tables[0].Rows[0]["ErrorMessage"].ToString();
if (row == "Success")
{
DataTable dt = ds.Tables[1];
if (dt.Rows.Count > 0)
{
UsersLogin user = new UsersLogin();
user.UserId = (int)dt.Rows[0]["UserId"];
user.Email = (dt.Rows[0]["Email"] == DBNull.Value ? "" : dt.Rows[0]["Email"].ToString());
user.Name = (dt.Rows[0]["Name"] == DBNull.Value ? "" : dt.Rows[0]["Name"].ToString());
// user.PhoneNumber = (dt.Rows[0]["PhoneNumber"] == DBNull.Value ? "" : dt.Rows[0]["PhoneNumber"].ToString());
user.SourceofReg = (dt.Rows[0]["SourceofReg"] == DBNull.Value ? "" : dt.Rows[0]["SourceofReg"].ToString());
user.IsPromoCodeApplicable = (dt.Rows[0]["IsPromoCodeApplicable"] == DBNull.Value ? false : (bool)dt.Rows[0]["IsPromoCodeApplicable"]);
user.IsEmailVerified = (dt.Rows[0]["IsEmailVerified"] == DBNull.Value ? false : (bool)dt.Rows[0]["IsEmailVerified"]);
user.IsPhoneNumVerified = (dt.Rows[0]["IsPhoneNumVerified"] == DBNull.Value ? false : (bool)dt.Rows[0]["IsPhoneNumVerified"]);
user.CreatedDate = (dt.Rows[0]["CreatedDate"] == DBNull.Value ? "" : dt.Rows[0]["CreatedDate"].ToString());
user.Role = (dt.Rows[0]["Role"] == DBNull.Value ? "" : dt.Rows[0]["Role"].ToString());
//user.ModifiedDate = (dt.Rows[0]["ModifiedDate"] == DBNull.Value ? "" : dt.Rows[0]["ModifiedDate"].ToString());
//user.IsDeleted = (dt.Rows[0]["IsDeleted"] == DBNull.Value ? false : (bool)dt.Rows[0]["IsDeleted"]);
userList.Add(user);
var token = GenerateJSONWebToken();
var encrypt = Common.EncryptData(token);
return(StatusCode((int)HttpStatusCode.OK, new { user, token }));
}
else
{
//string SaveErrorLog = Data.Common.SaveErrorLog("ExternalLogin", row);
return(StatusCode((int)HttpStatusCode.Forbidden, new { error = new { message = "Invalid User" } }));
}
}
else
{
string SaveErrorLog = Data.Common.SaveErrorLog("ExternalLogin", "User not exist");
return(StatusCode((int)HttpStatusCode.Forbidden, new { error = new { message = "User not exist" } }));
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("ExternalLogin", e.Message);
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } }));
}
}
