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() } })); } }